모두의 추첨(2022 SCG 해커톤)
테이블 (10)
group
- id — int — 기본 키 — NOT NULL
- user_id — int — 외래 키 → user.id — NOT NULL
- title (Field) — varchar(255) — NOT NULL
- members — text
history-horse
- id (Key) — int — 기본 키 — NOT NULL
- user_id (id) — int — 외래 키 → user.id — NOT NULL
- title (Field) — varchar(255) — NOT NULL
- number — int — NOT NULL
- content (Field2) — text — NOT NULL
- result — text — NOT NULL
history-ladder
- id — int — 기본 키 — NOT NULL
- user_id — int — 외래 키 → user.id — NOT NULL
- title (Field) — varchar(255) — NOT NULL
- number — int — NOT NULL
- topContent — text — NOT NULL
- bottomContent — text — NOT NULL
- result — text — NOT NULL
history-lottery
- id — int — 기본 키 — NOT NULL
- user_id — int — 외래 키 → user.id — NOT NULL
- title (Field) — varchar(255) — NOT NULL
- number — int — NOT NULL
- content — text — NOT NULL
- wins — int — NOT NULL
- result — text — NOT NULL
history-roulette
- id — int — 기본 키 — NOT NULL
- user_id — int — 외래 키 → user.id — NOT NULL
- title (Field) — varchar(255) — NOT NULL
- number — int — NOT NULL
- content — text — NOT NULL
- result — text — NOT NULL
preset-horse
- id (Key) — int — 기본 키 — NOT NULL
- user_id (id) — int — 외래 키 → user.id — NOT NULL
- title (Field) — varchar(255) — NOT NULL
- number — int — NOT NULL
- content (Field2) — text — NOT NULL
preset-ladder
- id (Key) — int — 기본 키 — NOT NULL
- user_id (id) — int — 외래 키 → user.id — NOT NULL
- title (Field) — varchar(255) — NOT NULL
- number — int — NOT NULL
- topContent — text — NOT NULL
- bottomContent — text — NOT NULL
preset-lottery
- id — int — 기본 키 — NOT NULL
- user_id — int — 외래 키 → user.id — NOT NULL
- title (Field) — varchar(255) — NOT NULL
- number — int — NOT NULL
- content — text — NOT NULL
- wins — int — NOT NULL
preset-roulette
- id — int — 기본 키 — NOT NULL
- user_id — int — 외래 키 → user.id — NOT NULL
- title (Field) — varchar(255) — NOT NULL
- number — int — NOT NULL
- content — text — NOT NULL
user
- id — int — 기본 키 — NOT NULL
- username — varchar(255) — NOT NULL
- email — varchar(255) — NOT NULL
- password — varchar(255) — NOT NULL
- imageUrl — varchar(255)