| Table Summary, by layer | ||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Fact | GeneralType | GeneralSchema | GeneralObject | create_date | modify_date | Columns | Indexes | PKs_AKs | Children | ReferenceOf | Estimate | Layer |
| 26 | U | dbo | AWBuildVersion | 2017-10-27 14:33:01 | 2017-10-27 14:33:06 | 4 | 1 | 1 | 0 | 0 | 16 | 0 |
| 26 | U | dbo | DatabaseLog | 2017-10-27 14:33:01 | 2017-10-27 14:33:07 | 8 | 1 | 1 | 0 | 0 | 20 | 0 |
| 26 | U | dbo | ErrorLog | 2017-10-27 14:33:01 | 2017-10-27 14:33:01 | 9 | 1 | 1 | 0 | 1 | 26 | 0 |
| 26 | U | HumanResources | Department | 2017-10-27 14:33:01 | 2017-10-27 14:33:14 | 4 | 2 | 1 | 1 | 2 | 36 | 0 |
| 26 | U | HumanResources | Shift | 2017-10-27 14:33:01 | 2017-10-27 14:33:14 | 5 | 3 | 1 | 1 | 1 | 35 | 0 |
| 26 | U | Person | AddressType | 2017-10-27 14:33:01 | 2017-10-27 14:33:14 | 4 | 3 | 1 | 1 | 3 | 44 | 0 |
| 26 | U | Person | BusinessEntity | 2017-10-27 14:33:01 | 2017-10-27 14:33:14 | 3 | 2 | 1 | 5 | 0 | 53 | 0 |
| 26 | U | Person | ContactType | 2017-10-27 14:33:01 | 2017-10-27 14:33:14 | 3 | 2 | 1 | 1 | 3 | 40 | 0 |
| 26 | U | Person | CountryRegion | 2017-10-27 14:33:01 | 2017-10-27 14:33:15 | 3 | 2 | 1 | 3 | 6 | 69 | 0 |
| 26 | U | Person | PhoneNumberType | 2017-10-27 14:33:01 | 2017-10-27 14:33:14 | 3 | 1 | 1 | 1 | 5 | 47 | 0 |
| 26 | U | Production | Culture | 2017-10-27 14:33:01 | 2017-10-27 14:33:14 | 3 | 2 | 1 | 1 | 0 | 25 | 0 |
| 26 | U | Production | Illustration | 2017-10-27 14:33:01 | 2017-10-27 14:33:14 | 3 | 1 | 1 | 1 | 0 | 22 | 0 |
| 26 | U | Production | Location | 2017-10-27 14:33:01 | 2017-10-27 14:33:14 | 5 | 2 | 1 | 2 | 0 | 34 | 0 |
| 26 | U | Production | ProductCategory | 2017-10-27 14:33:01 | 2017-10-27 14:33:14 | 4 | 3 | 1 | 1 | 0 | 29 | 0 |
| 26 | U | Production | ProductDescription | 2017-10-27 14:33:01 | 2017-10-27 14:33:15 | 4 | 2 | 1 | 1 | 1 | 31 | 0 |
| 26 | U | Production | ProductModel | 2017-10-27 14:33:01 | 2017-10-27 14:33:15 | 6 | 5 | 1 | 3 | 3 | 66 | 0 |
| 26 | U | Production | ProductPhoto | 2017-10-27 14:33:01 | 2017-10-27 14:33:14 | 6 | 1 | 1 | 1 | 0 | 25 | 0 |
| 26 | U | Production | ScrapReason | 2017-10-27 14:33:01 | 2017-10-27 14:33:14 | 3 | 2 | 1 | 1 | 0 | 25 | 0 |
| 26 | U | Production | TransactionHistoryArchive | 2017-10-27 14:33:01 | 2017-10-27 14:33:09 | 9 | 3 | 1 | 0 | 0 | 27 | 0 |
| 26 | U | Production | UnitMeasure | 2017-10-27 14:33:01 | 2017-10-27 14:33:14 | 3 | 2 | 1 | 4 | 0 | 46 | 0 |
| 26 | U | Purchasing | ShipMethod | 2017-10-27 14:33:01 | 2017-10-27 14:33:14 | 6 | 3 | 1 | 2 | 0 | 38 | 0 |
| 26 | U | Sales | CreditCard | 2017-10-27 14:33:01 | 2017-10-27 14:33:14 | 6 | 2 | 1 | 2 | 0 | 35 | 0 |
| 26 | U | Sales | Currency | 2017-10-27 14:33:01 | 2017-10-27 14:33:14 | 3 | 2 | 1 | 3 | 0 | 39 | 0 |
| 26 | U | Sales | SalesReason | 2017-10-27 14:33:01 | 2017-10-27 14:33:14 | 4 | 1 | 1 | 1 | 0 | 23 | 0 |
| 26 | U | Sales | SpecialOffer | 2017-10-27 14:33:01 | 2017-10-27 14:33:14 | 11 | 2 | 1 | 1 | 0 | 33 | 0 |
| 26 | U | Person | Person | 2017-10-27 14:33:01 | 2017-10-27 14:33:14 | 13 | 8 | 1 | 7 | 15 | 170 | 1 |
| 26 | U | Production | ProductModelIllustration | 2017-10-27 14:33:01 | 2017-10-27 14:33:14 | 3 | 1 | 1 | 0 | 0 | 15 | 1 |
| 26 | U | Production | ProductModelProductDescriptionCulture | 2017-10-27 14:33:01 | 2017-10-27 14:33:15 | 4 | 1 | 1 | 0 | 1 | 21 | 1 |
| 26 | U | Production | ProductSubcategory | 2017-10-27 14:33:01 | 2017-10-27 14:33:14 | 5 | 3 | 1 | 1 | 0 | 30 | 1 |
| 26 | U | Purchasing | Vendor | 2017-10-27 14:33:01 | 2017-10-27 14:33:14 | 8 | 2 | 1 | 2 | 3 | 52 | 1 |
| 26 | U | Sales | CountryRegionCurrency | 2017-10-27 14:33:01 | 2017-10-27 14:33:14 | 3 | 2 | 1 | 0 | 0 | 18 | 1 |
| 26 | U | Sales | CurrencyRate | 2017-10-27 14:33:01 | 2017-10-27 14:33:14 | 7 | 2 | 1 | 1 | 0 | 29 | 1 |
| 26 | U | Sales | SalesTerritory | 2017-10-27 14:33:01 | 2017-10-27 14:33:14 | 10 | 3 | 1 | 5 | 3 | 78 | 1 |
| 26 | U | HumanResources | Employee | 2017-10-27 14:33:01 | 2022-05-02 17:05:54 | 16 | 6 | 1 | 6 | 11 | 140 | 2 |
| 26 | U | Person | BusinessEntityContact | 2017-10-27 14:33:01 | 2017-10-27 14:33:14 | 5 | 4 | 1 | 0 | 3 | 41 | 2 |
| 26 | U | Person | EmailAddress | 2017-10-27 14:33:01 | 2017-10-27 14:33:14 | 5 | 2 | 1 | 0 | 5 | 45 | 2 |
| 26 | U | Person | Password | 2017-10-27 14:33:01 | 2017-10-27 14:33:14 | 5 | 1 | 1 | 0 | 0 | 17 | 2 |
| 26 | U | Person | PersonPhone | 2017-10-27 14:33:01 | 2017-10-27 14:33:14 | 4 | 2 | 1 | 0 | 5 | 44 | 2 |
| 26 | U | Person | StateProvince | 2017-10-27 14:33:01 | 2017-10-27 14:33:15 | 8 | 4 | 1 | 2 | 6 | 73 | 2 |
| 26 | U | Production | Product | 2017-10-27 14:33:01 | 2017-10-27 14:33:15 | 25 | 4 | 1 | 14 | 6 | 174 | 2 |
| 26 | U | Sales | PersonCreditCard | 2017-10-27 14:33:01 | 2017-10-27 14:33:14 | 3 | 1 | 1 | 0 | 0 | 15 | 2 |
| 26 | U | HumanResources | EmployeeDepartmentHistory | 2017-10-27 14:33:01 | 2017-10-27 14:33:14 | 6 | 3 | 1 | 0 | 2 | 34 | 3 |
| 26 | U | HumanResources | EmployeePayHistory | 2017-10-27 14:33:01 | 2017-10-27 14:33:14 | 5 | 1 | 1 | 0 | 1 | 22 | 3 |
| 26 | U | HumanResources | JobCandidate | 2017-10-27 14:33:01 | 2017-10-27 14:33:14 | 4 | 2 | 1 | 0 | 4 | 39 | 3 |
| 26 | U | Person | Address | 2017-10-27 14:33:01 | 2017-10-27 14:33:14 | 9 | 4 | 1 | 3 | 5 | 76 | 3 |
| 26 | U | Production | BillOfMaterials | 2017-10-27 14:33:01 | 2017-10-27 14:33:14 | 9 | 3 | 1 | 0 | 2 | 37 | 3 |
| 26 | U | Production | Document | 2017-10-27 14:33:01 | 2017-10-27 14:33:14 | 14 | 5 | 2 | 1 | 0 | 54 | 3 |
| 26 | U | Production | ProductCostHistory | 2017-10-27 14:33:01 | 2017-10-27 14:33:14 | 5 | 1 | 1 | 0 | 1 | 22 | 3 |
| 26 | U | Production | ProductInventory | 2017-10-27 14:33:01 | 2017-10-27 14:33:14 | 7 | 1 | 1 | 0 | 1 | 24 | 3 |
| 26 | U | Production | ProductListPriceHistory | 2017-10-27 14:33:01 | 2017-10-27 14:33:14 | 5 | 1 | 1 | 0 | 2 | 27 | 3 |
| 26 | U | Production | ProductProductPhoto | 2017-10-27 14:33:01 | 2017-10-27 14:33:14 | 4 | 1 | 1 | 0 | 0 | 16 | 3 |
| 26 | U | Production | ProductReview | 2017-10-27 14:33:01 | 2017-10-27 14:33:14 | 8 | 2 | 1 | 0 | 0 | 23 | 3 |
| 26 | U | Production | TransactionHistory | 2017-10-27 14:33:01 | 2017-10-27 14:33:14 | 9 | 3 | 1 | 0 | 5 | 52 | 3 |
| 26 | U | Production | WorkOrder | 2017-10-27 14:33:01 | 2017-10-27 14:33:14 | 10 | 3 | 1 | 1 | 0 | 35 | 3 |
| 26 | U | Purchasing | ProductVendor | 2017-10-27 14:33:01 | 2017-10-27 14:33:14 | 11 | 3 | 1 | 0 | 0 | 29 | 3 |
| 26 | U | Purchasing | PurchaseOrderHeader | 2017-10-27 14:33:01 | 2017-10-27 14:33:14 | 13 | 3 | 1 | 1 | 3 | 53 | 3 |
| 26 | U | Sales | SalesPerson | 2017-10-27 14:33:01 | 2017-10-27 14:33:14 | 9 | 2 | 1 | 4 | 3 | 67 | 3 |
| 26 | U | Sales | SalesTaxRate | 2017-10-27 14:33:01 | 2017-10-27 14:33:14 | 7 | 3 | 1 | 0 | 0 | 25 | 3 |
| 26 | U | Sales | ShoppingCartItem | 2017-10-27 14:33:01 | 2017-10-27 14:33:14 | 6 | 2 | 1 | 0 | 0 | 21 | 3 |
| 26 | U | Sales | SpecialOfferProduct | 2017-10-27 14:33:01 | 2017-10-27 14:33:14 | 4 | 3 | 1 | 1 | 0 | 29 | 3 |
| 26 | U | Person | BusinessEntityAddress | 2017-10-27 14:33:01 | 2017-10-27 14:33:14 | 5 | 4 | 1 | 0 | 5 | 51 | 4 |
| 26 | U | Production | ProductDocument | 2017-10-27 14:33:01 | 2017-10-27 14:33:14 | 3 | 1 | 1 | 0 | 0 | 15 | 4 |
| 26 | U | Production | WorkOrderRouting | 2017-10-27 14:33:01 | 2017-10-27 14:33:14 | 12 | 2 | 1 | 0 | 0 | 27 | 4 |
| 26 | U | Purchasing | PurchaseOrderDetail | 2017-10-27 14:33:01 | 2017-10-27 14:33:14 | 11 | 2 | 1 | 0 | 2 | 36 | 4 |
| 26 | U | Sales | SalesPersonQuotaHistory | 2017-10-27 14:33:01 | 2017-10-27 14:33:14 | 5 | 2 | 1 | 0 | 0 | 20 | 4 |
| 26 | U | Sales | SalesTerritoryHistory | 2017-10-27 14:33:01 | 2017-10-27 14:33:14 | 6 | 2 | 1 | 0 | 0 | 21 | 4 |
| 26 | U | Sales | Store | 2017-10-27 14:33:01 | 2017-10-27 14:33:14 | 6 | 4 | 1 | 1 | 4 | 54 | 4 |
| 26 | U | Sales | Customer | 2017-10-27 14:33:01 | 2017-10-27 14:33:14 | 7 | 4 | 1 | 1 | 3 | 50 | 5 |
| 26 | U | Sales | SalesOrderHeader | 2017-10-27 14:33:01 | 2017-10-27 14:33:14 | 26 | 5 | 1 | 2 | 3 | 79 | 6 |
| 26 | U | Sales | SalesOrderDetail | 2017-10-27 14:33:01 | 2017-10-27 14:33:14 | 11 | 3 | 1 | 0 | 1 | 34 | 7 |
| 26 | U | Sales | SalesOrderHeaderSalesReason | 2017-10-27 14:33:01 | 2017-10-27 14:33:14 | 3 | 1 | 1 | 0 | 0 | 15 | 7 |