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