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