테스트2
테이블 (6)
attachments
- id — NUMBER
- post_id — NUMBER — 외래 키 → posts.id — NOT NULL
- file_path — VARCHAR2(500) — NOT NULL
- original_name — VARCHAR2(255)
- uploaded_at — DATE — NOT NULL
boards
- id — NUMBER
- name — VARCHAR2(50) — NOT NULL
- description — VARCHAR2(500)
comments
- id — NUMBER
- post_id — NUMBER — 외래 키 → posts.id — NOT NULL
- user_id — NUMBER — 외래 키 → users.id — NOT NULL
- parent_id — NUMBER — 외래 키 → comments.id
- content — VARCHAR2(1000) — NOT NULL
- created_at — DATE — NOT NULL
likes
- user_id — NUMBER — 외래 키 → users.id — NOT NULL
- post_id — NUMBER — 외래 키 → posts.id — NOT NULL
- created_at — DATE — NOT NULL
posts
- id — NUMBER
- board_id — NUMBER — 외래 키 → boards.id — NOT NULL
- user_id — NUMBER — 외래 키 → users.id — NOT NULL
- title — VARCHAR2(200) — NOT NULL
- content — CLOB — NOT NULL
- view_count — NUMBER — NOT NULL
- created_at — DATE — NOT NULL
- updated_at — DATE
users
- id — NUMBER
- email — VARCHAR2(100) — NOT NULL
- password_hash — VARCHAR2(255) — NOT NULL
- nickname — VARCHAR2(50) — NOT NULL
- role — VARCHAR2(20) — NOT NULL
- created_at — DATE — NOT NULL