subject
Tables (12)
Book
- Book_no — NUMBER — Primary key — NOT NULL
- member_no — NUMBER — Foreign key → subject.member_no — NOT NULL
- subject_no — NUMBER — Foreign key → subject.subject_no
- book_name — VARCHER2(300) — NOT NULL
- writer — VARCHER2(100) — NOT NULL
- publisher — VARCHER2(300) — NOT NULL
- list_price — NUMBER — NOT NULL
- hope_price — NUMBER — NOT NULL
- written — _trace`
- torn_trace — CHAR(1)
- discolor — CHAR(1)
- name_entry — CHAR(1)
- TRACE_END — CHAR(1)
- FILENAME — VARCHER2(300)
- FILEPATH — VARCHER2(1000)
Book_COMMENT
- BC_NO — NUMBER — Primary key — NOT NULL
- Book_no — NUMBER — Foreign key → Book.Book_no — NOT NULL
- member_no2 — NUMBER — Foreign key → Book.member_no — NOT NULL
- subject_no — NUMBER — Foreign key → Book.subject_no
- Field — VARCHER2(1000)
- BC_DATE — NUMBER
- BC_SECRET — CHAR(1)
FREEBOARD
- FREE_NO — NUMBER — Primary key — NOT NULL
- member_no — NUMBER — Foreign key → Member.member_no
- FREE_TITLE — VARCHER2(300)
- FREE_CONTENT — VARCHER2(1000) — NOT NULL
- READ_COUNT — NUMBER
- FREE_DATE — CHAR(10)
- FILENAME — VARCHER2(300)
- FILEPATH — VARCHAR2(300)
MANAGERBOARD
- MB_NO — NUMBER — Primary key — NOT NULL
- MB_WRITER — VARCHAR2(20) — Foreign key → Member.member_no
- MB_TITLE — VHRCHAR2(20) — NOT NULL
- MB_CONTENT — VARCHER2(1000) — NOT NULL
- READ_COUNT — NUMBER
- REG_DATE — CHAR(10)
- FILENAME — VARCHAR2(300)
- FILEPATH — VARCHAR2(300)
- CATEGORY — VARCHAR2(20) — NOT NULL
MSG
- MSG_NO — NUMBER — Primary key — NOT NULL
- WRITER — VARCHAR2(20) — NOT NULL
- RECEIVER — VHARCHAR2(20) — NOT NULL
- MSG_TITLE — VARCHAR2(200) — NOT NULL
- MSG_CONTENT — VARCHAR2(2000) — NOT NULL
- DEL_REC — CHAR(1) — NOT NULL
- DEL_SEND — CHAR(1) — NOT NULL
- REQ_DATE — CHAR(10)
Member
- member_no — NUMBER — Primary key — NOT NULL
- MEMBER_ID — VARCHAR2(30) — NOT NULL
- MEMBER_PW — VARCHAR2(30) — NOT NULL
- Member_name — VARCHAR2(30) — NOT NULL
- age — NUMBER — NOT NULL
- phone — CHAR(13) — NOT NULL
- member_addr — VARCHAR2(300) — NOT NULL
- GRADE — CHAR(10) — NOT NULL
- unroll_date — ENROLL_DATE
- BLACK1 — NUMBER
- BLACK2 — NUMBER
- BLACK3 — NUMBER
NOTICE_COMMENT
- NC_NO — NUMBER — Primary key — NOT NULL
- MB_NO — NUMBER — Foreign key → MANAGERBOARD.MB_NO — NOT NULL
- MB_WRITER — VARCHAR2(20) — Foreign key → MANAGERBOARD.MB_WRITER
- NC_CONTENT — VARCHAR2(1000) — NOT NULL
- NC_DATE — CHAR(10)
QNA
- QNA_NO — NUMBER — Primary key — NOT NULL
- WRITER — NUMBER — Foreign key → Member.member_no — NOT NULL
- QNA_TITLE — VARCHAR2(200) — NOT NULL
- QNA_CONTENT — VARCHAR2(2000) — NOT NULL
- QNA_DATE — CHAR(10)
- RECEIVER — VARCHAR2(20)
REVIEWBOARD
- REVIEW_NO — NUMBER — Primary key — NOT NULL
- member_no — NUMBER — Foreign key → subject.member_no — NOT NULL
- subject_no — NUMBER — Foreign key → subject.subject_no
- REVIEW_CONTENT — VARCHER2(2000) — NOT NULL
- REVIEW_SCORE — NUMBER — NOT NULL
- REQ_DATE — CHAR(10)
SCHEDULE
- SCHEDULE_NO — NUMBER — Primary key — NOT NULL
- subject_no — NUMBER — Foreign key → subject.subject_no — NOT NULL
- member_no — NUMBER — Foreign key → subject.member_no — NOT NULL
- SCHEDULE_A — CHAR(1) — NOT NULL
- SCHEDULE_B — NUMBER — NOT NULL
- STU_NO — NUMBER — NOT NULL
SUB_MEM
- SM_NO — NUMBER — Primary key — NOT NULL
- member_no — NUMBER — Foreign key → REVIEWBOARD.member_no — NOT NULL
- subject_no — NUMBER — Foreign key → REVIEWBOARD.subject_no
subject
- subject_no — NUMBER — Primary key — NOT NULL
- member_no — NUMBER — Foreign key → Member.member_no — NOT NULL
- subject_name — VARCHAR2(30) — NOT NULL
- Start_time — VARCHAR2(3) — NOT NULL
- duration_time — NUMBER — NOT NULL
- GRAGE — NUMBER — NOT NULL
- SCORE_AVG — NUMBER — NOT NULL
- SELECT_SUBJECT — NUMBER — NOT NULL