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