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