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