금투

테이블 (78)

BATCH_JOB_EXECUTION_CONTEXT

  • JOB_EXECUTION_ID — NUMBER(19) — 기본 키 — NOT NULL
  • SHORT_CONTEXT — VARCHAR(2500 CHAR) — NOT NULL
  • SERIALIZED_CONTEXT — CLOB

BATCH_JOB_EXECUTION_PARAMS

  • JOB_EXECUTION_ID — NUMBER(19) — NOT NULL
  • TYPE_CD — VARCHAR(6 CHAR) — NOT NULL
  • KEY_NAME — VARCHAR(100 CHAR) — NOT NULL
  • STRING_VAL — VARCHAR(250 CHAR)
  • DATE_VAL — TIMESTAMP(6)
  • LONG_VAL — NUMBER(19)
  • DOUBLE_VAL — NUMBER
  • IDENTIFYING — CHAR(1) — NOT NULL

BATCH_JOB_INSTANCE

  • JOB_INSTANCE_ID — NUMBER(19) — 기본 키 — NOT NULL
  • VERSION — NUMBER(19)
  • JOB_NAME — VARCHAR(100 CHAR) — NOT NULL
  • JOB_KEY — VARCHAR(32 CHAR) — NOT NULL

BATCH_STEP_EXECUTION

  • STEP_EXECUTION_ID — NUMBER(19) — 기본 키 — NOT NULL
  • VERSION — NUMBER(19) — NOT NULL
  • STEP_NAME — VARCHAR(100 CHAR) — NOT NULL
  • JOB_EXECUTION_ID — NUMBER(19) — NOT NULL
  • START_TIME — TIMESTAMP(6) — NOT NULL
  • 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) — 기본 키 — NOT NULL
  • SHORT_CONTEXT — VARCHAR(2500 CHAR) — NOT NULL
  • SERIALIZED_CONTEXT — CLOB

BOOK

  • BOOK_ID — VARCHAR(32) — 기본 키 — NOT NULL
  • BOOK_SRC — VARCHAR(256) — NOT NULL
  • TITLE — VARCHAR(128) — NOT NULL
  • CREATE_DATE — DATE — NOT NULL
  • IMG_SRC — VARCHAR(256) — NOT NULL
  • DESCRIPTION — VARCHAR(1024) — NOT NULL
  • CREATOR_ID — VARCHAR(128)
  • PDF — VARCHAR(10000)

BOOK_BOOKMARK

  • USER_UUID — VARCHAR(36) — 기본 키 — NOT NULL
  • BOOK_ID — VARCHAR(32) — 기본 키 — NOT NULL

BOOK_HIT

  • BOOK_ID — VARCHAR(32) — 기본 키 — NOT NULL
  • HIT — NUMBER — NOT NULL

COMMENT_INFO

  • VERSION_NAME — VARCHAR(500) — 기본 키 — NOT NULL
  • SEQ_NUM — NUMBER(38) — 기본 키 — NOT NULL
  • COMMENT_TYPE — VARCHAR(100)
  • COMMENT_NAME — VARCHAR(500)
  • COMMENT_TEXT — VARCHAR(2000)
  • RULE_TEXT — VARCHAR(1000)

COMMENT_VERSION_INFO

  • VERSION_NAME — VARCHAR(500) — 기본 키 — NOT NULL
  • IS_SELECTED — NUMBER(38)

CONTENTS_RECOMMENDATION

  • USER_UUID — VARCHAR(1020) — 기본 키 — NOT NULL
  • 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) — 기본 키 — NOT NULL
  • 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 — 기본 키 — NOT NULL
  • INQUIRY_STATUS — VARCHAR(100)
  • INQUIRY_TITLE — VARCHAR(100)
  • INQUIRY_TYPE — VARCHAR(100)
  • INQUIRY_CONTENT — VARCHAR(3000)
  • INQUIRY_ANSWER — VARCHAR(2048)
  • USER_UUID — VARCHAR(36) — NOT NULL
  • CREATE_DATE — TIMESTAMP(6)
  • INQUIRY_ANSWER_TIME — TIMESTAMP(6)
  • ADMIN_UUID — VARCHAR(36)

