SuperExam 외부공유용

테이블 (22)

COMMON_TASK

  • TASK_ID — NUMBER — 기본 키 — NOT NULL
  • CONTENT_TYPE — VARCHAR(100)
  • TITLE — VARCHAR(100)
  • LAST_MODIFIER — VARCHAR(100)
  • CREATOR — VARCHAR(100)
  • DELETE_FLAG — BOOLEAN
  • CREATED_DATE — TIMESTAMP(6)
  • LAST_MODIFIED_DATE — TIMESTAMP(6)

CURRICULUM

  • ID — NUMBER — 기본 키 — NOT NULL
  • SUBJECT — VARCHAR(100) — NOT NULL
  • SCHOOL_TYPE — VARCHAR(100) — NOT NULL
  • GRADE — NUMBER — NOT NULL
  • SEMESTER — NUMBER — NOT NULL
  • FIRST_UNIT_ID — NUMBER — NOT NULL
  • SECOND_UNIT_ID — NUMBER — NOT NULL
  • THIRD_UNIT_ID — NUMBER — NOT NULL

EXAMPLE_BLOCK

  • BLOCK_ID — VARCHAR(2048) — 외래 키 → PROBLEM_BLOCK.BLOCK_ID — NOT NULL
  • PREFACE — VARCHAR(2048)
  • DISPOSITION (Field) — VARCHAR(2048)

EXAM_FOLDER

  • ID — NUMBER — 기본 키 — NOT NULL
  • PARENT_ID — NUMBER
  • NAME — VARCHAR(100)
  • DELETE_FLAG — BOOLEAN
  • CREATED_DATE — TIMESTAMP(6)
  • LAST_MODIFIED_DATE — TIMESTAMP(6)

EXAM_TASK

  • TASK_ID — NUMBER — 외래 키 → COMMON_TASK.TASK_ID — NOT NULL
  • COL_NUM — NUMBER
  • MAX_ROW — NUMBER
  • EXAM_CATEGORY — VARCHAR(100)
  • PROBLEM_CATEGORY — VARCHAR(100)
  • STATUS — VARCHAR(100)
  • TAG — VARCHAR(100)
  • SEMESTER_INFO — VARCHAR(100)
  • UNIT_INFO — VARCHAR(100)

FIGURE_BLOCK

  • BLOCK_ID — VARCHAR(2048) — 외래 키 → PROBLEM_BLOCK.BLOCK_ID — NOT NULL
  • FIGURE_TYPE — VARCHAR(1024)
  • DATA_TEMPLATE — VARCHAR(1024)
  • DATA — CLOB

IMG_BLOCK

  • BLOCK_ID — VARCHAR(2048) — 외래 키 → PROBLEM_BLOCK.BLOCK_ID — NOT NULL
  • NAME — VARCHAR(2048)
  • CAPTION — VARCHAR(2048)
  • LABEL — VARCHAR(2048)
  • DATA — CLOB

MODIFYING_PROBLEM_MAPPING

  • ID — NUMBER — 기본 키 — NOT NULL
  • PROBLEM_ID — NUMBER — 외래 키 → PROBLEM.ID — NOT NULL
  • MODIFYING_PROBLEM_ID — NUMBER — 외래 키 → PROBLEM.ID — NOT NULL

PROBLEM

  • ID — NUMBER — 기본 키 — NOT NULL
  • PROBLEM_SET_ID (ID2) — NUMBER — 외래 키 → PROBLEM_SET.ID — NOT NULL
  • CORRECT_ANSWER — VARCHAR(100)
  • STATUS — VARCHAR(100) — NOT NULL
  • PROBLEM_TYPE — VARCHAR(100) — NOT NULL
  • DIFFICULTY — VARCHAR(100)
  • CREATE_TYPE — VARCHAR(100) — NOT NULL
  • TAG — VARCHAR(100)
  • LEARNING_DOMAIN — VARCHAR(100)
  • CREATED_DATE — TIMESTAMP(6) — NOT NULL
  • CREATOR — VARCHAR(100) — NOT NULL
  • LAST_MODIFIED_DATE — TIMESTAMP(6) — NOT NULL
  • RECOMMEND_TIME — NUMBER(10)
  • DELETE_FLAG — BOOLEAN
  • VALID (Field) — BOOLEAN
  • TEMPLATE_ID (Field2) — NUMBER

