Datamart Table Relationships
- Fabio Scopel (Unlicensed)
Relationship between DataService entities | ||||
|---|---|---|---|---|
Parent Entity | Relationship | Child Entity | Parent Primary Key | Child Foreign Key |
CheckGratuities | one-to-many | CheckGratuityTaxes | id | CheckGratuityId |
Checks | one-to-many | CheckGratuities | id | CheckId |
one-to-many | ItemSales | id | CheckId | |
one-to-many | Payments | id | CheckId | |
ItemSaleComponents | one-to-many | ItemSaleComponentServingOptions | id | ItemSaleComponentId |
ItemSales | one-to-many | ItemSalesAdjustment | id | ItemSale_id |
one-to-many | ItemSaleComponents | id | ItemSaleId | |
one-to-many | ItemSaleServingOptions | id | ItemSaleId | |
one-to-many | ItemSaleTaxes | id | ItemSaleId | |
PartyInfo | one-to-many | Checks | id | PartyInfoId |
one-to-many | Customers | id | PartyInfo_Id | |
Punches | one-to-many | PuchAdjustment | id | PunchId |
one-to-many | Tips | id | PunchId | |
TimeRecords | one-to-many | Punches | id | TimeRecordId |
Tips | one-to-many | TipAdustments | id | TipId |
Tables with no DataService Relationships | ||||
Paidout | ||||
Cashout | ||||