mission8
Tables (8)
Artists (아티스트)
- Key — INT — Primary key — NOT NULL
- Field — VARCHAR(100)
- Field2 — VARCHAR(100)
- Field3 — DATE
Credit_Transactions (크레딧 거래이력)
- Key — INT — Primary key — NOT NULL
- Field — INT
- Field2 — INT
- Field3 — VARCHAR(20)
- Field4 — DATETIME
- Key (Key2) — INT — Foreign key → Users.Key — NOT NULL
Donations (후원내역)
- Key — INT — Primary key — NOT NULL
- Field — INT
- Field2 — INT
- Field4 — INT
- Field5 — DATETIME
- Key (Key2) — INT — Foreign key → Users.Key — NOT NULL
- Key (Key3) — INT — Foreign key → Projects.Key — NOT NULL
- Key (Key4) — INT — Foreign key → Credit_Transactions.Key — NOT NULL
Projects (조공 프로젝트)
- Key — INT — Primary key — NOT NULL
- Field — INT
- Field2 — VARCHAR(100)
- Field3 — INT
- Field4 — INT
- Field5 — VARCHAR(20)
- Key (Key2) — INT — Foreign key → Artists.Key — NOT NULL
User_Follows_Artists (사용자-아티스트 팔로우)
- Key — INT — Primary key — NOT NULL
- Field — INT
- Field2 — INT
- Field3 — DATETIME
- Key (Key2) — INT — Foreign key → Users.Key — NOT NULL
- Key (Key3) — INT — Foreign key → Artists.Key — NOT NULL
Users (사용자)
- Key — INT — Primary key — NOT NULL
- Field — VARCHAR(50)
- Field2 — VARCHAR(100)
- Field3 — INT
- Field4 — DATETIME
Vote_Events (투표 이벤트 정보)
- Key — INT — Primary key — NOT NULL
- Field — VARCHAR(100)
- Field2 — DATE
- Field3 — DATE
Votes (투표 이력)
- Key — INT — Primary key — NOT NULL
- Field — INT
- Field2 — INT
- Field3 — INT
- Field5 — INT
- Field6 — DATETIME
- Key (Key2) — INT — Foreign key → Users.Key — NOT NULL
- Key (Key3) — INT — Foreign key → Artists.Key — NOT NULL
- Key (Key4) — INT — Foreign key → Vote_Events.Key — NOT NULL
- Key (Key5) — INT — Foreign key → Credit_Transactions.Key — NOT NULL