IMPORTTEST
Tables (9)
CATEGORY
- CATEGORY_NUM — NUMBER — Primary key — NOT NULL
- CATEGORY_NAME — VARCHAR2(50) — NOT NULL
CLASS
- CLASS_NUM — NUMBER — Primary key — NOT NULL
- CATEGORY_NUM — NUMBER — Foreign key → CATEGORY.CATEGORY_NUM — NOT NULL
- MEM_NUM — NUMBER — Foreign key → MEMBER.MEM_NUM — NOT NULL — 회원번호;
- CLASS_TITLE — VARCHAR2(100) — NOT NULL
- CLASS_CONTENT — VARCHAR2(4000) — NOT NULL
- PRICE — NUMBER — NOT NULL
- MATERIAL — VARCHAR2(1000)
- MATERIAL_PRICE — NUMBER
- CURRENT_NUM — NUMBER — NOT NULL
- MAX_NUM — NUMBER — NOT NULL
- ENROLL_DATE — DATE — NOT NULL
- APPROVED_DATE — DATE
- START_DATE — DATE — NOT NULL
- END_DATE — DATE
- APPROVED — VARCHAR2(1) — NOT NULL
- CLASS_STATUS — VARCHAR2(1) — NOT NULL
- Field — VARCHAR2(20) — NOT NULL
CREATOR
- MEM_NUM — NUMBER — Foreign key → MEMBER.MEM_NUM — NOT NULL — 회원번호;
- INTRODUCTION — VARCHAR2(3000)
- CAREER — VARCHAR2(3000)
- EDUCATION — VARCHAR2(3000)
- CERTIFICATION — VARCHAR2(3000)
Detail
- CLASS_NUM — NUMBER — Foreign key → CLASS.CLASS_NUM — NOT NULL
- Field — VARCHAR(255)
INQUIRY
- INQUIRY_NUM — NUMBER — Primary key — NOT NULL
- MEM_NUM — NUMBER — Foreign key → MEMBER.MEM_NUM — NOT NULL — 회원번호;
- INQUIRY_CONTENT — VARCHAR2(3000) — NOT NULL
- INQURIY_ANSWER — VARCHAR2(1) — NOT NULL
- INQUIRY_ENROLL_DATE — DATE — NOT NULL
- INQUIRY_PARENT_NUM — NUMBER
- INQURIY_DEPTH_NUM — NUMBER — NOT NULL
INQUIRY_ATTACHMENT
- IA_NUM — NUMBER — Primary key — NOT NULL
- INQUIRY_NUM — NUMBER — Foreign key → INQUIRY.INQUIRY_NUM — NOT NULL
- IA_NAME — VARCHAR2(255) — NOT NULL
- IA_PATH — VARCHAR2(1000) — NOT NULL
MEMBER
- MEM_NUM — NUMBER — Primary key — NOT NULL — 회원번호;
- MEM_ID — VARCHAR2(20) — NOT NULL
- MEM_PWD — VARCHAR2(20) — NOT NULL
- MEM_NICKNAME — VARCHAR2(24)
- MEM_NAME — VARCHAR2(20)
- MEM_GENDER — VARCHAR2(1)
- MEM_PHONE — VARCHAR2(15)
- MEM_EMAIL — VARCHAR2(50) — NOT NULL
- MEM_COUPON — NUMBER
- MEM_TYPE — VARCHAR2(1) — NOT NULL
- MEM_STATUS — VARCHAR2(1) — NOT NULL
- ENROLL_DATE — DATE — NOT NULL
- OUT_DATE — DATE
NOTICE_ATTACHMENT
- NA_NUM — NUMBER — Primary key — NOT NULL
- NOTICE_NUM — NUMBER — NOT NULL
- NA_NAME — VARCHAR2(255) — NOT NULL
- NA_PATH — VARCHAR2(1000) — NOT NULL
REVIEW_ATTICHMENT
- RA_NUM — NUMBER — Primary key — NOT NULL
- REVIEW_NUM — NUMBER
- REV_REPLY_NUM — NUMBER — NOT NULL
- RA_NAME — VARCHAR2(255) — NOT NULL
- RA_PATH — VARCHAR2(1000) — NOT NULL