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