mission8
Tables (8)
Users (Untitled)
- user_id (Field) — INT — Primary key
- email (Field2) — VARCHAR(255)
- password_hash (Field3) — VARCHAR(255)
- nickname (Field4) — VARCHAR(255)
- created_at (Field6) — DATETIME
artists (Untitled2)
- artist_id (Field) — INT — Primary key
- name (Field2) — VARCHAR
- group_name (Field3) — VARCHAR
- debut_date (Field4) — DATE
- created_at (Field5) — DATETIME
credit_transactions (Untitled3)
- transaction_id (Field) — INT — Primary key
- amount (Field3) — INT
- fee_amount (Field4) — INT
- created_at (Field5) — DATETIME
- type (Field6) — VARCHAR(20)
- user_id (Field7) — INT — Foreign key → Users.user_id
support_contributions (Untitled5)
- contribution_id (Field) — INT — Primary key
- amount (Field4) — INT
- created_at (Field5) — DATETIME
- user_id (Field6) — INT — Foreign key → Users.user_id
- project_id (Field7) — INT — Foreign key → support_projects.project_id
support_projects (Untitled4)
- project_id (Field) — INT — Primary key
- artist_id (Field2) — INT
- title (Field3) — VARCHAR
- description (Field4) — TEXT
- target_credits (Field5) — INT
- start_date (Field6) — DATE
- end_date (Field7) — DATE
- status (Field8) — VARCHAR
- created_at (Field9) — DATETIME
- artist_id (Field10) — INT — Foreign key → artists.artist_id
user_artist_follows (Untitled8)
- follow_id (Field) — INT — Primary key
- followed_at (Field4) — DATETIME
- user_id (Field5) — INT — Foreign key → Users.user_id
- artist_id (Field6) — INT — Foreign key → artists.artist_id
vote_categories (Untitled6)
- category_id (Field) — INT — Primary key
- description (Field2) — TEXT
- name (Field3) — VARCHAR
- credit_cost (Field4) — INT
- start_date (Field5) — DATE
- end_date (Field6) — DATE
- created_at (Field7) — DATETIME
votes (Untitled7)
- vote_id (Field) — INT — Primary key
- credit_used (Field5) — INT
- voted_at (Field6) — DATETIME
- user_id (Field7) — INT — Foreign key → Users.user_id
- artist_id (Field8) — INT — Foreign key → artists.artist_id
- category_id (Field9) — INT — Foreign key → vote_categories.category_id