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