| Table Details, by row count | ||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Fact | GeneralSchema | GeneralObject | SQLServerFile | create_date | modify_date | PKs | AKs | FKs_P | FKs_C | Columns | From | Plus | Used | is_lvtor | Compression | Partitions | Rows | table_type | Indexes | GBs_Table | GBs_Indexes | Percent |
| 07 | Sales | SalesOrderDetail | PRIMARY | 2017-10-27 14:33:01 | 2017-10-27 14:33:14 | 1 | 0 | 2 | 0 | 11 | 1 | 1 | 121317 | False | 1 | 121317 | 1 | 2 | 0.01026 | 0.00667 | 11.95 | |
| 07 | Production | TransactionHistory | PRIMARY | 2017-10-27 14:33:01 | 2017-10-27 14:33:14 | 1 | 0 | 1 | 0 | 9 | 100000 | 1 | 213442 | False | 1 | 113443 | 1 | 2 | 0.00666 | 0.00459 | 7.94 | |
| 07 | Production | TransactionHistoryArchive | PRIMARY | 2017-10-27 14:33:01 | 2017-10-27 14:33:09 | 1 | 0 | 0 | 0 | 9 | 0 | 0 | 0 | False | 1 | 89253 | 1 | 2 | 0.00513 | 0.00410 | 6.51 | |
| 07 | Production | WorkOrder | PRIMARY | 2017-10-27 14:33:01 | 2017-10-27 14:33:14 | 1 | 0 | 2 | 1 | 10 | 1 | 1 | 72591 | False | 1 | 72591 | 1 | 2 | 0.00452 | 0.00209 | 4.66 | |
| 07 | Production | WorkOrderRouting | PRIMARY | 2017-10-27 14:33:01 | 2017-10-27 14:33:14 | 1 | 0 | 2 | 0 | 12 | 0 | 0 | 0 | False | 1 | 67131 | 1 | 1 | 0.00581 | 0.00184 | 5.40 | |
| 07 | Sales | SalesOrderHeader | PRIMARY | 2017-10-27 14:33:01 | 2017-10-27 14:33:14 | 1 | 0 | 8 | 2 | 26 | 1 | 1 | 75123 | False | 1 | 31465 | 1 | 4 | 0.00562 | 0.00278 | 5.93 | |
| 07 | Sales | SalesOrderHeaderSalesReason | PRIMARY | 2017-10-27 14:33:01 | 2017-10-27 14:33:14 | 1 | 0 | 2 | 0 | 3 | 0 | 0 | 0 | False | 1 | 27647 | 1 | 0 | 0.00074 | 0.00000 | 0.52 | |
| 07 | Person | BusinessEntity | PRIMARY | 2017-10-27 14:33:01 | 2017-10-27 14:33:14 | 1 | 0 | 0 | 5 | 3 | 1 | 1 | 20777 | False | 1 | 20777 | 1 | 1 | 0.00080 | 0.00062 | 1.00 | |
| 07 | Person | EmailAddress | PRIMARY | 2017-10-27 14:33:01 | 2017-10-27 14:33:14 | 1 | 0 | 1 | 0 | 5 | 1 | 1 | 19972 | False | 1 | 19972 | 1 | 1 | 0.00202 | 0.00147 | 2.46 | |
| 07 | Person | Password | PRIMARY | 2017-10-27 14:33:01 | 2017-10-27 14:33:14 | 1 | 0 | 1 | 0 | 5 | 0 | 0 | 0 | False | 1 | 19972 | 1 | 0 | 0.00190 | 0.00000 | 1.34 | |
| 07 | Person | Person | PRIMARY | 2017-10-27 14:33:01 | 2017-10-27 14:33:14 | 1 | 0 | 1 | 7 | 13 | 0 | 0 | 0 | False | 1 | 19972 | 1 | 2 | 0.03011 | 0.00179 | 22.51 | |
| 07 | Person | PersonPhone | PRIMARY | 2017-10-27 14:33:01 | 2017-10-27 14:33:14 | 1 | 0 | 2 | 0 | 4 | 0 | 0 | 0 | False | 1 | 19972 | 1 | 1 | 0.00123 | 0.00098 | 1.56 | |
| 07 | Sales | Customer | PRIMARY | 2017-10-27 14:33:01 | 2017-10-27 14:33:14 | 1 | 0 | 3 | 1 | 7 | 1 | 1 | 30118 | False | 1 | 19820 | 1 | 3 | 0.00105 | 0.00149 | 1.79 | |
| 07 | Person | Address | PRIMARY | 2017-10-27 14:33:01 | 2017-10-27 14:33:14 | 1 | 0 | 1 | 3 | 9 | 1 | 1 | 32521 | False | 1 | 19614 | 1 | 3 | 0.00320 | 0.00265 | 4.13 | |
| 07 | Person | BusinessEntityAddress | PRIMARY | 2017-10-27 14:33:01 | 2017-10-27 14:33:14 | 1 | 0 | 3 | 0 | 5 | 0 | 0 | 0 | False | 1 | 19614 | 1 | 3 | 0.00092 | 0.00161 | 1.79 | |
| 07 | Sales | CreditCard | PRIMARY | 2017-10-27 14:33:01 | 2017-10-27 14:33:14 | 1 | 0 | 0 | 2 | 6 | 1 | 1 | 19237 | False | 1 | 19118 | 1 | 1 | 0.00153 | 0.00086 | 1.69 | |
| 07 | Sales | PersonCreditCard | PRIMARY | 2017-10-27 14:33:01 | 2017-10-27 14:33:14 | 1 | 0 | 2 | 0 | 3 | 0 | 0 | 0 | False | 1 | 19118 | 1 | 0 | 0.00056 | 0.00000 | 0.40 | |
| 07 | Sales | CurrencyRate | PRIMARY | 2017-10-27 14:33:01 | 2017-10-27 14:33:14 | 1 | 0 | 2 | 1 | 7 | 1 | 1 | 13532 | False | 1 | 13532 | 1 | 1 | 0.00080 | 0.00050 | 0.92 | |
| 07 | Purchasing | PurchaseOrderDetail | PRIMARY | 2017-10-27 14:33:01 | 2017-10-27 14:33:14 | 1 | 0 | 2 | 0 | 11 | 1 | 1 | 8845 | False | 1 | 8845 | 1 | 1 | 0.00056 | 0.00031 | 0.61 | |
| 07 | Purchasing | PurchaseOrderHeader | PRIMARY | 2017-10-27 14:33:01 | 2017-10-27 14:33:14 | 1 | 0 | 3 | 1 | 13 | 1 | 1 | 4012 | False | 1 | 4012 | 1 | 2 | 0.00043 | 0.00038 | 0.57 | |
| 07 | Production | BillOfMaterials | PRIMARY | 2017-10-27 14:33:01 | 2017-10-27 14:33:14 | 1 | 0 | 3 | 0 | 9 | 1 | 1 | 3482 | False | 1 | 2679 | 1 | 2 | 0.00031 | 0.00044 | 0.53 | |
| 07 | dbo | DatabaseLog | PRIMARY | 2017-10-27 14:33:01 | 2017-10-27 14:33:07 | 1 | 0 | 0 | 0 | 8 | 1 | 1 | 1596 | False | 1 | 1596 | 0 | 1 | 0.00630 | 0.00007 | 4.50 | |
| 07 | Production | ProductInventory | PRIMARY | 2017-10-27 14:33:01 | 2017-10-27 14:33:14 | 1 | 0 | 2 | 0 | 7 | 0 | 0 | 0 | False | 1 | 1069 | 1 | 0 | 0.00019 | 0.00000 | 0.13 | |
| 07 | Person | BusinessEntityContact | PRIMARY | 2017-10-27 14:33:01 | 2017-10-27 14:33:14 | 1 | 0 | 3 | 0 | 5 | 0 | 0 | 0 | False | 1 | 909 | 1 | 3 | 0.00019 | 0.00057 | 0.54 | |
| 07 | Production | ProductDescription | PRIMARY | 2017-10-27 14:33:01 | 2017-10-27 14:33:15 | 1 | 0 | 0 | 1 | 4 | 1 | 1 | 2010 | False | 1 | 762 | 1 | 1 | 0.00025 | 0.00019 | 0.31 | |
| 07 | Production | ProductModelProductDescriptionCulture | PRIMARY | 2017-10-27 14:33:01 | 2017-10-27 14:33:15 | 1 | 0 | 3 | 0 | 4 | 0 | 0 | 0 | False | 1 | 762 | 1 | 0 | 0.00019 | 0.00000 | 0.13 | |
| 07 | Sales | Store | PRIMARY | 2017-10-27 14:33:01 | 2017-10-27 14:33:14 | 1 | 0 | 2 | 1 | 6 | 0 | 0 | 0 | False | 1 | 701 | 1 | 2 | 0.00086 | 0.00038 | 0.88 | |
| 07 | Sales | SpecialOfferProduct | PRIMARY | 2017-10-27 14:33:01 | 2017-10-27 14:33:14 | 1 | 0 | 2 | 1 | 4 | 0 | 0 | 0 | False | 1 | 538 | 1 | 2 | 0.00019 | 0.00026 | 0.32 | |
| 07 | Production | Product | PRIMARY | 2017-10-27 14:33:01 | 2017-10-27 14:33:15 | 1 | 0 | 4 | 14 | 25 | 1 | 1 | 999 | False | 1 | 504 | 1 | 3 | 0.00025 | 0.00057 | 0.58 | |
| 07 | Production | ProductProductPhoto | PRIMARY | 2017-10-27 14:33:01 | 2017-10-27 14:33:14 | 1 | 0 | 2 | 0 | 4 | 0 | 0 | 0 | False | 1 | 504 | 0 | 1 | 0.00007 | 0.00019 | 0.18 | |
| 07 | Purchasing | ProductVendor | PRIMARY | 2017-10-27 14:33:01 | 2017-10-27 14:33:14 | 1 | 0 | 3 | 0 | 11 | 0 | 0 | 0 | False | 1 | 460 | 1 | 2 | 0.00019 | 0.00026 | 0.32 | |
| 07 | Production | ProductCostHistory | PRIMARY | 2017-10-27 14:33:01 | 2017-10-27 14:33:14 | 1 | 0 | 1 | 0 | 5 | 0 | 0 | 0 | False | 1 | 395 | 1 | 0 | 0.00019 | 0.00000 | 0.13 | |
| 07 | Production | ProductListPriceHistory | PRIMARY | 2017-10-27 14:33:01 | 2017-10-27 14:33:14 | 1 | 0 | 1 | 0 | 5 | 0 | 0 | 0 | False | 1 | 395 | 1 | 0 | 0.00019 | 0.00000 | 0.13 | |
| 07 | HumanResources | EmployeePayHistory | PRIMARY | 2017-10-27 14:33:01 | 2017-10-27 14:33:14 | 1 | 0 | 1 | 0 | 5 | 0 | 0 | 0 | False | 1 | 316 | 1 | 0 | 0.00019 | 0.00000 | 0.13 | |
| 07 | HumanResources | EmployeeDepartmentHistory | PRIMARY | 2017-10-27 14:33:01 | 2017-10-27 14:33:14 | 1 | 0 | 3 | 0 | 6 | 0 | 0 | 0 | False | 1 | 296 | 1 | 2 | 0.00019 | 0.00014 | 0.23 | |
| 07 | HumanResources | Employee | PRIMARY | 2017-10-27 14:33:01 | 2022-05-02 17:05:54 | 1 | 0 | 1 | 6 | 16 | 0 | 0 | 0 | False | 1 | 290 | 1 | 5 | 0.00013 | 0.00059 | 0.51 | |
| 07 | Person | CountryRegion | PRIMARY | 2017-10-27 14:33:01 | 2017-10-27 14:33:15 | 1 | 0 | 0 | 3 | 3 | 0 | 0 | 0 | False | 1 | 238 | 1 | 1 | 0.00019 | 0.00019 | 0.27 | |
| 07 | Person | StateProvince | PRIMARY | 2017-10-27 14:33:01 | 2017-10-27 14:33:15 | 1 | 0 | 2 | 2 | 8 | 1 | 1 | 181 | False | 1 | 181 | 1 | 3 | 0.00019 | 0.00021 | 0.28 | |
| 07 | Sales | SalesPersonQuotaHistory | PRIMARY | 2017-10-27 14:33:01 | 2017-10-27 14:33:14 | 1 | 0 | 1 | 0 | 5 | 0 | 0 | 0 | False | 1 | 163 | 1 | 1 | 0.00019 | 0.00007 | 0.18 | |
| 07 | Production | ProductModel | PRIMARY | 2017-10-27 14:33:01 | 2017-10-27 14:33:15 | 1 | 0 | 0 | 3 | 6 | 1 | 1 | 128 | False | 1 | 128 | 1 | 2 | 0.00032 | 0.00014 | 0.32 | |
| 07 | Sales | CountryRegionCurrency | PRIMARY | 2017-10-27 14:33:01 | 2017-10-27 14:33:14 | 1 | 0 | 2 | 0 | 3 | 0 | 0 | 0 | False | 1 | 109 | 1 | 1 | 0.00007 | 0.00007 | 0.10 | |
| 07 | Sales | Currency | PRIMARY | 2017-10-27 14:33:01 | 2017-10-27 14:33:14 | 1 | 0 | 0 | 3 | 3 | 0 | 0 | 0 | False | 1 | 105 | 1 | 1 | 0.00007 | 0.00007 | 0.10 | |
| 07 | Purchasing | Vendor | PRIMARY | 2017-10-27 14:33:01 | 2017-10-27 14:33:14 | 1 | 0 | 1 | 2 | 8 | 0 | 0 | 0 | False | 1 | 104 | 1 | 1 | 0.00019 | 0.00007 | 0.18 | |
| 07 | Production | ProductPhoto | PRIMARY | 2017-10-27 14:33:01 | 2017-10-27 14:33:14 | 1 | 0 | 0 | 1 | 6 | 1 | 1 | 181 | False | 1 | 101 | 1 | 0 | 0.00240 | 0.00000 | 1.69 | |
| 07 | Production | UnitMeasure | PRIMARY | 2017-10-27 14:33:01 | 2017-10-27 14:33:14 | 1 | 0 | 0 | 4 | 3 | 0 | 0 | 0 | False | 1 | 38 | 1 | 1 | 0.00007 | 0.00007 | 0.10 | |
| 07 | Production | ProductSubcategory | PRIMARY | 2017-10-27 14:33:01 | 2017-10-27 14:33:14 | 1 | 0 | 1 | 1 | 5 | 1 | 1 | 37 | False | 1 | 37 | 1 | 2 | 0.00007 | 0.00014 | 0.15 | |
| 07 | Production | ProductDocument | PRIMARY | 2017-10-27 14:33:01 | 2017-10-27 14:33:14 | 1 | 0 | 2 | 0 | 3 | 0 | 0 | 0 | False | 1 | 32 | 1 | 0 | 0.00007 | 0.00000 | 0.05 | |
| 07 | Sales | SalesTaxRate | PRIMARY | 2017-10-27 14:33:01 | 2017-10-27 14:33:14 | 1 | 0 | 1 | 0 | 7 | 1 | 1 | 31 | False | 1 | 29 | 1 | 2 | 0.00007 | 0.00014 | 0.15 | |
| 07 | Person | ContactType | PRIMARY | 2017-10-27 14:33:01 | 2017-10-27 14:33:14 | 1 | 0 | 0 | 1 | 3 | 1 | 1 | 20 | False | 1 | 20 | 1 | 1 | 0.00007 | 0.00007 | 0.10 | |
| 07 | Sales | SalesPerson | PRIMARY | 2017-10-27 14:33:01 | 2017-10-27 14:33:14 | 1 | 0 | 2 | 4 | 9 | 0 | 0 | 0 | False | 1 | 17 | 1 | 1 | 0.00007 | 0.00007 | 0.10 | |
| 07 | Sales | SalesTerritoryHistory | PRIMARY | 2017-10-27 14:33:01 | 2017-10-27 14:33:14 | 1 | 0 | 2 | 0 | 6 | 0 | 0 | 0 | False | 1 | 17 | 1 | 1 | 0.00007 | 0.00007 | 0.10 | |
| 07 | HumanResources | Department | PRIMARY | 2017-10-27 14:33:01 | 2017-10-27 14:33:14 | 1 | 0 | 0 | 1 | 4 | 1 | 1 | 16 | False | 1 | 16 | 1 | 1 | 0.00007 | 0.00007 | 0.10 | |
| 07 | Production | ScrapReason | PRIMARY | 2017-10-27 14:33:01 | 2017-10-27 14:33:14 | 1 | 0 | 0 | 1 | 3 | 1 | 1 | 16 | False | 1 | 16 | 1 | 1 | 0.00007 | 0.00007 | 0.10 | |
| 07 | Sales | SpecialOffer | PRIMARY | 2017-10-27 14:33:01 | 2017-10-27 14:33:14 | 1 | 0 | 0 | 1 | 11 | 1 | 1 | 16 | False | 1 | 16 | 1 | 1 | 0.00007 | 0.00007 | 0.10 | |
| 07 | Production | Location | PRIMARY | 2017-10-27 14:33:01 | 2017-10-27 14:33:14 | 1 | 0 | 0 | 2 | 5 | 1 | 1 | 60 | False | 1 | 14 | 1 | 1 | 0.00007 | 0.00007 | 0.10 | |
| 07 | HumanResources | JobCandidate | PRIMARY | 2017-10-27 14:33:01 | 2017-10-27 14:33:14 | 1 | 0 | 1 | 0 | 4 | 1 | 1 | 13 | False | 1 | 13 | 1 | 1 | 0.00038 | 0.00007 | 0.32 | |
| 07 | Production | Document | PRIMARY | 2017-10-27 14:33:01 | 2017-10-27 14:33:14 | 1 | 1 | 1 | 1 | 14 | 0 | 0 | 0 | False | 1 | 13 | 1 | 4 | 0.00044 | 0.00027 | 0.50 | |
| 07 | Sales | SalesReason | PRIMARY | 2017-10-27 14:33:01 | 2017-10-27 14:33:14 | 1 | 0 | 0 | 1 | 4 | 1 | 1 | 10 | False | 1 | 10 | 1 | 0 | 0.00007 | 0.00000 | 0.05 | |
| 07 | Sales | SalesTerritory | PRIMARY | 2017-10-27 14:33:01 | 2017-10-27 14:33:14 | 1 | 0 | 1 | 5 | 10 | 1 | 1 | 10 | False | 1 | 10 | 1 | 2 | 0.00007 | 0.00014 | 0.15 | |
| 07 | Production | Culture | PRIMARY | 2017-10-27 14:33:01 | 2017-10-27 14:33:14 | 1 | 0 | 0 | 1 | 3 | 0 | 0 | 0 | False | 1 | 8 | 1 | 1 | 0.00007 | 0.00007 | 0.10 | |
| 07 | Production | ProductModelIllustration | PRIMARY | 2017-10-27 14:33:01 | 2017-10-27 14:33:14 | 1 | 0 | 2 | 0 | 3 | 0 | 0 | 0 | False | 1 | 7 | 1 | 0 | 0.00007 | 0.00000 | 0.05 | |
| 07 | Person | AddressType | PRIMARY | 2017-10-27 14:33:01 | 2017-10-27 14:33:14 | 1 | 0 | 0 | 1 | 4 | 1 | 1 | 6 | False | 1 | 6 | 1 | 2 | 0.00007 | 0.00014 | 0.15 | |
| 07 | Production | Illustration | PRIMARY | 2017-10-27 14:33:01 | 2017-10-27 14:33:14 | 1 | 0 | 0 | 1 | 3 | 1 | 1 | 7 | False | 1 | 5 | 1 | 0 | 0.00038 | 0.00000 | 0.27 | |
| 07 | Purchasing | ShipMethod | PRIMARY | 2017-10-27 14:33:01 | 2017-10-27 14:33:14 | 1 | 0 | 0 | 2 | 6 | 1 | 1 | 5 | False | 1 | 5 | 1 | 2 | 0.00007 | 0.00014 | 0.15 | |
| 07 | Production | ProductCategory | PRIMARY | 2017-10-27 14:33:01 | 2017-10-27 14:33:14 | 1 | 0 | 0 | 1 | 4 | 1 | 1 | 4 | False | 1 | 4 | 1 | 2 | 0.00007 | 0.00014 | 0.15 | |
| 07 | Production | ProductReview | PRIMARY | 2017-10-27 14:33:01 | 2017-10-27 14:33:14 | 1 | 0 | 1 | 0 | 8 | 1 | 1 | 4 | False | 1 | 4 | 1 | 1 | 0.00019 | 0.00019 | 0.27 | |
| 07 | HumanResources | Shift | PRIMARY | 2017-10-27 14:33:01 | 2017-10-27 14:33:14 | 1 | 0 | 0 | 1 | 5 | 1 | 1 | 3 | False | 1 | 3 | 1 | 2 | 0.00007 | 0.00014 | 0.15 | |
| 07 | Person | PhoneNumberType | PRIMARY | 2017-10-27 14:33:01 | 2017-10-27 14:33:14 | 1 | 0 | 0 | 1 | 3 | 1 | 1 | 3 | False | 1 | 3 | 1 | 0 | 0.00007 | 0.00000 | 0.05 | |
| 07 | Sales | ShoppingCartItem | PRIMARY | 2017-10-27 14:33:01 | 2017-10-27 14:33:14 | 1 | 0 | 1 | 0 | 6 | 1 | 1 | 5 | False | 1 | 3 | 1 | 1 | 0.00007 | 0.00007 | 0.10 | |
| 07 | dbo | AWBuildVersion | PRIMARY | 2017-10-27 14:33:01 | 2017-10-27 14:33:06 | 1 | 0 | 0 | 0 | 4 | 1 | 1 | 1 | False | 1 | 1 | 1 | 0 | 0.00007 | 0.00000 | 0.05 | |
| 07 | dbo | ErrorLog | PRIMARY | 2017-10-27 14:33:01 | 2017-10-27 14:33:01 | 1 | 0 | 0 | 0 | 9 | 1 | 1 | 1 | False | 1 | 0 | 1 | 0 | 0.00000 | 0.00000 | 0.00 | |