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