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