Model
DuckDB (link)
Address
AddressID 1
AddressLine1 1970 Napa Ct.
AddressLine2 None
City Bothell
StateProvinceID 79
PostalCode 98011
SpatialLocation E6100000010CAE8BFC28BCE4474067A89189898A5EC0
rowguid 9AADCB0D-36CF-483F-84D8-585C2D4EC6E9
ModifiedDate 2018-12-03 00:00:00
Number of rows: 19614AddressType
AddressTypeID 1
Name Billing
rowguid B84F78B1-4EFE-4A0E-8CB7-70E9F112F886
ModifiedDate 2019-04-30 00:00:00
Number of rows: 6BillOfMaterials
BillOfMaterialsID 893
ProductAssemblyID
ComponentID 749
StartDate 2021-05-25 00:00:00
EndDate NaT
UnitMeasureCode EA
BOMLevel 0
PerAssemblyQty 1.0
ModifiedDate 2021-05-11 00:00:00
Number of rows: 2679 BusinessEntity
BusinessEntityID 1
rowguid 0C7D8F81-D7B1-4CF0-9C0A-4CD8B6B50087
ModifiedDate 2017-12-13 13:20:24.150000
Number of rows: 20777BusinessEntityAddress
BusinessEntityID 1
AddressID 249
AddressTypeID 2
rowguid 3A5D0A00-6739-4DFE-A8F7-844CD9DEE3DF
ModifiedDate 2025-09-11 11:15:06.967000
Number of rows: 19614BusinessEntityContact
BusinessEntityID 292
PersonID 291
ContactTypeID 11
rowguid 7D4D2DBC-4A44-48F5-911D-A63ABAFD5120
ModifiedDate 2017-12-13 13:21:02.243000
Number of rows: 909ContactType
ContactTypeID 1
Name Accounting Manager
ModifiedDate 2019-04-30 00:00:00
Number of rows: 20CountryRegion
CountryRegionCode AD
Name Andorra
ModifiedDate 2019-04-30 00:00:00
Number of rows: 238CountryRegionCurrency
CountryRegionCode AE
CurrencyCode AED
ModifiedDate 2025-02-07 10:17:21.510000
Number of rows: 109CreditCard
CreditCardID 1
CardType SuperiorCard
CardNumber 33332664695310
ExpMonth 11
ExpYear 2006
ModifiedDate 2024-07-28 00:00:00
Number of rows: 19118Culture
CultureID
Name Invariant Language (Invariant Country)
ModifiedDate 2019-04-30 00:00:00
Number of rows: 8Currency
CurrencyCode AED
Name Emirati Dirham
ModifiedDate 2019-04-30 00:00:00
Number of rows: 105CurrencyRate
CurrencyRateID 1
CurrencyRateDate 2022-05-30 00:00:00
FromCurrencyCode USD
ToCurrencyCode ARS
AverageRate 1.0
EndOfDayRate 1.0002
ModifiedDate 2022-05-30 00:00:00
Number of rows: 13532Customer
CustomerID 1
PersonID
StoreID 934
TerritoryID 1
AccountNumber AW00000001
rowguid 3F5AE95E-B87D-4AED-95B4-C3797AFCB74F
ModifiedDate 2025-09-11 11:15:07.263000
Number of rows: 19820 Department
DepartmentID 1
Name Engineering
GroupName Research and Development
ModifiedDate 2008-04-30 00:00:00
Number of rows: 16EmailAddress
BusinessEntityID 1
EmailAddressID 1
EmailAddress ken0@adventure-works.com
rowguid 8A1901E4-671B-431A-871C-EADB2942E9EE
ModifiedDate 2020-01-07 00:00:00
Number of rows: 19972Employee
BusinessEntityID 1
NationalIDNumber 295847284
LoginID adventure-works\ken0
OrganizationNode None
OrganizationLevel
JobTitle Chief Executive Officer
BirthDate 1969-01-29 00:00:00
MaritalStatus S
Gender M
HireDate 2009-01-14 00:00:00
SalariedFlag b'\x00\x00\x00\x00\x00\x00\x00\x00\x01'
VacationHours 99
SickLeaveHours 69
CurrentFlag b'\x00\x00\x00\x00\x00\x00\x00\x00\x01'
rowguid F01251E5-96A3-448D-981E-0F99D789110D
ModifiedDate 2014-06-30 00:00:00
Number of rows: 290 EmployeeDepartmentHistory
BusinessEntityID 1
DepartmentID 16
ShiftID 1
StartDate 2009-01-14 00:00:00
EndDate NaT
ModifiedDate 2009-01-13 00:00:00
Number of rows: 296EmployeePayHistory
BusinessEntityID 1
RateChangeDate 2009-01-14 00:00:00
Rate 125.5
PayFrequency 2
ModifiedDate 2014-06-30 00:00:00
Number of rows: 316Location
LocationID 1
Name Tool Crib
CostRate 0.0
Availability 0.0
ModifiedDate 2019-04-30 00:00:00
Number of rows: 14Password
BusinessEntityID 1
PasswordHash pbFwXWE99vobT6g+vPWFy93NtUU/orrIWafF01hccfM=
PasswordSalt bE3XiWw=
rowguid 329EACBE-C883-4F48-B8B6-17AA4627EFFF
ModifiedDate 2020-01-07 00:00:00
Number of rows: 19972Person
BusinessEntityID 1
PersonType EM
NameStyle b'\x00\x00\x00\x00\x00\x00\x00\x00\x00'
Title None
FirstName Ken
MiddleName J
LastName Sánchez
Suffix None
EmailPromotion 0
AdditionalContactInfo None
Demographics <IndividualSurvey xmlns="http://schemas.micros...
rowguid 92C4279F-1207-48A3-8448-4636514EB7E2
ModifiedDate 2020-01-07 00:00:00
Number of rows: 19972PersonCreditCard
BusinessEntityID 293
CreditCardID 17038
ModifiedDate 2024-07-30 00:00:00
Number of rows: 19118PersonPhone
BusinessEntityID 1
PhoneNumber 697-555-0142
PhoneNumberTypeID 1
ModifiedDate 2020-01-07 00:00:00
Number of rows: 19972PhoneNumberType
PhoneNumberTypeID 1
Name Cell
ModifiedDate 2017-12-13 13:19:22.273000
Number of rows: 3Product
ProductID 1
Name Adjustable Race
ProductNumber AR-5381
MakeFlag b'\x00\x00\x00\x00\x00\x00\x00\x00\x00'
FinishedGoodsFlag b'\x00\x00\x00\x00\x00\x00\x00\x00\x00'
Color None
SafetyStockLevel 1000
ReorderPoint 750
StandardCost 0.0
ListPrice 0.0
Size None
SizeUnitMeasureCode None
WeightUnitMeasureCode None
Weight NaN
DaysToManufacture 0
ProductLine None
Class None
Style None
ProductSubcategoryID <NA>
ProductModelID <NA>
SellStartDate 2019-04-30 00:00:00
SellEndDate NaT
DiscontinuedDate NaT
rowguid 694215B7-08F7-4C0D-ACB1-D734BA44C0C8
ModifiedDate 2025-02-07 10:01:36.827000
Number of rows: 504ProductCategory
ProductCategoryID 1
Name Bikes
rowguid CFBDA25C-DF71-47A7-B81B-64EE161AA37C
ModifiedDate 2019-04-30 00:00:00
Number of rows: 4ProductCostHistory
ProductID 707
StartDate 2022-05-30 00:00:00
EndDate 2023-05-29 00:00:00
StandardCost 12.0278
ModifiedDate 2023-05-29 00:00:00
Number of rows: 395ProductDescription
ProductDescriptionID 3
Description Chromoly steel.
rowguid 301EED3A-1A82-4855-99CB-2AFE8290D641
ModifiedDate 2024-04-29 00:00:00
Number of rows: 762ProductInventory
ProductID 1
LocationID 1
Shelf A
Bin 1
Quantity 408
rowguid 47A24246-6C43-48EB-968F-025738A8A410
ModifiedDate 2025-08-07 00:00:00
Number of rows: 1069ProductListPriceHistory
ProductID 707
StartDate 2022-05-30 00:00:00
EndDate 2023-05-29 00:00:00
ListPrice 33.6442
ModifiedDate 2023-05-29 00:00:00
Number of rows: 395ProductModel
ProductModelID 1
Name Classic Vest
CatalogDescription None
Instructions None
rowguid 29321D47-1E4C-4AAC-887C-19634328C25E
ModifiedDate 2024-04-29 00:00:00
Number of rows: 128ProductModelProductDescriptionCulture
ProductModelID 1
ProductDescriptionID 1199
CultureID en
ModifiedDate 2024-04-29 00:00:00
Number of rows: 762ProductSubcategory
ProductSubcategoryID 1
ProductCategoryID 1
Name Mountain Bikes
rowguid 2D364ADE-264A-433C-B092-4FCBF3804E01
ModifiedDate 2019-04-30 00:00:00
Number of rows: 37ProductVendor
ProductID 1
BusinessEntityID 1580
AverageLeadTime 17
StandardPrice 47.87
LastReceiptCost 50.2635
LastReceiptDate 2022-08-28 00:00:00
MinOrderQty 1
MaxOrderQty 5
OnOrderQty 3
UnitMeasureCode CS
ModifiedDate 2022-08-28 00:00:00
Number of rows: 460PurchaseOrderDetail
PurchaseOrderID 1
PurchaseOrderDetailID 1
DueDate 2022-04-29 00:00:00
OrderQty 4
ProductID 1
UnitPrice 50.26
LineTotal 201.04
ReceivedQty 3.0
RejectedQty 0.0
StockedQty 3.0
ModifiedDate 2022-04-22 00:00:00
Number of rows: 8845PurchaseOrderHeader
PurchaseOrderID 1
RevisionNumber 5
Status 4
EmployeeID 258
VendorID 1580
ShipMethodID 3
OrderDate 2022-04-15 00:00:00
ShipDate 2022-04-24 00:00:00
SubTotal 201.04
TaxAmt 16.0832
Freight 5.026
TotalDue 222.1492
ModifiedDate 2022-04-24 00:00:00
Number of rows: 4012SalesOrderDetail
SalesOrderID 43659
SalesOrderDetailID 1
CarrierTrackingNumber 4911-403C-98
OrderQty 1
ProductID 776
SpecialOfferID 1
UnitPrice 2024.994
UnitPriceDiscount 0.0
LineTotal 2024.994
rowguid B207C96D-D9E6-402B-8470-2CC176C42283
ModifiedDate 2022-05-30 00:00:00
Number of rows: 121317SalesOrderHeader
SalesOrderID 43659
RevisionNumber 10
OrderDate 2022-05-30 00:00:00
DueDate 2022-06-11 00:00:00
ShipDate 2022-06-06 00:00:00
Status 5
OnlineOrderFlag b'\x00\x00\x00\x00\x00\x00\x00\x00\x00'
SalesOrderNumber SO43659
PurchaseOrderNumber PO522145787
AccountNumber 10-4020-000676
CustomerID 29825
SalesPersonID 279
TerritoryID 5
BillToAddressID 985
ShipToAddressID 985
ShipMethodID 5
CreditCardID 16281
CreditCardApprovalCode 105041Vi84182
CurrencyRateID
SubTotal 20565.6206
TaxAmt 1971.5149
Freight 616.0984
TotalDue 23153.2339
Comment None
rowguid 79B65321-39CA-4115-9CBA-8FE0903E12E6
ModifiedDate 2022-06-06 00:00:00
Number of rows: 31465 SalesOrderHeaderSalesReason
SalesOrderID 43697
SalesReasonID 5
ModifiedDate 2022-05-30 00:00:00
Number of rows: 27647SalesPerson
BusinessEntityID 274
TerritoryID
SalesQuota NaN
Bonus 0.0
CommissionPct 0.0
SalesYTD 559697.5639
SalesLastYear 0.0
rowguid 48754992-9EE0-4C0E-8C94-9451604E3E02
ModifiedDate 2021-12-27 00:00:00
Number of rows: 17 SalesPersonQuotaHistory
BusinessEntityID 274
QuotaDate 2022-05-30 00:00:00
SalesQuota 28000.0
rowguid 99109BBF-8693-4587-BC23-6036EC89E1BE
ModifiedDate 2022-04-15 00:00:00
Number of rows: 163SalesReason
SalesReasonID 1
Name Price
ReasonType Other
ModifiedDate 2019-04-30 00:00:00
Number of rows: 10SalesTaxRate
SalesTaxRateID 1
StateProvinceID 1
TaxType 1
TaxRate 14.0
Name Canadian GST + Alberta Provincial Tax
rowguid 683DE5DD-521A-47D4-A573-06A3CDB1BC5D
ModifiedDate 2019-04-30 00:00:00
Number of rows: 29SalesTerritory
TerritoryID 1
Name Northwest
CountryRegionCode US
Grp North America
SalesYTD 7887186.7882
SalesLastYear 3298694.4938
CostYTD 0.0
CostLastYear 0.0
rowguid 43689A10-E30B-497F-B0DE-11DE20267FF7
ModifiedDate 2019-04-30 00:00:00
Number of rows: 10SalesTerritoryHistory
BusinessEntityID 275
TerritoryID 2
StartDate 2022-05-30 00:00:00
EndDate 2023-11-29 00:00:00
rowguid 8563CE6A-00FF-47D7-BA4D-3C3E1CDEF531
ModifiedDate 2023-11-22 00:00:00
Number of rows: 17ScrapReason
ScrapReasonID 1
Name Brake assembly not as ordered
ModifiedDate 2019-04-30 00:00:00
Number of rows: 16Shift
ShiftID 1
Name Day
StartTime 07:00:00
EndTime 15:00:00
ModifiedDate 2008-04-30 00:00:00
Number of rows: 3ShipMethod
ShipMethodID 1
Name XRQ - TRUCK GROUND
ShipBase 3.95
ShipRate 0.99
rowguid 6BE756D9-D7BE-4463-8F2C-AE60C710D606
ModifiedDate 2019-04-30 00:00:00
Number of rows: 5ShoppingCartItem
ShoppingCartItemID 2
ShoppingCartID 14951
Quantity 3
ProductID 862
DateCreated 2024-11-08 17:54:07.603000
ModifiedDate 2024-11-08 17:54:07.603000
Number of rows: 3SpecialOffer
SpecialOfferID 1
Description No Discount
DiscountPct 0.0
Type No Discount
Category No Discount
StartDate 2022-04-30 00:00:00
EndDate 2025-11-29 00:00:00
MinQty 0
MaxQty
rowguid 0290C4F5-191F-4337-AB6B-0A2DDE03CBF9
ModifiedDate 2022-03-31 00:00:00
Number of rows: 16 SpecialOfferProduct
SpecialOfferID 1
ProductID 680
rowguid BB30B868-D86C-4557-8DB2-4B2D0A83A0FB
ModifiedDate 2022-03-31 00:00:00
Number of rows: 538StateProvince
StateProvinceID 1
StateProvinceCode AB
CountryRegionCode CA
IsOnlyStateProvinceFlag b'\x00\x00\x00\x00\x00\x00\x00\x00\x00'
Name Alberta
TerritoryID 6
rowguid 298C2880-AB1C-4982-A5AD-A36EB4BA0D34
ModifiedDate 2025-02-07 10:17:21.587000
Number of rows: 181Store
BusinessEntityID 292
Name Next-Door Bike Store
SalesPersonID 279
Demographics <StoreSurvey xmlns="http://schemas.microsoft.c...
rowguid A22517E3-848D-4EBE-B9D9-7437F3432304
ModifiedDate 2025-09-11 11:15:07.497000
Number of rows: 701TransactionHistory
TransactionID 100000
ProductID 784
ReferenceOrderID 41590
ReferenceOrderLineID 0
TransactionDate 2024-07-30 00:00:00
TransactionType W
Quantity 2
ActualCost 0.0
ModifiedDate 2024-07-30 00:00:00
Number of rows: 113443TransactionHistoryArchive
TransactionID 1
ProductID 1
ReferenceOrderID 1
ReferenceOrderLineID 1
TransactionDate 2022-04-15 00:00:00
TransactionType P
Quantity 4
ActualCost 50.26
ModifiedDate 2022-04-15 00:00:00
Number of rows: 89253UnitMeasure
UnitMeasureCode BOX
Name Boxes
ModifiedDate 2019-04-30 00:00:00
Number of rows: 38Vendor
BusinessEntityID 1492
AccountNumber AUSTRALI0001
Name Australia Bike Retailer
CreditRating 1
PreferredVendorStatus b'\x00\x00\x00\x00\x00\x00\x00\x00\x01'
ActiveFlag b'\x00\x00\x00\x00\x00\x00\x00\x00\x01'
PurchasingWebServiceURL None
ModifiedDate 2022-12-22 00:00:00
Number of rows: 104WorkOrder
WorkOrderID 1
ProductID 722
OrderQty 8
StockedQty 8
ScrappedQty 0
StartDate 2022-06-02 00:00:00
EndDate 2022-06-12 00:00:00
DueDate 2022-06-13 00:00:00
ScrapReasonID
ModifiedDate 2022-06-12 00:00:00
Number of rows: 72591 WorkOrderRouting
WorkOrderID 13
ProductID 747
OperationSequence 1
LocationID 10
ScheduledStartDate 2022-06-02 00:00:00
ScheduledEndDate 2022-06-13 00:00:00
ActualStartDate 2022-06-02 00:00:00
ActualEndDate 2022-06-18 00:00:00
ActualResourceHrs 4.1
PlannedCost 92.25
ActualCost 92.25
ModifiedDate 2022-06-18 00:00:00
Number of rows: 67131YAML
tables:
- tablename: Address
columns:
- columnname: AddressID
type: INTEGER
- columnname: AddressLine1
type: VARCHAR
- columnname: AddressLine2
type: VARCHAR
- columnname: City
type: VARCHAR
- columnname: StateProvinceID
type: INTEGER
- columnname: PostalCode
type: VARCHAR
- columnname: SpatialLocation
type: VARCHAR
- columnname: rowguid
type: VARCHAR
- columnname: ModifiedDate
type: TIMESTAMP
primary_key:
- AddressID
- tablename: AddressType
columns:
- columnname: AddressTypeID
type: INTEGER
- columnname: Name
type: VARCHAR
- columnname: rowguid
type: VARCHAR
- columnname: ModifiedDate
type: TIMESTAMP
primary_key:
- AddressTypeID
- tablename: BillOfMaterials
columns:
- columnname: BillOfMaterialsID
type: INTEGER
- columnname: ProductAssemblyID
type: INTEGER
- columnname: ComponentID
type: INTEGER
- columnname: StartDate
type: TIMESTAMP
- columnname: EndDate
type: TIMESTAMP
- columnname: UnitMeasureCode
type: VARCHAR
- columnname: BOMLevel
type: SMALLINT
- columnname: PerAssemblyQty
type: DECIMAL(8,2)
- columnname: ModifiedDate
type: TIMESTAMP
primary_key:
- BillOfMaterialsID
foreign_keys:
- sourcecolumns:
- ProductAssemblyID
targettable: Product
targetcolumns:
- ProductID
- sourcecolumns:
- ComponentID
targettable: Product
targetcolumns:
- ProductID
- sourcecolumns:
- UnitMeasureCode
targettable: UnitMeasure
targetcolumns:
- UnitMeasureCode
- tablename: BusinessEntity
columns:
- columnname: BusinessEntityID
type: INTEGER
- columnname: rowguid
type: VARCHAR
- columnname: ModifiedDate
type: TIMESTAMP
primary_key:
- BusinessEntityID
- tablename: BusinessEntityAddress
columns:
- columnname: BusinessEntityID
type: INTEGER
- columnname: AddressID
type: INTEGER
- columnname: AddressTypeID
type: INTEGER
- columnname: rowguid
type: VARCHAR
- columnname: ModifiedDate
type: TIMESTAMP
primary_key:
- BusinessEntityID
- AddressID
- AddressTypeID
foreign_keys:
- sourcecolumns:
- AddressID
targettable: Address
targetcolumns:
- AddressID
- sourcecolumns:
- AddressTypeID
targettable: AddressType
targetcolumns:
- AddressTypeID
- sourcecolumns:
- BusinessEntityID
targettable: BusinessEntity
targetcolumns:
- BusinessEntityID
- tablename: BusinessEntityContact
columns:
- columnname: BusinessEntityID
type: INTEGER
- columnname: PersonID
type: INTEGER
- columnname: ContactTypeID
type: INTEGER
- columnname: rowguid
type: VARCHAR
- columnname: ModifiedDate
type: TIMESTAMP
primary_key:
- BusinessEntityID
- PersonID
- ContactTypeID
foreign_keys:
- sourcecolumns:
- PersonID
targettable: Person
targetcolumns:
- BusinessEntityID
- sourcecolumns:
- ContactTypeID
targettable: ContactType
targetcolumns:
- ContactTypeID
- sourcecolumns:
- BusinessEntityID
targettable: BusinessEntity
targetcolumns:
- BusinessEntityID
- tablename: ContactType
columns:
- columnname: ContactTypeID
type: INTEGER
- columnname: Name
type: VARCHAR
- columnname: ModifiedDate
type: TIMESTAMP
primary_key:
- ContactTypeID
- tablename: CountryRegion
columns:
- columnname: CountryRegionCode
type: VARCHAR
- columnname: Name
type: VARCHAR
- columnname: ModifiedDate
type: TIMESTAMP
primary_key:
- CountryRegionCode
- tablename: CountryRegionCurrency
columns:
- columnname: CountryRegionCode
type: VARCHAR
- columnname: CurrencyCode
type: VARCHAR
- columnname: ModifiedDate
type: TIMESTAMP
primary_key:
- CountryRegionCode
- CurrencyCode
foreign_keys:
- sourcecolumns:
- CountryRegionCode
targettable: CountryRegion
targetcolumns:
- CountryRegionCode
- sourcecolumns:
- CurrencyCode
targettable: Currency
targetcolumns:
- CurrencyCode
- tablename: CreditCard
columns:
- columnname: CreditCardID
type: INTEGER
- columnname: CardType
type: VARCHAR
- columnname: CardNumber
type: VARCHAR
- columnname: ExpMonth
type: UTINYINT
- columnname: ExpYear
type: SMALLINT
- columnname: ModifiedDate
type: TIMESTAMP
primary_key:
- CreditCardID
- tablename: Culture
columns:
- columnname: CultureID
type: VARCHAR
- columnname: Name
type: VARCHAR
- columnname: ModifiedDate
type: TIMESTAMP
primary_key:
- CultureID
- tablename: Currency
columns:
- columnname: CurrencyCode
type: VARCHAR
- columnname: Name
type: VARCHAR
- columnname: ModifiedDate
type: TIMESTAMP
primary_key:
- CurrencyCode
- tablename: CurrencyRate
columns:
- columnname: CurrencyRateID
type: INTEGER
- columnname: CurrencyRateDate
type: TIMESTAMP
- columnname: FromCurrencyCode
type: VARCHAR
- columnname: ToCurrencyCode
type: VARCHAR
- columnname: AverageRate
type: DECIMAL(18,4)
- columnname: EndOfDayRate
type: DECIMAL(18,4)
- columnname: ModifiedDate
type: TIMESTAMP
primary_key:
- CurrencyRateID
foreign_keys:
- sourcecolumns:
- FromCurrencyCode
targettable: Currency
targetcolumns:
- CurrencyCode
- sourcecolumns:
- ToCurrencyCode
targettable: Currency
targetcolumns:
- CurrencyCode
- tablename: Customer
columns:
- columnname: CustomerID
type: INTEGER
- columnname: PersonID
type: INTEGER
- columnname: StoreID
type: INTEGER
- columnname: TerritoryID
type: INTEGER
- columnname: AccountNumber
type: VARCHAR
- columnname: rowguid
type: VARCHAR
- columnname: ModifiedDate
type: TIMESTAMP
primary_key:
- CustomerID
foreign_keys:
- sourcecolumns:
- PersonID
targettable: Person
targetcolumns:
- BusinessEntityID
- sourcecolumns:
- StoreID
targettable: Store
targetcolumns:
- BusinessEntityID
- sourcecolumns:
- TerritoryID
targettable: SalesTerritory
targetcolumns:
- TerritoryID
- tablename: Department
columns:
- columnname: DepartmentID
type: SMALLINT
- columnname: Name
type: VARCHAR
- columnname: GroupName
type: VARCHAR
- columnname: ModifiedDate
type: TIMESTAMP
primary_key:
- DepartmentID
- tablename: EmailAddress
columns:
- columnname: BusinessEntityID
type: INTEGER
- columnname: EmailAddressID
type: INTEGER
- columnname: EmailAddress
type: VARCHAR
- columnname: rowguid
type: VARCHAR
- columnname: ModifiedDate
type: TIMESTAMP
primary_key:
- BusinessEntityID
- EmailAddressID
foreign_keys:
- sourcecolumns:
- BusinessEntityID
targettable: Person
targetcolumns:
- BusinessEntityID
- tablename: Employee
columns:
- columnname: BusinessEntityID
type: INTEGER
- columnname: NationalIDNumber
type: VARCHAR
- columnname: LoginID
type: VARCHAR
- columnname: OrganizationNode
type: VARCHAR
- columnname: OrganizationLevel
type: INTEGER
- columnname: JobTitle
type: VARCHAR
- columnname: BirthDate
type: DATE
- columnname: MaritalStatus
type: VARCHAR
- columnname: Gender
type: VARCHAR
- columnname: HireDate
type: DATE
- columnname: SalariedFlag
type: BIT
- columnname: VacationHours
type: SMALLINT
- columnname: SickLeaveHours
type: SMALLINT
- columnname: CurrentFlag
type: BIT
- columnname: rowguid
type: VARCHAR
- columnname: ModifiedDate
type: TIMESTAMP
primary_key:
- BusinessEntityID
foreign_keys:
- sourcecolumns:
- BusinessEntityID
targettable: Person
targetcolumns:
- BusinessEntityID
- tablename: EmployeeDepartmentHistory
columns:
- columnname: BusinessEntityID
type: INTEGER
- columnname: DepartmentID
type: SMALLINT
- columnname: ShiftID
type: UTINYINT
- columnname: StartDate
type: DATE
- columnname: EndDate
type: DATE
- columnname: ModifiedDate
type: TIMESTAMP
primary_key:
- BusinessEntityID
- StartDate
- DepartmentID
- ShiftID
foreign_keys:
- sourcecolumns:
- DepartmentID
targettable: Department
targetcolumns:
- DepartmentID
- sourcecolumns:
- BusinessEntityID
targettable: Employee
targetcolumns:
- BusinessEntityID
- sourcecolumns:
- ShiftID
targettable: Shift
targetcolumns:
- ShiftID
- tablename: EmployeePayHistory
columns:
- columnname: BusinessEntityID
type: INTEGER
- columnname: RateChangeDate
type: TIMESTAMP
- columnname: Rate
type: DECIMAL(18,4)
- columnname: PayFrequency
type: UTINYINT
- columnname: ModifiedDate
type: TIMESTAMP
primary_key:
- BusinessEntityID
- RateChangeDate
foreign_keys:
- sourcecolumns:
- BusinessEntityID
targettable: Employee
targetcolumns:
- BusinessEntityID
- tablename: Location
columns:
- columnname: LocationID
type: SMALLINT
- columnname: Name
type: VARCHAR
- columnname: CostRate
type: DECIMAL(18,4)
- columnname: Availability
type: DECIMAL(8,2)
- columnname: ModifiedDate
type: TIMESTAMP
primary_key:
- LocationID
- tablename: Password
columns:
- columnname: BusinessEntityID
type: INTEGER
- columnname: PasswordHash
type: VARCHAR
- columnname: PasswordSalt
type: VARCHAR
- columnname: rowguid
type: VARCHAR
- columnname: ModifiedDate
type: TIMESTAMP
primary_key:
- BusinessEntityID
foreign_keys:
- sourcecolumns:
- BusinessEntityID
targettable: Person
targetcolumns:
- BusinessEntityID
- tablename: Person
columns:
- columnname: BusinessEntityID
type: INTEGER
- columnname: PersonType
type: VARCHAR
- columnname: NameStyle
type: BIT
- columnname: Title
type: VARCHAR
- columnname: FirstName
type: VARCHAR
- columnname: MiddleName
type: VARCHAR
- columnname: LastName
type: VARCHAR
- columnname: Suffix
type: VARCHAR
- columnname: EmailPromotion
type: INTEGER
- columnname: AdditionalContactInfo
type: VARCHAR
- columnname: Demographics
type: VARCHAR
- columnname: rowguid
type: VARCHAR
- columnname: ModifiedDate
type: TIMESTAMP
primary_key:
- BusinessEntityID
foreign_keys:
- sourcecolumns:
- BusinessEntityID
targettable: BusinessEntity
targetcolumns:
- BusinessEntityID
- tablename: PersonCreditCard
columns:
- columnname: BusinessEntityID
type: INTEGER
- columnname: CreditCardID
type: INTEGER
- columnname: ModifiedDate
type: TIMESTAMP
primary_key:
- BusinessEntityID
- CreditCardID
foreign_keys:
- sourcecolumns:
- BusinessEntityID
targettable: Person
targetcolumns:
- BusinessEntityID
- sourcecolumns:
- CreditCardID
targettable: CreditCard
targetcolumns:
- CreditCardID
- tablename: PersonPhone
columns:
- columnname: BusinessEntityID
type: INTEGER
- columnname: PhoneNumber
type: VARCHAR
- columnname: PhoneNumberTypeID
type: INTEGER
- columnname: ModifiedDate
type: TIMESTAMP
primary_key:
- BusinessEntityID
- PhoneNumber
- PhoneNumberTypeID
foreign_keys:
- sourcecolumns:
- BusinessEntityID
targettable: Person
targetcolumns:
- BusinessEntityID
- sourcecolumns:
- PhoneNumberTypeID
targettable: PhoneNumberType
targetcolumns:
- PhoneNumberTypeID
- tablename: PhoneNumberType
columns:
- columnname: PhoneNumberTypeID
type: INTEGER
- columnname: Name
type: VARCHAR
- columnname: ModifiedDate
type: TIMESTAMP
primary_key:
- PhoneNumberTypeID
- tablename: Product
columns:
- columnname: ProductID
type: INTEGER
- columnname: Name
type: VARCHAR
- columnname: ProductNumber
type: VARCHAR
- columnname: MakeFlag
type: BIT
- columnname: FinishedGoodsFlag
type: BIT
- columnname: Color
type: VARCHAR
- columnname: SafetyStockLevel
type: SMALLINT
- columnname: ReorderPoint
type: SMALLINT
- columnname: StandardCost
type: DECIMAL(18,4)
- columnname: ListPrice
type: DECIMAL(18,4)
- columnname: Size
type: VARCHAR
- columnname: SizeUnitMeasureCode
type: VARCHAR
- columnname: WeightUnitMeasureCode
type: VARCHAR
- columnname: Weight
type: DECIMAL(8,2)
- columnname: DaysToManufacture
type: INTEGER
- columnname: ProductLine
type: VARCHAR
- columnname: Class
type: VARCHAR
- columnname: Style
type: VARCHAR
- columnname: ProductSubcategoryID
type: INTEGER
- columnname: ProductModelID
type: INTEGER
- columnname: SellStartDate
type: TIMESTAMP
- columnname: SellEndDate
type: TIMESTAMP
- columnname: DiscontinuedDate
type: TIMESTAMP
- columnname: rowguid
type: VARCHAR
- columnname: ModifiedDate
type: TIMESTAMP
primary_key:
- ProductID
foreign_keys:
- sourcecolumns:
- SizeUnitMeasureCode
targettable: UnitMeasure
targetcolumns:
- UnitMeasureCode
- sourcecolumns:
- WeightUnitMeasureCode
targettable: UnitMeasure
targetcolumns:
- UnitMeasureCode
- sourcecolumns:
- ProductModelID
targettable: ProductModel
targetcolumns:
- ProductModelID
- sourcecolumns:
- ProductSubcategoryID
targettable: ProductSubcategory
targetcolumns:
- ProductSubcategoryID
- tablename: ProductCategory
columns:
- columnname: ProductCategoryID
type: INTEGER
- columnname: Name
type: VARCHAR
- columnname: rowguid
type: VARCHAR
- columnname: ModifiedDate
type: TIMESTAMP
primary_key:
- ProductCategoryID
- tablename: ProductCostHistory
columns:
- columnname: ProductID
type: INTEGER
- columnname: StartDate
type: TIMESTAMP
- columnname: EndDate
type: TIMESTAMP
- columnname: StandardCost
type: DECIMAL(18,4)
- columnname: ModifiedDate
type: TIMESTAMP
primary_key:
- ProductID
- StartDate
foreign_keys:
- sourcecolumns:
- ProductID
targettable: Product
targetcolumns:
- ProductID
- tablename: ProductDescription
columns:
- columnname: ProductDescriptionID
type: INTEGER
- columnname: Description
type: VARCHAR
- columnname: rowguid
type: VARCHAR
- columnname: ModifiedDate
type: TIMESTAMP
primary_key:
- ProductDescriptionID
- tablename: ProductInventory
columns:
- columnname: ProductID
type: INTEGER
- columnname: LocationID
type: SMALLINT
- columnname: Shelf
type: VARCHAR
- columnname: Bin
type: UTINYINT
- columnname: Quantity
type: SMALLINT
- columnname: rowguid
type: VARCHAR
- columnname: ModifiedDate
type: TIMESTAMP
primary_key:
- ProductID
- LocationID
foreign_keys:
- sourcecolumns:
- LocationID
targettable: Location
targetcolumns:
- LocationID
- sourcecolumns:
- ProductID
targettable: Product
targetcolumns:
- ProductID
- tablename: ProductListPriceHistory
columns:
- columnname: ProductID
type: INTEGER
- columnname: StartDate
type: TIMESTAMP
- columnname: EndDate
type: TIMESTAMP
- columnname: ListPrice
type: DECIMAL(18,4)
- columnname: ModifiedDate
type: TIMESTAMP
primary_key:
- ProductID
- StartDate
foreign_keys:
- sourcecolumns:
- ProductID
targettable: Product
targetcolumns:
- ProductID
- tablename: ProductModel
columns:
- columnname: ProductModelID
type: INTEGER
- columnname: Name
type: VARCHAR
- columnname: CatalogDescription
type: VARCHAR
- columnname: Instructions
type: VARCHAR
- columnname: rowguid
type: VARCHAR
- columnname: ModifiedDate
type: TIMESTAMP
primary_key:
- ProductModelID
- tablename: ProductModelProductDescriptionCulture
columns:
- columnname: ProductModelID
type: INTEGER
- columnname: ProductDescriptionID
type: INTEGER
- columnname: CultureID
type: VARCHAR
- columnname: ModifiedDate
type: TIMESTAMP
primary_key:
- ProductModelID
- ProductDescriptionID
- CultureID
foreign_keys:
- sourcecolumns:
- ProductDescriptionID
targettable: ProductDescription
targetcolumns:
- ProductDescriptionID
- sourcecolumns:
- CultureID
targettable: Culture
targetcolumns:
- CultureID
- sourcecolumns:
- ProductModelID
targettable: ProductModel
targetcolumns:
- ProductModelID
- tablename: ProductSubcategory
columns:
- columnname: ProductSubcategoryID
type: INTEGER
- columnname: ProductCategoryID
type: INTEGER
- columnname: Name
type: VARCHAR
- columnname: rowguid
type: VARCHAR
- columnname: ModifiedDate
type: TIMESTAMP
primary_key:
- ProductSubcategoryID
foreign_keys:
- sourcecolumns:
- ProductCategoryID
targettable: ProductCategory
targetcolumns:
- ProductCategoryID
- tablename: ProductVendor
columns:
- columnname: ProductID
type: INTEGER
- columnname: BusinessEntityID
type: INTEGER
- columnname: AverageLeadTime
type: INTEGER
- columnname: StandardPrice
type: DECIMAL(18,4)
- columnname: LastReceiptCost
type: DECIMAL(18,4)
- columnname: LastReceiptDate
type: TIMESTAMP
- columnname: MinOrderQty
type: INTEGER
- columnname: MaxOrderQty
type: INTEGER
- columnname: OnOrderQty
type: INTEGER
- columnname: UnitMeasureCode
type: VARCHAR
- columnname: ModifiedDate
type: TIMESTAMP
primary_key:
- ProductID
- BusinessEntityID
foreign_keys:
- sourcecolumns:
- ProductID
targettable: Product
targetcolumns:
- ProductID
- sourcecolumns:
- UnitMeasureCode
targettable: UnitMeasure
targetcolumns:
- UnitMeasureCode
- sourcecolumns:
- BusinessEntityID
targettable: Vendor
targetcolumns:
- BusinessEntityID
- tablename: PurchaseOrderDetail
columns:
- columnname: PurchaseOrderID
type: INTEGER
- columnname: PurchaseOrderDetailID
type: INTEGER
- columnname: DueDate
type: TIMESTAMP
- columnname: OrderQty
type: SMALLINT
- columnname: ProductID
type: INTEGER
- columnname: UnitPrice
type: DECIMAL(18,4)
- columnname: LineTotal
type: DECIMAL(18,4)
- columnname: ReceivedQty
type: DECIMAL(8,2)
- columnname: RejectedQty
type: DECIMAL(8,2)
- columnname: StockedQty
type: DECIMAL(8,2)
- columnname: ModifiedDate
type: TIMESTAMP
primary_key:
- PurchaseOrderID
- PurchaseOrderDetailID
foreign_keys:
- sourcecolumns:
- ProductID
targettable: Product
targetcolumns:
- ProductID
- sourcecolumns:
- PurchaseOrderID
targettable: PurchaseOrderHeader
targetcolumns:
- PurchaseOrderID
- tablename: PurchaseOrderHeader
columns:
- columnname: PurchaseOrderID
type: INTEGER
- columnname: RevisionNumber
type: UTINYINT
- columnname: Status
type: UTINYINT
- columnname: EmployeeID
type: INTEGER
- columnname: VendorID
type: INTEGER
- columnname: ShipMethodID
type: INTEGER
- columnname: OrderDate
type: TIMESTAMP
- columnname: ShipDate
type: TIMESTAMP
- columnname: SubTotal
type: DECIMAL(18,4)
- columnname: TaxAmt
type: DECIMAL(18,4)
- columnname: Freight
type: DECIMAL(18,4)
- columnname: TotalDue
type: DECIMAL(18,4)
- columnname: ModifiedDate
type: TIMESTAMP
primary_key:
- PurchaseOrderID
- tablename: SalesOrderDetail
columns:
- columnname: SalesOrderID
type: INTEGER
- columnname: SalesOrderDetailID
type: INTEGER
- columnname: CarrierTrackingNumber
type: VARCHAR
- columnname: OrderQty
type: SMALLINT
- columnname: ProductID
type: INTEGER
- columnname: SpecialOfferID
type: INTEGER
- columnname: UnitPrice
type: DECIMAL(18,4)
- columnname: UnitPriceDiscount
type: DECIMAL(18,4)
- columnname: LineTotal
type: DECIMAL(18,4)
- columnname: rowguid
type: VARCHAR
- columnname: ModifiedDate
type: TIMESTAMP
primary_key:
- SalesOrderID
- SalesOrderDetailID
foreign_keys:
- sourcecolumns:
- SalesOrderID
targettable: SalesOrderHeader
targetcolumns:
- SalesOrderID
- sourcecolumns:
- SpecialOfferID
- ProductID
targettable: SpecialOfferProduct
targetcolumns:
- SpecialOfferID
- ProductID
- tablename: SalesOrderHeader
columns:
- columnname: SalesOrderID
type: INTEGER
- columnname: RevisionNumber
type: UTINYINT
- columnname: OrderDate
type: TIMESTAMP
- columnname: DueDate
type: TIMESTAMP
- columnname: ShipDate
type: TIMESTAMP
- columnname: Status
type: UTINYINT
- columnname: OnlineOrderFlag
type: BIT
- columnname: SalesOrderNumber
type: VARCHAR
- columnname: PurchaseOrderNumber
type: VARCHAR
- columnname: AccountNumber
type: VARCHAR
- columnname: CustomerID
type: INTEGER
- columnname: SalesPersonID
type: INTEGER
- columnname: TerritoryID
type: INTEGER
- columnname: BillToAddressID
type: INTEGER
- columnname: ShipToAddressID
type: INTEGER
- columnname: ShipMethodID
type: INTEGER
- columnname: CreditCardID
type: INTEGER
- columnname: CreditCardApprovalCode
type: VARCHAR
- columnname: CurrencyRateID
type: INTEGER
- columnname: SubTotal
type: DECIMAL(18,4)
- columnname: TaxAmt
type: DECIMAL(18,4)
- columnname: Freight
type: DECIMAL(18,4)
- columnname: TotalDue
type: DECIMAL(18,4)
- columnname: Comment
type: VARCHAR
- columnname: rowguid
type: VARCHAR
- columnname: ModifiedDate
type: TIMESTAMP
primary_key:
- SalesOrderID
foreign_keys:
- sourcecolumns:
- BillToAddressID
targettable: Address
targetcolumns:
- AddressID
- sourcecolumns:
- ShipToAddressID
targettable: Address
targetcolumns:
- AddressID
- sourcecolumns:
- CreditCardID
targettable: CreditCard
targetcolumns:
- CreditCardID
- sourcecolumns:
- CurrencyRateID
targettable: CurrencyRate
targetcolumns:
- CurrencyRateID
- sourcecolumns:
- CustomerID
targettable: Customer
targetcolumns:
- CustomerID
- sourcecolumns:
- SalesPersonID
targettable: SalesPerson
targetcolumns:
- BusinessEntityID
- sourcecolumns:
- ShipMethodID
targettable: ShipMethod
targetcolumns:
- ShipMethodID
- sourcecolumns:
- TerritoryID
targettable: SalesTerritory
targetcolumns:
- TerritoryID
- tablename: SalesOrderHeaderSalesReason
columns:
- columnname: SalesOrderID
type: INTEGER
- columnname: SalesReasonID
type: INTEGER
- columnname: ModifiedDate
type: TIMESTAMP
primary_key:
- SalesOrderID
- SalesReasonID
foreign_keys:
- sourcecolumns:
- SalesOrderID
targettable: SalesOrderHeader
targetcolumns:
- SalesOrderID
- sourcecolumns:
- SalesReasonID
targettable: SalesReason
targetcolumns:
- SalesReasonID
- tablename: SalesPerson
columns:
- columnname: BusinessEntityID
type: INTEGER
- columnname: TerritoryID
type: INTEGER
- columnname: SalesQuota
type: DECIMAL(18,4)
- columnname: Bonus
type: DECIMAL(18,4)
- columnname: CommissionPct
type: DECIMAL(18,4)
- columnname: SalesYTD
type: DECIMAL(18,4)
- columnname: SalesLastYear
type: DECIMAL(18,4)
- columnname: rowguid
type: VARCHAR
- columnname: ModifiedDate
type: TIMESTAMP
primary_key:
- BusinessEntityID
foreign_keys:
- sourcecolumns:
- BusinessEntityID
targettable: Employee
targetcolumns:
- BusinessEntityID
- sourcecolumns:
- TerritoryID
targettable: SalesTerritory
targetcolumns:
- TerritoryID
- tablename: SalesPersonQuotaHistory
columns:
- columnname: BusinessEntityID
type: INTEGER
- columnname: QuotaDate
type: TIMESTAMP
- columnname: SalesQuota
type: DECIMAL(18,4)
- columnname: rowguid
type: VARCHAR
- columnname: ModifiedDate
type: TIMESTAMP
primary_key:
- BusinessEntityID
- QuotaDate
foreign_keys:
- sourcecolumns:
- BusinessEntityID
targettable: SalesPerson
targetcolumns:
- BusinessEntityID
- tablename: SalesReason
columns:
- columnname: SalesReasonID
type: INTEGER
- columnname: Name
type: VARCHAR
- columnname: ReasonType
type: VARCHAR
- columnname: ModifiedDate
type: TIMESTAMP
primary_key:
- SalesReasonID
- tablename: SalesTaxRate
columns:
- columnname: SalesTaxRateID
type: INTEGER
- columnname: StateProvinceID
type: INTEGER
- columnname: TaxType
type: UTINYINT
- columnname: TaxRate
type: DECIMAL(8,4)
- columnname: Name
type: VARCHAR
- columnname: rowguid
type: VARCHAR
- columnname: ModifiedDate
type: TIMESTAMP
primary_key:
- SalesTaxRateID
foreign_keys:
- sourcecolumns:
- StateProvinceID
targettable: StateProvince
targetcolumns:
- StateProvinceID
- tablename: SalesTerritory
columns:
- columnname: TerritoryID
type: INTEGER
- columnname: Name
type: VARCHAR
- columnname: CountryRegionCode
type: VARCHAR
- columnname: Grp
type: VARCHAR
- columnname: SalesYTD
type: DECIMAL(18,4)
- columnname: SalesLastYear
type: DECIMAL(18,4)
- columnname: CostYTD
type: DECIMAL(18,4)
- columnname: CostLastYear
type: DECIMAL(18,4)
- columnname: rowguid
type: VARCHAR
- columnname: ModifiedDate
type: TIMESTAMP
primary_key:
- TerritoryID
foreign_keys:
- sourcecolumns:
- CountryRegionCode
targettable: CountryRegion
targetcolumns:
- CountryRegionCode
- tablename: SalesTerritoryHistory
columns:
- columnname: BusinessEntityID
type: INTEGER
- columnname: TerritoryID
type: INTEGER
- columnname: StartDate
type: TIMESTAMP
- columnname: EndDate
type: TIMESTAMP
- columnname: rowguid
type: VARCHAR
- columnname: ModifiedDate
type: TIMESTAMP
primary_key:
- BusinessEntityID
- StartDate
- TerritoryID
foreign_keys:
- sourcecolumns:
- BusinessEntityID
targettable: SalesPerson
targetcolumns:
- BusinessEntityID
- sourcecolumns:
- TerritoryID
targettable: SalesTerritory
targetcolumns:
- TerritoryID
- tablename: ScrapReason
columns:
- columnname: ScrapReasonID
type: SMALLINT
- columnname: Name
type: VARCHAR
- columnname: ModifiedDate
type: TIMESTAMP
primary_key:
- ScrapReasonID
- tablename: Shift
columns:
- columnname: ShiftID
type: UTINYINT
- columnname: Name
type: VARCHAR
- columnname: StartTime
type: TIME
- columnname: EndTime
type: TIME
- columnname: ModifiedDate
type: TIMESTAMP
primary_key:
- ShiftID
- tablename: ShipMethod
columns:
- columnname: ShipMethodID
type: INTEGER
- columnname: Name
type: VARCHAR
- columnname: ShipBase
type: DECIMAL(18,4)
- columnname: ShipRate
type: DECIMAL(18,4)
- columnname: rowguid
type: VARCHAR
- columnname: ModifiedDate
type: TIMESTAMP
primary_key:
- ShipMethodID
- tablename: ShoppingCartItem
columns:
- columnname: ShoppingCartItemID
type: INTEGER
- columnname: ShoppingCartID
type: VARCHAR
- columnname: Quantity
type: INTEGER
- columnname: ProductID
type: INTEGER
- columnname: DateCreated
type: TIMESTAMP
- columnname: ModifiedDate
type: TIMESTAMP
primary_key:
- ShoppingCartItemID
foreign_keys:
- sourcecolumns:
- ProductID
targettable: Product
targetcolumns:
- ProductID
- tablename: SpecialOffer
columns:
- columnname: SpecialOfferID
type: INTEGER
- columnname: Description
type: VARCHAR
- columnname: DiscountPct
type: DECIMAL(18,4)
- columnname: Type
type: VARCHAR
- columnname: Category
type: VARCHAR
- columnname: StartDate
type: TIMESTAMP
- columnname: EndDate
type: TIMESTAMP
- columnname: MinQty
type: INTEGER
- columnname: MaxQty
type: INTEGER
- columnname: rowguid
type: VARCHAR
- columnname: ModifiedDate
type: TIMESTAMP
primary_key:
- SpecialOfferID
- tablename: SpecialOfferProduct
columns:
- columnname: SpecialOfferID
type: INTEGER
- columnname: ProductID
type: INTEGER
- columnname: rowguid
type: VARCHAR
- columnname: ModifiedDate
type: TIMESTAMP
primary_key:
- SpecialOfferID
- ProductID
foreign_keys:
- sourcecolumns:
- ProductID
targettable: Product
targetcolumns:
- ProductID
- sourcecolumns:
- SpecialOfferID
targettable: SpecialOffer
targetcolumns:
- SpecialOfferID
- tablename: StateProvince
columns:
- columnname: StateProvinceID
type: INTEGER
- columnname: StateProvinceCode
type: VARCHAR
- columnname: CountryRegionCode
type: VARCHAR
- columnname: IsOnlyStateProvinceFlag
type: BIT
- columnname: Name
type: VARCHAR
- columnname: TerritoryID
type: INTEGER
- columnname: rowguid
type: VARCHAR
- columnname: ModifiedDate
type: TIMESTAMP
primary_key:
- StateProvinceID
foreign_keys:
- sourcecolumns:
- CountryRegionCode
targettable: CountryRegion
targetcolumns:
- CountryRegionCode
- sourcecolumns:
- TerritoryID
targettable: SalesTerritory
targetcolumns:
- TerritoryID
- tablename: Store
columns:
- columnname: BusinessEntityID
type: INTEGER
- columnname: Name
type: VARCHAR
- columnname: SalesPersonID
type: INTEGER
- columnname: Demographics
type: VARCHAR
- columnname: rowguid
type: VARCHAR
- columnname: ModifiedDate
type: TIMESTAMP
primary_key:
- BusinessEntityID
foreign_keys:
- sourcecolumns:
- BusinessEntityID
targettable: BusinessEntity
targetcolumns:
- BusinessEntityID
- sourcecolumns:
- SalesPersonID
targettable: SalesPerson
targetcolumns:
- BusinessEntityID
- tablename: TransactionHistory
columns:
- columnname: TransactionID
type: INTEGER
- columnname: ProductID
type: INTEGER
- columnname: ReferenceOrderID
type: INTEGER
- columnname: ReferenceOrderLineID
type: INTEGER
- columnname: TransactionDate
type: TIMESTAMP
- columnname: TransactionType
type: VARCHAR
- columnname: Quantity
type: INTEGER
- columnname: ActualCost
type: DECIMAL(18,4)
- columnname: ModifiedDate
type: TIMESTAMP
primary_key:
- TransactionID
foreign_keys:
- sourcecolumns:
- ProductID
targettable: Product
targetcolumns:
- ProductID
- tablename: TransactionHistoryArchive
columns:
- columnname: TransactionID
type: INTEGER
- columnname: ProductID
type: INTEGER
- columnname: ReferenceOrderID
type: INTEGER
- columnname: ReferenceOrderLineID
type: INTEGER
- columnname: TransactionDate
type: TIMESTAMP
- columnname: TransactionType
type: VARCHAR
- columnname: Quantity
type: INTEGER
- columnname: ActualCost
type: DECIMAL(18,4)
- columnname: ModifiedDate
type: TIMESTAMP
primary_key:
- TransactionID
foreign_keys:
- sourcecolumns:
- ProductID
targettable: Product
targetcolumns:
- ProductID
- tablename: UnitMeasure
columns:
- columnname: UnitMeasureCode
type: VARCHAR
- columnname: Name
type: VARCHAR
- columnname: ModifiedDate
type: TIMESTAMP
primary_key:
- UnitMeasureCode
- tablename: Vendor
columns:
- columnname: BusinessEntityID
type: INTEGER
- columnname: AccountNumber
type: VARCHAR
- columnname: Name
type: VARCHAR
- columnname: CreditRating
type: UTINYINT
- columnname: PreferredVendorStatus
type: BIT
- columnname: ActiveFlag
type: BIT
- columnname: PurchasingWebServiceURL
type: VARCHAR
- columnname: ModifiedDate
type: TIMESTAMP
primary_key:
- BusinessEntityID
foreign_keys:
- sourcecolumns:
- BusinessEntityID
targettable: BusinessEntity
targetcolumns:
- BusinessEntityID
- tablename: WorkOrder
columns:
- columnname: WorkOrderID
type: INTEGER
- columnname: ProductID
type: INTEGER
- columnname: OrderQty
type: INTEGER
- columnname: StockedQty
type: INTEGER
- columnname: ScrappedQty
type: SMALLINT
- columnname: StartDate
type: TIMESTAMP
- columnname: EndDate
type: TIMESTAMP
- columnname: DueDate
type: TIMESTAMP
- columnname: ScrapReasonID
type: SMALLINT
- columnname: ModifiedDate
type: TIMESTAMP
primary_key:
- WorkOrderID
foreign_keys:
- sourcecolumns:
- ProductID
targettable: Product
targetcolumns:
- ProductID
- sourcecolumns:
- ScrapReasonID
targettable: ScrapReason
targetcolumns:
- ScrapReasonID
- tablename: WorkOrderRouting
columns:
- columnname: WorkOrderID
type: INTEGER
- columnname: ProductID
type: INTEGER
- columnname: OperationSequence
type: SMALLINT
- columnname: LocationID
type: SMALLINT
- columnname: ScheduledStartDate
type: TIMESTAMP
- columnname: ScheduledEndDate
type: TIMESTAMP
- columnname: ActualStartDate
type: TIMESTAMP
- columnname: ActualEndDate
type: TIMESTAMP
- columnname: ActualResourceHrs
type: DECIMAL(9,4)
- columnname: PlannedCost
type: DECIMAL(18,4)
- columnname: ActualCost
type: DECIMAL(18,4)
- columnname: ModifiedDate
type: TIMESTAMP
primary_key:
- WorkOrderID
- ProductID
- OperationSequence
foreign_keys:
- sourcecolumns:
- LocationID
targettable: Location
targetcolumns:
- LocationID
- sourcecolumns:
- WorkOrderID
targettable: WorkOrder
targetcolumns:
- WorkOrderID