codeit

Tables (5)

artists (Untitled3)

  • artist_id (Key) — NOT NULL — Primary key — NOT NULL
  • name (Field) — NOT NULL
  • group (Field2)
  • agency (Field3)
  • profile_image_url (Field4) — NOT NULL

credit_transactions (Untitled5)

  • transaction_id (Key) — NOT NULL — Primary key — NOT NULL
  • user_id (Key2) — NOT NULL — Foreign key → user.user_id — NOT NULL
  • support_id (Key3) — NOT NULL — Foreign key → supports.support_id — NOT NULL
  • amount (Field) — NOT NULL
  • Field3
  • label (Field2)
  • Field4

supports (Untitled2)

  • support_id (Key) — NOT NULL — Primary key — NOT NULL
  • title (Field) — NOT NULL
  • Field2

user (Untitled)

  • user_id (Key) — NOT NULL — Primary key — NOT NULL
  • id (Field) — NOT NULL
  • password (Field2) — NOT NULL
  • nickname (Field3) — NOT NULL
  • credit (Field4)

votes (Untitled4)

  • artist_id (Key2) — NOT NULL — Foreign key → artists.artist_id — NOT NULL
  • user_id (Key) — NOT NULL — Foreign key → user.user_id — NOT NULL
  • vote_count (Field)
  • Field2