sprint_17

Tables (8)

Artist

  • artist_id — INT — Primary key — NOT NULL
  • name — VARCHAR(100)
  • agency — VARCHAR(100)
  • debut_date — DATE
  • description — TEXT
  • user_id — INT

Category

  • category_id — INT — Primary key — NOT NULL
  • name — VARCHAR(100)
  • description — TEXT
  • vote_id — INT — Foreign key → Vote.vote_id — NOT NULL

CreditTransaction

  • transaction_id — INT — Primary key — NOT NULL
  • user_id (Field) — INT
  • artist_id — INT
  • followed_at — DATETIME
  • Field2
  • Key (user_id) — int — Foreign key → User.Key — NOT NULL

Follow

  • follow_id — INT — Primary key — NOT NULL
  • user_id — INT
  • artist_id — INT
  • followed_at (Field) — DATETIME
  • Field2
  • Key (user_id2) — int — Foreign key → User.Key — NOT NULL
  • artist_id (artist_id2) — INT — Foreign key → Artist.artist_id — NOT NULL

Project

  • project_id (project_if) — INT — Primary key — NOT NULL
  • artist_id — INT
  • title — VARCHAR(255)
  • goal_credit — INT
  • current_credit — INT
  • start_date — DATE
  • end_date (Field) — DATE
  • status — ENUM
  • artist_id (artist_id2) — INT — Foreign key → Artist.artist_id — NOT NULL
  • support_id — INT — Foreign key → Support.support_id — NOT NULL
  • support_id (support_id2) — INT — Foreign key → Support.support_id — NOT NULL

Support

  • support_id — INT — Primary key — NOT NULL
  • user_id — INT
  • project_id — INT
  • supported_at — DATETIME
  • supported_credit — INT
  • Key (user_id2) — int — Foreign key → User.Key — NOT NULL

User

  • Key (user_id) — int — Primary key — NOT NULL
  • password — varchar(50)
  • name — varchar(50)
  • Field2 (email) — varchar(100)
  • credit_balance — INT
  • credit_at — DATETIME
  • profile_image_url — varchar(255)

Vote

  • vote_id — INT — Primary key — NOT NULL
  • user_id — INT
  • artist_id — INT
  • category_id — INT
  • vote_credit — INT
  • vote_at — DATETIME
  • Key (user_id2) — int — Foreign key → User.Key — NOT NULL