delivery

Tables (10)

cart (장바구니)

  • id — int(11) — Primary key — NOT NULL
  • customer_id — int(11) — Foreign key → customer.id — NOT NULL
  • menu_id — int(11) — Foreign key → menu.id — NOT NULL
  • count — int(11) — NOT NULL
  • is_deleted — boolean — NOT NULL
  • created_at — datetime
  • updated_at — datetime

customer (고객)

  • id — int(11) — Primary key — NOT NULL
  • email — varchar(64) — NOT NULL
  • password — varchar(300) — NOT NULL
  • name — varchar(32) — NOT NULL
  • created_at — datetime
  • updated_at — datetime

food_category (음식 카테고리)

  • id — int(11) — Primary key — NOT NULL
  • name — varchar(32) — NOT NULL
  • image_url — varchar(256)
  • created_at — datetime
  • updated_at — datetime

menu (메뉴정보)

  • id — int(11) — Primary key — NOT NULL
  • store_id — int(11) — Foreign key → store.id — NOT NULL
  • name — varchar(128) — NOT NULL
  • price — int(11) — NOT NULL
  • is_soldout — tinyint(1) — NOT NULL
  • created_at — datetime
  • updated_at — datetime

menu_like (고객의 즐겨찾기 메뉴)

  • id — int(11) — Primary key — NOT NULL
  • customer_id — int(11) — Foreign key → customer.id — NOT NULL
  • menu_id — int(11) — Foreign key → menu.id — NOT NULL
  • created_at — datetime
  • updated_at — datetime

order (주문)

  • id — int(11) — Primary key — NOT NULL
  • customer_id — int(11) — Foreign key → customer.id — NOT NULL
  • orderer_name — varchar(32) — NOT NULL
  • orderer_phone — varchar(32) — NOT NULL
  • shipping_address — varchar(256) — NOT NULL
  • created_at — datetime
  • updated_at — datetime

order_menu (주문 메뉴)

  • id — int(11) — Primary key — NOT NULL
  • order_id — int(11) — Foreign key → order.id — NOT NULL
  • menu_id — int(11) — Foreign key → menu.id — NOT NULL
  • menu_name — varchar(128) — NOT NULL
  • price — int(11) — NOT NULL
  • count — int(11) — NOT NULL
  • created_at — datetime
  • updated_at — datetime

order_review (주문후기)

  • id — int(11) — Primary key — NOT NULL
  • order_menu_id — int(11) — Foreign key → order_menu.id — NOT NULL
  • review — text — NOT NULL
  • score — tinyint(1) — NOT NULL
  • is_deleted — boolean — NOT NULL
  • created_at — datetime
  • updated_at — datetime

seller (판매자)

  • id — int(11) — Primary key — NOT NULL
  • email — varchar(64) — NOT NULL
  • password — varchar(300) — NOT NULL
  • owner_name — varchar(16) — NOT NULL
  • company_phone — varchar(32) — NOT NULL
  • reg_num — varchar(32) — NOT NULL
  • created_at — datetime
  • updated_at — datetime

store (매장정보)

  • id — int(11) — Primary key — NOT NULL
  • seller_id — int(11) — Foreign key → seller.id — NOT NULL
  • food_category_id — int(11) — Foreign key → food_category.id — NOT NULL
  • name — varchar(64) — NOT NULL
  • address — varchar(128) — NOT NULL
  • description — varchar(256)
  • created_at — datetime
  • updated_at — datetime