WWWE

Tables (3)

Comment (tbl_comment)

  • id — PK — Primary key — NOT NULL
  • post_id — PK — Foreign key → Post.id — NOT NULL
  • user_id — PK — Foreign key → User.id — NOT NULL
  • content — NOT NULL

Post (tbl_post)

  • id — PK — Primary key — NOT NULL
  • user_id — FK — Foreign key → User.id — NOT NULL
  • total_likes — NOT NULL
  • created_at — NOT NULL
  • total_comments (total_coments) — NOT NULL
  • content — NOT NULL
  • post_image_url (post_image) — NOT NULL
  • post_type — NOT NULL

User (tbl_user)

  • id — PK — Primary key — NOT NULL
  • email — NOT NULL
  • profile_url
  • username
  • created_at — NOT NULL
  • updated_at — NOT NULL