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