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