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)