ERD-PRCTICE2

테이블 (5)

게시판 (BOARD)

  • BOARD_NO — NUMBER — 기본 키 — NOT NULL
  • TITLE — VARCHAR2(200) — NOT NULL — CLOB
  • CONTENT — VARCHAR2(200)
  • MEMBER_NO — NUMBER — 외래 키 → 회원.MEMBER_NO — NOT NULL
  • VIEW_COUNT — NUMBER
  • CREATE_DATE — DATE

댓글 (REPLY)

  • REPLY_ID — NUMBER — 기본 키 — NOT NULL
  • CONTENT — VARCHAR2(500) — NOT NULL
  • CREATE_DATE — DATE
  • MEMBER_NO — NUMBER — 외래 키 → 회원.MEMBER_NO — NOT NULL
  • BOARD_NO — NUMBER — 외래 키 → 게시판.BOARD_NO — NOT NULL

좋아요 (LIKES)

  • MEMBER_NO — NUMBER — 외래 키 → 회원.MEMBER_NO — NOT NULL
  • BOARD_NO — NUMBER — 외래 키 → 게시판.BOARD_NO — NOT NULL
  • LIKE_DATE — DATE

회원 (MEMBER)

  • MEMBER_NO — NUMBER — 기본 키 — NOT NULL
  • USER_ID — VARCHAR2(30) — NOT NULL
  • USER_PWD — VARCHAR2(100) — NOT NULL
  • USER_NAME — VARCHAR2(50) — NOT NULL
  • EMAIL — VARCHAR2(100)
  • ENROLL_DATE — DATE

회원 상세정보 (MEMBER_DETAIL)

  • MEMBER_NO — NUMBER — 외래 키 → 회원.MEMBER_NO — NOT NULL
  • PHONE — VARCHAR2(20)
  • ADDRESS — VARCHAR2(200)
  • BIRTHDATE — DATE