team1

Tables (6)

deals

  • id — BIGINT — Primary key — NOT NULL
  • party_request_id — BIGINT — Foreign key → party_requests.id — NOT NULL
  • accepted_offer_id — BIGINT — Foreign key → offers.id — NOT NULL
  • matched_at — DATETIME(6) — NOT NULL
  • created_at — DATETIME(6) — NOT NULL

members

  • id — BIGINT — Primary key — NOT NULL
  • login_id — VARCHAR(50) — NOT NULL
  • password_hash — VARCHAR(255) — NOT NULL
  • role — VARCHAR(20) — NOT NULL — STUDENT, MERCHANT
  • name — VARCHAR(50) — NOT NULL
  • phone — VARCHAR(20) — NOT NULL — 채결 후 공개
  • created_at — DATETIME(6) — NOT NULL
  • updated_at — DATETIME(6) — NOT NULL

menu_items

  • id — BIGINT — Primary key — NOT NULL
  • store_id — BIGINT — Foreign key → stores.id — NOT NULL
  • name — VARCHAR(100) — NOT NULL
  • price — BIGINT — NOT NULL
  • category — VARCHAR(30) — NOT NULL — MAIN, FRIED, SOUP, DRY, SIDE, ETC
  • serving_size — INT — 메뉴 1개당 권장 인원
  • available — BOOLEAN — NOT NULL
  • created_at — DATETIME(6) — NOT NULL
  • updated_at — DATETIME(6) — NOT NULL

offers

  • id — BIGINT — Primary key — NOT NULL
  • party_request_id — BIGINT — Foreign key → party_requests.id — NOT NULL
  • store_id — BIGINT — Foreign key → stores.id — NOT NULL
  • discount_rate (offered_total_price) — BIGINT — NOT NULL — 사장님이 제시한 할인율
  • benefit_description — VARCHAR(255) — 음료, 안주, 단체석 등 비가격 혜택
  • message — VARCHAR(500) — NOT NULL
  • status — VARCHAR(20) — NOT NULL — PENDING, ACCEPTED, REJECTED
  • created_at — DATETIME(6) — NOT NULL
  • accepted_at — DATETIME(6)
  • updated_at — DATETIME(6) — NOT NULL

party_requests

  • id — BIGINT — Primary key — NOT NULL
  • student_id — BIGINT — Foreign key → members.id — NOT NULL
  • group_name — VARCHAR(30) — NOT NULL
  • purpose — VARCHAR(30) — NOT NULL
  • headcount — INT — NOT NULL
  • reserved_at — DATETIME(6) — NOT NULL
  • preferred_region — VARCHAR(20) — SINCHON, EWHA, HONGDAE
  • total_budget — BIGINT — NOT NULL — 술과 추가 주문을 포함한 전체 예산
  • base_food_budget — BIGINT — NOT NULL — 최초 안주 주문에 사용할 전체 예산
  • table_count — INT — NOT NULL — ceil(headcount / 4)
  • per_table_food_budget — BIGINT — NOT NULL — base_food_budget / table_count
  • note — VARCHAR(500)
  • status — VARCHAR(20) — NOT NULL — OPEN, MATCHED, CLOSED
  • created_at — DATETIME(6) — NOT NULL
  • updated_at — DATETIME(6) — NOT NULL

stores

  • id — BIGINT — Primary key — NOT NULL
  • merchant_id — BIGINT — Foreign key → members.id — NOT NULL
  • name — VARCHAR(100) — NOT NULL
  • region — VARCHAR(20) — NOT NULL — SINCHON, EWHA, HONGDAE
  • address — VARCHAR(255) — NOT NULL
  • max_capacity — INT — NOT NULL
  • open_time — TIME
  • close_time — TIME
  • description — VARCHAR(500)
  • created_at — DATETIME(6) — NOT NULL
  • updated_at — DATETIME(6) — NOT NULL