concept map

Tables (10)

algrisom

  • algrisom_id — BIGINT — Primary key — NOT NULL
  • item_id — BIGINT — Foreign key → anq_item.item_id — NOT NULL
  • tag_group_id — BIGINT — Foreign key → tag_group.tag_group_id — NOT NULL
  • concept_id — BIGINT — Foreign key → concept.concept_id — NOT NULL
  • sort_no — INT — NOT NULL
  • role — ENUM('PRIMARY','SUB')
  • is_confirmed — TINYINT(1) — NOT NULL
  • calc_version — BIGINT
  • 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)

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
  • topic_source — ENUM('MANUAL','DERIVED_FROM_TAG') — NOT NULL
  • derived_topic_id — BIGINT — Foreign key → curriculum_node.node_id
  • 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)

concept

  • concept_id — BIGINT — Primary key — NOT NULL
  • school_level — ENUM('C','J','G') — NOT NULL
  • name — VARCHAR(255) — NOT NULL
  • description — TEXT
  • status — ENUM('ACTIVE','HOLD','HIDDEN') — NOT NULL
  • version — INT — 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)

concept_revision

  • concept_revision_id — BIGINT — Primary key — NOT NULL
  • concept_id — BIGINT — Foreign key → concept.concept_id — 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)

error_check_algrisom

  • error_id — BIGINT — Primary key — NOT NULL
  • item_id — BIGINT — Foreign key → anq_item.item_id — NOT NULL
  • topic_id — BIGINT — Foreign key → curriculum_node.node_id — NOT NULL
  • error_type — ENUM('MISSING','EXTRA','MISMATCH') — NOT NULL
  • rule_code — VARCHAR(50)
  • concept_id — BIGINT — Foreign key → concept.concept_id
  • expected_count — INT
  • actual_count — INT
  • detail — VARCHAR(1000)
  • detected_at — DATETIME — NOT NULL
  • detected_by — VARCHAR(100)
  • resolved — TINYINT(1) — NOT NULL
  • resolved_at — DATETIME
  • resolved_by — VARCHAR(100)

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

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 — Foreign key → concept.concept_id — 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 — Foreign key → concept.concept_id — 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)