KTB_Week5
Tables (5)
Auth
- user_id — int — Foreign key → User.user_id — NOT NULL
- email — varchar
- password — varchar
Comment
- comment_id — int — Primary key — NOT NULL
- posted_time — timestamp — NOT NULL
- content — varchar
- user_id — int — Foreign key → User.user_id — NOT NULL
- post_id — int — Foreign key → Post.post_id — NOT NULL
Post
- post_id — int — Primary key — NOT NULL
- user_id — int — Foreign key → User.user_id — NOT NULL
- title — varchar
- content — varchar
- image — varchar
PostMetadata
- post_id — int — Foreign key → Post.post_id — NOT NULL
- posted_time — timestamp
- likes — int
- views — int
User
- user_id — int — Primary key — NOT NULL
- nickname — varchar
- profile_image — varchar
- is_deleted — boolean