practice-ERD

ERD 연습하는 화면

테이블 (3)

User (Untitled)

  • (id) — VARCHAR2(14) — 기본 키 — NOT NULL
  • (name) — VARCHAR2(14) — NOT NULL
  • (pw) — VARCHAR2(30) — NOT NULL
  • (reg_dater) — DATE

board (Untitled2)

  • Key (board_no) — NUMBER — 기본 키 — NOT NULL
  • Field (title) — VARCHAR2(500) — NOT NULL
  • Field2 — VARCHAR(4000)
  • Field (writer) — VARCHAR2(14) — NOT NULL
  • (id) — VARCHAR2(14) — 외래 키 → User.id — NOT NULL

reply (Untitled3)

  • Key (reply_no) — NUMBER — 기본 키 — NOT NULL
  • (id) — VARCHAR2(14) — 외래 키 → User.id — NOT NULL
  • Key (board_no) — NUMBER — 외래 키 → board.Key — NOT NULL
  • Field (reply_content) — VARCHAR2(500) — NOT NULL