tttt

Tables (5)

artist

  • artist_id — INT — Primary key
  • artist_name — VARCHAR(255) — NOT NULL

comment

  • comment_id — INT — Primary key
  • post_id (post_id2) — INT — Foreign key → posts.post_id
  • user_id (user_id2) — INT — Foreign key → posts.user_id
  • comment_content — TEXT — NOT NULL

fandom

  • fandom_id — INT — Primary key
  • artist_id — INT — Foreign key → artist.artist_id
  • fandom_name — VARCHAR(255) — NOT NULL

posts

  • post_id — INT — Primary key
  • user_id — INT — Foreign key → user.user_id
  • fandom_id — INT — Foreign key → fandom.fandom_id
  • post_title — VARCHAR(255) — NOT NULL
  • post_content — TEXT
  • tag — VARCHAR(50) — NOT NULL

user

  • user_id — INT — Primary key
  • fandom_id — INT — Foreign key → fandom.fandom_id
  • user_name — VARCHAR(255) — NOT NULL