CS_INQUIRY_FILE

  • INQUIRY_FILE_ID — NUMBER — 기본 키 — NOT NULL
  • 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) — 기본 키 — NOT NULL
  • 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 — 기본 키 — NOT NULL
  • CHAPTER — VARCHAR(100) — NOT NULL
  • SECTION — VARCHAR(100) — NOT NULL
  • SUB_SECTION — VARCHAR(100) — NOT NULL
  • SUBJECT — VARCHAR(100)
  • STATUS — VARCHAR(20) — NOT NULL

DIAGNOSIS_PROBLEM

  • PROB_ID — NUMBER — 기본 키 — NOT NULL
  • CURRICULUM_ID — NUMBER — NOT NULL — �з�
  • ORDER_NUM — NUMBER — ����

DIAGNOSIS_REPORT

  • DIAGNOSIS_ID — VARCHAR(36) — 기본 키 — NOT NULL
  • USER_UUID — VARCHAR(50) — NOT NULL
  • 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) — NOT NULL
  • KNOWLEDGE_COMMON_PROFIT — NUMBER
  • KNOWLEDGE_COMMON_BASIC — NUMBER
  • KNOWLEDGE_COMMON_RULE — NUMBER

ERROR_REPORT

  • ERROR_ID — NUMBER — 기본 키 — NOT NULL
  • PROB_ID — NUMBER — NOT NULL
  • USER_UUID — VARCHAR(36) — NOT NULL
  • REPORT_TYPE — VARCHAR(32) — NOT NULL
  • REPORT_TEXT — VARCHAR(1024)

EVENT_V1

  • PHONE_NUMBER — VARCHAR(100 CHAR) — 기본 키 — NOT NULL
  • USER_UUID — VARCHAR(200 CHAR) — NOT NULL
  • APPLICATION_DATE — TIMESTAMP(6)

FUND_REPORT

  • DIAGNOSIS_ID — VARCHAR(36) — 기본 키 — NOT NULL
  • USER_UUID — VARCHAR(50) — NOT NULL
  • 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) — NOT NULL

GOLDENBELL_PROBLEM

  • PROB_ID — NUMBER(10) — 기본 키 — NOT NULL
  • DIFFICULTY — VARCHAR(8 CHAR)
  • ORDER_NUM — NUMBER(10)

