homework13 +a
Tables (5)
Convenient store (convenient)
- Key (id) — Primary key — NOT NULL
- Field (store name) — string
- Field2 (location) — string
- Field3 (scale) — integer
id
- Key (convenient_id) — Foreign key → Convenient store.Key — NOT NULL
- Key (item_id) — Foreign key → item.Key — NOT NULL
- Field (count) — integer
- Field (delivery_date) — datetype
item
- Key (id) — Primary key — NOT NULL
- Key (supplier_id) — Foreign key → supplier.Key — NOT NULL
- Field (item name) — string
- Field2 (price) — integer
- Field (classification) — string
membership
- Key (id) — Primary key — NOT NULL
- Field
supplier
- Key — Primary key — NOT NULL
- Field (supplier_name) — string
- Field (location) — string