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