lotto

Tables (6)

WinngingNumbers (Untitled)

  • WinningNumbers_id (Key) — Primary key — NOT NULL
  • number_1 (1)
  • number_2 (2)
  • number_3 (3)
  • number_5 (4)
  • number_5 (5)
  • number_6 (6)

analytics (통계)

  • id (분석 테이블 아이디) — NUMBER — Primary key — NOT NULL
  • memberId (Key2) — NUMBER — Foreign key → member.id — NOT NULL
  • total_purchase_amount (총 구매금액) — NUMBER — NOT NULL
  • total_prize_amount (총 당첨금액) — NUMBER — NOT NULL
  • total_purchase_count (총 구매 장수) — NUMBER — NOT NULL
  • total_win_count (총 당첨 횟수) — NUMBER — NOT NULL
  • updated_at (통계 갱신 시간) — DATE — NOT NULL

lotto_purchases (구매 내역)

  • id (Key) — NUMBER — Primary key — NOT NULL
  • number_1 (로또 번호1) — NUMBER — NOT NULL
  • number_2 (로또 번호2) — NUMBER — NOT NULL
  • number_3 (로또 번호3) — NUMBER — NOT NULL
  • number_4 (로또 번호4) — NUMBER — NOT NULL
  • number_5 (로또 번호5) — NUMBER — NOT NULL
  • number_6 (로또 번호6) — NUMBER — NOT NULL
  • lotto_draw_id (회차별 로또 추첨 아이디) — NUMBER — Foreign key → member_round.id — NOT NULL
  • purchase_type (구매 타입(자동/수동)) — ENUM — NOT NULL
  • id (유저 아이디) — NUMBER — Foreign key → member.id — NOT NULL

member (유저)

  • id (유저 아이디) — NUMBER — Primary key — NOT NULL
  • password (비밀번호) — VARCHER2(50) — NOT NULL
  • username (닉네임) — VARCHER2(50) — NOT NULL
  • sido (주소 (8도)) — VARCHER2(50) — NOT NULL
  • sigungu (동 부분) — VARCHER2(50) — NOT NULL
  • roadName (도로명) — VARCHER2(50) — NOT NULL

member_round (회차별 로또 추첨)

  • id (로또 추첨 아이디) — NUMBER — Primary key — NOT NULL
  • draw_round (로또 추첨 회차) — NUMBER — NOT NULL
  • draw_date (추첨 날짜) — DATE — NOT NULL
  • winning_numbers (당첨 번호) — VARCHER(50)
  • WinningNumbers_id (Key) — Foreign key → WinngingNumbers.WinningNumbers_id — NOT NULL

quote (명언)

  • id (명언 아이디) — NUMBER — Primary key — NOT NULL
  • content (명언 내용) — VARCHER2(300) — NOT NULL
  • writer (명언 주인) — VARCHER(50) — NOT NULL