프로젝트 테스트

테이블 (4)

board

  • idx (board_idx) — number — 기본 키 — NOT NULL
  • idx (user_idx) — number — 외래 키 → user_information.idx — NOT NULL
  • Field2 (subject) — varchar2(100)
  • Field3 (content) — varchar2(5000)
  • Field4 (address) — varchar2(200)
  • Field5 (pay) — number
  • Field (category) — varchar2(20)
  • Field (regDate) — date
  • Field (clickCount) — number
  • Field (likeCount) — number
  • Field (commentCount) — number

comment

  • Key (comment_idx) — number — 기본 키 — NOT NULL
  • idx (board_idx) — number — 외래 키 → board.idx — NOT NULL
  • idx (user_idx) — number — 외래 키 → board.idx — NOT NULL
  • Field (content) — varchar2(150)
  • Field2 (regDate) — date
  • Field (category) — varchar2(20)

image

  • Key (image_idx) — number — 기본 키 — NOT NULL
  • idx (board_idx) — number — 외래 키 → board.idx — NOT NULL
  • idx (user_idx) — number — 외래 키 → board.idx — NOT NULL
  • Field (ofileName) — varchar2(100)
  • Field (sfileName) — varchar2(100)

user_information

  • idx (user_idx) — number — 기본 키 — NOT NULL
  • id — varchar2(50)
  • password — varchar2(50)
  • name — varchar2(50)
  • birth — date
  • gender — char(1)
  • email — varchar2(50)
  • phone — varchar2(20)
  • postcode (postCode) — varchar2(10)
  • addr1 — varchar2(200)
  • addr2 — varchar2(200)
  • use — number
  • lev — number
  • point — number