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