PROBLEM_BLOCK

  • BLOCK_ID — VARCHAR(2048) — 기본 키 — NOT NULL
  • PROBLEM_ID — NUMBER — 외래 키 → PROBLEM.ID — NOT NULL
  • QNS — VARCHAR(2048)
  • BLOCK_TYPE — VARCHAR(2048)
  • SEQ — NUMBER
  • PARENT_BLOCK_ID — VARCHAR(2048)

PROBLEM_CURR_MAPPING

  • ID — NUMBER — 기본 키 — NOT NULL
  • PROBLEM_ID (PROB_ID) — NUMBER — 외래 키 → PROBLEM.ID — NOT NULL
  • CURRICULUM_ID — NUMBER — 외래 키 → CURRICULUM.ID — NOT NULL

PROBLEM_EXAM_MAPPING

  • ID (Key) — NUMBER — 기본 키 — NOT NULL
  • SEQ — NUMBER
  • POINT — NUMBER
  • TASK_ID — NUMBER — 외래 키 → EXAM_TASK.TASK_ID — NOT NULL
  • PROBLEM_ID — NUMBER — 외래 키 → PROBLEM.ID — NOT NULL

PROBLEM_HISTORY

  • ID — NUMBER — 기본 키 — NOT NULL
  • PROBLEM_ID (PROB_ID) — NUMBER — 외래 키 → PROBLEM.ID — NOT NULL
  • USER_ID — VARCHAR(100) — NOT NULL
  • ACTION_TYPE — VARCHAR(100) — NOT NULL
  • ACTION_TIME — TIMESTAMP(6) — NOT NULL

PROBLEM_SET

  • ID — NUMBER — 기본 키 — NOT NULL
  • NAME — VARCHAR(100) — NOT NULL
  • ROOT_FLAG — BOOLEAN — NOT NULL
  • DELETE_FLAG — BOOLEAN
  • TASK_ID — NUMBER — 외래 키 → PROBLEM_TASK.TASK_ID — NOT NULL

PROBLEM_TASK

  • TASK_ID (Key) — NUMBER — 외래 키 → COMMON_TASK.TASK_ID — NOT NULL

PROBLEM_UK_MAPPING

  • ID — NUMBER — 기본 키 — NOT NULL
  • PROBLEM_ID (PROB_ID) — NUMBER — 외래 키 → PROBLEM.ID — NOT NULL
  • UK_ID — NUMBER — 외래 키 → UK.ID — NOT NULL

PUBLISHED_EXAM_FOLDER_MAPPING

  • ID — NUMBER — 기본 키 — NOT NULL
  • EXAM_FOLDER_ID — NUMBER — 외래 키 → EXAM_FOLDER.ID — NOT NULL
  • TASK_ID — NUMBER — 외래 키 → COMMON_TASK.TASK_ID — NOT NULL

SEARCH_HISTORY

  • USER_ID — VARCHAR(100) — 기본 키 — NOT NULL
  • KEYWORD — VARCHAR(255) — 기본 키 — NOT NULL
  • CONTENT_TYPE — VARCHAR(100) — 기본 키 — NOT NULL
  • SEARCHED_DATE — TIMESTAMP(6)

TEXT_BLOCK

  • BLOCK_ID — VARCHAR(2048) — 외래 키 → PROBLEM_BLOCK.BLOCK_ID — NOT NULL
  • DATA — VARCHAR(2048)

UK

  • ID — NUMBER — 기본 키 — NOT NULL
  • NAME — VARCHAR(255)

UK_CURRICULUM_MAPPING

  • UK_ID — NUMBER — 외래 키 → UK.ID — NOT NULL
  • CURRICULUM_ID — NUMBER — 외래 키 → CURRICULUM.ID — NOT NULL

UNIT

  • ID — NUMBER — 기본 키 — NOT NULL
  • UNIT — VARCHAR(150) — NOT NULL
  • DETAIL — VARCHAR(1000) — NOT NULL
  • UNIT_SIZE — VARCHAR(100) — NOT NULL