테스트
테이블 (4)
comments
- comment_id — NUMBER
- post_id — NUMBER — 외래 키 → posts.post_id — NOT NULL
- author_id — NUMBER — 외래 키 → users.user_id — NOT NULL
- content — VARCHAR2(1000) — NOT NULL
- parent_comment_id — NUMBER — 외래 키 → comments.comment_id
- created_at — DATE
likes
- like_id — NUMBER
- user_id — NUMBER — 외래 키 → users.user_id — NOT NULL
- post_id — NUMBER — 외래 키 → posts.post_id — NOT NULL
- created_at — DATE
posts
- post_id — NUMBER
- title — VARCHAR2(200) — NOT NULL
- content — CLOB — NOT NULL
- author_id — NUMBER — 외래 키 → users.user_id — NOT NULL
- view_count — NUMBER
- is_public — CHAR(1)
- created_at — DATE
- updated_at — DATE
users
- user_id — NUMBER
- username — VARCHAR2(50) — NOT NULL
- password — VARCHAR2(255) — NOT NULL
- email — VARCHAR2(100) — NOT NULL
- role — VARCHAR2(20) — NOT NULL
- created_at — DATE
- updated_at — DATE