lotto - 2026-02-21 13:36:15
Tables (7)
event
- event_id — BIGINT
- name — VARCHAR(100) — NOT NULL
- event_start_at — DATETIME — NOT NULL
- event_end_at — DATETIME — NOT NULL
- announce_start_at — DATETIME — NOT NULL
- announce_end_at — DATETIME — NOT NULL
- first_prize_phone — VARCHAR(20) — NOT NULL
- winning_n1 — TINYINT
- winning_n2 — TINYINT
- winning_n3 — TINYINT
- winning_n4 — TINYINT
- winning_n5 — TINYINT
- winning_n6 — TINYINT
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
lotto_result
- result_id — BIGINT
- event_id — BIGINT — Foreign key — NOT NULL
- participant_id — BIGINT — Foreign key — NOT NULL
- rank — TINYINT — NOT NULL
- matched_count — TINYINT — NOT NULL
- announced_at — DATETIME
- INDEX — idx_result_event_rank
lotto_ticket
- ticket_id — BIGINT
- event_id — BIGINT — Foreign key — NOT NULL
- participant_id — BIGINT — Foreign key — NOT NULL
- n1 — TINYINT — NOT NULL
- n2 — TINYINT — NOT NULL
- n3 — TINYINT — NOT NULL
- n4 — TINYINT — NOT NULL
- n5 — TINYINT — NOT NULL
- n6 — TINYINT — NOT NULL
- issued_at — DATETIME — NOT NULL
participant
- participant_id — BIGINT
- event_id — BIGINT — Foreign key — NOT NULL
- phone — VARCHAR(20) — NOT NULL
- verified_at — DATETIME
- created_at — DATETIME — NOT NULL
- INDEX — idx_participant_event_pid
preassigned_rank
- preassigned_id — BIGINT
- event_id — BIGINT — Foreign key — NOT NULL
- participant_id — BIGINT — NOT NULL
- rank — TINYINT — NOT NULL
- is_reserve — BOOLEAN — NOT NULL
- INDEX — idx_preassigned_event_rank
result_view
- view_id — BIGINT
- event_id — BIGINT — Foreign key — NOT NULL
- participant_id — BIGINT — Foreign key — NOT NULL
- view_count — TINYINT — NOT NULL
- first_viewed_at — DATETIME
- second_viewed_at — DATETIME
- INDEX — idx_view_event_count
sms_log
- sms_id — BIGINT
- event_id — BIGINT — Foreign key — NOT NULL
- phone — VARCHAR(20) — NOT NULL
- type — VARCHAR(30) — NOT NULL
- status — VARCHAR(20) — NOT NULL
- provider_message_id — VARCHAR(100)
- sent_at — DATETIME — NOT NULL
- INDEX — idx_sms_event_phone_type