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