디비고 ERD

okky erd

테이블 (7)

content (tip_content)

  • id — number — 기본 키 — NOT NULL
  • id (user_id) — number — 외래 키 → user.id — NOT NULL
  • date_created — date — NOT NULL
  • text — varchar2(4000) — NOT NULL
  • Field (start_date) — date — NOT NULL
  • Field (end_date) — date — NOT NULL
  • Field (title) — varchar2(255)
  • Field (vote_count) — number — NOT NULL — default 0

content_vote (tip_vote)

  • id — number — 기본 키 — NOT NULL
  • id (user_id) — number — 외래 키 → user.id — NOT NULL
  • content_id — number — 외래 키 → content.id — NOT NULL
  • date_created — date — NOT NULL

opinion (tip_opinion)

  • id — number — 기본 키 — NOT NULL
  • id (user_id) — number — 외래 키 → user.id — NOT NULL
  • content_id — number — 외래 키 → content.id — NOT NULL
  • comment — varchar2(4000) — NOT NULL
  • date_created — date — NOT NULL

qna (qna_content)

  • id — number — 기본 키 — NOT NULL
  • id (user_id) — number — 외래 키 → user.id — NOT NULL
  • date_created — date — NOT NULL
  • text — varchar2(4000) — NOT NULL
  • Field (category) — varchar2(255) — NOT NULL
  • Field (title) — varchar2(255)
  • Field (vote_count) — number

qna_opinion

  • id — number — 기본 키 — NOT NULL
  • id (content_id) — number — 외래 키 → qna.id — NOT NULL
  • id (user_id) — number — 외래 키 → user.id — NOT NULL
  • comment — varchar2(4000) — NOT NULL
  • date_created — date — NOT NULL
  • last_updated — date — NOT NULL

qna_vote

  • id — number — 기본 키 — NOT NULL
  • id (content_id) — number — 외래 키 → qna.id — NOT NULL
  • id (user_id) — number — 외래 키 → user.id — NOT NULL
  • date_created — date — NOT NULL

user

  • id — number — 기본 키 — NOT NULL
  • date_created — date — NOT NULL
  • password — varchar2(255) — NOT NULL
  • Field (email) — varchar2(255) — NOT NULL
  • Field (nick_name) — varchar2(255) — NOT NULL