11

Tables (15)

anq_item

  • item_id — BIGINT — Primary key — NOT NULL
  • problem_type — VARCHAR(50)
  • item_type — VARCHAR(50)
  • curriculum_unit — VARCHAR(255)
  • title — VARCHAR(255)
  • description — TEXT
  • external_code — VARCHAR(100)
  • external_parent_code — VARCHAR(100)
  • topic_id — BIGINT — Foreign key → curriculum_node.node_id
  • difficulty — TINYINT
  • status — ENUM('DRAFT','ACTIVE','HOLD','HIDDEN','ARCHIVED') — NOT NULL
  • is_deleted — TINYINT(1) — NOT NULL
  • deleted_at — DATETIME
  • created_at — DATETIME — NOT NULL
  • created_by — VARCHAR(100)
  • updated_at — DATETIME — NOT NULL
  • updated_by — VARCHAR(100)

arc (tag(concetp_group))

  • group_id (Key) — Foreign key → master.group_id — NOT NULL
  • concept_id (Key2) — Foreign key → master.concept_id — NOT NULL
  • concept_id (Key3) — Foreign key → master.concept_id — NOT NULL

arc (error_check_algrisom)

  • Key — Foreign key → info.Key — NOT NULL
  • id (Key2) — Foreign key → info.id — NOT NULL
  • concept_id (Key22) — Foreign key → info.concept_id — NOT NULL
  • group_id (Key3) — Foreign key → info.group_id — NOT NULL
  • concept_id (Key23) — Foreign key → info.concept_id — NOT NULL
  • concept_id (Key32) — Foreign key → info.concept_id — NOT NULL
  • Field

concept_revision

  • concept_revision_id — BIGINT — Primary key — NOT NULL
  • concept_id — BIGINT — NOT NULL
  • version — INT — NOT NULL
  • snapshot_name — VARCHAR(255) — NOT NULL
  • snapshot_description — TEXT
  • snapshot_concept_type — VARCHAR(50) — NOT NULL
  • snapshot_status — VARCHAR(20) — NOT NULL
  • effective_from — DATETIME
  • effective_to — DATETIME
  • changed_at — DATETIME — NOT NULL
  • changed_by — VARCHAR(100)
  • change_reason — VARCHAR(255)

curriculum_node

  • node_id — BIGINT — Primary key — NOT NULL
  • school_level — ENUM('C','J','G') — NOT NULL
  • depth — TINYINT — NOT NULL
  • parent_id — BIGINT — Foreign key → curriculum_node.node_id
  • name — VARCHAR(255) — NOT NULL
  • sort_no — INT — NOT NULL
  • status — ENUM('ACTIVE','HIDDEN') — NOT NULL
  • effective_from — DATETIME
  • effective_to — DATETIME
  • is_deleted — TINYINT(1) — NOT NULL
  • deleted_at — DATETIME
  • created_at — DATETIME — NOT NULL
  • created_by — VARCHAR(100)
  • updated_at — DATETIME — NOT NULL
  • updated_by — VARCHAR(100)

info ((AS-IS) ANQ)

  • Key — Primary key — NOT NULL
  • id (Key2) — Foreign key → master.id — NOT NULL
  • concept_id (Key22) — Foreign key → master.concept_id — NOT NULL
  • name (Field)
  • 기타 정보 (Field2)

info (tag)

  • group_id (Key) — Foreign key → arc.group_id — NOT NULL
  • concept_id (Key2) — Foreign key → arc.concept_id — NOT NULL
  • concept_id (Key3) — Foreign key → arc.concept_id — NOT NULL
  • 중복도 (Field)

master (Curriculum_node)

  • id (Key) — Primary key — NOT NULL
  • concept_id (Key2) — Foreign key → master.concept_id — NOT NULL
  • name (Field)
  • depth (Field2)
  • status (Field3)
  • update (Field4)

master (concept)

  • concept_id (Key) — Primary key — NOT NULL
  • school (Field)
  • name (Field2)
  • description (Field3)
  • status (Field4)
  • sort_n o (Field5)

master (concept_group)

  • group_id (Key) — Primary key — NOT NULL
  • concept_id (Key2) — Foreign key → master.concept_id — NOT NULL
  • name (Field)
  • description (Field2)
  • version (Field3)

recalc_job

  • job_id — BIGINT — Primary key — NOT NULL
  • job_type — ENUM('ALGRISOM_PRIMARY_RECALC','TOPIC_CONCEPT_RECALC') — NOT NULL
  • scope_school_level — ENUM('C','J','G')
  • scope_topic_id — BIGINT — Foreign key → curriculum_node.node_id
  • status — ENUM('RUNNING','DONE','FAILED') — NOT NULL
  • started_at — DATETIME — NOT NULL
  • finished_at — DATETIME
  • requested_by — VARCHAR(100)
  • note — TEXT

relation (algrisom)

  • group_id (Key) — Foreign key → info.group_id — NOT NULL
  • concept_id (Key2) — Foreign key → info.concept_id — NOT NULL
  • concept_id (Key3) — Foreign key → info.concept_id — NOT NULL
  • algrisom (Field)

tag_group

  • tag_group_id — BIGINT — Primary key — NOT NULL
  • school_level — ENUM('C','J','G') — NOT NULL
  • display_text — VARCHAR(255) — NOT NULL
  • tag_kind — ENUM('SINGLE','BUNDLE') — NOT NULL
  • status — ENUM('ACTIVE','HOLD','HIDDEN') — NOT NULL
  • version — INT — NOT NULL
  • is_deleted — TINYINT(1) — NOT NULL
  • deleted_at — DATETIME
  • created_at — DATETIME — NOT NULL
  • created_by — VARCHAR(100)
  • updated_at — DATETIME — NOT NULL
  • updated_by — VARCHAR(100)

tag_group_member

  • tag_group_member_id — BIGINT — Primary key — NOT NULL
  • tag_group_id — BIGINT — Foreign key → tag_group.tag_group_id — NOT NULL
  • concept_id — BIGINT — NOT NULL
  • sort_no — INT — NOT NULL
  • is_deleted — TINYINT(1) — NOT NULL
  • deleted_at — DATETIME
  • created_at — DATETIME — NOT NULL
  • created_by — VARCHAR(100)

topic_concept

  • topic_concept_id — BIGINT — Primary key — NOT NULL
  • topic_id — BIGINT — Foreign key → curriculum_node.node_id — NOT NULL
  • concept_id — BIGINT — NOT NULL
  • sort_no — INT — NOT NULL
  • status — ENUM('ACTIVE','HIDDEN') — NOT NULL
  • is_deleted — TINYINT(1) — NOT NULL
  • deleted_at — DATETIME
  • created_at — DATETIME — NOT NULL
  • created_by — VARCHAR(100)
  • updated_at — DATETIME — NOT NULL
  • updated_by — VARCHAR(100)