notice1

테이블 (4)

게시판 (notice)

  • PK (Idx) — number — 기본 키 — NOT NULL
  • FK (Userid) — varchar2 — 외래 키 → 회원.FK — NOT NULL
  • FK (nickname) — varchar2 — 외래 키 → 회원.FK
  • Field (Title) — varchar2
  • Field (Content) — varchar2
  • Field (Regdate) — date
  • Field (grade) — number

댓글 (NoticeComment)

  • PK (Idx) — number — 기본 키 — NOT NULL
  • FK (NoticeIdx) — number — 외래 키 → 게시판.PK — NOT NULL
  • FK (Userid) — varchar2 — 외래 키 → 회원.FK — NOT NULL
  • FK (nickname) — varchar2 — 외래 키 → 회원.FK
  • Field (content) — varchar2
  • Field (regdate) — date
  • Field (isdelete) — number

파일 (NoticeFile)

  • PK (Idx) — number — 기본 키 — NOT NULL
  • FK (NoticeIdx) — number — 외래 키 → 게시판.PK — NOT NULL
  • FK (Userid) — varchar2 — 외래 키 → 게시판.FK — NOT NULL
  • fK (nickname) — varchar2 — 외래 키 → 게시판.FK
  • Field (Sfile) — varchar2
  • Field (Ofile) — varchar2
  • Field (FileSize) — number
  • Field (FileType) — varchar2

회원 (Member)

  • PK (Idx) — number — 기본 키 — NOT NULL
  • FK (Userid) — varchar2 — 기본 키 — NOT NULL
  • FK (nickname) — varchar2 — 기본 키
  • Field (Pwd) — varchar2
  • Field (name) — varchar2
  • Field (email) — varchar2
  • Field (postnumber) — number
  • Field2 (street) — varchar2
  • Field (address) — varchar2
  • Field (regdate) — date
  • Field (grade) — number
  • Field (icon) — varchar2