hw1
Tables (3)
items (Untitled2)
- PK (item_id) — Primary key — NOT NULL
- field (item_price)
- field (item_category)
stocks (Untitled3)
- PK (stock_id) — Primary key — NOT NULL
- FK (store_id) — Foreign key → stores.PK — NOT NULL
- FK (item_id) — Foreign key → items.PK — NOT NULL
- field (stock)
stores (Untitled)
- PK (store_id) — Primary key — NOT NULL
- field (store_address)