TEST

Tables (4)

CATEGORY

  • CATEGORY_NUM — NUMBER — Primary key — NOT NULL
  • CATEGORY_NAME — VARCHAR2(50) — NOT NULL

COURSE

  • COURSE_NUM — NUMBER — Primary key — NOT NULL
  • CATEGORY_NUM — NUMBER — NOT NULL
  • MEM_NUM — NUMBER — NOT NULL
  • COURSE_TITLE — VARCHAR2(100) — NOT NULL
  • COURSE_CONTENT — VARCHAR2(4000) — NOT NULL
  • COURSE_KIND — NUMBER — NOT NULL
  • COURSE_PRICE — NUMBER — NOT NULL
  • COURSE_MATERIAL — VARCHAR2(1000)
  • COURSE_MATERIAL_PRICE — NUMBER
  • COURSE_CURRENT_NUM — NUMBER — NOT NULL
  • COURSE_MAX_NUM — NUMBER — NOT NULL
  • COURSE_ENROLL_DATE — DATE — NOT NULL
  • COURSE_APPROVED_DATE — DATE
  • COURSE_START_DATE — DATE — NOT NULL
  • COURSE_END_DATE — DATE
  • COURSE_APPROVED — VARCHAR2(1) — NOT NULL
  • COURSE_STATUS — VARCHAR2(1) — NOT NULL

MEMBER

  • MEM_NUM — NUMBER — Primary key — NOT NULL
  • MEM_ID — VARCHAR2(20) — NOT NULL
  • MEM_PWD — VARCHAR2(1000) — NOT NULL
  • MEM_NICKNAME — VARCHAR2(24)
  • MEM_NAME — VARCHAR2(20)
  • MEM_GENDER — VARCHAR2(1)
  • MEM_PHONE — VARCHAR2(15)
  • MEM_ADDRESS — VARCHAR2(500)
  • MEM_TYPE — VARCHAR2(1) — NOT NULL
  • MEM_STATUS — VARCHAR2(1) — NOT NULL
  • ENROLL_DATE — DATE — NOT NULL
  • OUT_DATE — DATE

REVIEW

  • REVIEW_NUM — NUMBER — Primary key — NOT NULL
  • COURSE_NUM — NUMBER — NOT NULL
  • MEM_NUM — NUMBER — NOT NULL
  • REVIEW_CONTENT — VARCHAR2(4000) — NOT NULL
  • REVIEW_ENROLL_DATE — DATE — NOT NULL
  • REVIEW_MODIFY_DATE — DATE — NOT NULL
  • REVIEW_STATUS — VARCHAR2(1) — NOT NULL