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