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