0504

Tables (3)

Items (items)

  • Item (item) — INT(11) — Primary key — NOT NULL
  • Company (company) — VARCHAR(255)
  • Create_time (create_time) — datetime
  • Shelf_life (shelf_life) — VARCHAR(255)
  • Name (name) — INT(11) — Foreign key → Store.Name — NOT NULL

My_Store (my_store)

  • Store_id (store_id) — INT(11) — Primary key — NOT NULL
  • Location (location) — VARCHAR(255)
  • Number (number) — VARCHAR(255)
  • Manager (manager) — VARCHAR(255)

Store (store)

  • Name (name) — INT(11) — Primary key — NOT NULL
  • Price (price) — INT(11)
  • Store_id (store_id) — INT(11) — Foreign key → My_Store.Store_id — NOT NULL
  • Post (post) — VARCHAR(255)