blog
Tables (21)
AuditLogs
- id — INT
- action — VARCHAR(255)
- user_id — INT
- details — TEXT
- created_at — TIMESTAMP
Blogs
- id — INT
- user_id — INT
- title — VARCHAR(255)
- description — TEXT
- cover_image_url — VARCHAR(255)
Comments
- id — INT
- post_id — INT
- user_id — INT
- content — TEXT
- created_at — TIMESTAMP
DraftImages
- id — INT
- draft_id — INT
- image_url — VARCHAR(255)
Drafts
- id — INT
- user_id — INT
- title — VARCHAR(255)
- content — TEXT
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
Followers
- id — INT
- user_id — INT
- follower_id — INT
- created_at — TIMESTAMP
Likes
- id — INT
- user_id — INT
- post_id — INT
Messages
- id — INT
- sender_id — INT
- receiver_id — INT
- content — TEXT
- created_at — TIMESTAMP
Notifications
- id — INT
- user_id — INT
- type — VARCHAR(255)
- message — TEXT
- read_status — BOOLEAN
- created_at — TIMESTAMP
PostImages
- id — INT
- post_id — INT
- image_url — VARCHAR(255)
PostTags
- post_id — INT
- tag_id — INT
Posts
- id — INT
- blog_id — INT
- series_id — INT
- title — VARCHAR(255)
- content — TEXT
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
Replies
- id — INT
- comment_id — INT
- user_id — INT
- content — TEXT
- created_at — TIMESTAMP
Reports
- id — INT
- reporter_id — INT
- reported_id — INT
- type — VARCHAR(255)
- reason — TEXT
- created_at — TIMESTAMP
Roles
- id — INT
- name — VARCHAR(255)
Series
- id — INT
- blog_id — INT
- title — VARCHAR(255)
- cover_image_url — VARCHAR(255)
Subscriptions
- id — INT
- user_id — INT
- blog_id — INT
- created_at — TIMESTAMP
Tags
- id — INT
- name — VARCHAR(255)
UserRoles
- role_id — INT
- user_id — INT
- id (id2) — INT — Foreign key → Users.id
Users
- id — INT — Primary key
- username — VARCHAR(255)
- email — VARCHAR(255)
- password — VARCHAR(255)
- profile_image_url — VARCHAR(255)
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
Views
- id — INT
- post_id — INT
- view_count — INT
- created_at — TIMESTAMP