Sepfolio
Tables (4)
comments
- id — INT — Primary key — NOT NULL
- user_id — INT — Foreign key → users.id — NOT NULL
- post_id — INT — Foreign key → posts.id — NOT NULL
- content — TEXT — NOT NULL
- created_at — TIMESTAMP
likes
- user_id — INT — Foreign key → users.id — NOT NULL
- post_id — INT — Foreign key → posts.id — NOT NULL
posts
- id — INT — Primary key — NOT NULL
- title — VARCHAR(255) — NOT NULL
- body — TEXT — NOT NULL
- user_id — INT — Foreign key → users.id — NOT NULL
- post_image — VARCHAR(255)
- view_count — INT
- like_count — INT
- comment_count — INT
- created_at — TIMESTAMP
users
- id — INT — Primary key — NOT NULL
- name — VARCHAR(255) — NOT NULL
- email — VARCHAR(255) — NOT NULL
- password — VARCHAR(255) — NOT NULL
- profile_image — VARCHAR(255)
- created_at — TIMESTAMP