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