게시판
테이블 (3)
comments
- id — INTEGER
- post_id — INTEGER — 외래 키 → posts.id — NOT NULL
- user_id — INTEGER — 외래 키 → users.id — NOT NULL
- content — TEXT — NOT NULL
- is_deleted — INTEGER
- created_at — TEXT
- updated_at — TEXT
posts
- id — INTEGER
- user_id — INTEGER — 외래 키 → users.id — NOT NULL
- title — TEXT — NOT NULL
- content — TEXT — NOT NULL
- view_count — INTEGER
- is_notice — INTEGER
- is_deleted — INTEGER
- created_at — TEXT
- updated_at — TEXT
users
- id — INTEGER
- username — TEXT — NOT NULL
- password_hash — TEXT — NOT NULL
- name — TEXT — NOT NULL
- student_number — TEXT — NOT NULL
- role — TEXT
- profile_message — TEXT
- created_at — TEXT
- updated_at — TEXT