event
Tables (16)
email_verification_tokens
- token_id — BIGINT
- user_id — BIGINT — Foreign key → users.user_id — NOT NULL
- token — VARCHAR(255) — NOT NULL
- expires_at — DATETIME — NOT NULL
- used_at — DATETIME
- sent_at — DATETIME — NOT NULL
- send_count_window_key — VARCHAR(20)
- send_count — INT
event_images
- image_id — BIGINT
- event_id — BIGINT — Foreign key → events.event_id — NOT NULL
- image_url — VARCHAR(500) — NOT NULL
- sort_order — INT — NOT NULL
event_options
- option_id — BIGINT
- event_id — BIGINT — Foreign key → events.event_id — NOT NULL
- course — VARCHAR(50) — NOT NULL
- pace — VARCHAR(50) — NOT NULL
- price — INT — NOT NULL
- capacity — INT — NOT NULL
- sold_count — INT — NOT NULL
- created_at — DATETIME — NOT NULL
events
- event_id — BIGINT
- title — VARCHAR(200) — NOT NULL
- region — VARCHAR(100)
- event_type — ENUM('LOTTERY','FIRST_COME') — NOT NULL
- event_status — VARCHAR(30) — NOT NULL
- event_date — DATE
- apply_start_at — DATETIME
- apply_end_at — DATETIME
- ticket_open_at — DATETIME
- location_text — VARCHAR(255)
- description — TEXT
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
orders
- order_id — BIGINT
- participation_id — BIGINT — Foreign key → participation.participation_id — NOT NULL
- order_no — VARCHAR(50) — NOT NULL
- order_status — ENUM('UNPAID','PAID') — NOT NULL
- order_at — DATETIME — NOT NULL
- payment_method_text — VARCHAR(50)
- amount_product — INT — NOT NULL
- amount_shipping — INT — NOT NULL
- amount_discount — INT — NOT NULL
- amount_total — INT — NOT NULL
- shipping_address_snapshot — TEXT
participation
- participation_id — BIGINT
- user_id — BIGINT — Foreign key → users.user_id — NOT NULL
- event_id — BIGINT — Foreign key → events.event_id — NOT NULL
- option_id — BIGINT — Foreign key → event_options.option_id — NOT NULL
- user_status — ENUM('APPLIED','WAITED','PAYABLE','PAID') — NOT NULL
- applied_at — DATETIME
- waited_at — DATETIME
- payable_at — DATETIME
- paid_at — DATETIME
- is_active — BOOLEAN — NOT NULL
password_reset_tokens
- token_id — BIGINT
- user_id — BIGINT — Foreign key → users.user_id — NOT NULL
- token — VARCHAR(255) — NOT NULL
- expires_at — DATETIME — NOT NULL
- used_at — DATETIME
- requested_at — DATETIME — NOT NULL
pre_selections
- preselect_id — BIGINT
- user_id — BIGINT — Foreign key → users.user_id — NOT NULL
- event_id — BIGINT — Foreign key → events.event_id — NOT NULL
- option_id — BIGINT — Foreign key → event_options.option_id — NOT NULL
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
queue_sessions
- queue_id — BIGINT
- user_id — BIGINT — Foreign key → users.user_id
- event_id — BIGINT — Foreign key → events.event_id — NOT NULL
- token — VARCHAR(255) — NOT NULL
- status — ENUM('WAITING','PASSED','EXPIRED','BLOCKED') — NOT NULL
- position — INT
- estimated_wait_seconds — INT
- issued_at — DATETIME — NOT NULL
- expires_at — DATETIME — NOT NULL
- last_polled_at — DATETIME
- vaq_verified_at — DATETIME
terms
- terms_id — BIGINT
- code — ENUM('TOS','PRIVACY','MARKETING') — NOT NULL
- is_required — BOOLEAN — NOT NULL
- version — VARCHAR(30) — NOT NULL
- content_url — VARCHAR(500)
- created_at — DATETIME — NOT NULL
user_addresses
- address_id — BIGINT
- user_id — BIGINT — Foreign key → users.user_id — NOT NULL
- receiver_name — VARCHAR(100) — NOT NULL
- receiver_phone — VARCHAR(30) — NOT NULL
- address_line1 — VARCHAR(255) — NOT NULL
- address_line2 — VARCHAR(255)
- zipcode — VARCHAR(20) — NOT NULL
- is_default — BOOLEAN — NOT NULL
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
user_credentials
- user_id — BIGINT — Foreign key → users.user_id
- password_hash — VARCHAR(255) — NOT NULL
- password_changed_at — DATETIME
user_marketing_settings
- user_id — BIGINT — Foreign key → users.user_id
- marketing_opt_in — BOOLEAN — NOT NULL
- updated_at — DATETIME — NOT NULL
user_oauth_accounts
- oauth_id — BIGINT
- user_id — BIGINT — Foreign key → users.user_id — NOT NULL
- provider — ENUM('KAKAO','NAVER','GOOGLE') — NOT NULL
- provider_user_id — VARCHAR(255) — NOT NULL
- provider_email — VARCHAR(255)
- created_at — DATETIME — NOT NULL
user_terms_agreements
- agreement_id — BIGINT
- user_id — BIGINT — Foreign key → users.user_id — NOT NULL
- terms_id — BIGINT — Foreign key → terms.terms_id — NOT NULL
- agreed — BOOLEAN — NOT NULL
- agreed_at — DATETIME
users
- user_id — BIGINT
- email — VARCHAR(255)
- name — VARCHAR(100) — NOT NULL
- mobile — VARCHAR(30)
- account_type — ENUM('EMAIL','SNS') — NOT NULL
- account_status — ENUM('EMAIL_PENDING','VERIFIED','DISABLED','PW_RESET_PENDING','IDV_FAILED') — NOT NULL
- is_deleted — BOOLEAN — NOT NULL
- deleted_at — DATETIME
- last_login_at — DATETIME
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL