ex1

Tables (7)

Untitled (첨부파일)

  • Key (파일번호) — number — Primary key — NOT NULL
  • Field (게시글코드) — varchar2
  • Field2 (파일이름) — varchar2
  • Field (파일저장경로) — varchar2
  • Field (파일크기) — number
  • Field (파일타입) — varchar2

Untitled3 (댓글)

  • Key (댓글번호) — number — Primary key — NOT NULL
  • Field (게시글코드) — boardno
  • Field (댓글작성자) — userno
  • Field2 (댓글내용) — varchar2
  • Field (작성일) — date

board (게시판)

  • boardno (게시판코드) — number — Primary key — NOT NULL
  • Field (게시판종류코드) — varchar2
  • Field2 (글제목) — varchar2
  • Field3 (글내용) — varchar2
  • Field (작성일) — date
  • Field (수정일) — date
  • Field (조회수) — number
  • Field (작성자) — varchar2

board_cate (게시판 종류)

  • cateno (게시판종류코드) — number — Primary key
  • cate_name (게시판종류이름) — varchar2 — NOT NULL
  • cate_dat (게시판종류등록일) — date — NOT NULL

grade (회원등급)

  • Key (등급코드) — number — Primary key — NOT NULL
  • gradename (등급명) — varchar2 — NOT NULL

report (회원신고)

  • Key (신고코드) — number — Primary key — NOT NULL
  • report_dat (신고일) — date
  • report_reason (신고사유) — varchar2

userid (회원)

  • Key (회원번호) — number — Primary key — NOT NULL
  • userid (회원아이디) — varchar2
  • userpw (회원비밀번호) — varchar2
  • gender (성별) — number
  • email (이메일) — varchar2
  • phone (전화번호) — varchar2
  • grade (등급코드) — varchar2
  • report (신고코드) — number