test

Tables (4)

Member

  • member_id — INT — Primary key
  • member_name — INT
  • member_adress — INT — NOT NULL
  • member_phone

Menu

  • menu_id — INT — Primary key
  • menu_name — VARCHAR(255) — NOT NULL
  • menu_price — DECIMAL(10, 2) — NOT NULL
  • restaurant_id — INT — Foreign key → Restaurant.restaurant_id

Order_baemin

  • order_id — INT — Primary key
  • member_id — INT — NOT NULL
  • order_address — VARCHAR(255) — NOT NULL
  • order_request — TEXT
  • total_amount — DECIMAL(10, 2) — NOT NULL
  • order_type — ENUM('포장', '배달') — NOT NULL
  • payment_status — BOOLEAN — NOT NULL
  • order_time — DATETIME — NOT NULL
  • menu_id — INT — Foreign key → Menu.menu_id
  • member_id (member_id2) — INT — Foreign key → Member.member_id

Restaurant

  • restaurant_id — INT — Primary key
  • restaurant_name — VARCHAR(255) — NOT NULL
  • restaurant_address — VARCHAR(255) — NOT NULL
  • restaurant_tel — VARCHAR(20) — NOT NULL