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