GROWTH_COMMENT

  • COMMENT — VARCHAR(500) — ARCHAR(500
  • _ID — NUMBER — NOT NULL
  • STEP — NUMBER
  • COMMENT — VARCHAR(255 CHAR) — ARCHAR(255 CHAR
  • _MAIN — VARCHAR(5000) — ARCHAR(255 CHAR
  • _SUB — VARCHAR(5000)

GROWTH_CONTENTS

  • ID — NUMBER — 기본 키 — 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 — 기본 키 — NOT NULL
  • PROB_NUMBER — NUMBER — 기본 키 — NOT NULL
  • QUESTION — VARCHAR(1000 CHAR)
  • ANSWER — VARCHAR(100 CHAR)
  • LOCATION — VARCHAR(100 CHAR)
  • WORDS — VARCHAR(200)

GROWTH_PROBLEM

  • PROB_ID — NUMBER — 기본 키 — NOT NULL
  • STAGE — NUMBER
  • STEP — NUMBER
  • STEP_PROB_SEQ — NUMBER
  • TIME_RECORD — TIMESTAMP(6)

GROWTH_STAGE

  • USER_UUID — VARCHAR(100 CHAR) — 기본 키 — NOT NULL
  • STAGE — NUMBER
  • END_DATE — TIMESTAMP(6)

HASHTAG

  • HASHTAG_ID — NUMBER — 기본 키 — NOT NULL
  • NAME — VARCHAR(128)

HIT_STAT

  • STAT_DATE — DATE — 기본 키 — NOT NULL
  • HIT_STAT_ID — NUMBER — 기본 키 — NOT NULL
  • VIDEO_HIT — NUMBER
  • BOOK_HIT — NUMBER
  • WIKI_HIT — NUMBER
  • ARTICLE_HIT — NUMBER

INVEST_REPORT

  • DIAGNOSIS_ID — VARCHAR(36) — 기본 키 — NOT NULL
  • USER_UUID — VARCHAR(50) — NOT NULL
  • INVESTMENTATTITUDE_SCORE — NUMBER
  • INVESTMENTMANAGEMENT_SCORE — NUMBER
  • INVESTMENTBASIC_SCORE — NUMBER
  • INVESTMENTHARD_SCORE — NUMBER
  • USER_MBTI — VARCHAR(500)
  • MBTI_COMMENT — VARCHAR(255 CHAR) — ARCHAR(255 CHAR
  • 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) — NOT NULL

JUNIORDIAGNOSIS_REPORT

  • REPORT_ID — NUMBER(19) — 기본 키 — NOT NULL
  • CREATED_DATE — TIMESTAMP(6)
  • DIAGNOSIS_SET_ID — VARCHAR(255 CHAR)
  • DIAGNOSIS_TYPE — VARCHAR(255 CHAR)
  • GI_COMMENT — VARCHAR(255 CHAR) — NOT NULL — ARCHAR(255 CHAR) GI_SCORE NUMBER(10) NOT NUL
  • KNOWLEDGE_BASIC_SCORE — NUMBER(10) — NOT NULL
  • KNOWLEDGE_HARD_SCORE — NUMBER(10) — NOT NULL
  • MBTI — VARCHAR(255 CHAR)
  • MBTI_COMMENT — VARCHAR(2000) — ARCHAR(2000
  • UPDATED_DATE — TIMESTAMP(6)
  • USER_NAME — VARCHAR(255 CHAR)
  • USER_UUID — VARCHAR(255 CHAR)

JUNIORDIAGNOSIS_SCOREINFO

  • SCORE_ID — NUMBER(19) — 기본 키 — NOT NULL
  • AVG — NUMBER(10) — NOT NULL
  • AVG_TOP — NUMBER(10) — NOT NULL
  • SCORE — NUMBER(10) — NOT NULL
  • SECTION — VARCHAR(255 CHAR)
  • SECTION_COMMENT — VARCHAR(2000) — ARCHAR(2000) TITLE VARCHAR(255 CHAR
  • REPORT_ID — NUMBER(19)

JUNIOR_COMMENT_INFO

  • ID — NUMBER(19) — 기본 키 — NOT NULL
  • 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) — 기본 키 — NOT NULL
  • CONSUMPTION — VARCHAR(255 CHAR)
  • INVEST — VARCHAR(255 CHAR)
  • MONEY — VARCHAR(255 CHAR)
  • TITLE — VARCHAR(255 CHAR)
  • TYPE_COMMENT — ON — N TABLE ETEST.PROBLEM IS '���� ������ ����'; ) TABLESPACE USR PCTFREE 10 INITRANS 2 STORAGE ( MAXEXTENTS UNLIMITE

JUNIOR_PROBLEM

  • PROB_ID — NUMBER — 기본 키 — NOT NULL
  • 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) — 기본 키 — NOT NULL
  • DETAIL_SUBJECT — VARCHAR(255 CHAR)
  • DIFFICULTY — VARCHAR(255 CHAR)
  • ORDER_NUM — NUMBER(10)
  • SUBJECT — VARCHAR(2000)
  • CORRECT_COMMENT — ON — N COLUMN PROBLEM.PROB_ID IS '���� ID'; WRONG_COMMENT ON COLUMN PROBLEM.ANSWER_TYPE IS '��� ����'; ) TABLESPACE USR PCTF…

KNOWLEDGE_FUND_REPORT

  • DIAGNOSIS_ID — VARCHAR(255 CHAR) — 기본 키 — NOT NULL
  • 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) — 기본 키 — NOT NULL
  • 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) — 기본 키 — NOT NULL
  • DOMAIN — VARCHAR(100) — NOT NULL
  • SEQUENCE — NUMBER
  • CODE — VARCHAR(100) — NOT NULL
  • CODE_NAME — VARCHAR(256) — NOT NULL

