dev-blog
Tables (4)
Category
- PK (id) — BIGINT — Primary key — NOT NULL
- (name) — VARCHAR(50)
- (description) — VARCHAR(100)
- (created_at) — DATETIME
- (modified_at) — DATETIME
Comment
- PK (id) — BIGINT — Primary key — NOT NULL
- FK (user_id) — BIGINT
- FK (post_id) — BIGINT
- (content) — VARCHAR(255)
- (created_at) — DATETIME
- (modified_at) — DATETIME
- (deleted_at) — DATETIME
Post
- PK (id) — BIGINT — Primary key — NOT NULL
- FK (user_id) — BIGINT
- FK (category_id) — VARCHAR(255)
- (title) — VARCHAR(100)
- (content) — TEXT
- (post_image) — VARCHAR(255)
- (created_at) — DATETIME
- (modified_at) — DATETIME
- (deleted_at) — VARCHAR(255)
User
- PK (id) — BIGINT — Primary key — NOT NULL
- (email) — VARCHAR(50)
- (password) — VARCHAR(100)
- (nickname) — VARCHAR(20)
- (profile_image) — VARCHAR(255)
- (user_role) — ENUM('USER', 'ADMIN')
- (created_at) — DATETIME
- (modified_at) — DATETIME
- (deleted_at) — DATETIME