tempCoffee
Tables (6)
Detail (tmtktDetail)
- Key4 — varchar — Primary key — NOT NULL
- Key5 — int — Primary key — NOT NULL
- Key2 — varchar — Primary key — NOT NULL
- Key — varchar — Primary key — NOT NULL
- Key3 — int — Primary key — NOT NULL
- field — int — NOT NULL
- Field — int
- Field2 — int
- Field3 — char(1)
- Field4
ItemCode (TktItems)
- Key — varchar — Primary key — NOT NULL
- Field2 — char(1)
- Field
SubCode
- Key2 — varchar — Primary key — NOT NULL
- Key — varchar — Primary key — NOT NULL
- Field5 — char(1)
- Field
SubDetail
- Key4 (Key42) — varchar — Foreign key → Detail.Key4 — NOT NULL
- Key5 (Key52) — int — Foreign key → Detail.Key5 — NOT NULL
- Key2 (Key22) — varchar — Foreign key → Detail.Key2 — NOT NULL
- Key (Key6) — varchar — Foreign key → Detail.Key — NOT NULL
- Key3 (Key32) — int — Foreign key → Detail.Key3 — NOT NULL
- Key5 — varchar — NOT NULL
- Field3 — varchar
- Field2 — int
- Field7 — int
- Field — char(1)
- Field4
SubItems
- Key — varchar — Foreign key → ItemCode.Key — NOT NULL
- Key2 (Key22) — varchar — Foreign key → SubCode.Key2 — NOT NULL
- Field — char(1)
SubType
- Key — varchar — Foreign key → SubCode.Key — NOT NULL
- Field — varchar
- Field2 — int