learning machine

Tables (17)

ACADEMY (Untitled)

  • ACADEMY_NO — NUMBER(19,0) — Primary key — NOT NULL
  • ACADEMY_ADDR_CITY — VARCHAR2(225)
  • ACADEMY_ADDR_DETAIL — VARCHAR2(255 CHAR)
  • ACADEMY_NAME — VARCHAR2(255 CHAR)

AUTHORITY (Untitled3)

  • AUTHORITY_NO — NUMBER(19,0) — Primary key — NOT NULL
  • USERDB_NO — NUMBER(19,0) — Foreign key → USERDB.USERDB_NO — NOT NULL
  • ROLE — VARCHAR2(255 CHAR)

CART (Untitled4)

  • CART_NO — NUMBER(19,0) — Primary key — NOT NULL
  • USERDB_NO (USERDB_NO2) — NUMBER(19,0) — Foreign key → USERDB.USERDB_NO — NOT NULL
  • ON_LECTURE_NO (ON_LECTURE_NO2) — NUMBER(19,0) — Foreign key → ONLECTURE.ON_LECTURE_NO — NOT NULL

CLASS_ANSWER (Untitled5)

  • CLASS_ANSWER_NO — NUMBER(19,0) — Primary key — NOT NULL
  • CLASS_QUESTION_NO (CLASS_QUESTION_NO2) — NUMBER(19,0) — Foreign key → CLASS_QUESTION.CLASS_QUESTION_NO — NOT NULL
  • USERDB_NO (USERDB_NO2) — NUMBER(19,0) — Foreign key → CLASS_QUESTION.USERDB_NO — NOT NULL
  • ON_LECTURE_NO (ON_LECTURE_NO2) — NUMBER(19,0) — Foreign key → CLASS_QUESTION.ON_LECTURE_NO — NOT NULL
  • CLASS_ANSWER_CONTENT — VARCHAR2(1000 CHAR)
  • CLASS_ANSWER_REGDATE — NOT NULL

CLASS_QUESTION (Untitled6)

  • CLASS_QUESTION_NO — NUMBER(19,0) — Primary key — NOT NULL
  • USERDB_NO (USERDB_NO2) — NUMBER(19,0) — Foreign key → USERDB.USERDB_NO — NOT NULL
  • ON_LECTURE_NO (ON_LECTURE_NO2) — NUMBER(19,0) — Foreign key → ONLECTURE.ON_LECTURE_NO — NOT NULL
  • CLASS_QUESTION_TITLE — VARCHAR2(255 CHAR)
  • CLASS_QUESTION_CONTENT — VARCHAR2(1000 CHAR)
  • CLASS_QUESTION_REGDATE — TIMESTAMP(6) — NOT NULL

COUPON (Untitled7)

  • COUPON_NO — NUMBER(19,0) — Primary key — NOT NULL
  • COUPON_DATE — TIMESTAMP(6) — NOT NULL
  • COUPON_DISCOUNT — NUMBER(10,0)
  • COUPON_NAME — VARCHAR2(255 CHAR)
  • COUPON_CODE — VARCHAR2(255 CHAR)
  • COUPON_ORIGINAL_COUNT — NUMBER(10,0)
  • COUPON_REMAINING_COUNT — NUMBER(10,0)

NOTICE (Untitled8)

  • NOTICE_NO — NUMBER(19,0) — Primary key — NOT NULL
  • NOTICE_REGDATE — TIMESTAMP(6) — NOT NULL
  • NOTICE_TITLE — VARCHAR2(255 CHAR)
  • NOTICE_CONTENT — CLOB — NOT NULL

O NORDER (Untitled13)

  • ON_ORDER_NO — NUMBER(19,0) — Primary key — NOT NULL
  • ON_LECTURE_NO (ON_LECTURE_NO2) — NUMBER(19,0) — Foreign key → ONLECTURE.ON_LECTURE_NO — NOT NULL
  • USERDB_NO (USERDB_NO2) — NUMBER(19,0) — Foreign key → USERDB.USERDB_NO — NOT NULL
  • ON_ORDER_CODE — VARCHAR2(255 CHAR)
  • ON_ORDER_METHOD — VARCHAR2(255 BYTE) — NOT NULL
  • ON_ORDER_PRICE — NUMBER(10,0)
  • ON_ORDER_REGDATE — TIMESTAMP(6) — NOT NULL
  • ON_ORDER_STATE — VARCHAR2(255 BYTE) — NOT NULL

OFF_LECTURE (Untitled9)

  • OFF_LECTURE_NO — NUMBER(19,0) — Primary key — NOT NULL
  • ACADEMY_NO — NUMBER(19,0) — Foreign key → ACADEMY.ACADEMY_NO — NOT NULL
  • CATEGORY — VARCHAR2(255 CHAR)
  • OFF_DETAIL — VARCHAR2(255 CHAR)
  • OFF_LECTURE_DATE — TIMESTAMP(6) — NOT NULL
  • OFF_LECTURE_NAME — VARCHAR2(255 CHAR)
  • OFF_LECTURE_RESERVEDSEAT — NUMBER(10,0) — NOT NULL
  • OFF_LECTURE_SEAT — NUMBER(10,0)
  • OFF_LECTURE_TEACHER — VARCHAR2(255 CHAR)
  • PRICE — NUMBER(10,0)

