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