fandomk

Tables (8)

artist (Untitled5)

  • artist_id (Key) — Primary key — NOT NULL
  • name (Field)
  • description (Field2)
  • created_at (Field3)

credit (Untitled2)

  • credit_id (Key) — Primary key — NOT NULL
  • user_id (Key2) — Foreign key → user.user_id — NOT NULL
  • amount (Field2)
  • type (Field3)
  • created_at (Field4)
  • creditcol (Field)

follow (Untitled3)

  • follow_id (Key) — Primary key — NOT NULL
  • user_id (Key3) — Foreign key → user.user_id — NOT NULL
  • artist_id (Key2) — Foreign key → artist.artist_id — NOT NULL
  • followed_at (Field)

project (Untitled6)

  • project_id (Key) — Primary key — NOT NULL
  • artist_id (Key2) — Foreign key → artist.artist_id — NOT NULL
  • title (Field)
  • description (Field2)
  • target_credit (Field3)
  • status (Field4)
  • created_at (Field5)

projectsupport (Untitled7)

  • support_id (Key) — Primary key — NOT NULL
  • user_id (Key2) — Foreign key → user.user_id — NOT NULL
  • artist_id (Key3) — Foreign key → artist.artist_id — NOT NULL
  • credit_amount (Field)
  • supported_at (Field2)

user (Untitled)

  • user_id (Key) — Primary key — NOT NULL
  • email (Field)
  • passward (Field2)
  • nickname (Field3)
  • created_ata (Field4)

vote (Untitled4)

  • vote_id (Key) — Primary key — NOT NULL
  • user_id (Key3) — Foreign key → user.user_id — NOT NULL
  • artist_id (Key4) — Foreign key → artist.artist_id — NOT NULL
  • category_id (Key2) — Foreign key → votecategory.category_id — NOT NULL
  • credit_used (Field)
  • voted_at (Field2)

votecategory (Untitled8)

  • category_id (Key) — Primary key — NOT NULL
  • name (Field)
  • description (Field2)