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