금투
테이블 (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