NGBOARD

테이블 (6)

게시글이미지 (NG_BoardImage)

  • Key (image_no) — NUMBER — 기본 키 — NOT NULL
  • Key (board_no) — NUMBER — 외래 키 → 게시판정보.Key — NOT NULL
  • Field (image_url) — VARCHAR2(1000)
  • Field (image_original_filename) — VARCHAR2(1000)

게시판정보 (NG_Board)

  • Key (board_no) — NUMBER — 기본 키 — NOT NULL
  • Key (member_no) — NUMBER — 외래 키 → 회원정보.Key — NOT NULL
  • Field (board_content) — VARCHAR2(1000)
  • Field (board_writedate) — DATE

댓글 (NG_Comment)

  • Key (comment_no) — NUMBER — 기본 키 — NOT NULL
  • Key (member_no) — NUMBER — 외래 키 → 회원정보.Key — NOT NULL
  • Key (board_no) — NUMBER — 외래 키 → 게시판정보.Key — NOT NULL
  • Field (comment_content) — VARCHAR(200)
  • Field (comment_writedate) — DATE

메일인증 (NG_MailAuth)

  • Key (mailauth_no) — NUMBER — 기본 키 — NOT NULL
  • Key (member_no) — NUMBER — 외래 키 → 회원정보.Key — NOT NULL
  • Field (mailauth_key) — VARCHAR2(400)
  • Field (mailauth_complete) — VARCHAR2(1)
  • Field (mailauth_date) — DATE

좋아요 (NG_BoardLike)

  • Key (like_no) — NUMBER — 기본 키 — NOT NULL
  • Key (member_no) — NUMBER — 외래 키 → 회원정보.Key — NOT NULL
  • Key (board_no) — NUMBER — 외래 키 → 게시판정보.Key — NOT NULL
  • Field (like_date) — DATE

회원정보 (NG_Member)

  • Key (member_no) — NUMBER — 기본 키 — NOT NULL
  • Field (member_id) — VARCHAR2(20)
  • Field (member_pw) — VARCHAR2(100)
  • Field (member_gender) — VARCHAR2(1)
  • Field (member_birth) — DATE
  • Field (member_phone) — VARCHAR2(30)
  • Field (member_email) — VARCHAR2(100)
  • Field (member_joindate) — DATE