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

Untitled