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