convenienceStore
Tables (3)
Item (item)
- Primary Key (item_pk) — INT — Primary key — NOT NULL
- Item Name (item_name) — VARCHAR(20)
- Stores (item_store) — Store
Store (store)
- Primary Key (store_pk) — INT — Primary key — NOT NULL
- Store Name (store_name) — VARCHAR(10)
- Store Location (store_location) — VARCHAR(20)
- Items (store_items) — Item
Store_Items (store_item)
- Primary Key (store_pk) — INT — Foreign key → Store.Primary Key — NOT NULL
- Primary Key (item_pk) — INT — Foreign key → Item.Primary Key — NOT NULL