RunGo

Tables (9)

course

  • id — BIGINT — Primary key — NOT NULL
  • marathon_id — BIGINT — Foreign key → marathon.id — NOT NULL
  • course_type — VARCHAR(20) — NOT NULL
  • price — DECIMAL(10, 2) — NOT NULL
  • capacity — INT — NOT NULL
  • current_count — INT — NOT NULL

email_outbox

  • id — BIGINT — Primary key — NOT NULL
  • recipient — VARCHAR(255) — NOT NULL
  • subject — VARCHAR(255) — NOT NULL
  • body — TEXT — NOT NULL
  • status — ENUM('PENDING', 'PROCESSING', 'SUCCESS', 'FAILED', 'EXHAUSTED') — NOT NULL
  • retry_count — INT — NOT NULL
  • last_error_message — VARCHAR(255)
  • created_at — TIMESTAMP — NOT NULL
  • sent_at — TIMESTAMP

marathon

  • id — BIGINT — Primary key — NOT NULL
  • organizer_id — BIGINT — Foreign key → users.id — NOT NULL
  • title — VARCHAR(200) — NOT NULL
  • region — VARCHAR(50) — NOT NULL
  • event_date — DATE — NOT NULL
  • poster_image_url — VARCHAR(500)
  • created_at — TIMESTAMP — NOT NULL
  • registration_start_at — TIMESTAMP — NOT NULL
  • registration_end_at — TIMESTAMP — NOT NULL
  • status — ENUM('TEMP', 'OPEN', 'CLOSED') — NOT NULL
  • detailed_address — VARCHAR(255) — NOT NULL

organizer_application

  • id — BIGINT — Primary key — NOT NULL
  • user_id — BIGINT — Foreign key → users.id — NOT NULL
  • business_registration_number — VARCHAR(100) — NOT NULL
  • status — ENUM('PENDING', 'APPROVED', 'REJECTED') — NOT NULL
  • reject_reason — VARCHAR(500)
  • requested_at — TIMESTAMP — NOT NULL

payments

  • id — BIGINT — Primary key — NOT NULL
  • original_registration_id — BIGINT — Foreign key → registrations.id — NOT NULL
  • user_id — BIGINT — Foreign key → users.id — NOT NULL
  • marathon_id — BIGINT — Foreign key → marathon.id — NOT NULL
  • course_id — BIGINT — Foreign key → course.id — NOT NULL
  • order_id — VARCHAR(100) — NOT NULL
  • payment_key — VARCHAR(100)
  • amount — BIGINT — NOT NULL
  • method — VARCHAR(50)
  • status — ENUM('READY', 'DONE', 'FAILED', 'CANCELED', 'REFUNDED') — NOT NULL
  • requested_at — TIMESTAMP — NOT NULL
  • approved_at — TIMESTAMP
  • expires_at — TIMESTAMP
  • refunded_at — TIMESTAMP
  • refund_reason — VARCHAR(200)
  • fail_code — VARCHAR(100)
  • fail_message — VARCHAR(500)
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL

registration_cancel_histories

  • id — BIGINT — Primary key — NOT NULL
  • id2 — BIGINT — NOT NULL
  • user_id — BIGINT — Foreign key → users.id — NOT NULL
  • marathon_id — BIGINT — Foreign key → marathon.id — NOT NULL
  • course_id — BIGINT — Foreign key → course.id — NOT NULL
  • snap_name — VARCHAR(50) — NOT NULL
  • snap_phone_number — VARCHAR(20) — NOT NULL
  • snap_zip_code — VARCHAR(10) — NOT NULL
  • snap_address — VARCHAR(255) — NOT NULL
  • snap_detail — VARCHAR(255) — NOT NULL
  • t_size — VARCHAR(10) — NOT NULL
  • agreed_terms — BOOLEAN — NOT NULL
  • applied_at — TIMESTAMP — NOT NULL
  • cancel_reason — ENUM('USER_CANCELED', 'MARATHON_CANCELED', 'PAYMENT_TIMEOUT') — NOT NULL
  • canceled_at — TIMESTAMP — NOT NULL

registrations

  • id — BIGINT — Primary key — NOT NULL
  • user_id — BIGINT — Foreign key → users.id — NOT NULL
  • course_id — BIGINT — Foreign key → course.id — NOT NULL
  • marathon_id — BIGINT — Foreign key → marathon.id — NOT NULL
  • status — ENUM('COMPLETED', 'CANCELED', 'PENDING_PAYMENT') — NOT NULL
  • snap_name — VARCHAR(50)
  • snap_phone_number — VARCHAR(20)
  • snap_zip_code — VARCHAR(10)
  • snap_address — VARCHAR(255)
  • snap_detail — VARCHAR(255)
  • t_size — VARCHAR(10)
  • applied_at — TIMESTAMP — NOT NULL
  • agreed_terms — BOOLEAN — NOT NULL

user_auth

  • id — BIGINT — Primary key — NOT NULL
  • user_id — BIGINT — NOT NULL
  • password — VARCHAR(255)
  • provider — VARCHAR(100) — NOT NULL
  • provider_id — VARCHAR(100) — NOT NULL

users

  • id — BIGINT — Primary key — NOT NULL
  • email — VARCHAR(100) — NOT NULL
  • name — VARCHAR(50) — NOT NULL
  • phone_number — VARCHAR(20)
  • role — ENUM('PARTICIPANT', 'ORGANIZER', 'ADMIN') — NOT NULL
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL
  • gender — ENUM('MALE', 'FEMALE')
  • birth — DATE