sprint 8

Tables (7)

artists (Untitled2)

  • id (Key) — Primary key — NOT NULL
  • name (Field)
  • agency (Field2)
  • debut_date (Field3)

credits (Untitled7)

  • Key — Primary key — NOT NULL
  • user_id (Key2) — Foreign key → users.id — NOT NULL
  • amount (Field2)
  • reason_type (Field3)
  • credits_at (Field5)

follows (Untitled3)

  • id (Key) — Primary key — NOT NULL
  • user_id (Key2) — Foreign key → users.id — NOT NULL
  • artists_id (Key3) — Foreign key → artists.id — NOT NULL
  • followed_at (Field3)

projects (Untitled5)

  • id (Key) — Primary key — NOT NULL
  • artist_id (Key2) — Foreign key → artists.id — NOT NULL
  • total_credits (Field)
  • deadline (Field2)

supports (Untitled6)

  • id (Key) — Primary key — NOT NULL
  • project_id (Key2) — Foreign key → projects.id — NOT NULL
  • user_id (Key3) — Foreign key → users.id — NOT NULL
  • id (Key22) — Foreign key → projects.artist_id — NOT NULL
  • credit (Field)
  • project_at (Field2)

users (Untitled)

  • id (Key) — Primary key — NOT NULL
  • user_name (Field)
  • password (Field2)
  • email (Field3)
  • created_at (Field4)
  • credits (Field5)

votes (Untitled4)

  • id (Key) — Primary key — NOT NULL
  • user_id (Key2) — Foreign key → users.id — NOT NULL
  • artists_id (Key3) — Foreign key → artists.id — NOT NULL
  • vote_at (Field3)