Livoa LogoLivoa
dynamic_theme_mapping


dynamic_theme_mapping_id (PK)

reporting_kpi_id

reporting_kpi_name

question_category

question_code

created_date

created_by

updated_date

updated_by

question_name

theme_name

dynamic_theme_mapping_1800


dynamic_theme_mapping_1800_id (PK)

reporting_kpi_id

reporting_kpi_name

question_category

question_code

created_date

created_by

updated_date

updated_by

question_name

theme_name

theme_year

theme_month

parent_question

dynamic_unit

reporting_kpi


reporting_kpi_id (PK)

group_id

reporting_kpi_name

created_date

created_by

updated_date

updated_by

filter_by

display_json

reporting_kpi_description

reporting_kpi_data_type

reporting_kpi_unit

data_item_name

default_theme_kpi_mapping


dtkm_id (PK)

default_theme_id

reporting_kpi_id

default_theme_datapoint_path

created_date

created_by

updated_date

updated_by

default_themes


default_theme_id (PK)

default_theme_name

default_theme_group

description

created_date

created_by

updated_by

updated_date

req_design_json

rtiuin

tags

group_id

group


group_id (PK)

group_1

group_2

created_date

created_by

updated_date

updated_by

description

narrative_summary


ns_id (PK)

theme_id

tkm_id

narr_summary_genai

created_date

created_by

updated_date

updated_by

theme_kpi_mapping


tkm_id (PK)

repo_period_id

theme_id

reporting_kpi_id

rp_theme_datapoint_path

created_date

created_by

updated_date

updated_by

notification


notification_id (PK)

description

entity_id

repo_period_id

theme_id

entity_theme_id

acknowledge

created_date

created_by

pre_agg_summary


pre_agg_summary_id (PK)

entity_id

entity_property_id

entity_theme_id

tkm_id

rp_theme_datapoint_value

created_date

created_by

updated_by

entity_theme


entity_theme_id (PK)

entity_property_id

theme_id

created_date

created_by

updated_date

updated_by

repo_period_id

entity_id

data_collector_id

approver_id

locksel

frequency

sub_frequency

policy_id

comments


comment_id (PK)

entity_theme_id

user_id

comment

created_date

created_by

updated_date

updated_by

entity_theme_response


entity_theme_response_id (PK)

response_json

created_date

created_by

updated_date

updated_by

status

entity_theme_id

is_rejected

entity_property


entity_property_id (PK)

entity_id

parent_id

location

address

created_date

created_by

updated_date

updated_by

repo_period_id

city

region

tags

facility_id

control_id

entity


entity_id (PK)

entity_name

entity_type_id

description

created_date

created_by

active

tenant_id

entity_group_id

entity_group_name

entity_threshold

entity_type


entity_type_id (PK)

entity_type

entity_control


control_id (PK)

control_name

policy


policy_id (PK)

policy_name

status

created_date

created_by

updated_date

updated_by

is_indexed

geo_location


geo_id (PK)

city

region

country

created_date

created_by

updated_date

updated_by

reporting_kpi_master_list


ml_id (PK)

reporting_kpi_name

sample_input

data_item_name

reporting_kpi_description

reporting_kpi_data_type

reporting_kpi_unit

SampleInput Data type

tags


tag_id (PK)

tag_name

tag_type

tenant_id

created_date

created_by

updated_date

updated_by

theme_response_logs


trl_id (PK)

entity_theme_response_id

user_id

key_name_path

key_name

old_value

new_value

change_type

created_date

created_by

repo_period


repo_period_id (PK)

period_name

start_date

end_date

lock

created_date

created_by

updated_date

updated_by

active

tenant_id

collection_ends_by

reporting_period_themes


theme_id (PK)

theme_name

theme_group

description

created_date

created_by

updated_by

updated_date

req_design_json

status

repo_period_id

tags

group_id

is_default_theme

i

by Krishna

0
0 uses