board
Tables (6)
Attachments (attachments)
- file_id — INT — Primary key — NOT NULL
- original_name — VARCHAR(255)
- save_name — VARCHAR(255)
- file_path — VARCHAR(255)
- file_size — BIGINT
- post_id — INT — Foreign key → Posts.post_id — NOT NULL
Categories (categories)
- category_id — INT — Primary key — NOT NULL
- name — VARCHAR(255)
- slug — VARCHAR(255)
Comments (comments)
- comment_id — INT — Primary key — NOT NULL
- content — VARCHAR(255)
- created_at — DATETIME
- post_id — INT — Foreign key → Posts.post_id — NOT NULL
- user_id — INT — Foreign key → Users.user_id — NOT NULL
- parent_id — INT — Foreign key → Comments.comment_id
Likes (likes)
- like_id — INT — Primary key — NOT NULL
- created_at — DATETIME
- post_id — INT — Foreign key → Posts.post_id — NOT NULL
- user_id — INT — Foreign key → Users.user_id — NOT NULL
Posts (posts)
- post_id — INT — Primary key — NOT NULL
- title — VARCHAR(255)
- content — LONGTEXT
- view_count — INT
- created_at — DATETIME
- updated_at — DATETIME
- is_deleted — BOOLEAN
- user_id — INT — Foreign key → Users.user_id — NOT NULL
- category_id — INT — Foreign key → Categories.category_id — NOT NULL
Users (users)
- user_id — INT — Primary key — NOT NULL
- email — VARCHAR(255)
- password — VARCHAR(255)
- name — VARCHAR(255)
- nickname — VARCHAR(100)
- phone_number — VARCHAR(20)
- role — VARCHAR(20)
- created_at — DATETIME