UNDONGPEDIA

Tables (17)

CART

  • CART_SEQ — NUMBER — Primary key — NOT NULL
  • COURSE_SEQ (COURSE_SEQ2) — NUMBER — Foreign key → COURSE.COURSE_SEQ — NOT NULL
  • MEMBER_NO (MEMBER_NO2) — NUMBER — Foreign key → COURSE.MEMBER_NO — NOT NULL
  • CART_TIMESTAMP — TIMESTAMP(6)

CATEGORY

  • CATE_SEQ — NUMBER — Primary key — NOT NULL
  • CATE_KEY — VARCHAR2(100)
  • CATE_VALUE — VARCHAR2(100)
  • CATE_ICON — VARCHAR2(100)
  • CATE_DESC — VARCHAR2(500)

COACH_APPLY

  • COA_SEQ — NUMBER — Primary key — NOT NULL
  • COA_BANK — VARCHAR2(50)
  • COA_BANK_NUM — VARCHAR2(100)
  • COA_BANK_NAME — VARCHAR2(100)
  • COA_INTRO — VARCHAR2(2000)
  • COA_YN — VARCHAR2(2)
  • APPLY_DATE — DATE
  • APPROVE_DATE — DATE
  • MEMBER_NO (MEMBER_NO2) — NUMBER — Foreign key → MEMBER.MEMBER_NO — NOT NULL

COURSE

  • COURSE_SEQ — NUMBER — Primary key — NOT NULL
  • MEMBER_NO — NUMBER — Foreign key → MEMBER.MEMBER_NO — NOT NULL
  • COURSE_TITLE — VARCHAR2(200)
  • COURSE_CONTENT — VARCHAR2(2000)
  • COURSE_CATEGORY — NUMBER
  • COURSE_DIFFICULT — NUMBER
  • COURSE_PRICE — NUMBER
  • COURSE_DISCOUNT — NUMBER
  • COURSE_THUMBNAIL — VARCHAR2(300)
  • COURSE_TARGET — VARCHAR2(500)
  • COURSE_PREPARATION — VARCHAR2(500)
  • COURSE_EXPOSE — VARCHAR2(2)
  • COURSE_CONFIRM_TIME — TIMESTAMP(6)
  • COURSE_CREATE_TIME — TIMESTAMP(6)
  • COURSE_TYPE — VARCHAR2(10)

COURSE_PROGRESS

  • PRG_SEQ — NUMBER — Primary key — NOT NULL
  • PRG_PLAY_TIME — NUMBER
  • PRG_TOTAL_TIME — NUMBER
  • PRG_COMPLETE_YN — VARCHAR2(10)
  • PGR_LAST_VIEW_TIME — TIMESTAMP(6)
  • PRG_CREATE_TIME — TIMESTAMP(6)
  • PRG_UPDATE_TIME — TIMESTAMP(6)
  • MEMBER_SEQ — NUMBER
  • COURSE_SEQ — NUMBER
  • SECTION_SEQ — NUMBER
  • CURR_SEQ — NUMBER

COURSE_RESERVATION_CONFIG

  • CONFIG_ID — NUMBER — Primary key — NOT NULL
  • COURSE_SEQ — NUMBER(19) — NOT NULL
  • OPEN_DATE_TIME — DATE — NOT NULL
  • MAX_CONCURRENT_USERS — NUMBER(10)
  • WAITING_ROOM_OPEN_MINUTES — NUMBER(10)
  • IS_ACTIVE — CHAR
  • CREATED_AT — DATE
  • UPDATED_AT — DATE
  • COURSE_SEQ (COURSE_SEQ2) — NUMBER — Foreign key → COURSE.COURSE_SEQ — NOT NULL

COURSE_REVIEW

  • REVIEW_SEQ — NUMBER — Primary key — NOT NULL
  • REVIEW_TITLE — VARCHAR2(100)
  • REVIEW_CONTENT — VARCHAR2(500)
  • REVIEW_RATE — NUMBER
  • REVIEW_CREATE_TIME — TIMESTAMP(6)
  • REVIEW_DELETE_TIME — TIMESTAMP(6)
  • COURSE_SEQ (COURSE_SEQ2) — NUMBER — Foreign key → COURSE.COURSE_SEQ — NOT NULL
  • MEMBER_NO — NUMBER — Foreign key → COURSE.MEMBER_NO — NOT NULL

COURSE_SCHEDULE

  • SCHEDULE_ID — NUMBER — Primary key — NOT NULL
  • COURSE_DATE — DATE — NOT NULL
  • COURSE_START_TIME — VARCHAR2(10) — NOT NULL
  • COURSE_END_TIME — VARCHAR2(10) — NOT NULL
  • COURSE_CAPACITY — NUMBER
  • COURSE_LOCATION — VARCHAR2(200)
  • BOOKED_SEATS — NUMBER
  • STATUS — VARCHAR2(20)
  • COURSE_SEQ (COURSE_SEQ2) — NUMBER — Foreign key → COURSE.COURSE_SEQ — NOT NULL

