prac

Tables (7)

board (게시판)

  • boardno (게시글코드) — NUMBER — Primary key — NOT NULL
  • userno (작성자) — VARCHAR2(30) — Primary key — NOT NULL
  • title (글제목) — VARCHAR2(100)
  • content (글내용) — VARCHAR2(300)
  • insert_dat (작성일) — DATE
  • update_dat (수정일) — DATE
  • hit (조회수) — NUMBER
  • cateno (게시판종류코드) — NUMBER — Foreign key → board_cate.cateno — NOT NULL

board_cate (게시판 종류)

  • cateno (게시판종류코드) — NUMBER — Primary key — NOT NULL
  • cate_name (게시판종류이름) — VARCHAR2(20) — NOT NULL
  • cate_dat (게시판종류등록일) — DATE — NOT NULL

commenttb (댓글)

  • commentno (댓글번호) — NUMBER — Primary key — NOT NULL
  • content (댓글내용) — VARCHAR2(100)
  • insert_dat (작성일) — DATE
  • boardno (게시글코드) — NUMBER — Foreign key → board.boardno — NOT NULL
  • userno (댓글작성자) — VARCHAR2(30) — Foreign key → board.userno — NOT NULL

filetb (첨부파일)

  • fileno (파일번호) — NUMBER — Primary key — NOT NULL
  • filename (파일이름) — VARCHAR2(20)
  • filepath (파일저장경로) — VARCHAR2(100)
  • filesize (파일크기) — NUMBER
  • filetype (파일타입) — VARCHAR2(20)
  • boardno (게시글코드) — NUMBER — Foreign key → board.boardno — NOT NULL
  • userno (작성자) — VARCHAR2(30) — Foreign key → board.userno — NOT NULL

grade (회원등급)

  • grade (등급코드) — NUMBER — Primary key — NOT NULL
  • gradename (등급명) — VARCHAR2(10)

report (회원신고)

  • report (신고코드) — NUMBER — Primary key — NOT NULL
  • report_dat (신고일) — DATE — NOT NULL
  • report_reason (신고사유) — VARCHAR2(20) — NOT NULL

userTb (회원)

  • userno (회원번호) — NUMBER — Primary key — NOT NULL
  • userid (회원아이디) — VARCHAR2(20) — NOT NULL
  • userpw (회원비밀번호) — VARCHAR2(20) — NOT NULL
  • gender (성별) — VARCHAR2(10)
  • email (이메일) — VARCHAR2(20)
  • phone (전화번호) — VARCHAR2(20)
  • grade (등급코드) — NUMBER — Foreign key → grade.grade — NOT NULL
  • report (신고코드) — NUMBER — Foreign key → report.report — NOT NULL