quiz
Tables (6)
FK (Untitled)
- grade (등급코드) — number — Primary key — NOT NULL
- report (신고코드) — number — Primary key — NOT NULL
- userno (회원번호) — number — Foreign key → userTb.userno — NOT NULL
- report (신고코드2) — NUMBER — Foreign key → userTb.report — NOT NULL
- cateno (게시판종류코드) — NUMBER — Foreign key → userTb.cateno — NOT NULL
board (게시판)
- boardno (게시글코드) — NUMBER — Primary key — NOT NULL
- userno (회원번호) — number — Foreign key → userTb.userno — NOT NULL
- report (신고코드2) — NUMBER — Foreign key → userTb.report — NOT NULL
- cateno (게시판종류코드2) — NUMBER — Foreign key → userTb.cateno — NOT NULL
- cateno (게시판종류코드) — VARCHAR2(100)
- title (글제목) — VARCHAR2(100)
- content (글내용) — VARCHAR2(100)
- insert_dat (작성일) — DATE
- update_dat (수정일) — DATE
- hit (조회수) — NUMBER
- userno (작성자) — VARCHAR2(100)
board_cate (게시판 종류)
- cateno (게시판종류코드) — NUMBER — Primary key — NOT NULL
- cate_name (게시판종류이름) — VARCHAR2(100)
- cate_dat (게시판종류등록일) — DATE
grade (회원등급)
- grade (등급코드) — NUMBER — Primary key — NOT NULL
- userno (회원번호) — number — Foreign key → userTb.userno — NOT NULL
- report (신고코드2) — NUMBER — Foreign key → userTb.report — NOT NULL
- cateno (게시판종류코드) — NUMBER — Foreign key → userTb.cateno — NOT NULL
- gradename (등급명) — VARCHAR2(100)
report (회원신고)
- report (신고코드) — NUMBER — Primary key — NOT NULL
- report_dat (신고일) — DATE
- report_reason (신고사유) — VARCHAR2(100)
userTb (회원)
- userno (회원번호) — number — Primary key — NOT NULL
- report (신고코드2) — NUMBER — Foreign key → report.report — NOT NULL
- cateno (게시판종류코드) — NUMBER — Foreign key → board_cate.cateno — NOT NULL
- userid (회원아이디) — VARCHAR2(100)
- userpw (회원비밀번호) — VARCHAR2(100)
- gender (성별) — VARCHAR2(100) — NOT NULL
- email (이메일) — VARCHAR2(100) — NOT NULL
- phone (전화번호) — VARCHAR2(100) — NOT NULL
- grade (등급코드) — number — NOT NULL
- report (신고코드) — number — NOT NULL