면담용
테이블 (22)
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
- ID (ID2) — NUMBER — 외래 키 → PROBLEM_BLOCK.ID — NOT NULL
- DATA — VARCHAR(2048)
- PREFACE — VARCHAR(2048)
FIGURE_BLOCK
- FIGURE_ID — VARCHAR(2048) — 기본 키 — NOT NULL
- BLOCK_ID — VARCHAR(2048) — 외래 키 → PROBLEM_BLOCK.BLOCK_ID — NOT NULL
- ID (ID2) — NUMBER — 외래 키 → PROBLEM_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
- ID (ID2) — NUMBER — 외래 키 → PROBLEM_BLOCK.ID — NOT NULL
- NAME — VARCHAR(2048)
- CAPTION — VARCHAR(2048)
- LABEL — VARCHAR(2048)
- DATA — CLOB
PAPER_PROBLEM
- ID — NUMBER — 기본 키 — 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)
- QUESTION — VARCHAR
- SOLUTION — VARCHAR
PAPER_PROJECT
- PROJECT_ID — NUMBER — 외래 키 → PROJECT.ID — NOT NULL
- GRADE — NUMBER
- SEMESTER — NUMBER
- SUBJECT — VARCHAR
- TAG — VARCHAR
- DESIGN_TEMPLATE — VARCHAR
- DIFFICULTY — VARCHAR
- STATUS — VARCHAR
- 다단설정 (다단 설정) — VARCHAR
- 시험지 표출항목 — VARCHAR
- 문제 표출 항목 — VARCHAR
PROBLEM
- ID — NUMBER — 기본 키 — 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
- MAPPING_ID — NUMBER — 외래 키 → SET_PROBLEM_MAPPING.ID — NOT NULL
- TEMPLATE_ID — NUMBER
- ID (ID2) — NUMBER — 외래 키 → TEMPLATE.ID — NOT NULL
PROBLEM_BLOCK
- BLOCK_ID — VARCHAR(2048) — 기본 키 — NOT NULL
- QNS — VARCHAR(2048)
- BLOCK_TYPE — VARCHAR(2048)
- SEQ — NUMBER
- PARENT_ID — VARCHAR(2048)
- PROBLEM_ID — NUMBER — 외래 키 → PROBLEM.ID — NOT NULL
- ID (ID2) — NUMBER — 외래 키 — NOT NULL
PROBLEM_CURR_MAPPING
- ID — NUMBER — 기본 키 — NOT NULL
- CURRICULUM_ID — NUMBER — 외래 키 → CURRICULUM.ID — NOT NULL
- PROBLEM_ID — NUMBER — 외래 키 → PROBLEM.ID — NOT NULL
- ID (ID2) — NUMBER — 외래 키 — NOT NULL
PROBLEM_PAPER_MAPPING (Untitled4)
- ID — NUMBER — 기본 키 — NOT NULL
- PROJECT_ID — NUMBER — 외래 키 → PAPER_PROJECT.PROJECT_ID — NOT NULL
- PROBLEM_ID — NUMBER — 외래 키 → PAPER_PROBLEM.ID — NOT NULL
- SEQUENCE (Field) — NUMBER
PROBLEM_PROJECT
- PROJECT_ID — NUMBER — 외래 키 → PROJECT.ID — NOT NULL
- CONTENT_TYPE — VARCHAR(100) — NOT NULL
- PROJECT_NAME — VARCHAR(100)
- CREATOR — VARCHAR(100) — NOT NULL
- VERSION — NUMBER — NOT NULL
- STATUS — VARCHAR(100) — NOT NULL
- LAST_MODIFIED_DATE — TIMESTAMP(6)
- CREATED_DATE — TIMESTAMP(6)
- LAST_MODIFIER — VARCHAR(100)
- DELETE_FLAG — BOOLEAN
PROBLEM_SET
- ID — NUMBER — 기본 키 — NOT NULL
- NAME — VARCHAR(100) — NOT NULL
- ROOT_FLAG — BOOLEAN — NOT NULL
- DELETE_FLAG — BOOLEAN
- PROJECT_ID — NUMBER — 외래 키 → PROBLEM_PROJECT.PROJECT_ID — NOT NULL
PROBLEM_UK_MAPPING
- ID — VARCHAR(255) — 기본 키 — NOT NULL
- PROBLEM_ID — NUMBER — 외래 키 → PROBLEM.ID — NOT NULL
- UK_ID — NUMBER — 외래 키 → UK.ID — NOT NULL
- ID (ID2) — NUMBER — 외래 키 — NOT NULL
PROJECT (Untitled2)
- ID — NUMBER — 기본 키 — NOT NULL
- TITLE — VARCHAR(100)
- CREATOR — VARCHAR(100)
- LAST_MODIFIED_DATE — TIMESTAMP(6)
RG_ROOM (Untitled)
- ROOM_ID — NUMBER — 기본 키 — NOT NULL
ROOM_PROJECT_MAPPING (Untitled3)
- ID — NUMBER — 기본 키
- ROOM_ID — NUMBER — 외래 키 → RG_ROOM.ROOM_ID — NOT NULL
- PROJECT_ID — NUMBER — 외래 키 → PROJECT.ID — NOT NULL
- CREATOR — VARCHAR(100)
- AUTHORITY
SET_PROBLEM_MAPPING (ARTICLE)
- ID — NUMBER — 기본 키 — NOT NULL
- ROOT_FLAG — BOOLEAN
- DELETE_FLAG — BOOLEAN
- SET_ID — NUMBER — 외래 키 → PROBLEM_SET.ID — NOT NULL
TEMPLATE (Untitled5)
- ID — NUMBER — 기본 키 — NOT NULL
TEXT_BLOCK
- BLOCK_ID — VARCHAR(2048) — 외래 키 → PROBLEM_BLOCK.BLOCK_ID — NOT NULL
- ID (ID2) — NUMBER — 외래 키 → PROBLEM_BLOCK.ID — NOT NULL
- DATA — VARCHAR(2048)
UK
- ID — NUMBER — 기본 키 — NOT NULL
- NAME — VARCHAR(255)
UK_CURRICULUM_REL (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