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)