0504_workshop

Tables (3)

Product (products)

  • Product_id (product_id) — BIGINT(11) — Primary key — NOT NULL
  • Name (name) — VARCHAR(255)
  • Price (price)

Stock (stocks)

  • Stock_id (stock_id) — BININT(11) — Primary key — NOT NULL
  • Product_id (product_id) — BIGINT(11) — Foreign key → Product.Product_id — NOT NULL
  • Store_id (store_id) — BIGINT(11) — Foreign key → Store.Store_id — NOT NULL
  • Expiration_Date (expiration_date)

Store (stores)

  • Store_id (store_id) — BIGINT(11) — Primary key — NOT NULL
  • Adress (adress) — VARCHAR(255)
  • Name (name) — VARCHAR(255)
  • Phone_number (phone_number) — VARCHAR(255)
  • Manager (manager) — VARCHAR(255)