MINITEST_REPORT

  • MINITEST_ID — VARCHAR(36) — 기본 키 — NOT NULL
  • USER_UUID — VARCHAR(36) — NOT NULL
  • AVG_UK_MASTERY — NUMBER — NOT NULL
  • SET_NUM — NUMBER — NOT NULL
  • CORRECT_NUM — NUMBER
  • WRONG_NUM — NUMBER
  • DUNNO_NUM — NUMBER
  • MINITEST_DATE — TIMESTAMP(6) — NOT NULL
  • MINITEST_UK_MASTERY — VARCHAR(3000)

NICE_CRYPTO_KEY

  • ID — NUMBER — 기본 키 — NOT NULL
  • 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) — 기본 키 — NOT NULL
  • NAME — VARCHAR(32)
  • BIRTH — VARCHAR(16)

NICE_KEY

  • TOKEN_VERSION_ID — VARCHAR(63) — 기본 키 — NOT NULL
  • ENCRYPT_KEY — VARCHAR(20)
  • ENCRYPT_IV — VARCHAR(20)
  • ENC_DATA — VARCHAR(10000)

NOTIFICATION

  • ID — NUMBER(19) — 기본 키 — NOT NULL
  • USER_UUID — VARCHAR(36) — NOT NULL
  • READ — VARCHAR(1) — NOT NULL
  • CATEGORY — VARCHAR(20) — NOT NULL
  • TITLE — VARCHAR(100) — NOT NULL
  • TIMESTAMP — TIMESTAMP(6) — NOT NULL

PART

  • PART_ID — NUMBER — 기본 키 — NOT NULL
  • PART_NAME — VARCHAR(100) — NOT NULL
  • ORDER_NUM — NUMBER — NOT NULL
  • PROBLEM_COUNT — NUMBER — NOT NULL

PORTFOLIO_MASTER

  • PRODUCT_CODE — VARCHAR(7) — 기본 키 — NOT NULL
  • 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 — NOT NULL
  • PRODUCT_CODE — VARCHAR(7)
  • CLOSING_PRICE — NUMBER — NOT NULL
  • ID — NUMBER — NOT NULL

PROBLEM

  • PROB_ID — NUMBER — 기본 키 — NOT NULL
  • ANSWER_TYPE — VARCHAR(50) — NOT NULL — ���
  • QUESTION — VARCHAR(40000) — NOT NULL — ����
  • SOLUTION — VARCHAR(40000) — NOT NULL — �ؼ�
  • 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 — 기본 키 — NOT NULL
  • CHOICE_NUM — NUMBER — 기본 키 — NOT NULL — ����
  • UK_ID — NUMBER — UK_ID
  • CHOICE_SCORE — NUMBER

PROBLEM_UK_REL

  • PROB_ID — NUMBER — 기본 키 — NOT NULL
  • UK_ID — NUMBER — 기본 키 — NOT NULL — UK_ID

PRO_CERTIFICATION

  • PROB_SET_ID — VARCHAR(200 CHAR) — 기본 키 — NOT NULL
  • USER_UUID — VARCHAR(200 CHAR)
  • CERTIFICATION_NUMBER — VARCHAR(200 CHAR) — NOT NULL
  • PUBLISH_DATE — TIMESTAMP(6)

PRO_DIAGNOSIS_PROBLEM

  • PROB_ID — NUMBER(10) — 기본 키 — NOT NULL
  • AREA — VARCHAR(255 CHAR)
  • DIFFICULTY — VARCHAR(8 CHAR)

PRO_DIAGNOSIS_PROBLEM_BAK

  • PROB_ID — NUMBER(10) — 기본 키 — NOT NULL
  • AREA — VARCHAR(255 CHAR)
  • DIFFICULTY — VARCHAR(8 CHAR)

