SPRINT 8
Tables (8)
Artists (Untitled2)
- id (Key) — INT — Primary key — NOT NULL
- name (Field) — VARCHAR(20)
- agency (Field2) — VARCHAR(20)
- debut_date (Field3) — DATE
Follows (Untitled5)
- id (Key3) — INT — Primary key — NOT NULL
- artist_id (Key) — INT — Foreign key → Artists.id — NOT NULL
- user_id (Key2) — INT — Foreign key → Users.id — NOT NULL
- followed_at (Field) — DATETIME
Projects (Untitled3)
- id (Key) — INT — Primary key — NOT NULL
- artist_id (Key2) — INT — Foreign key → Artists.id — NOT NULL
- title (Field2) — VARCHAR(120)
- status (Field3) — VARCHAR(20)
- starts_at (Field4) — DATETIME
- ends_at (Field5) — DATETIME
- created_at (Field6) — DATETIME
Supports (Untitled4)
- id (Key3) — BIGINT — Primary key — NOT NULL
- project_artist (Key2) — INT — Foreign key → Projects.artist_id — NOT NULL
- id (Key) — INT — Foreign key → Users.id — NOT NULL
- credits_spent (Field) — BIGINT
- note (Field2) — VARCHAR(140)
- supported_at (Field3) — DATETIME
Users (Untitled)
- id (Key) — INT — Primary key — NOT NULL
- email (Field) — VARCHAR(20)
- username (Field2) — VARCHAR(20)
- password (Field3) — VARCHAR(20)
- Field4 — DATE
credits (Untitled8)
- id (Key2) — BIGINT — Primary key — NOT NULL
- user_id (Key) — INT — Foreign key → Users.id — NOT NULL
- change_credits (Field) — BIGINT
- reason (Field2) — VARCHAR(24)
- created_at (Field3) — DATETIME
- total_credits (Field4) — BIGINT
vote_monthly (Untitled7)
- id (Key) — INT — Foreign key → Artists.id — NOT NULL
- month (Field) — DATE
- total_votes (Field2) — BIGINT
- tast_refreshed (Field3) — DATETIME
votes (Untitled6)
- id (Key3) — INT — Primary key — NOT NULL
- user_id (Key) — INT — Foreign key → Users.id — NOT NULL
- artist_id (Key2) — INT — Foreign key → Artists.id — NOT NULL
- vote_value (Field) — INT
- cost_credits (Field2) — INT
- voted_at (Field3) — DATETIME
- is_valid (Field4) — BOOLEAN