0504 workshop

Tables (4)

ExpirationDate (Untitled3)

  • good_a (Field)
  • good_b (Field2)

Price (Untitled2)

  • good_a (Field) — Integer
  • good_b (Field2) — Integer

Product (Untitled4)

  • Key — Primary key — NOT NULL
  • Key (Key2) — Foreign key → Store.Key — NOT NULL
  • category (Field) — Char
  • code_num (Field2) — Integer
  • Price (Field3) — Integer
  • product_store (Field6)

Store (Untitled)

  • Key — Primary key — NOT NULL
  • name (Field6) — Char
  • location (Field) — Text
  • contact (Field2) — Text
  • master (Field3) — Char
  • month_profit (Field4) — Integer
  • day_profit (Field5) — Integer