디비고 ref

okky erd

테이블 (4)

Untitled (board)

  • Key (board_no) — number — 기본 키 — NOT NULL — primary key
  • Field (user_nick) — varchar2(30) — 기본 키 — NOT NULL
  • id (board_no2) — number — 외래 키 → content_vote.id — NOT NULL
  • id (reply_no) — number — 외래 키 → opinion.id — NOT NULL — primary key
  • Field (board_title) — varchar2(300) — NOT NULL
  • Field2 (board_content) — varchar2(4000) — NOT NULL
  • Field (board_read) — number — NOT NULL

content_vote (board_like)

  • id (board_no) — number — 기본 키 — NOT NULL
  • date_created (like_count) — number — NOT NULL

opinion (board_reply)

  • id (reply_no) — number — 기본 키 — NOT NULL — primary key
  • date_created (user_nick) — datetime — NOT NULL
  • comment (reply_read) — number — NOT NULL
  • Field (reply_content) — varchar(2000) — NOT NULL
  • Field

user

  • Key (user_no) — number — 기본 키 — NOT NULL
  • Field (user_nick2) — varchar2(30) — 외래 키 → Untitled.Field — NOT NULL
  • id (reply_no) — number — 외래 키 → opinion.id — NOT NULL — primary key
  • id (board_no2) — number — 외래 키 → Untitled.id — NOT NULL
  • id (reply_no2) — number — 외래 키 → Untitled.id — NOT NULL — primary key
  • id (user_email) — varchar2(50) — NOT NULL — unique
  • date_created (user_pw) — varchar2(30) — NOT NULL
  • password (user_phone) — number — NOT NULL
  • Field (user_nick) — varchar2(30) — NOT NULL
  • Field (regist_date) — varchar2(11) — NOT NULL