와플수학_공유용

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