0504 Workshop

Tables (6)

Admin (admins)

  • Admin id (admin_id) — BIGINT(11) — Primary key — NOT NULL
  • Admin password (admin_pw) — VARCHAR(255)
  • Admin name (admin_name) — VARCHAR(255)
  • Store id (store_id) — BIGINT(11) — Foreign key → Store.Store id — NOT NULL
  • Phone (phone_number) — VARCHAR(255)

Category (categories)

  • Catergory id (category_id) — BIGINT(11) — Primary key — NOT NULL
  • Name (name) — VARCHAR(255)

Order (orders)

  • Order id (order_id) — BIGINT(11) — Primary key — NOT NULL
  • Order date (order_date) — DATETIME
  • Cost (order_cost) — INT(11)
  • State (order_state) — VARCHAR(255)
  • Admin id (admin_id) — BIGINT(11) — Foreign key → Admin.Admin id — NOT NULL

Order Detail (order_details)

  • Order detail id (order_detail_id) — BIGINT(11) — Primary key — NOT NULL
  • Order id (order_id) — BIGINT(11) — Foreign key → Order.Order id — NOT NULL
  • Product id (product_id) — BIGINT(11) — Foreign key → Product.Product id — NOT NULL
  • Count (count) — INT(11)
  • Unit price (unit_price) — INT(11)
  • State (state) — VARCHAR(255)

Product (products)

  • Product id (product_id) — BIGINT(11) — Primary key — NOT NULL
  • Name (name) — VARCHAR(255)
  • Price (price) — INT(11)
  • Expiration Date (expiration_date) — DATETIME
  • Catergory id (category_id) — BIGINT(11) — Foreign key → Category.Catergory id — NOT NULL
  • Count (count) — INT(11)
  • Image (image_path) — VARCHAR(255)
  • State (state) — VARCHAR(255)
  • Manufacturer (manufacturer) — VARCHAR(255)

Store (stores)

  • Store id (store_id) — BIGINT(11) — Primary key — NOT NULL
  • Location (location) — VARCHAR(255)
  • Name (name) — VARCHAR(255)
  • Phone Number (phone_number) — VARCHAR(255)