PRO_DIAGNOSIS_PROBLEM_SET

  • DIAG_PROB_SET_ID — VARCHAR(63 CHAR) — 기본 키 — NOT NULL
  • 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) — 기본 키 — NOT NULL
  • 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) — 기본 키 — NOT NULL
  • USER_ID — VARCHAR(36) — 기본 키 — NOT NULL
  • TYPE — VARCHAR(20) — NOT NULL
  • DATA — CLOB — NOT NULL
  • UPDATE_TIME — TIMESTAMP(6) — NOT NULL

ROOM

  • ROOM_ID — VARCHAR(255 CHAR) — 기본 키 — NOT NULL
  • COURSE_NAME — VARCHAR(255 CHAR)
  • DIFFICULTY — VARCHAR(8 CHAR)
  • USER_UUID — VARCHAR(255 CHAR)
  • CREATED_DATE — TIMESTAMP(6)

ROOM_MEMBER_REL

  • ID — NUMBER(19) — 기본 키 — NOT NULL
  • ANSWER_CHECK_RESULT — CHAR(1 CHAR)
  • MEMBER_ID — VARCHAR(255 CHAR)
  • ROOM_ID — VARCHAR(255 CHAR)

SHEDLOCK

  • NAME — VARCHAR(64) — 기본 키 — NOT NULL
  • LOCK_UNTIL — TIMESTAMP(3)
  • LOCKED_AT — TIMESTAMP(3)
  • LOCKED_BY — VARCHAR(255)

STATEMENT

  • STATEMENT_ID — VARCHAR(100) — 기본 키 — NOT NULL
  • USER_ID — VARCHAR(100) — NOT NULL
  • ACTION_TYPE — VARCHAR(100) — NOT NULL
  • SOURCE_TYPE — VARCHAR(100) — NOT NULL
  • SOURCE_ID — VARCHAR(100)
  • TIMESTAMP — VARCHAR(100) — NOT NULL
  • 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) — 기본 키 — NOT NULL
  • 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) — 기본 키 — NOT NULL
  • USER_UUID — VARCHAR(50) — NOT NULL
  • 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) — NOT NULL
  • KNOWLEDGE_COMMON_PROFIT — NUMBER
  • KNOWLEDGE_COMMON_BASIC — NUMBER
  • KNOWLEDGE_COMMON_RULE — NUMBER

TEST_PROBLEM

  • PROB_ID — NUMBER — 기본 키 — NOT NULL
  • PART_ID — NUMBER
  • SUBJECT — VARCHAR(100)
  • STATUS — VARCHAR(20) — NOT NULL

TEST_PROBLEM_BAK

  • PROB_ID — NUMBER — 기본 키 — NOT NULL
  • PART_ID — NUMBER
  • SUBJECT — VARCHAR(100)
  • STATUS — VARCHAR(20) — NOT NULL

UK_DESCRIPTION_VERSION

  • UK_ID — NUMBER — 기본 키 — NOT NULL
  • VERSION_ID — NUMBER — 기본 키 — NOT NULL
  • UK_NAME — VARCHAR(200)
  • UK_DESCRIPTION — VARCHAR(2000)
  • EXTERNAL_LINK — VARCHAR(2000)
  • EDIT_DATE — TIMESTAMP(6)
  • PAGE — NUMBER

UK_MASTER

  • UK_ID — NUMBER — 기본 키 — NOT NULL
  • UK_NAME — VARCHAR(200) — NOT NULL
  • UK_DESCRIPTION — VARCHAR(2000)
  • TRAIN_UNSEEN — CHAR(1) — NOT NULL
  • PART — VARCHAR(50)
  • EXTERNAL_LINK — VARCHAR(2000)

UK_REL

  • BASE_UK_ID — NUMBER — 기본 키 — NOT NULL
  • PRE_UK_ID — NUMBER — 기본 키 — NOT NULL
  • RELATION_REFERENCE — VARCHAR(32)

