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