배민

테이블 (5)

Menu

  • menuid — bigint(20) — 기본 키 — NOT NULL
  • name — varchar(50) — NOT NULL
  • price — int — NOT NULL
  • description — varchar(255)
  • status — ENUM('Available', 'Unavailable') — NOT NULL
  • created_at — timestamp
  • updated_at — timestamp
  • restaurantid — bigint(20) — NOT NULL

Order

  • orderid — bigint(20) — 기본 키 — NOT NULL
  • orderdate — date — NOT NULL
  • totalamount — int — NOT NULL
  • status — ENUM('Pending', 'Completed', 'Cancelled') — NOT NULL
  • created_at — timestamp
  • updated_at — timestamp
  • userid — bigint(20) — NOT NULL
  • restaurantid — bigint(20) — NOT NULL

OrderItem

  • orderitemid — bigint(20) — 기본 키 — NOT NULL
  • quantity — int — NOT NULL
  • price — int — NOT NULL
  • status — ENUM('Pending', 'Prepared', 'Delivered') — NOT NULL
  • created_at — timestamp
  • updated_at — timestamp
  • menuid — bigint(20) — NOT NULL
  • orderid — bigint(20) — NOT NULL

Restaurant

  • restaurantid — bigint(20) — 기본 키 — NOT NULL
  • name — varchar(50) — NOT NULL
  • location — varchar(200) — NOT NULL
  • phone — varchar(50)
  • category — varchar(50)
  • min_order_amount — int — NOT NULL
  • status — ENUM('Open', 'Closed') — NOT NULL
  • created_at — timestamp
  • updated_at — timestamp

User

  • userId — bigint(20) — 기본 키 — NOT NULL
  • name — varchar(50) — NOT NULL
  • password — varchar(200) — NOT NULL
  • phone — varchar(50) — NOT NULL
  • current_address — varchar(200)
  • email — varchar(200) — NOT NULL
  • status — ENUM('Active', 'Inactive') — NOT NULL
  • created_at — timestamp
  • updated_at — timestamp