dynamic_theme_mappingdynamic_theme_mapping_id (PK)reporting_kpi_idreporting_kpi_namequestion_categoryquestion_codecreated_datecreated_byupdated_dateupdated_byquestion_nametheme_name

dynamic_theme_mapping_1800dynamic_theme_mapping_1800_id (PK)reporting_kpi_idreporting_kpi_namequestion_categoryquestion_codecreated_datecreated_byupdated_dateupdated_byquestion_nametheme_nametheme_yeartheme_monthparent_questiondynamic_unit

reporting_kpireporting_kpi_id (PK)group_idreporting_kpi_namecreated_datecreated_byupdated_dateupdated_byfilter_bydisplay_jsonreporting_kpi_descriptionreporting_kpi_data_typereporting_kpi_unitdata_item_name

default_theme_kpi_mappingdtkm_id (PK)default_theme_idreporting_kpi_iddefault_theme_datapoint_pathcreated_datecreated_byupdated_dateupdated_by

default_themesdefault_theme_id (PK)default_theme_namedefault_theme_groupdescriptioncreated_datecreated_byupdated_byupdated_datereq_design_jsonrtiuintagsgroup_id

groupgroup_id (PK)group_1group_2created_datecreated_byupdated_dateupdated_bydescription

narrative_summaryns_id (PK)theme_idtkm_idnarr_summary_genaicreated_datecreated_byupdated_dateupdated_by

theme_kpi_mappingtkm_id (PK)repo_period_idtheme_idreporting_kpi_idrp_theme_datapoint_pathcreated_datecreated_byupdated_dateupdated_by

notificationnotification_id (PK)descriptionentity_idrepo_period_idtheme_identity_theme_idacknowledgecreated_datecreated_by

pre_agg_summarypre_agg_summary_id (PK)entity_identity_property_identity_theme_idtkm_idrp_theme_datapoint_valuecreated_datecreated_byupdated_by

entity_themeentity_theme_id (PK)entity_property_idtheme_idcreated_datecreated_byupdated_dateupdated_byrepo_period_identity_iddata_collector_idapprover_idlockselfrequencysub_frequencypolicy_id

commentscomment_id (PK)entity_theme_iduser_idcommentcreated_datecreated_byupdated_dateupdated_by

entity_theme_responseentity_theme_response_id (PK)response_jsoncreated_datecreated_byupdated_dateupdated_bystatusentity_theme_idis_rejected

entity_propertyentity_property_id (PK)entity_idparent_idlocationaddresscreated_datecreated_byupdated_dateupdated_byrepo_period_idcityregiontagsfacility_idcontrol_id

entityentity_id (PK)entity_nameentity_type_iddescriptioncreated_datecreated_byactivetenant_identity_group_identity_group_nameentity_threshold

entity_typeentity_type_id (PK)entity_type

entity_controlcontrol_id (PK)control_name

policypolicy_id (PK)policy_namestatuscreated_datecreated_byupdated_dateupdated_byis_indexed

geo_locationgeo_id (PK)cityregioncountrycreated_datecreated_byupdated_dateupdated_by

reporting_kpi_master_listml_id (PK)reporting_kpi_namesample_inputdata_item_namereporting_kpi_descriptionreporting_kpi_data_typereporting_kpi_unitSampleInput Data type

tagstag_id (PK)tag_nametag_typetenant_idcreated_datecreated_byupdated_dateupdated_by

theme_response_logstrl_id (PK)entity_theme_response_iduser_idkey_name_pathkey_nameold_valuenew_valuechange_typecreated_datecreated_by

repo_periodrepo_period_id (PK)period_namestart_dateend_datelockcreated_datecreated_byupdated_dateupdated_byactivetenant_idcollection_ends_by

reporting_period_themestheme_id (PK)theme_nametheme_groupdescriptioncreated_datecreated_byupdated_byupdated_datereq_design_jsonstatusrepo_period_idtagsgroup_idis_default_theme