Database Properties
Database Type: PostgreSQL - 13.7
Tables
| Table / View | Children | Parents | Columns | Rows | Type | Comments |
|---|---|---|---|---|---|---|
| CompanyType | 1 | 0 | 2 | 4 | Table | Company type option set |
| SystemUserBase | 40 | 1 | 10 | 154 | Table | User |
| new_receiptBase | 1 | 6 | 56 | 3730 | Table | Receipts |
| Months | 0 | 0 | 2 | 12 | Table | |
| Website_Platform | 1 | 0 | 2 | 22 | Table | |
| process | 0 | 1 | 4 | 3 | Table | |
| ContactBase | 9 | 7 | 70 | 4757 | Table | Writers |
| POFix | 0 | 0 | 2 | 4944 | Table | |
| PostsSEODeclineReason | 1 | 0 | 2 | 6 | Table | |
| SalesOrderDetailBase | 0 | 0 | 61 | 0 | Table | |
| ContactBasePaymentOption | 0 | 0 | 2 | 3 | Table | |
| WebsiteTopics | 3 | 0 | 4 | 385 | Table | |
| OrderPriority | 1 | 0 | 2 | 4 | Table | |
| new_POBase | 2 | 11 | 52 | 6171 | Table | Purchase Orders |
| Categories | 1 | 0 | 2 | 33 | Table | Project categories |
| new_paymentmethodBase | 5 | 1 | 34 | 59 | Table | PaymentMethod |
| WebsiteStatus | 1 | 0 | 2 | 7 | Table | Website status option set |
| Contacts_Roles | 0 | 2 | 3 | 4624 | Table | Content Portal |
| TrackerDeal | 1 | 0 | 2 | 3 | Table | |
| Roles | 3 | 0 | 2 | 13 | Table | |
| Preferences | 0 | 1 | 4 | 172 | Table | |
| ProjectImportance | 1 | 0 | 2 | 3 | Table | |
| StrategyFieldsSet | 1 | 0 | 2 | 2 | Table | combination of fields for Campign srategy |
| CampaignType | 1 | 0 | 2 | 7 | Table | Tyes of campaign |
| Users_Roles | 0 | 2 | 3 | 85 | Table | |
| project_topic | 0 | 1 | 4 | 175 | Table | Project to Topic relation |
| Tags | 1 | 0 | 3 | 15 | Table | |
| Posts | 1 | 36 | 128 | 111978 | Table | |
| PurchaseOrderStatus | 1 | 0 | 2 | 4 | Table | |
| new_brandBase | 4 | 2 | 15 | 1859 | Table | Brands |
| WebsitesToTopics | 0 | 2 | 3 | 0 | Table | |
| Offer | 0 | 4 | 17 | 6967 | Table | |
| new_regemailBase | 1 | 0 | 6 | 20 | Table | Registration Emails (for Affiliate Order) |
| ReceiptStatus | 0 | 0 | 2 | 5 | Table | |
| AdvertiserPostStatus | 1 | 0 | 2 | 12 | Table | |
| PublisherPostStatus | 1 | 0 | 2 | 9 | Table | |
| Teams | 0 | 0 | 2 | 5 | Table | Teams contain many Users |
| new_affiliateincomereportBase | 0 | 0 | 38 | 136 | Table | Affiliate Income Report |
| CampaignStatus | 1 | 0 | 2 | 8 | Table | Campaigns status codes |
| new_affordertypeBase | 1 | 1 | 13 | 37 | Table | |
| ServiceTypes | 0 | 0 | 2 | 14 | Table | Services Received |
| Campaign | 1 | 11 | 57 | 2667 | Table | |
| PostsStatus | 1 | 0 | 2 | 5 | Table | |
| PostsOnlineStatus | 1 | 0 | 2 | 2 | Table | This describes the online status of the Post, content and links |
| process_rate | 1 | 0 | 2 | 4 | Table | |
| CampaignFix | 0 | 0 | 2 | 2664 | Table | |
| new_trackerBase | 1 | 6 | 36 | 5318 | Table | Trackers |
| new_countryBase | 3 | 0 | 8 | 62 | Table | |
| OrderPriorityFix | 0 | 0 | 2 | 5348 | Table | |
| LandingPages | 0 | 3 | 7 | 258 | Table | |
| OrderPayTo | 1 | 0 | 2 | 6 | Table | |
| PostsStatusCode | 1 | 0 | 2 | 8 | Table | |
| Configurations | 0 | 0 | 3 | 2 | Table | |
| ContentTypes | 2 | 1 | 11 | 1058 | Table | |
| Events | 0 | 0 | 7 | 49692 | Table | Table to store information about resource events |
| OrderFor | 1 | 0 | 2 | 9 | Table | |
| LandingPagePriority | 1 | 0 | 2 | 3 | Table | |
| InvoiceState | 1 | 0 | 2 | 4 | Table | |
| UsersStatus | 1 | 0 | 2 | 3 | Table | |
| TrackerTags | 1 | 0 | 3 | 0 | Table | |
| PostsRemovalStatus | 0 | 0 | 2 | 3 | Table | |
| new_new_brand_new_countryBase | 0 | 2 | 7 | 3103 | Table | |
| WebsiteBlogProbability | 1 | 0 | 2 | 3 | Table | Website blog probability option sets |
| nc_evolutions | 0 | 0 | 10 | 0 | Table | |
| PostsOutreachStatus | 1 | 0 | 2 | 7 | Table | |
| AffDealType | 1 | 0 | 2 | 4 | Table | |
| Project | 5 | 7 | 79 | 761 | Table | |
| AccountBase | 5 | 4 | 26 | 2624 | Table | Companies table |
| InvoiceBase | 1 | 11 | 73 | 6123 | Table | |
| AffiliateOrderCategoriesPriority | 1 | 0 | 2 | 3 | Table | Affiliate Order Categories Priority |
| OrderType | 1 | 0 | 2 | 13 | Table | |
| PostsContentStatus | 1 | 0 | 2 | 9 | Table | Content order status for post |
| Page | 1 | 2 | 7 | 269 | Table | |
| Users_Teams | 0 | 0 | 3 | 19 | Table | Users-Teams N:N Relationship Table |
| TrackerToTags | 0 | 2 | 3 | 0 | Table | |
| PostsFix | 0 | 0 | 5 | 108603 | Table | |
| PostsPageTypeDeprecated | 0 | 0 | 2 | 3 | Table | |
| SalesOrderBase | 2 | 13 | 61 | 5734 | Table | Affiliate Order Entity |
| Project_Countries | 0 | 2 | 3 | 3 | Table | |
| Website | 6 | 10 | 41 | 362055 | Table | |
| PostsSEOApproval | 1 | 0 | 2 | 4 | Table | |
| CampaignStrategy | 1 | 4 | 27 | 65 | Table | |
| PaymentCompanies | 2 | 0 | 2 | 6 | Table | Payment Companies |
| PostsAnchorTextType | 6 | 0 | 2 | 7 | Table | |
| ProjectStatus | 1 | 0 | 2 | 4 | Table | Project statuscode |
| InvoiceDetailBase | 0 | 3 | 15 | 5931 | Table | |
| SupplierCurrency | 1 | 0 | 2 | 5 | Table | Supplier Currency |
| Report_Roles | 0 | 2 | 3 | 25 | Table | |
| WebsiteDToxRisk | 1 | 0 | 2 | 6 | Table | WebsiteDToxRisk option set |
| new_languagesBase | 6 | 0 | 14 | 66 | Table | |
| WebsiteContentIndicator | 1 | 0 | 2 | 5 | Table | Website content indicator |
| InvoiceStatus | 1 | 0 | 2 | 5 | Table | |
| WebsiteUptimeStatus | 1 | 0 | 2 | 13 | Table | WebsiteUptimeStatus option set |
| PostsCopyScape | 1 | 0 | 2 | 4 | Table | |
| ContactType | 1 | 0 | 2 | 8 | Table | ContactType Option set |
| Report | 1 | 0 | 4 | 11 | Table | |
| Supplier_Tag_rel | 0 | 2 | 4 | 106 | Table | |
| PostsLinkStatus | 1 | 0 | 2 | 7 | Table | This describes the Status of the Link(s) on the Post |
| ProjectTopic | 1 | 0 | 2 | 30 | Table | |
| CampaignPriority | 1 | 0 | 2 | 3 | Table | |
| TransactionCurrencyBase | 9 | 0 | 21 | 5 | Table | |
| PoToPosts | 0 | 2 | 3 | 0 | Table | |
| ProjectManagers | 0 | 0 | 2 | 0 | View | |
| Suppliers | 0 | 0 | 70 | 0 | View | |
| ActiveUsers | 0 | 0 | 10 | 0 | View |