CVS

Tables (4)

Company

  • pk — int — Primary key — NOT NULL
  • name — text — NOT NULL

Incharge (Untitled)

  • pk (Key) — int — Primary key — NOT NULL
  • store_id (pk) — int — Foreign key → Store.pk — NOT NULL
  • item_id (pk3) — int — Foreign key → Item.pk — NOT NULL
  • name (Field) — text — NOT NULL
  • sex (Field2) — text — NOT NULL
  • age (Field3) — int — NOT NULL
  • goods (Field4) — text — NOT NULL

Item (Beverage)

  • pk — int — Primary key — NOT NULL
  • name — text — NOT NULL
  • stock (price) — int — NOT NULL
  • exp_date — datetime
  • category (Field) — text — NOT NULL
  • company_id (pk2) — int — Foreign key → Company.pk — NOT NULL

Store

  • pk — int — Primary key — NOT NULL
  • name — text — NOT NULL
  • manager (Field) — text — NOT NULL