coffee
Tables (4)
menu (메뉴)
- id (메뉴번호) — BIGINT — Primary key — NOT NULL
- name (메뉴이름) — VARCHAR(255) — NOT NULL
- price (가격) — INT — NOT NULL
- category (종류) — VARCHAR(30) — NOT NULL
- description (메뉴설명) — VARCHAR(500) — NOT NULL
- status (상태) — VARCHAR(10) — NOT NULL — 품절, 판매중
- created_at (생성시간) — DATETIME — NOT NULL
- updated_at (수정시간) — DATETIME — NOT NULL
order (주문)
- id (주문번호) — BIGINT — Primary key — NOT NULL
- user_id (회원번호) — BIGINT — Foreign key → user.id — NOT NULL
- total_price (총 가격) — INT — NOT NULL
- status (주문 상태) — VARCHAR — NOT NULL
- created_at (주문시간) — DATETIME — NOT NULL
order_item (주문 상세)
- id (주문상세번호) — BIGINT — Primary key — NOT NULL
- menu_id (메뉴번호) — BIGINT — Foreign key → menu.id — NOT NULL
- order_id (주문번호) — BIGINT — Foreign key → order.id — NOT NULL
- - — - — Foreign key → order.user_id
- count (수량) — INT — NOT NULL
- order_price (가격) — INT — NOT NULL
- option (옵션) — JSON — NOT NULL — 아이스 or 핫, 샷추가 등
user (회원)
- id (회원번호) — BIGINT — Primary key — NOT NULL
- email (이메일) — VARCHAR(255) — NOT NULL
- password (비밀번호) — VARCHAR(255) — NOT NULL
- name (이름) — VARCHAR — NOT NULL
- point (보유 포인트) — INT — NOT NULL
- created_at (생성시간) — DATETIME — NOT NULL
- updated_at (수정시간) — DATETIME — NOT NULL