mission_17
Tables (9)
Account
- ID (id) — INT — Primary key — NOT NULL
- Email (email) — VARCHAR(259) — NOT NULL
- Password (password) — VARCHAR(259) — NOT NULL
- Credit (credit) — INT
Artist
- ID (artist_id) — INT — Primary key — NOT NULL
- ID (category_id) — INT — Foreign key → Artist_Category.ID
- Name (name) — VARCAHR(50) — NOT NULL
Artist_Category
- ID (id) — INT — Primary key — NOT NULL
- Category (name) — VARCHAR(259) — NOT NULL
Artist_News
- ID (id) — INT — Primary key — NOT NULL
- News (news) — VARCHAR(259)
- ID (artist_id) — INT — Foreign key → Artist.ID — NOT NULL — ON DELETE CASCADE
Followed
- ID (account_id) — INT — Foreign key → Account.ID — NOT NULL
- ID (artist_id) — INT — Foreign key → Artist.ID — NOT NULL
Support_Category
- ID (s_category_id) — INT — Primary key — NOT NULL
- Support_Category_Name (s_category_name) — VARCHAR(255) — NOT NULL
Support_List
- ID (support_id) — INT — Primary key — NOT NULL
- Total_Amount (total_amount) — INT
- Goal (goal) — INT — NOT NULL
- Support_Category (s_category_id) — INT — Foreign key → Support_Category.ID — NOT NULL
- ID (artist_id) — INT — Foreign key → Artist.ID — NOT NULL
- Due_Date (due_date) — DATETIME — NOT NULL
Supporting
- ID (account_id) — INT — Foreign key → Account.ID — NOT NULL
- ID (support_id) — INT — Foreign key → Support_List.ID — NOT NULL
- Contributed_Credit (credit) — INT
- Support_date (support_date) — DATETIME — NOT NULL
Vote
- ID (id) — INT — Primary key — NOT NULL
- ID (artist_id) — INT — Foreign key → Artist.ID — NOT NULL
- ID (account_id) — INT — Foreign key → Account.ID
- Count (count) — INT
- Vote_Date (vote_date) — DATETIME — NOT NULL