KH 3조
테이블 (7)
board
- boardno — NUMBER — NOT NULL
- titile — VARCHAR2(30)
- content — VARCHAR2(50)
- insert_dat — DATE
- update_dat — DATE
- hit — NUMBER
- cateno — NUMBER — NOT NULL
- userno — NUMBER — NOT NULL
board_cate
- cateno — NUMBER — NOT NULL
- cate_name — VARCHAR2(20)
- cate_dat — DATE
commenttb
- commentno — NUMBER — NOT NULL
- content — VARCHAR2(50)
- insert_date — DATE
- boardno — NUMBER — NOT NULL
- userno — NUMBER — NOT NULL
filetb
- fileno — NUMBER — NOT NULL
- filename — VARCHAR2(20)
- filepath — VARCHAR2(30)
- filesize — NUMBER
- filetype — VARCHAR2(10)
- boardno — NUMBER — NOT NULL
grade
- grade — NUMBER — NOT NULL
- gradename — VARCHAR2(10) — NOT NULL
report
- report — NUMBER — NOT NULL
- report_dat — DATE — NOT NULL
- report_reason — VARCHAR2(50) — NOT NULL
userTb
- userno — NUMBER — NOT NULL
- userid — VARCHAR2(20) — NOT NULL
- userpw — VARCHAR2(20) — NOT NULL
- gender — VARCHAR2(5)
- email — VARCHAR2(20)
- phone — VARCHAR2(10)
- grade — NUMBER — NOT NULL
- report — NUMBER — NOT NULL