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