etest
Tables (79)
BATCH_JOB_EXECUTION
- JOB_EXECUTION_ID — NUMBER(19)
- VERSION — NUMBER(19)
- JOB_INSTANCE_ID — NUMBER(19)
- CREATE_TIME — TIMESTAMP(6)
- START_TIME — TIMESTAMP(6)
- END_TIME — TIMESTAMP(6)
- STATUS — VARCHAR(10 CHAR)
- EXIT_CODE — VARCHAR(2500 CHAR)
- EXIT_MESSAGE — VARCHAR(2500 CHAR)
- LAST_UPDATED — TIMESTAMP(6)
- JOB_CONFIGURATION_LOCATION — VARCHAR(2500 CHAR)
BATCH_JOB_EXECUTION_CONTEXT
- JOB_EXECUTION_ID — NUMBER(19)
- SHORT_CONTEXT — VARCHAR(2500 CHAR)
- SERIALIZED_CONTEXT — CLOB
BATCH_JOB_EXECUTION_PARAMS
- JOB_EXECUTION_ID — NUMBER(19)
- TYPE_CD — VARCHAR(6 CHAR)
- KEY_NAME — VARCHAR(100 CHAR)
- STRING_VAL — VARCHAR(250 CHAR)
- DATE_VAL — TIMESTAMP(6)
- LONG_VAL — NUMBER(19)
- DOUBLE_VAL — NUMBER
- IDENTIFYING — CHAR(1)
BATCH_JOB_INSTANCE
- JOB_INSTANCE_ID — NUMBER(19)
- VERSION — NUMBER(19)
- JOB_NAME — VARCHAR(100 CHAR)
- JOB_KEY — VARCHAR(32 CHAR)
BATCH_STEP_EXECUTION
- STEP_EXECUTION_ID — NUMBER(19)
- VERSION — NUMBER(19)
- STEP_NAME — VARCHAR(100 CHAR)
- JOB_EXECUTION_ID — NUMBER(19)
- START_TIME — TIMESTAMP(6)
- END_TIME — TIMESTAMP(6)
- STATUS — VARCHAR(10 CHAR)
- COMMIT_COUNT — NUMBER(19)
- READ_COUNT — NUMBER(19)
- FILTER_COUNT — NUMBER(19)
- WRITE_COUNT — NUMBER(19)
- READ_SKIP_COUNT — NUMBER(19)
- WRITE_SKIP_COUNT — NUMBER(19)
- PROCESS_SKIP_COUNT — NUMBER(19)
- ROLLBACK_COUNT — NUMBER(19)
- EXIT_CODE — VARCHAR(2500 CHAR)
- EXIT_MESSAGE — VARCHAR(2500 CHAR)
- LAST_UPDATED — TIMESTAMP(6)
BATCH_STEP_EXECUTION_CONTEXT
- STEP_EXECUTION_ID — NUMBER(19)
- SHORT_CONTEXT — VARCHAR(2500 CHAR)
- SERIALIZED_CONTEXT — CLOB
BOOK
- BOOK_ID — VARCHAR(32)
- BOOK_SRC — VARCHAR(256)
- TITLE — VARCHAR(128)
- CREATE_DATE — DATE
- IMG_SRC — VARCHAR(256)
- DESCRIPTION — VARCHAR(1024)
- CREATOR_ID — VARCHAR(128)
- PDF — VARCHAR(10000)
BOOK_BOOKMARK
- USER_UUID — VARCHAR(36)
- BOOK_ID — VARCHAR(32)
BOOK_HIT
- BOOK_ID — VARCHAR(32)
- HIT — NUMBER
COMMENT_INFO
- VERSION_NAME — VARCHAR(500)
- SEQ_NUM — NUMBER(38)
- COMMENT_TYPE — VARCHAR(100)
- COMMENT_NAME — VARCHAR(500)
- COMMENT_TEXT — VARCHAR(2000)
- RULE_TEXT — VARCHAR(1000)
COMMENT_VERSION_INFO
- VERSION_NAME — VARCHAR(500)
- IS_SELECTED — NUMBER(38)
CONTENTS_RECOMMENDATION
- USER_UUID — VARCHAR(1020) — Primary key
- DANGER_BIASED_LIST — VARCHAR(10200)
- INVEST_ABILITY_LIST — VARCHAR(10200)
- STOCK_UNDERSTANDING_LIST — VARCHAR(10200)
- FUND_UNDERSTANDING_LIST — VARCHAR(10200)
- MBTI — VARCHAR(32)
CS_FAQ
- FAQ_ID — NUMBER(19) — Primary key
- CATEGORY — VARCHAR(100)
- DRAFT — VARCHAR(1)
- TITLE — VARCHAR(255)
- CONTENT — VARCHAR(2000)
- VIEWS — NUMBER(19)
- DATE_ADD — TIMESTAMP(6)
- DATE_EDIT — TIMESTAMP(6)
- IMAGE_ENCODING — CLOB
CS_INQUIRY
- INQUIRY_ID — NUMBER
- INQUIRY_STATUS — VARCHAR(100)
- INQUIRY_TITLE — VARCHAR(100)
- INQUIRY_TYPE — VARCHAR(100)
- INQUIRY_CONTENT — VARCHAR(3000)
- INQUIRY_ANSWER — VARCHAR(2048)
- USER_UUID — VARCHAR(36)
- CREATE_DATE — TIMESTAMP(6)
- INQUIRY_ANSWER_TIME — TIMESTAMP(6)
- ADMIN_UUID — VARCHAR(36)
CS_INQUIRY_FILE
- INQUIRY_FILE_ID — NUMBER
- INQUIRY_FILE_TYPE — VARCHAR(100)
- INQUIRY_ID — NUMBER
- INQUIRY_FILE_SIZE — NUMBER
- INQUIRY_FILE_NAME — VARCHAR(255)
- INQUIRY_FILE_ENCODING — CLOB
CS_NOTICE
- NOTICE_ID — NUMBER(19)
- DRAFT — VARCHAR(1 CHAR)
- TITLE — VARCHAR(100 CHAR)
- CONTENT — VARCHAR(21844 CHAR)
- VIEWS — NUMBER(19)
- DATE_ADD — TIMESTAMP(6)
- DATE_EDIT — TIMESTAMP(6)
- IMAGE_ENCODING — CLOB
DIAGNOSIS_CURRICULUM
- CURRICULUM_ID — NUMBER
- CHAPTER — VARCHAR(100)
- SECTION — VARCHAR(100)
- SUB_SECTION — VARCHAR(100)
- SUBJECT — VARCHAR(100)
- STATUS — VARCHAR(20)
DIAGNOSIS_PROBLEM
- PROB_ID — NUMBER
- CURRICULUM_ID — NUMBER — 분류
- ORDER_NUM — NUMBER — 문제
DIAGNOSIS_REPORT
- DIAGNOSIS_ID — VARCHAR(36)
- USER_UUID — VARCHAR(50)
- GI_SCORE — NUMBER
- RISK_SCORE — NUMBER
- RISK_PROFILE_SCORE — NUMBER
- RISK_INVEST_PERIOD_SCORE — NUMBER
- RISK_STOCK_RATIO_SCORE — NUMBER
- RISK_STOCK_NUM_SCORE — NUMBER
- RISK_STOCK_PREFER_SCORE — NUMBER
- RISK_TRACING_SCORE — NUMBER
- RISK_LEVEL_SCORE — NUMBER
- RISK_CAPA_SCORE — NUMBER
- INVEST_SCORE — NUMBER
- INVEST_PROFILE_SCORE — NUMBER
- INVEST_ANCHOR_SCORE — NUMBER
- INVEST_SELF_SCORE — NUMBER
- INVEST_LOSS_SCORE — NUMBER
- INVEST_CONFIRM_SCORE — NUMBER
- INVEST_CROWN_SCORE — NUMBER
- INVEST_TRACING_SCORE — NUMBER
- INVEST_METHOD_SCORE — NUMBER
- INVEST_SELL_SCORE — NUMBER
- INVEST_PORTFOLIO_SCORE — NUMBER
- INVEST_INFO_SCORE — NUMBER
- KNOWLEDGE_SCORE — NUMBER
- KNOWLEDGE_COMMON_SCORE — NUMBER
- KNOWLEDGE_TYPE_SCORE — NUMBER
- KNOWLEDGE_CHANGE_SCORE — NUMBER
- KNOWLEDGE_SELL_SCORE — NUMBER
- AVG_UK_MASTERY — NUMBER
- USER_MBTI — VARCHAR(5)
- INVEST_PERIOD — NUMBER
- INVEST_ITEM_NUM — NUMBER
- STOCK_RATIO — NUMBER
- RECOMMEND_BASIC_LIST — VARCHAR(1020)
- RECOMMEND_TYPE_LIST — VARCHAR(1020)
- RECOMMEND_ADVANCED_LIST — VARCHAR(1020)
- DIAGNOSIS_DATE — TIMESTAMP(6)
- KNOWLEDGE_COMMON_PROFIT — NUMBER
- KNOWLEDGE_COMMON_BASIC — NUMBER
- KNOWLEDGE_COMMON_RULE — NUMBER
ERROR_REPORT
- ERROR_ID — NUMBER
- PROB_ID — NUMBER
- USER_UUID — VARCHAR(36)
- REPORT_TYPE — VARCHAR(32)
- REPORT_TEXT — VARCHAR(1024)
EVENT_V1
- USER_UUID — VARCHAR(200 CHAR)
- PHONE_NUMBER — VARCHAR(100 CHAR)
- APPLICATION_DATE — TIMESTAMP(6)
FUND_REPORT
- DIAGNOSIS_ID — VARCHAR(36)
- USER_UUID — VARCHAR(50)
- INVESTMENTATTITUDE_SCORE — NUMBER
- INVESTMENTMANAGEMENT_SCORE — NUMBER
- INVESTMENTBASIC_SCORE — NUMBER
- INVESTMENTHARD_SCORE — NUMBER
- USER_MBTI — VARCHAR(500)
- MBTI_COMMENT — VARCHAR(500) — ARCHAR(500
- RECOMMEND_INVESTMENTATTITUDE_LIST — VARCHAR(1020)
- RECOMMEND_INVESTMENTMANAGEMENT_LIST — VARCHAR(1020)
- RECOMMEND_KNOWLEDGE_LIST — VARCHAR(1020)
- INVESTMENTATTITUDE_RECOGNIZE — NUMBER
- INVESTMENTATTITUDE_JUDGMENT — NUMBER
- INVESTMENTATTITUDE_ATTITUDE — NUMBER
- INVESTMENTMANAGEMENT_SCAM — NUMBER
- INVESTMENTMANAGEMENT_RIGHT — NUMBER
- INVESTMENTMANAGEMENT_HABITS — NUMBER
- DIAGNOSIS_DATE — TIMESTAMP(6)
GOLDENBELL_PROBLEM
- PROB_ID — NUMBER(10)
- DIFFICULTY — VARCHAR(8 CHAR)
- ORDER_NUM — NUMBER(10)
GROWTH_COMMENT
- COMMENT — (_ID NUMBER NOT NULL STAGE NUMBER, STEP NUMBER, COMMENT ADD CONSTRAINT _ETEST_CON745700890_MAIN VARCHAR(5000) — NOT NULL — _ID NUMBER NOT NULL STAGE NUMBER, STEP NUMBER, COMMENT ADD CONSTRAINT _ETEST_CON745700890_MAIN VARCHAR(5000) COMMENT VA…
- _SUB — VARCHAR(5000)
GROWTH_CONTENTS
- ID — NUMBER — Primary key — NOT NULL
- STUDY — VARCHAR(32)
- STAGE — NUMBER
- STEP — NUMBER
- TYPE — VARCHAR(16)
- SOURCE — VARCHAR(510)
- THUMBNAIL — VARCHAR(510)
- TITLE — VARCHAR(100)
GROWTH_CROSS_QUIZ
- QUIZ_NUMBER — NUMBER — Primary key — NOT NULL
- PROB_NUMBER — NUMBER — Primary key — NOT NULL
- QUESTION — VARCHAR(1000 CHAR)
- ANSWER — VARCHAR(100 CHAR)
- LOCATION — VARCHAR(100 CHAR)
- WORDS — VARCHAR(200)
GROWTH_PROBLEM
- PROB_ID — NUMBER — Primary key — NOT NULL
- STAGE — NUMBER
- STEP — NUMBER
- STEP_PROB_SEQ — NUMBER
- TIME_RECORD — TIMESTAMP(6)
GROWTH_STAGE
- USER_UUID — VARCHAR(100 CHAR) — Primary key — NOT NULL
- STAGE — NUMBER
- END_DATE — TIMESTAMP(6)
HASHTAG
- HASHTAG_ID — NUMBER
- NAME — VARCHAR(128)
HIT_STAT
- STAT_DATE — DATE
- HIT_STAT_ID — NUMBER
- VIDEO_HIT — NUMBER
- BOOK_HIT — NUMBER
- WIKI_HIT — NUMBER
- ARTICLE_HIT — NUMBER
INVEST_REPORT
- DIAGNOSIS_ID — VARCHAR(36)
- USER_UUID — VARCHAR(50)
- INVESTMENTATTITUDE_SCORE — NUMBER
- INVESTMENTMANAGEMENT_SCORE — NUMBER
- INVESTMENTBASIC_SCORE — NUMBER
- INVESTMENTHARD_SCORE — NUMBER
- USER_MBTI — VARCHAR(500)
- MBTI_COMMENT — VARCHAR(2000) — ARCHAR(2000
- RECOMMEND_INVESTMENTATTITUDE_LIST — VARCHAR(21844)
- RECOMMEND_INVESTMENTMANAGEMENT_LIST — VARCHAR(21844)
- RECOMMEND_KNOWLEDGE_LIST — VARCHAR(21844)
- INVESTMENTATTITUDE_RECOGNIZE — NUMBER
- INVESTMENTATTITUDE_JUDGMENT — NUMBER
- INVESTMENTATTITUDE_ATTITUDE — NUMBER
- INVESTMENTMANAGEMENT_SCAM — NUMBER
- INVESTMENTMANAGEMENT_RIGHT — NUMBER
- INVESTMENTMANAGEMENT_HABITS — NUMBER
- DIAGNOSIS_DATE — TIMESTAMP(6)
JUNIORDIAGNOSIS_REPORT
- REPORT_ID — NUMBER(19)
- CREATED_DATE — TIMESTAMP(6)
- DIAGNOSIS_SET_ID — VARCHAR(255 CHAR)
- DIAGNOSIS_TYPE — VARCHAR(255 CHAR)
- GI_COMMENT — VARCHAR(2000) — ARCHAR(2000) GI_SCORE NUMBER(10
- KNOWLEDGE_BASIC_SCORE — NUMBER(10)
- KNOWLEDGE_HARD_SCORE — NUMBER(10)
- MBTI — VARCHAR(255 CHAR)
- MBTI_COMMENT — ON — N TABLE ETEST.PROBLEM IS '문제 내용을 저장'; UPDATED_DATE TIMESTAMP(6
- USER_NAME — VARCHAR(255 CHAR)
- USER_UUID — VARCHAR(255 CHAR)
JUNIORDIAGNOSIS_SCOREINFO
- SCORE_ID — NUMBER(19)
- AVG — NUMBER(10)
- AVG_TOP — NUMBER(10)
- SCORE — NUMBER(10)
- SECTION — VARCHAR(255 CHAR)
- SECTION_COMMENT — ON — N COLUMN PROBLEM.PROB_ID IS '문제 ID'; TITLE VARCHAR(255 CHAR
- REPORT_ID — NUMBER(19)
JUNIOR_COMMENT_INFO
- ID — NUMBER(19)
- CATEGORY — VARCHAR(255 CHAR)
- COMMENT_INFO — VARCHAR(255 CHAR)
- COMMENT_TEXT — VARCHAR(1000)
- SUB_BOT — NUMBER(10)
- SUB_MID — NUMBER(10)
- SUB_TOP — NUMBER(10)
JUNIOR_MBTI_TYPE
- ID — NUMBER(19)
- CONSUMPTION — VARCHAR(255 CHAR)
- INVEST — VARCHAR(255 CHAR)
- MONEY — VARCHAR(255 CHAR)
- TITLE — VARCHAR(255 CHAR)
- TYPE_COMMENT — ON — N COLUMN PROBLEM.ANSWER_TYPE IS '답안 유형'; ) TABLESPACE USR PCTFREE 10 INITRANS 2 STORAGE ( MAXEXTENTS UNLIMITE
JUNIOR_PROBLEM
- PROB_ID — NUMBER
- CATEGORY — VARCHAR(100)
- CONTENT — VARCHAR(500)
- DETAIL_TYPE — VARCHAR(100)
- DETAIL_TYPE_POSITION — VARCHAR(100)
- MBTI_YN — VARCHAR(50)
- PROB_SEQ — NUMBER
- SCORE — NUMBER
- DIAGNOSIS_TYPE — VARCHAR(100)
KNOWLEDGE_FUND_PROBLEM
- PROB_ID — NUMBER(10)
- DETAIL_SUBJECT — VARCHAR(255 CHAR)
- DIFFICULTY — VARCHAR(255 CHAR)
- ORDER_NUM — NUMBER(10)
- SUBJECT — VARCHAR(2000)
- CORRECT_COMMENT — ON — N COLUMN PROBLEM.QUESTION IS '질문'; WRONG_COMMENT ON COLUMN PROBLEM.SOLUTION IS '해설'; ) TABLESPACE USR PCTFREE 10 INITRA…
KNOWLEDGE_FUND_REPORT
- DIAGNOSIS_ID — VARCHAR(255 CHAR)
- CATEGORY — VARCHAR(255 CHAR)
- CATEGORY_DETAIL — VARCHAR(2000)
- DIAGNOSIS_DATE — TIMESTAMP(6)
- TOTAL_SCORE — NUMBER(10)
- USER_UUID — VARCHAR(255 CHAR)
- SUB_CATEGORY — VARCHAR(255 CHAR)
- SUB_CATEGORY_TOTAL_SCORE — NUMBER(10)
KNOWLEDGE_STOCK_REPORT
- DIAGNOSIS_ID — VARCHAR(255 CHAR)
- CATEGORY — VARCHAR(255 CHAR)
- DIAGNOSIS_DATE — TIMESTAMP(6)
- KNOWLEDGE_CHANGE_SCORE — NUMBER(10)
- KNOWLEDGE_COMMON_BASIC — NUMBER(10)
- KNOWLEDGE_COMMON_PROFIT — NUMBER(10)
- KNOWLEDGE_COMMON_RULE — NUMBER(10)
- KNOWLEDGE_COMMON_SCORE — NUMBER(10)
- KNOWLEDGE_SCORE — NUMBER(10)
- KNOWLEDGE_SELL_SCORE — NUMBER(10)
- KNOWLEDGE_TYPE_SCORE — NUMBER(10)
- USER_UUID — VARCHAR(255 CHAR)
META_CODE_MASTER
- META_CODE_ID — VARCHAR(32) — Primary key — NOT NULL
- DOMAIN — VARCHAR(100)
- SEQUENCE — NUMBER
- CODE — VARCHAR(100)
- CODE_NAME — VARCHAR(256)
MINITEST_REPORT
- MINITEST_ID — VARCHAR(36)
- USER_UUID — VARCHAR(36)
- AVG_UK_MASTERY — NUMBER
- SET_NUM — NUMBER
- CORRECT_NUM — NUMBER
- WRONG_NUM — NUMBER
- DUNNO_NUM — NUMBER
- MINITEST_DATE — TIMESTAMP(6)
- MINITEST_UK_MASTERY — VARCHAR(3000)
NICE_CRYPTO_KEY
- ID — NUMBER
- RSP_CD — VARCHAR(8)
- RES_MSG — VARCHAR(255)
- RESULT_CD — VARCHAR(8)
- SITE_CODE — VARCHAR(16)
- TOKEN_VERSION_ID — VARCHAR(64)
- TOKEN_VAL — VARCHAR(128)
- PERIOD — NUMBER
- ISSUED_DATE — TIMESTAMP(6)
NICE_ID_AUTH_RESULT
- PROB_SET_ID — VARCHAR(50)
- NAME — VARCHAR(32)
- BIRTH — VARCHAR(16)
NICE_KEY
- TOKEN_VERSION_ID — VARCHAR(63)
- ENCRYPT_KEY — VARCHAR(20)
- ENCRYPT_IV — VARCHAR(20)
- ENC_DATA — VARCHAR(10000)
NOTIFICATION
- ID — NUMBER(19)
- USER_UUID — VARCHAR(36)
- READ — VARCHAR(1)
- CATEGORY — VARCHAR(20)
- TITLE — VARCHAR(100)
- TIMESTAMP — TIMESTAMP(6)
PART
- PART_ID — NUMBER
- PART_NAME — VARCHAR(100)
- ORDER_NUM — NUMBER
- PROBLEM_COUNT — NUMBER
PORTFOLIO_MASTER
- PRODUCT_CODE — VARCHAR(7)
- PRODUCT_NAME — VARCHAR(100)
- PRODUCT_USENAME — VARCHAR(100)
- PRODUCT_TYPE — NUMBER
- PRODUCT_DESC — VARCHAR(100)
- RISK_CLASS — NUMBER
- VIEW_ORDER — NUMBER
- VIEW_DEFAULT — NUMBER
PORTFOLIO_PRODUCT_DATA
- TRADING_DATE — DATE
- PRODUCT_CODE — VARCHAR(7)
- CLOSING_PRICE — NUMBER
- ID — NUMBER
PROBLEM
- PROB_ID — NUMBER
- ANSWER_TYPE — VARCHAR(50) — 답안
- QUESTION — VARCHAR(40000) — 질문
- SOLUTION — VARCHAR(40000) — 해설
- DIFFICULTY — VARCHAR(20) — 문제
- CATEGORY — VARCHAR(80) — 분류
- IMG_SRC — VARCHAR(256) — 이미지
- TIME_RECOMMENDATION — NUMBER — 적정
- CREATOR_ID — VARCHAR(32) — 생성자
- CREATE_DATE — TIMESTAMP(6) — 생성
- VALIDATOR_ID — VARCHAR(32) — 검수자
- VALIDATE_DATE — TIMESTAMP(6) — 검수
- EDITOR_ID — VARCHAR(32) — 수정자
- EDIT_DATE — TIMESTAMP(6) — 수정
- SOURCE — VARCHAR(512) — 문제
- INTENTION — VARCHAR(100) — 출제
- QUESTION_INITIAL — VARCHAR(40000) — 질문
- SOLUTION_INITIAL — VARCHAR(40000) — 해설
PROBLEM_CHOICE
- PROB_ID — NUMBER
- CHOICE_NUM — NUMBER — 문제
- UK_ID — NUMBER — UK_ID
- CHOICE_SCORE — NUMBER
PROBLEM_UK_REL
- PROB_ID — NUMBER — 문제
- UK_ID — NUMBER — UK_ID
PRO_CERTIFICATION
- PROB_SET_ID — VARCHAR(200 CHAR)
- USER_UUID — VARCHAR(200 CHAR)
- CERTIFICATION_NUMBER — VARCHAR(200 CHAR)
- PUBLISH_DATE — TIMESTAMP(6)
PRO_DIAGNOSIS_PROBLEM
- PROB_ID — NUMBER(10)
- AREA — VARCHAR(255 CHAR)
- DIFFICULTY — VARCHAR(8 CHAR)
PRO_DIAGNOSIS_PROBLEM_BAK
- PROB_ID — NUMBER(10)
- AREA — VARCHAR(255 CHAR)
- DIFFICULTY — VARCHAR(8 CHAR)
PRO_DIAGNOSIS_PROBLEM_SET
- DIAG_PROB_SET_ID — VARCHAR(63 CHAR)
- ISSUED_DATE — TIMESTAMP(6)
- PROBLEM_SET — VARCHAR(1020 CHAR)
- TIME_TAKEN — NUMBER(10)
- USER_UUID — VARCHAR(255 CHAR)
PRO_DIAGNOSIS_REPORT
- DIAG_PROB_SET_ID — VARCHAR(63 CHAR)
- AREA_SCORE_SET — VARCHAR(1020 CHAR)
- ISSUED_DATE — TIMESTAMP(6)
- PDF_FILE_PATH — VARCHAR(510 CHAR)
- TOTAL_SCORE — NUMBER(10)
- USER_UUID — VARCHAR(255 CHAR)
REPORT_CACHE
- REPORT_ID — VARCHAR(36)
- USER_ID — VARCHAR(36)
- TYPE — VARCHAR(20)
- DATA — CLOB
- UPDATE_TIME — TIMESTAMP(6)
ROOM
- ROOM_ID — VARCHAR(255 CHAR)
- COURSE_NAME — VARCHAR(255 CHAR)
- DIFFICULTY — VARCHAR(8 CHAR)
- USER_UUID — VARCHAR(255 CHAR)
- CREATED_DATE — TIMESTAMP(6)
ROOM_MEMBER_REL
- ID — NUMBER(19)
- ANSWER_CHECK_RESULT — CHAR(1 CHAR)
- MEMBER_ID — VARCHAR(255 CHAR)
- ROOM_ID — VARCHAR(255 CHAR)
SHEDLOCK
- NAME — VARCHAR(64)
- LOCK_UNTIL — TIMESTAMP(3)
- LOCKED_AT — TIMESTAMP(3)
- LOCKED_BY — VARCHAR(255)
STATEMENT
- STATEMENT_ID — VARCHAR(100)
- USER_ID — VARCHAR(100)
- ACTION_TYPE — VARCHAR(100)
- SOURCE_TYPE — VARCHAR(100)
- SOURCE_ID — VARCHAR(100)
- TIMESTAMP — VARCHAR(100)
- PLATFORM — VARCHAR(100)
- CURSOR_TIME — NUMBER
- IS_CORRECT — NUMBER
- IS_DELETED — NUMBER
- USER_ANSWER — VARCHAR(500)
- DURATION — VARCHAR(100)
- EXTENSION — VARCHAR(2000)
- STATEMENT_DATE — TIMESTAMP(6)
TEACHING_PERMISSION_MANAGEMENT
- ID — NUMBER(19)
- NICKNAME — VARCHAR(255 CHAR)
- REASON — VARCHAR(255 CHAR)
- REQUEST_DATE — TIMESTAMP(6)
- STATUS — VARCHAR(255 CHAR)
- USER_UUID — VARCHAR(255 CHAR)
TENDENCY_REPORT
- DIAGNOSIS_ID — VARCHAR(36)
- USER_UUID — VARCHAR(50)
- GI_SCORE — NUMBER
- RISK_SCORE — NUMBER
- RISK_PROFILE_SCORE — NUMBER
- RISK_INVEST_PERIOD_SCORE — NUMBER
- RISK_STOCK_RATIO_SCORE — NUMBER
- RISK_STOCK_NUM_SCORE — NUMBER
- RISK_STOCK_PREFER_SCORE — NUMBER
- RISK_TRACING_SCORE — NUMBER
- RISK_LEVEL_SCORE — NUMBER
- RISK_CAPA_SCORE — NUMBER
- INVEST_SCORE — NUMBER
- INVEST_PROFILE_SCORE — NUMBER
- INVEST_ANCHOR_SCORE — NUMBER
- INVEST_SELF_SCORE — NUMBER
- INVEST_LOSS_SCORE — NUMBER
- INVEST_CONFIRM_SCORE — NUMBER
- INVEST_CROWN_SCORE — NUMBER
- INVEST_TRACING_SCORE — NUMBER
- INVEST_METHOD_SCORE — NUMBER
- INVEST_SELL_SCORE — NUMBER
- INVEST_PORTFOLIO_SCORE — NUMBER
- INVEST_INFO_SCORE — NUMBER
- KNOWLEDGE_SCORE — NUMBER
- KNOWLEDGE_COMMON_SCORE — NUMBER
- KNOWLEDGE_TYPE_SCORE — NUMBER
- KNOWLEDGE_CHANGE_SCORE — NUMBER
- KNOWLEDGE_SELL_SCORE — NUMBER
- AVG_UK_MASTERY — NUMBER
- USER_MBTI — VARCHAR(5)
- INVEST_PERIOD — NUMBER
- INVEST_ITEM_NUM — NUMBER
- STOCK_RATIO — NUMBER
- RECOMMEND_BASIC_LIST — VARCHAR(10000)
- RECOMMEND_TYPE_LIST — VARCHAR(10000)
- RECOMMEND_ADVANCED_LIST — VARCHAR(10000)
- DIAGNOSIS_DATE — TIMESTAMP(6)
- KNOWLEDGE_COMMON_PROFIT — NUMBER
- KNOWLEDGE_COMMON_BASIC — NUMBER
- KNOWLEDGE_COMMON_RULE — NUMBER
TEST_PROBLEM
- PROB_ID — NUMBER
- PART_ID — NUMBER
- SUBJECT — VARCHAR(100)
- STATUS — VARCHAR(20)
TEST_PROBLEM_BAK
- PROB_ID — NUMBER
- PART_ID — NUMBER
- SUBJECT — VARCHAR(100)
- STATUS — VARCHAR(20)
UK_DESCRIPTION_VERSION
- VERSION_ID — NUMBER
- UK_ID — NUMBER
- UK_NAME — VARCHAR(200)
- UK_DESCRIPTION — VARCHAR(2000)
- EXTERNAL_LINK — VARCHAR(2000)
- EDIT_DATE — TIMESTAMP(6)
- PAGE — NUMBER
UK_MASTER
- UK_ID — NUMBER
- UK_NAME — VARCHAR(200)
- UK_DESCRIPTION — VARCHAR(2000)
- TRAIN_UNSEEN — CHAR(1)
- PART — VARCHAR(50)
- EXTERNAL_LINK — VARCHAR(2000)
UK_REL
- BASE_UK_ID — NUMBER
- PRE_UK_ID — NUMBER
- RELATION_REFERENCE — VARCHAR(32)
USER_KNOWLEDGE
- USER_UUID — VARCHAR(36)
- UK_MASTERY — VARCHAR(50000)
- UPDATE_DATE — TIMESTAMP(6)
USER_MASTER
- USER_UUID — VARCHAR(36)
- USER_TYPE — VARCHAR(100)
- EMAIL — VARCHAR(100)
- PROVIDER — VARCHAR(100)
- ROLE — VARCHAR(100)
- COLLECT_INFO — VARCHAR(10)
- SERVICE_AGREEMENT — VARCHAR(10)
- OLDER_THAN_14 — VARCHAR(10)
- PROVIDER_ID — VARCHAR(1000)
- CREATE_DATE — TIMESTAMP(6)
- NICK_NAME — VARCHAR(200)
- REFRESH_TOKEN — VARCHAR(200)
- EVENT_SMS_AGREEMENT — VARCHAR(10)
- TEACH_PERMISSION — VARCHAR(255 CHAR)
- TEACH_PERMISSION_EXPIRATION_DATE — TIMESTAMP(6)
USER_NOTIFICATION_CONFIG
- TOKEN — VARCHAR(255)
- USER_UUID — VARCHAR(36)
- GLOBAL — VARCHAR(1)
- NOTICE — VARCHAR(1)
- INQUIRY — VARCHAR(1)
- CONTENT — VARCHAR(1)
USER_PORTFOLIO
- PORTFOLIO_SET_ID — VARCHAR(100)
- USER_UUID — VARCHAR(36)
- CREATE_TIME — TIMESTAMP(6)
- RISK_GRADE — NUMBER
- INVESTMENT_NOTE — VARCHAR(2000)
- EXPERIENCEPERIOD — NUMBER
- COMPARE_PRODUCT_CODE — VARCHAR(7)
- PRODUCT_CODE_1 — VARCHAR(7)
- PRODUCT_CODE_2 — VARCHAR(7)
- PRODUCT_CODE_3 — VARCHAR(7)
- PRODUCT_CODE_4 — VARCHAR(7)
- PRODUCT_CODE_5 — VARCHAR(7)
- PRODUCT_RATIO_1 — NUMBER
- PRODUCT_RATIO_2 — NUMBER
- PRODUCT_RATIO_3 — NUMBER
- PRODUCT_RATIO_4 — NUMBER
- PRODUCT_RATIO_5 — NUMBER
VERSION_MASTER
- VERSION_ID — NUMBER
- VERSION_NAME — VARCHAR(200)
- VERSION_NUM — VARCHAR(50)
- CREATE_DATE — TIMESTAMP(6)
- EDIT_DATE — TIMESTAMP(6)
- IS_DEFAULT — CHAR(1)
- IS_DELETED — CHAR(1)
VIDEO
- VIDEO_ID — VARCHAR(100)
- VIDEO_SRC — VARCHAR(256)
- ORIGINAL_FILE_SRC — VARCHAR(256)
- TITLE — VARCHAR(512)
- IMG_SRC — VARCHAR(256)
- CURRICULUM_ID — NUMBER
- TOTAL_TIME — NUMBER
- START_TIME — NUMBER
- END_TIME — NUMBER
- CREATE_DATE — DATE
- REGISTER_DATE — DATE
- END_DATE — DATE
- SEQUENCE — NUMBER
- CODE_SET — VARCHAR(512)
- TYPE — VARCHAR(32)
- RELATED — VARCHAR(32)
- DESCRIPTION — VARCHAR(10000)
- SHOW — CHAR(1)
VIDEO_BOOKMARK
- USER_UUID — VARCHAR(36)
- VIDEO_ID — VARCHAR(100)
VIDEO_CURRICULUM
- CURRICULUM_ID — NUMBER
- SUBJECT — VARCHAR(128)
VIDEO_HASHTAG
- HASHTAG_ID — NUMBER
- VIDEO_ID — VARCHAR(100)
VIDEO_HIT
- HIT — NUMBER
- VIDEO_ID — VARCHAR(100)
VIDEO_UK_REL
- UK_ID — NUMBER
- VIDEO_ID — VARCHAR(100)