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
|