스플린트8
테이블 (7)
ARTISTS
- artist_id (Field) — INT — 기본 키 — NOT NULL
- name (Field4) — VARCHAR(100)
- GROUP (Field5) — STRING
USERS
- user_id (Field) — INT — 기본 키 — NOT NULL
- email (Field2) — VARCHAR(255) — NOT NULL
- password (Field3) — VARCHAR(255) — NOT NULL
- name (Field4) — VARCHAR(100)
- created_time (Field5) — DATETIME
- credit (Field6) — DECIMAL
credit_transactions
- credit_id (Field2) — INT — 기본 키 — NOT NULL
- user_id (Field) — INT — 외래 키 → USERS.user_id — NOT NULL — 1
- credit_where (Field3) — STRING — NOT NULL
- amount (Field4) — DECIMAL
- created_time (Field5) — DATETIME
donations
- donations_id (Field) — INT — 기본 키 — NOT NULL
- project_id (Field2) — INT — NOT NULL
- user_id (Field3) — INT — NOT NULL
- amount (Field4) — DECIMAL
- created_time (Field5) — DATETIME
follow
- user_id (Field3) — INT — 외래 키 → USERS.user_id — NOT NULL
- artist_id (Field4) — INT
- created_time (Field2) — DATETIME
projcts
- projcts_id (Field) — INT — 기본 키 — NOT NULL
- artist_id (Field2) — INT — NOT NULL
- title (Field3) — VARCHAR(100) — NOT NULL
- target_amount (Field4) — DECIMAL
- deadline (Field5) — DATETIME
- created_time (Field6) — DATETIME
votes
- vote_id (Field) — INT — 기본 키 — NOT NULL
- user_id (Field2) — INT — NOT NULL
- artist_id (Field3) — INT — NOT NULL
- votes_count (Field4) — INT
- created_time (Field5) — DATETIME