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