OFF_ORDER (Untitled10)

  • OFF_ORDER_NO — NUMBER(19,0) — Primary key — NOT NULL
  • OFF_LECTURE_NO (OFF_LECTURE_NO2) — NUMBER(19,0) — Foreign key → OFF_LECTURE.OFF_LECTURE_NO — NOT NULL
  • USERDB_NO (USERDB_NO2) — NUMBER(19,0) — Foreign key → USERDB.USERDB_NO — NOT NULL
  • OFF_ORDER_METHOD — VARCHAR2(255 CHAR)
  • OFF_ORDER_REGDATE — TIMESTAMP(6) — NOT NULL

ONLECTURE (Untitled12)

  • ON_LECTURE_NO — NUMBER(19,0) — Primary key — NOT NULL
  • ON_LECTURE_CATEGORY — VARCHAR2(255 CHAR)
  • ON_LECTURE_CONTENT — VARCHAR2(255 CHAR)
  • ON_LECTURE_DISCOUNT — NUMBER(10,0) — NOT NULL
  • ON_LECTURE_NAME — VARCHAR2(255 CHAR)
  • ON_LECTURE_PRICE — NUMBER(10,0)
  • ON_LECTURE_REGDATE — TIMESTAMP(6) — NOT NULL
  • ON_LECTURE_SUMMARY — VARCHAR2(255 CHAR)
  • ON_LECTURE_TEACHER — VARCHAR2(255 CHAR)

ON_DETAIL (Untitled11)

  • ON_DETAIL_NO — NUMBER(19,0) — Primary key — NOT NULL
  • ON_LECTURE_NO (ON_LECTURE_NO2) — NUMBER(19,0) — Foreign key → ONLECTURE.ON_LECTURE_NO — NOT NULL
  • ON_DETAIL_NAME — VARCHAR2(255 CHAR)
  • ON_DETAIL_PLAYTIME — VARCHAR2(255 CHAR)
  • ON_DETAIL_URL — VARCHAR2(255 CHAR)

REVIEW (Untitled14)

  • REVIEW_NO — NUMBER(19,0) — Primary key — NOT NULL
  • USERDB_NO (USERDB_NO2) — NUMBER(19,0) — Foreign key → USERDB.USERDB_NO — NOT NULL
  • ON_LECTURE_NO (ON_LECTURE_NO2) — NUMBER(19,0) — Foreign key → ONLECTURE.ON_LECTURE_NO — NOT NULL
  • REVIEW_CONTENT — VARCHAR2(255 CHAR)
  • REVIEW_REGDATE — TIMESTAMP(6) — NOT NULL
  • REVIEW_SCORE — NUMBER(10,0)

ROADMAP (Untitled15)

  • ROADMAP_NO — NUMBER(19,0) — Primary key — NOT NULL
  • Key — Primary key — NOT NULL
  • ON_LECTURE_NO (ON_LECTURE_NO2) — NUMBER(19,0) — Foreign key → ONLECTURE.ON_LECTURE_NO — NOT NULL
  • ROADMAP_CONTENT — VARCHAR2(255 CHAR)
  • ROADMAP_NAME — VARCHAR2(255 CHAR)
  • ROADMAP_PRICE — NUMBER(10,0)
  • ROADMAP_REGDATE — TIMESTAMP(6) — NOT NULL
  • Field

SUGANG (Untitled16)

  • SUGANG_NO — NUMBER(19,0) — Primary key — NOT NULL
  • USERDB_NO (USERDB_NO2) — NUMBER(19,0) — Foreign key → USERDB.USERDB_NO — NOT NULL
  • ON_DETAIL_NO (ON_DETAIL_NO2) — NUMBER(19,0) — Foreign key → ON_DETAIL.ON_DETAIL_NO — NOT NULL
  • ON_LECTURE_NO (ON_LECTURE_NO2) — NUMBER(19,0) — Foreign key → ON_DETAIL.ON_LECTURE_NO — NOT NULL
  • SUGANG_DATE — TIMESTAMP(6)
  • SUGANG_STATE — VARCHAR2(255 CHAR)

USERDB (Untitled2)

  • USERDB_NO — NUMBER(19,0) — Primary key — NOT NULL
  • USERDB_EMAIL — VARCHAR2(255 CHAR)
  • USERDB_NICKNAME — VARCHAR2(255 CHAR)
  • USERDB_PASSWORD — VARCHAR2(255 CHAR)
  • REG_DATE — TIMESTAMP(6) — NOT NULL

WISH_LIST (Untitled17)

  • WISH_LIST_NO — NUMBER(19,0) — Primary key — NOT NULL
  • USERDB_NO (USERDB_NO2) — NUMBER(19,0) — Foreign key → USERDB.USERDB_NO — NOT NULL
  • ON_LECTURE_NO (ON_LECTURE_NO2) — NUMBER(19,0) — Foreign key → ONLECTURE.ON_LECTURE_NO — NOT NULL