면담용

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