CURRICULUM

  • CURR_SEQ — NUMBER — Primary key — NOT NULL
  • SECTION_SEQ — NUMBER — Foreign key → SECTION.SECTION_SEQ — NOT NULL
  • CURR_TITLE — VARCHAR2(200)
  • CURR_VIDEO_URL — VARCHAR2(500)
  • CURR_VIDEO_TYPE — VARCHAR2(20)
  • CURR_PREVIEW — VARCHAR2(10)
  • CURR_ORDER — NUMBER

EMAIL_VERIFICATION

  • VERIFICATION_ID — NUMBER — Primary key — NOT NULL
  • MEMBER_ID — VARCHAR2(100) — NOT NULL
  • VERIFICATION_CODE — VARCHAR2(6) — NOT NULL
  • CREATED_DATE — DATE — NOT NULL
  • EXPIRE_DATE — DATE — NOT NULL
  • IS_USED — CHAR

MEMBER

  • MEMBER_NO — NUMBER — Primary key — NOT NULL
  • MEMBER_NO (MEMBER_NO2) — NUMBER — NOT NULL
  • MEMBER_ID — VARCHAR2(50) — NOT NULL
  • MEMBER_PASSWORD — VARCHAR2(100) — NOT NULL
  • MEMBER_NAME — VARCHAR2(50) — NOT NULL
  • MEMBER_NICKNAME — VARCHAR2(50)
  • MEMBER_ROLE — VARCHAR2(10)
  • MEMBER_SIGNTYPE — VARCHAR2(20)
  • MEMBER_ENROLLDATE — DATE
  • MEMBER_STATUS — VARCHAR2(10)

NOTIFICATION

  • NOTIFICATION_ID — NUMBER — Primary key — NOT NULL
  • NOTIFICATION_TYPE — VARCHAR2(100)
  • NOTIFICATION_TITLE — VARCHAR2(100)
  • NOTIFICATION_CONTENT — VARCHAR2(100)
  • NOTIFICATION_LINK — VARCHAR2(100)
  • IS_READ — VARCHAR2(1)
  • CREATED_AT — TIMESTAMP(6)
  • READ_AT — TIMESTAMP(6)
  • MEMBER_NO (MEMBER_NO2) — NUMBER — Foreign key → MEMBER.MEMBER_NO — NOT NULL

OFFLINE_CART

  • CART_SEQ — NUMBER — Primary key — NOT NULL
  • COURSE_SEQ (COURSE_SEQ2) — NUMBER — Foreign key → COURSE.COURSE_SEQ — NOT NULL
  • MEMBER_NO (MEMBER_NO2) — NUMBER — Foreign key → COURSE.MEMBER_NO — NOT NULL
  • SCHEDULE_ID — NUMBER — NOT NULL
  • TEMP_RESERVATION_ID — VARCHAR2(100)
  • CART_TIMESTAMP — TIMESTAMP(6)

ORDERS

  • ORDERS_SEQ — NUMBER — Primary key — NOT NULL
  • COURSE_SEQ (COURSE_SEQ2) — NUMBER — Foreign key → COURSE.COURSE_SEQ — NOT NULL
  • MEMBER_NO (MEMBER_NO2) — NUMBER — Foreign key → COURSE.MEMBER_NO — NOT NULL
  • ORDERS_PRICE — NUMBER — NOT NULL
  • ORDERS_PRIMARYPAY — VARCHAR2(10) — NOT NULL
  • ORDERS_STATUS — VARCHAR2(4) — NOT NULL
  • ORDERS_TIMESTAMP — TIMESTAMP(6) — NOT NULL
  • CANCEL_YN — VARCHAR2(1) — NOT NULL
  • CANCEL_TIMESTAMP — TIMESTAMP(6)
  • CREATED_AT — TIMESTAMP(6) — NOT NULL
  • UPDATED_AT — TIMESTAMP(6) — NOT NULL
  • SCHEDULE_ID — NUMBER(19)
  • TEMP_RESERVATION_ID — VARCHAR2(100)
  • COURSE_TYPE — VARCHAR2(10)

ORDER_DETAILS

  • ORDERS_SEQ (ORDERS_SEQ2) — NUMBER — Foreign key → ORDERS.ORDERS_SEQ — NOT NULL
  • ORDERS_BANK — VARCHAR2(10)
  • ORDERS_ACCOUNT_NO — VARCHAR2(50)
  • ORDERS_CARD_CORP — VARCHAR2(10)
  • ORDERS_CARD_NO — VARCHAR2(50)
  • ORDERS_PAYMENT_ID — VARCHAR2(50) — NOT NULL
  • ORDERS_PAYHIST_ID — VARCHAR2(50) — NOT NULL

PASSWORD_UPDATE_TOKEN

  • TOKEN_NO — NUMBER — Primary key — NOT NULL
  • TOKEN — VARCHAR2(255 char) — NOT NULL
  • EXPIRY_DATE — DATE — NOT NULL
  • USED — CHAR
  • CREATED_AT — DATE
  • MEMBER_NO (MEMBER_NO2) — NUMBER — Foreign key → MEMBER.MEMBER_NO — NOT NULL

SECTION

  • SECTION_SEQ — NUMBER — Primary key — NOT NULL
  • COURSE_SEQ — NUMBER — Foreign key → COURSE.COURSE_SEQ — NOT NULL
  • SECTION_TITLE — VARCHAR2(200)
  • SECTION_CONTENT — VARCHAR2(500)
  • SECTION_ORDER — NUMBER