220801_선생님
테이블 (7)
Board
- boardno — NUMBER — 기본 키 — NOT NULL
- cateno — NUMBER — 외래 키 → board_cate.cateno — NOT NULL
- title — VARCHAR2(500)
- content — VARCHAR2(4000)
- insert_dat — DATE
- update_dat — DATE
- hit — NUMBER
- userno — NUMBER — 외래 키 → userTb.userno — NOT NULL
board_cate
- cateno — NUMBER — 기본 키 — NOT NULL
- cate_name — VARCHAR2(100) — NOT NULL
- cate_dat — DATE — NOT NULL
commenttb
- commentno — NUMBER — 기본 키 — NOT NULL
- userno — NUMBER — 외래 키 → userTb.userno — NOT NULL
- boardno — NUMBER — 외래 키 → Board.boardno — NOT NULL
- content — VARCHAR2(4000)
- insert_dat — DATE
filetb
- fileno — NUMBER — 기본 키 — NOT NULL
- boardno — NUMBER — 외래 키 → Board.boardno — NOT NULL
- filename — VARCHAR2(500)
- filepathV — VARCHAR2(1000)
- filesize — NUMBER
- filetype — VARCHAR2(50)
grade
- grade — NUMBER — 기본 키 — NOT NULL
- gradename — VARCHAR2(100) — NOT NULL
report
- report — NUMBER — 기본 키 — NOT NULL
- report_dat — DATE — NOT NULL
- report_reason — VARCHAR2(4000) — NOT NULL
userTb
- userno — NUMBER — 기본 키 — NOT NULL
- userid — VARCHAR2(100) — NOT NULL
- userpw — VARCHAR2(100) — NOT NULL
- gender — VARCHAR2(1)
- email — VARCHAR2(100)
- phone — VARCHAR2(11)
- grade — NUMBER — 외래 키 → grade.grade — NOT NULL
- report — NUMBER — 외래 키 → report.report