Dashboard
Master Data
Spesifikasi teknis modul Master Data (/dashboard/master/*), data induk sektor, wilayah, organisasi, taksonomi, keywords, dan datasets, serta pemetaan database PostgreSQL, Elasticsearch, dan Kafka.
Master Data Induk (/dashboard/master/*)
Modul Master Data Induk merupakan Single Source of Truth untuk seluruh entitas referensi platform Nexa Intelligence, mencakup 8 sub-katalog induk: Sektor, Wilayah Administratif, Organisasi K/L/Pemda, Target Scraping, Taksonomi 5 Tingkat, Kata Kunci Taksonomi, Kata Kunci Sosmed, dan Datasets Statis.
Tabel Pemetaan Komponen ke PostgreSQL & Elasticsearch
| Sub-Katalog Master Data | PostgreSQL (Tabel & Kolom Kunci) | Elasticsearch (Indeks & Field Kunci) | Kafka (Topik & Alur Event) |
|---|---|---|---|
Sektor (/master/sectors) | • master_sectors↳ id, sector_name, public_id | • sectors_index↳ sector_id, sector_name | queue-master-sync(Master Sync Bus) |
Wilayah (/master/regions) | • master_regions↳ id, region_name, region_level, parent_id, public_id | • regions_index↳ region_id, region_name, region_level, parent_name | queue-master-sync |
Organisasi (/master/organizations) | • organization_nodes↳ id, parent_id, sector_id, region_id, org_name, org_type, aliases, public_id | • organizations_index↳ org_id, org_name, org_type, sector_name, region_name | queue-master-sync |
Target Scraping (/master/scraping-targets) | • scraping_targets↳ id, organization_node_id, domain_name, base_url, scraping_config, is_active | • scraper_audit_logs↳ target_domain, is_active | queue-master-sync |
Taksonomi & Keywords (/master/taxonomy, /master/taxonomy-keywords) | • taxonomy_nodes↳ id, parent_id, label, level, pillar, color, sort_order• taxonomy_keywords↳ id, taxonomy_node_id, keyword_phrase, is_active | • taxonomy_dictionary↳ keyword_phrase, taxonomy_node_id, pillar, full_path | queue-taxonomy-cache-evict(Cache Evict Signal) |
Sosmed Keywords (/master/social-keywords) | • social_keywords↳ id, keyword, article_id, taxonomy, level, taxonomy_node_id, is_active | • social_keywords_index↳ keyword, taxonomy, level, active | queue-social-keyword-sync |
Datasets (/master/datasets) | • static_datasets↳ id, file_sha256, file_path_minio, original_name, dataset_kind, status, rows_loaded, rows_expected• static_dataset_records↳ dataset_id, row_hash, raw_payload, business_key | • static_datasets_catalog↳ dataset_id, dataset_name, kind, total_records | queue-dataset-ingest |