와플수학_공유용
테이블 (47)
AGREEMENT_OF_TERMS_OF_SERVICE
- AGREEMENT_ID — NUMBER(38) — 기본 키 — NOT NULL
- USER_UUID — VARCHAR(240)
- TERMS_ID — NUMBER(38)
- AGREEMENT — CHAR(1)
ATTENDANCE
- ATTENDANCE_ID — NUMBER(38) — 기본 키 — NOT NULL
- USER_UUID — VARCHAR(240)
- ATTENDANCE_TIME — TIMESTAMP(6)
- CONSECUTIVE — NUMBER
BADGE
- BADGE_ID — NUMBER — 기본 키 — NOT NULL
- USER_UUID — VARCHAR(240)
- BADGE_TYPE — VARCHAR(20)
- TIME — TIMESTAMP(6)
BADGE_ACTION
- USER_UUID — VARCHAR(240) — NOT NULL
- ACTION_TIME — TIMESTAMP(6)
- ACTION_TYPE — VARCHAR(20)
- ACTION_ID — NUMBER(38)
BADGE_PUSH
- USER_UUID — VARCHAR(240) — 기본 키 — NOT NULL
- BADGE_TYPE — VARCHAR(20)
- BADGE_LEVEL — NUMBER
- BADGE_PUSH_ID — NUMBER — NOT NULL
CARD_PROBLEM
- CARD_ID — NUMBER — 기본 키 — NOT NULL
- PROB_INDEX — NUMBER — 기본 키 — NOT NULL
- PROB_ID — NUMBER — NOT NULL
- USER_ANSWER — VARCHAR(20)
- DURATION — NUMBER
- IS_CORRECT — CHAR(1)
- SOLVE_TIME — TIMESTAMP(6)
- FAVORITE — VARCHAR(20)
CURRICULUM
- CURRICULUM_ID — VARCHAR(240) — 기본 키 — NOT NULL
- SCHOOL_TYPE — VARCHAR(20)
- GRADE — VARCHAR(20)
- SEMESTER — VARCHAR(20)
- CHAPTER — VARCHAR(240)
- SECTION — VARCHAR(240)
- SUB_SECTION — VARCHAR(240)
- PART — VARCHAR(240)
- CURRICULUM_SEQ — NUMBER(38)
DIAGNOSIS
- DIAGNOSIS_ID — NUMBER — 기본 키 — NOT NULL
- USER_UUID — VARCHAR(240) — NOT NULL
- DIAGNOSIS_TYPE — CHAR(1)
- ASSIGN_TIME — TIMESTAMP(6) — NOT NULL
- ASSIGN_RULE — VARCHAR(4000) — NOT NULL
- REPORT — VARCHAR(2000)
- END_TIME — TIMESTAMP(6)
- LENGTH — NUMBER
DIAGNOSIS_PROBLEM
- DIAGNOSIS_ID — NUMBER — 기본 키 — NOT NULL
- PROB_ID — NUMBER — 기본 키 — NOT NULL
- USER_ANSWER — VARCHAR(1000)
- PROB_INDEX — NUMBER
- DURATION — NUMBER
- IS_CORRECT — CHAR(1)
- SOLVE_TIME — TIMESTAMP(6)
DIVISION
- DIVISION_ID — NUMBER — 기본 키 — NOT NULL
- DIVISION_PARENT_ID — NUMBER — NOT NULL
- DIVISION_NAME — VARCHAR(20) — NOT NULL
- DIVISION_LEVEL — NUMBER
- DIVISION_ROOT_ID — NUMBER
- DIVISION_CODE — VARCHAR(20)
EVENT
- EVENT_ID — NUMBER — 기본 키 — NOT NULL
- START_TIME — TIMESTAMP(6)
- END_TIME — TIMESTAMP(6)
- ANNOUNCEMENT_TIME — TIMESTAMP(6)
- VIEW_COUNT — NUMBER
- CATEGORY — VARCHAR(20)
- REG_TIME — TIMESTAMP(6)
- EVENT_NAME — VARCHAR(40)
- BUTTON_NAME — VARCHAR(20)
- BUTTON_LINK — VARCHAR(200)
- STATUS — VARCHAR(20)
- BUTTON_CLICK_STATUS — VARCHAR(40)
- EVENT_TITLE — VARCHAR(200)
- EVENT_CONTENT — CLOB
- FILE_NAMES — VARCHAR(4000)
- UNIQUE_CODE — VARCHAR(20)
EVENT_BUTTON_LOG
- LOG_ID — NUMBER — 기본 키 — NOT NULL
- EVENT_ID — NUMBER — NOT NULL
- CLICK_TIME — TIMESTAMP(6) — NOT NULL
EVENT_FILE
- EVENT_ID — NUMBER — 기본 키 — NOT NULL
- FILE_NAME — VARCHAR(20) — 기본 키 — NOT NULL
EVENT_LOG
- LOG_ID — NUMBER — 기본 키 — NOT NULL
- EVENT_ID — NUMBER — NOT NULL
- CLICK_TIME — TIMESTAMP(6) — NOT NULL
EXAM_CHAPTER_INFORMATION
- EXAM_CHAPTER_ID — NUMBER — 기본 키 — NOT NULL
- EXAMTERM_ID — NUMBER
- CHAPTER_NAME — VARCHAR(400)
EXAM_INFORMATION
- EXAMTERM_ID — NUMBER — 기본 키 — NOT NULL
- USER_UUID — VARCHAR(240) — NOT NULL
- CHANGED_TIME — TIMESTAMP(6) — NOT NULL
- LEARNING_MODE — CHAR(1)
- START_TIME — TIMESTAMP(6)
- ISEXAM — CHAR(1)
- END_TIME — TIMESTAMP(6)
- LENGTH — NUMBER
- PROGRESS — NUMBER
FILTER_CHIP
- CHIP_ID — NUMBER — 기본 키 — NOT NULL
- FILTER_ID — NUMBER — NOT NULL
- CHIP_TYPE — VARCHAR(20) — NOT NULL
- CHIP_NAME — VARCHAR(20)
- PERIOD — VARCHAR(40)
- USER_UUID — VARCHAR(240)
- DIVISION_ID — NUMBER
FILTER_MASTER
- FILTER_ID — NUMBER — 기본 키 — NOT NULL
- FILTER_MASTER — VARCHAR(240) — NOT NULL
- FILTER_NAME — VARCHAR(40) — NOT NULL
- REGI_TIME — TIMESTAMP(6)
INQUIRY
- INQUIRY_ID — NUMBER — 기본 키 — NOT NULL
- USER_UUID — VARCHAR(240) — NOT NULL
- QUESTION_TITLE — VARCHAR(4000) — NOT NULL
- QUESTION_CONTENT — VARCHAR(4000)
- QUESTION_TIME — TIMESTAMP(6)
- ANSWER_CONTENT — VARCHAR(4000)
- ANSWER_TIME — TIMESTAMP(6)
- MANAGER_ID — VARCHAR(32)
- CATEGORY — VARCHAR(32)
- REPLY_NUMBER — NUMBER
INQUIRY_FILE
- INQUIRY_ID — NUMBER — 기본 키 — NOT NULL
- FILE_NAME — VARCHAR(200) — 기본 키 — NOT NULL
INQUIRY_REPLY
- REPLY_ID — NUMBER — 기본 키 — NOT NULL
- INQUIRY_ID — NUMBER — NOT NULL
- USER_UUID — VARCHAR(240) — NOT NULL
- REPLY_PARENT_ID — NUMBER
- REPLY_CONTENT — VARCHAR(2000)
- REPLY_TIME — TIMESTAMP(6)
- MODIFY_TIME — TIMESTAMP(6)
LEARNING_REPORT_SCORE
- SCORE_ID — NUMBER(38) — 기본 키 — NOT NULL
- USER_UUID — VARCHAR(240)
- SCORE — NUMBER
- REPORT_DATE — TIMESTAMP(6)
LRS
- LRS_ID — NUMBER(38) — 기본 키 — NOT NULL
- INSERT_TIME — TIMESTAMP(6)
- LRS_DATA — VARCHAR(4000)
MAIN_CHAPTER
- CHAPTER_ID — NUMBER — 기본 키 — NOT NULL
- CHAPTER_NAME — VARCHAR(200)
MISSION_LIST
- MISSION_ID — NUMBER — 기본 키 — NOT NULL
- DESCRIPTION — VARCHAR(200)
- POINT — NUMBER
- LIMIT — NUMBER
MISSION_LOG
- USER_UUID — VARCHAR(240) — 기본 키 — NOT NULL
- MISSION_ID — NUMBER — NOT NULL
- EXEC_TIME — TIMESTAMP(6)
- POINT — NUMBER
MY_CARD
- CARD_ID — NUMBER — 기본 키 — NOT NULL
- USER_UUID — VARCHAR(240) — NOT NULL
- ASSIGN_TIME — TIMESTAMP(6) — NOT NULL
- LEARNING_MODE — CHAR(1) — NOT NULL
- CARD_TYPE — VARCHAR(100) — NOT NULL
- CARD_TITLE — VARCHAR(100) — NOT NULL
- ESTIMATED_TIME — NUMBER — NOT NULL
- STATUS — VARCHAR(20)
- LENGTH — NUMBER — NOT NULL
- ASSIGN_RULE — VARCHAR(5000) — NOT NULL
- CARD_DETAIL — VARCHAR(2000) — NOT NULL
- CARD_INDEX — NUMBER — NOT NULL
MY_NOTE
- USER_UUID — VARCHAR(240) — 기본 키 — NOT NULL
- PROB_ID — NUMBER — 기본 키 — NOT NULL
- DURATION — NUMBER
- IS_CORRECT — CHAR(1) — NOT NULL
- FAVORITE — CHAR(1)
- USER_ANSWER — VARCHAR(1000)
- SOLVE_TIME — TIMESTAMP(6) — NOT NULL
MY_PERFECT_LEARNING
- PERFECT_ID — NUMBER — 기본 키 — NOT NULL
- USER_UUID — VARCHAR(240) — NOT NULL
- ASSIGN_TIME — TIMESTAMP(6) — NOT NULL
- PERFECT_TYPE — CHAR(1)
- TITLE — VARCHAR(50) — NOT NULL
- SECTION — VARCHAR(400) — NOT NULL
NOTICE
- NOTICE_ID — NUMBER(38) — 기본 키 — NOT NULL
- USER_UUID — VARCHAR(240)
- CATEGORY — VARCHAR(20)
- STATUS — VARCHAR(20)
- TITLE — VARCHAR(4000)
- CONTENT — VARCHAR(4000)
- TIME — TIMESTAMP(6)
NOTICE_USER
- NOTICE_ID — NUMBER(38)
- USER_UUID — VARCHAR(240)
PERFECT_PROBLEM
- PERFECT_ID — NUMBER — 기본 키 — NOT NULL
- PROB_INDEX — NUMBER — 기본 키 — NOT NULL
- PROB_ID — NUMBER — NOT NULL
- USER_ANSWER — VARCHAR(20)
- DURATION — NUMBER
- IS_CORRECT — CHAR(1)
- SOLVE_TIME — TIMESTAMP(6)
- FAVORITE — VARCHAR(20)
POPUP_BANNER
- BANNER_ID — NUMBER — 기본 키 — NOT NULL
- BANNER_NAME — VARCHAR(40) — NOT NULL
- START_TIME — TIMESTAMP(6) — NOT NULL
- END_TIME — TIMESTAMP(6) — NOT NULL
- RECENT_SHOW_INDEX — NUMBER — NOT NULL
- EVENT_ID — NUMBER — NOT NULL
- IMG — VARCHAR(2000) — NOT NULL
POPUP_BANNER_LOG
- LOG_ID — NUMBER — 기본 키 — NOT NULL
- BANNER_ID — NUMBER — NOT NULL
- SHOW_INDEX — NUMBER — NOT NULL
- CLICK_TIME — TIMESTAMP(6) — NOT NULL
PROBLEM
- PROB_ID — NUMBER — 기본 키 — NOT NULL
- PROB_TYPE — VARCHAR(240)
- ANSWER_TYPE — VARCHAR(240) — NOT NULL
- CURRICULUM_ID — VARCHAR(240)
- QUESTION — VARCHAR(4000) — NOT NULL
- SOLUTION — VARCHAR(4000) — NOT NULL
- DIFFICULTY — VARCHAR(20)
- STATUS — VARCHAR(20) — NOT NULL
- CORRECT_RATE — NUMBER
- SOURCE — VARCHAR(200)
- AVERAGE_DURATION — VARCHAR(20)
- PREDICT_DURATION — VARCHAR(20)
- UPDATED_TIME — TIMESTAMP(6) — NOT NULL
PROBLEM_IMAGE
- PROB_ID — NUMBER — NOT NULL
- FILE_NAME — VARCHAR(256) — NOT NULL
PROBLEM_LOG
- LOG_ID — NUMBER — NOT NULL
- USER_UUID — VARCHAR(240) — NOT NULL
- PROB_ID — NUMBER — NOT NULL
- SOLVE_TIME — TIMESTAMP(6)
- PROB_TYPE — VARCHAR(200)
PROBLEM_REPORT
- ID — NUMBER — NOT NULL
- USER_UUID — VARCHAR(255) — NOT NULL
- PROB_ID — NUMBER — NOT NULL
- CONTENT — VARCHAR(4000)
- STATUS — VARCHAR(40)
- REG_TIME — TIMESTAMP(6)
- CHECK_TIME — TIMESTAMP(6)
SCHOOL
- SCHOOL_NAME — VARCHAR(100) — 기본 키 — NOT NULL
- SCHOOL_ADDRESS — VARCHAR(400) — 기본 키 — NOT NULL
- INTERDISCIPLINARY — VARCHAR(20)
SMALL_CHAPTER
- SMALL_CHAPTER_ID — NUMBER — 기본 키 — NOT NULL
- SUB_CHAPTER_ID — NUMBER
- SMALL_CHAPTER_NAME — VARCHAR(200)
SUB_CHAPTER
- SUB_CHAPTER_ID — NUMBER — 기본 키 — NOT NULL
- CHAPTER_ID — NUMBER
- SUB_CHAPTER_NAME — VARCHAR(200)
TEMP_WAPL_LOGIN
- LOGIN_ID — VARCHAR(100) — 기본 키 — NOT NULL
- LOGIN_PASSWORD — VARCHAR(100)
- EMAIL — VARCHAR(100)
- USER_UUID — VARCHAR(240)
TERMS_OF_SERVICES
- TERMS_ID — NUMBER(38) — 기본 키 — NOT NULL
- TERMS_NAME — VARCHAR(200)
- TERMS_TIME — TIMESTAMP(6)
- TERMS_FILE — VARCHAR(200)
UPDATE_FAILED_PROBLEM
- PROB_ID — NUMBER — 기본 키 — NOT NULL
- REGI_TIME — TIMESTAMP(6) — NOT NULL
USER_DIVISION
- DIVISION_ID — NUMBER — 기본 키 — NOT NULL
- USER_UUID — VARCHAR(240) — 기본 키 — NOT NULL
- REGI_TIME — TIMESTAMP(6)
USER_EVENT
- USER_UUID — VARCHAR(240) — 기본 키 — NOT NULL
- EVENT_ID — NUMBER — 기본 키 — NOT NULL
- JOIN_TIME — TIMESTAMP(6)
USER_MASTER
- USER_UUID — VARCHAR(240) — 기본 키 — NOT NULL
- NICKNAME — VARCHAR(100)
- SCHOOL_NAME — VARCHAR(200)
- SCHOOL_TYPE — VARCHAR(100)
- SCHOOL_YEAR — VARCHAR(20)
- REGI_TIME — TIMESTAMP(6)
- TARGET_SCORE — NUMBER
- RECENT_SCORE — NUMBER
- CURRENT_SCORE — NUMBER
- FILE_NAME — VARCHAR(200)
- RANKING — NUMBER
- DIAGNOSIS_TYPE — CHAR(1)
- PROBLEM_COUNT — NUMBER
- CONSECUTIVE_MY_NOTE_USE — NUMBER
- CONSECUTIVE_STUDY — NUMBER
- CONSECUTIVE_ATTENDANCE — NUMBER
- PHONE_NUMBER — VARCHAR(40)
- TARGET_PERCENT — NUMBER
- USER_TYPE — VARCHAR(20)
- EMAIL — VARCHAR(240)
- SCHOOL_CLASS — VARCHAR(20)
- SCHOOL_NUMBER — VARCHAR(20)
- MASTER_UK — NUMBER
- SIGNOUT_STATE — VARCHAR(1)
- PASSWORD_UPDATED_TIME — TIMESTAMP(6)
- DEVICE_TOKEN — VARCHAR(400)