ㅇㅇ
Tables (4)
comments
- id — NUMBER
- post_id — NUMBER — Foreign key → posts.id — NOT NULL — 대상_게시글_ID
- user_id — NUMBER — Foreign key → users.id — NOT NULL — 작성자_회원_ID
- content — VARCHAR2(500) — NOT NULL — 댓글_내용
- created_at — TIMESTAMP — 작성일시
post_likes
- id — NUMBER
- post_id — NUMBER — Foreign key — NOT NULL — 대상_게시글_번호
- user_id — NUMBER — Foreign key — NOT NULL — 누른_회원_번호
- created_at — TIMESTAMP — 누른_일시
posts
- id — NUMBER
- user_id — NUMBER — Foreign key → users.id — NOT NULL — 작성자_회원_ID
- title — VARCHAR2(255) — NOT NULL — 게시글_제목
- content — CLOB — NOT NULL — 게시글_본문
- view_count — NUMBER — 조회수
- created_at — TIMESTAMP — 작성일시
- updated_at — TIMESTAMP — 수정일시
users
- id — NUMBER
- login_id — VARCHAR2(50) — NOT NULL — 로그인_아이디
- password — VARCHAR2(255) — NOT NULL — 비밀번호
- nickname — VARCHAR2(50) — NOT NULL — 닉네임
- created_at — TIMESTAMP — 가입일시