FandomK
Tables (11)
Artists (artists)
- Artist ID (artist_id) — INT — Primary key — NOT NULL
- Group ID (group_id) — INT — Foreign key → Groups.Group ID — NOT NULL
- Artist Name (artist_name) — VARCHAR(100)
- Artist Gender (artist_gender) — ENUM('male', 'female')
Credit Charge (credit_charge)
- Charge ID (charge_id) — INT — Primary key — NOT NULL
- User ID (user_id) — INT — Foreign key → Users.User ID — NOT NULL
- Charged Amount (charged_amount) — DECIMAL(10,2)
- Charged At (charged_at) — DATETIME
Credit Used (credit_used)
- Credit Used ID (used_id) — INT — Primary key — NOT NULL
- User ID (user_id) — INT — Foreign key → Users.User ID — NOT NULL
- Used Amount (used_amount) — DECIMAL(10,2)
- Used At (used_at) — DATETIME
- Use Type (use_type) — ENUM('vote', 'donate')
Donation (donation)
- ID (donate_id) — INT — Primary key — NOT NULL
- User ID (user_id) — INT — Foreign key → Users.User ID — NOT NULL
- Tribution ID (trib_id) — INT — Foreign key → Tribution.Tribution ID — NOT NULL
- Donated Credit amount (donated_credit_amt) — DECIMAL(10,2)
- Donated At (donated_at) — DATE
Follow (follow)
- ID (follow_id) — INT — Primary key — NOT NULL
- User ID (user_id) — INT — Foreign key → Users.User ID — NOT NULL
- Artist ID (artist_id) — INT — Foreign key → Artists.Artist ID — NOT NULL
- Follow_At (follow_at) — DATETIME
Groups (groups)
- Group ID (group_id) — INT — Primary key — NOT NULL
- Group name (group_name) — VARCHAR(100)
- Group gender (group_gender) — ENUM('male', 'female' ,'mixed')
News (artist_news)
- NEWS ID (news_id) — INT — Primary key — NOT NULL
- Artist ID (artist_id) — INT — Foreign key → Artists.Artist ID — NOT NULL
- Group ID (group_id) — INT — Foreign key → Groups.Group ID
- Title (title) — VARCHAR(255)
- Content (content) — TEXT
Tribution (tribution)
- Tribution ID (trib_id) — INT — Primary key — NOT NULL
- Artist ID (artist_id) — INT — Foreign key → Artists.Artist ID — NOT NULL
- Content (content) — TEXT — Contents of tribution for artists
- Target Amount (target_amt) — DECIMAL(10,2)
- Current Amount (current_amt) — DECIMAL(10,2)
- Tribution Start Date (tribute_start_date) — DATETIME
- Tribution End Date (tribute_end_date) — DATETIME
Users (users)
- User ID (user_id) — INT — Primary key — NOT NULL
- User Name (user_name) — VARCHAR(100)
Vote for Artists (vote_artist)
- ID (vote_id) — INT — Primary key — NOT NULL
- User ID (user_id) — INT — Foreign key → Users.User ID — NOT NULL
- Artist ID (artist_id) — INT — Foreign key → Artists.Artist ID — NOT NULL
- Credit Used (credit_used) — DECIMAL(10,2)
- Vote At (vote_at) — DATETIME
- Vote Start Date (vote_start_date) — DATETIME
- Vote End Date (vote_end_date) — DATETIME
Vote for Groups (vote_group)
- ID (vote_id) — INT — Primary key — NOT NULL
- User ID (user_id) — INT — Foreign key → Users.User ID — NOT NULL
- Group ID (group_id) — INT — Foreign key → Groups.Group ID — NOT NULL
- Credit Used (credit_used) — DECIMAL(10,2)
- Vote At (vote_at) — DATETIME
- Vote Start Date (vote_start_date) — DATETIME
- Vote End Date (vote_end_date) — DATETIME