mission8

mission8

Tables (7)

Artist (artist)

  • Artist_id (artist_id) — INTEGER — Primary key — NOT NULL
  • Artist_name (artist_name) — VARCHAR(50)
  • Gender (gender) — ENUM('M', 'F')

Credit_txn (credit_txn)

  • Txn_id (txn_id) — INTEGER — Primary key — NOT NULL
  • User_id (user_id) — INTEGER — Foreign key → Users.User_id — NOT NULL
  • Project_id (project_id) — INTEGER — Foreign key → Project.Project_id — NOT NULL
  • Type (type) — ENUM('CHARGE,'VOTE','SUPPORT')
  • Amount (amount) — INTEGER
  • Occurred_at (occurred_at) — TIMESTAMP

Follow (follow)

  • User_id (user_id) — INTEGER — Foreign key → Users.User_id — NOT NULL
  • Artist_id (artist_id) — INTEGER — Foreign key → Artist.Artist_id — NOT NULL

Project (project)

  • Project_id (project_id) — INTEGER — Primary key — NOT NULL
  • Artist_id (artist_id) — INTEGER — Foreign key → Artist.Artist_id — NOT NULL
  • Category (category) — ENUM('birthday', 'album', 'drama', 'movie', 'etc')
  • Goal_credits (goal_credits) — INTEGER
  • End_date (end_date) — DATE

Support (support)

  • Support_d (support_id) — INTEGER — Primary key — NOT NULL
  • User_id (user_id2) — INTEGER — Foreign key → Users.User_id — NOT NULL
  • Project_id (project_id2) — INTEGER — Foreign key → Project.Project_id — NOT NULL
  • Credits (Field) — INTEGER
  • Supported_at (supported_at) — TIMESTAMP

Users (users)

  • User_id (user_id) — INTEGER — Primary key — NOT NULL
  • User_name (user_name) — VARCHAR(20)
  • email — VARCHAR(50
  • Phone_number (phone_number) — VARCHAR(11)

Vote (vote)

  • Vote_id (vote_id) — INTEGER — Primary key — NOT NULL
  • User_id (user_id) — INTEGER — Foreign key → Users.User_id — NOT NULL
  • Artist_id (artist_id) — INTEGER — Foreign key → Artist.Artist_id — NOT NULL
  • Voted_at (voted_at) — TIMESTAMP