Fandom-K
Tables (7)
Artists
- PK (artist_id) — INT AUTO_INCREMENT — Primary key — NOT NULL
- Field (artist_name) — VARCHAR(20) NOT_NULL
- Field (gender) — BOOLEAN
- Field (group_name) — VARCHAR(20)
- Field (birth_date) — DATETIME
- Field (agency) — VARCHAR(20)
Donations
- PK (donation_id) — INT AUTO_INCREMENT — Primary key — NOT NULL
- FK (user_id) — INT — Foreign key → Users.PK — NOT NULL
- FK (project_id) — INT — Foreign key → Projects.PK — NOT NULL
- Field (credits_used) — INT NOT NULL
- Field (donated_at) — TIMESTAMP
- Field
Follows
- FK (user_id) — INT — Foreign key → Users.PK — NOT NULL
- FK (artist_id) — INT — Foreign key → Artists.PK — NOT NULL
- Field (followed_at) — TIMESTAMP
Projects
- PK (project_id) — INT AUTO_INCREMENT — Primary key — NOT NULL
- FK (artist_id) — INT — Foreign key → Artists.PK — NOT NULL
- Field (title) — VARCHAR(30)
- Field (project_category) — VARCHAR(20)
- Field (Field3) — INT NOT NULL
- Field (collected_credits) — INT DEFAULT 0
- Field (start_date) — TIMESTAMP DEFAULT CURRENT_TIMESTAMP
- Field (end_date) — TIMESTAMP NOT NULL
Users
- PK (user_id) — INT AUTO_INCREMENT — Primary key — NOT NULL
- Field (user_name) — VARCHAR(20)
- Field (age) — INT
- Field (gender) — BOOLEAN(MALE OR FEMALE)
- Field (phone_number) — INT UNIQUE
- Field (email) — VARCHAR(30) UNIQUE
- Field (created_at) — TIMESTAMP
Vote_categories
- PK (category_id) — INT AUTO_INCREMENT — Primary key — NOT NULL
- Field (name) — VARCHAR(100)
Votes
- PK (vote_id) — INT AUTO_INCREMENT — Primary key — NOT NULL
- FK (user_id) — INT — Foreign key → Users.PK — NOT NULL
- FK (category_id) — INT — Foreign key → Vote_categories.PK — NOT NULL
- FK (artist_id) — INT — Foreign key → Artists.PK — NOT NULL
- Field (credits_used) — INT NOT NULL
- Field (voted_at) — TIMESTAMP