Fandom-K
Tables (7)
artist votes
- Key (id) — INT — Primary key — NOT NULL
- Key (user_id) — INT — Foreign key → users.Key — NOT NULL
- Key (artist_id) — INT — Foreign key → artists.Key — NOT NULL
- Field (category) — VARCHAR(20)
- Field2 (vote_count) — INT
- Field3 (voted_at) — DATETIME
artists
- Key (id) — INT — Primary key — NOT NULL
- Field (name) — VARCHAR(20)
- Field2 (agency) — VARCHAR(20)
- Field3 (debut_date) — DATE
credits
- Key (id) — INT — Primary key — NOT NULL
- Key (user_id) — INT — Foreign key → users.Key — NOT NULL
- Field2 (amount) — INT
- Field3 (status) — VARCHAR(20)
- Field4 (created_at) — DATETIME
donate
- Key (id) — INT — Primary key — NOT NULL
- Key (user_id) — INT — Foreign key → users.Key — NOT NULL
- Key (project_id) — INT — Foreign key → donate projects.Key — NOT NULL
- Field (amount) — INT
- Field2 (donate_at) — DATETIME
donate projects
- Key (id) — INT — Primary key — NOT NULL
- Key (artist_id) — INT — Foreign key → artists.Key — NOT NULL
- Field (project_name) — VARCHAR(20)
- Field2 (start_date) — DATETIME
- Field3 (end_date) — DATETIME
- Field4 (status) — VARCHAR(20)
- Field5 (target_amount) — INT
follows
- Key (id) — INT — Primary key — NOT NULL
- Key (user_id) — INT — Foreign key → users.Key — NOT NULL
- Key (artist_id) — INT — Foreign key → artists.Key — NOT NULL
- Field (followed_at) — DATETIME
users
- Key (id) — INT — Primary key — NOT NULL
- Field1 (username) — VARCHAR(20)
- Field2 (password) — VARCHAR(20)
- Field3 (email) — VARCHAR(20)
- Field4 (created_at) — DATETIME