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