lotto

Tables (7)

event

  • event_id — BIGINT — Primary key
  • 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 — Primary key
  • event_id — BIGINT — Foreign key → event.event_id — NOT NULL
  • participant_id — BIGINT — Foreign key → participant.participant_id — NOT NULL
  • rank — TINYINT — NOT NULL
  • matched_count — TINYINT — NOT NULL
  • announced_at — DATETIME

lotto_ticket

  • ticket_id — BIGINT — Primary key
  • event_id — BIGINT — Foreign key → event.event_id — NOT NULL
  • participant_id — BIGINT — Foreign key → participant.participant_id — 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 — Primary key
  • event_id — BIGINT — Foreign key → event.event_id — NOT NULL
  • phone — VARCHAR(20) — NOT NULL
  • verified_at — DATETIME
  • created_at — DATETIME — NOT NULL

preassigned_rank

  • preassigned_id — BIGINT — Primary key
  • event_id — BIGINT — Foreign key → event.event_id — NOT NULL
  • participant_id — BIGINT — NOT NULL
  • rank — TINYINT — NOT NULL
  • is_reserve — BOOLEAN — NOT NULL

result_view

  • view_id — BIGINT — Primary key — NOT NULL
  • event_id — BIGINT — Foreign key → event.event_id — NOT NULL
  • participant_id — BIGINT — Foreign key → participant.participant_id — NOT NULL
  • view_count — TINYINT — NOT NULL
  • first_viewed_at — DATETIME

sms_log

  • sms_id — BIGINT — Primary key
  • event_id — BIGINT — Foreign key → event.event_id — 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