ㅇㅇ

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 — 가입일시