test
Tables (4)
boards
- board_id — INTEGER
- name — TEXT — NOT NULL
- description — TEXT
- created_at — DATETIME
comments
- comment_id — INTEGER
- post_id — INTEGER — Foreign key → posts.post_id — NOT NULL
- author_id — INTEGER — Foreign key → users.user_id — NOT NULL
- parent_id — INTEGER — Foreign key → comments.comment_id
- content — TEXT — NOT NULL
- created_at — DATETIME
- deleted_at — DATETIME
posts
- post_id — INTEGER
- board_id — INTEGER — Foreign key → boards.board_id — NOT NULL
- author_id — INTEGER — Foreign key → users.user_id — NOT NULL
- title — TEXT — NOT NULL
- content — TEXT — NOT NULL
- view_count — INTEGER
- is_notice — INTEGER
- created_at — DATETIME
- updated_at — DATETIME
- deleted_at — DATETIME
users
- user_id — INTEGER
- username — TEXT — NOT NULL
- email — TEXT — NOT NULL
- password_hash — TEXT — NOT NULL
- role — TEXT
- created_at — DATETIME
- updated_at — DATETIME
- deleted_at — DATETIME