test1
Tables (4)
COMMENTS
- ID — NUMBER — 댓글
- POST_ID — NUMBER — Foreign key → POSTS.ID — NOT NULL — 게시글
- USER_ID — NUMBER — Foreign key → USERS.ID — NOT NULL — 작성자
- CONTENT — VARCHAR2(1000) — NOT NULL
- CREATED_AT — DATE
POSTS
- ID — NUMBER — 게시글
- USER_ID — NUMBER — Foreign key → USERS.ID — NOT NULL — 작성자
- TITLE — VARCHAR2(200) — NOT NULL — 게시글
- CONTENT — CLOB — NOT NULL — 게시글
- VIEW_COUNT — NUMBER
- CREATED_AT — DATE
- UPDATED_AT — DATE
USERS
- ID — NUMBER — 사용자
- USER_ID — VARCHAR2(50) — NOT NULL — 로그인
- PASSWORD — VARCHAR2(255) — NOT NULL — 암호화된
- NICKNAME — VARCHAR2(50) — NOT NULL — 사용자
- EMAIL — VARCHAR2(100)
- ROLE — VARCHAR2(20)
- CREATED_AT — DATE