MyBlog
Tables (3)
comment
- comment_id — BIGINT — Primary key — NOT NULL
- user_id — BIGINT — Foreign key → user.user_id — NOT NULL
- post_id — BIGINT — Foreign key → post.post_id — NOT NULL
- comment_id (parent_id) — BIGINT — Foreign key → comment.comment_id — NOT NULL
- content — TEXT
- like_count — INT
- is_deleted — BOOLEAN
- created_at — TIMESTAMP
- modified_at (modefied_at) — TIMESTAMP
- depth — INT
post (post_id)
- post_id — BIGINT — Primary key — NOT NULL
- user_id — BIGINT — Foreign key → user.user_id — NOT NULL
- title — VARCHAR(50)
- content — TEXT
- thumbnail_url — VARCHAR(512)
- view_count
- like_count
- is_published — BOOLEAN
- create_at — TIMESTAMP
- modified_at — TIMESTAMP
user
- user_id — BIGINT — Primary key — NOT NULL
- username — VARCHAR(50)
- password — VARCHAR(255)
- email — VARCHAR(100)
- nickname — VARCHAR(50)
- role — ENUM('ADMIN', 'GUEST')
- created_at — TIMESTAMP
- modified_at — TIMESTAMP