USER_KNOWLEDGE

  • USER_UUID — VARCHAR(36) — 기본 키 — NOT NULL
  • UK_MASTERY — VARCHAR(50000)
  • UPDATE_DATE — TIMESTAMP(6)

USER_MASTER

  • USER_UUID — VARCHAR(36) — 기본 키 — NOT NULL
  • USER_TYPE — VARCHAR(100)
  • EMAIL — VARCHAR(100) — NOT NULL
  • PROVIDER — VARCHAR(100) — NOT NULL
  • ROLE — VARCHAR(100) — NOT NULL
  • COLLECT_INFO — VARCHAR(10) — NOT NULL
  • SERVICE_AGREEMENT — VARCHAR(10) — NOT NULL
  • OLDER_THAN_14 — VARCHAR(10) — NOT NULL
  • PROVIDER_ID — VARCHAR(1000) — NOT NULL
  • CREATE_DATE — TIMESTAMP(6)
  • NICK_NAME — VARCHAR(200) — NOT NULL
  • REFRESH_TOKEN — VARCHAR(200)
  • EVENT_SMS_AGREEMENT — VARCHAR(10) — NOT NULL
  • TEACH_PERMISSION — VARCHAR(255 CHAR)
  • TEACH_PERMISSION_EXPIRATION_DATE — TIMESTAMP(6)

USER_NOTIFICATION_CONFIG

  • TOKEN — VARCHAR(255) — 기본 키 — NOT NULL
  • USER_UUID — VARCHAR(36)
  • GLOBAL — VARCHAR(1) — NOT NULL
  • NOTICE — VARCHAR(1) — NOT NULL
  • INQUIRY — VARCHAR(1) — NOT NULL
  • CONTENT — VARCHAR(1) — NOT NULL

USER_PORTFOLIO

  • PORTFOLIO_SET_ID — VARCHAR(100) — 기본 키 — NOT NULL
  • USER_UUID — VARCHAR(36) — NOT NULL
  • CREATE_TIME — TIMESTAMP(6)
  • RISK_GRADE — NUMBER — NOT NULL
  • INVESTMENT_NOTE — VARCHAR(2000)
  • EXPERIENCEPERIOD — NUMBER — NOT NULL
  • 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 — 기본 키 — NOT NULL
  • 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) — 기본 키 — NOT NULL
  • VIDEO_SRC — VARCHAR(256) — NOT NULL
  • ORIGINAL_FILE_SRC — VARCHAR(256)
  • TITLE — VARCHAR(512) — NOT NULL
  • IMG_SRC — VARCHAR(256) — NOT NULL
  • CURRICULUM_ID — NUMBER — NOT NULL
  • TOTAL_TIME — NUMBER
  • START_TIME — NUMBER
  • END_TIME — NUMBER
  • CREATE_DATE — DATE
  • REGISTER_DATE — DATE
  • END_DATE — DATE
  • SEQUENCE — NUMBER — NOT NULL
  • CODE_SET — VARCHAR(512)
  • TYPE — VARCHAR(32)
  • RELATED — VARCHAR(32)
  • DESCRIPTION — VARCHAR(10000)
  • SHOW — CHAR(1)

VIDEO_BOOKMARK

  • USER_UUID — VARCHAR(36) — 기본 키 — NOT NULL
  • VIDEO_ID — VARCHAR(100) — 기본 키 — NOT NULL

VIDEO_CURRICULUM

  • CURRICULUM_ID — NUMBER — 기본 키 — NOT NULL
  • SUBJECT — VARCHAR(128) — NOT NULL

VIDEO_HASHTAG

  • HASHTAG_ID — NUMBER — 기본 키 — NOT NULL
  • VIDEO_ID — VARCHAR(100) — 기본 키 — NOT NULL

VIDEO_HIT

  • VIDEO_ID — VARCHAR(100) — 기본 키 — NOT NULL
  • HIT — NUMBER — NOT NULL

VIDEO_UK_REL

  • UK_ID — NUMBER — 기본 키 — NOT NULL
  • VIDEO_ID — VARCHAR(100) — 기본 키 — NOT NULL