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