"""
Django settings for dala project.

Generated by 'django-admin startproject' using Django 1.10.3.

For more information on this file, see
https://docs.djangoproject.com/en/1.10/topics/settings/

For the full list of settings and their values, see
https://docs.djangoproject.com/en/1.10/ref/settings/
"""

import os

# Build paths inside the project like this: os.path.join(BASE_DIR, ...)
BASE_DIR = os.path.dirname(os.path.dirname(os.path.abspath(__file__)))

# Quick-start development settings - unsuitable for production
# See https://docs.djangoproject.com/en/1.10/howto/deployment/checklist/

# SECURITY WARNING: keep the secret key used in production secret!
SECRET_KEY = 'z(-pb7d!3-efta70vsay=by7=*ng#=9vayn@dc)9b8ddcg%54&'

# SECURITY WARNING: don't run with debug turned on in production!
DEBUG = True

ALLOWED_HOSTS = ['*']

ADMINS = (
    ('Dileepa', 'dileepa.ozi@mail.com'),
)

# Application definition

INSTALLED_APPS = [
    'django.contrib.admin',
    'django.contrib.auth',
    'django.contrib.contenttypes',
    'django.contrib.sessions',
    'django.contrib.messages',
    'django.contrib.staticfiles',
    # 'report_builder',
    'incidents',
    'dashboard',
    # 'tastypie',
    'settings',
    'users',
    'reports',
    'charts',
    'health',
    'health.base_line',
    'health.damage_losses',
    'education',
    'education.base_line',
    'education.damage_losses',
    # 'db_tools'
    'other_govn_services',
    'other_govn_services.base_line',
    'other_govn_services.damage_losses',
    'mining.base_line',
    'mining.damage_losses',
    'mining',
    'transport_rail',
    'transport_rail.base_line',
    'transport_rail.damage_losses',
    'transport_water',
    'transport_water.base_line',
    'transport_water.damage_losses',
    'transport_land',
    'transport_land.base_line',
    'transport_land.damage_losses',
    'transport_air',
    'transport_air.base_line',
    'transport_air.damage_losses',
    'transport_summary',
    'transport_summary.damage_losses',
    'agri_agrarian',
    'agri_agrarian.base_line',
    'agri_agrarian.damage_losses',
    'agri_irrigation',
    'agri_irrigation.base_line',
    'agri_irrigation.damage_losses',
    'agri_livestock',
    'agri_livestock.base_line',
    'agri_livestock.damage_losses',
    'agri_fisheries',
    'agri_fisheries.base_line',
    'agri_fisheries.damage_losses',
    'agri_summary',
    'agri_summary.damage_losses',
    'water_supply',
    'water_supply.base_line',
    'water_supply.damage_losses',
    'housing',
    'housing.base_line',
    'housing.damage_losses',
    'tourism',
    'tourism.base_line',
    'tourism.damage_losses',
    'industry_services',
    'industry_services.base_line',
    'industry_services.damage_losses',
    'telecommunication',
    'telecommunication.base_line',
    'telecommunication.damage_losses',
    'power_supply',
    'power_supply.base_line',
    'power_supply.damage_losses',
    'new_charts',
]

MIDDLEWARE_CLASSES = [
    'django.middleware.security.SecurityMiddleware',
    'django.contrib.sessions.middleware.SessionMiddleware',
    'django.middleware.common.CommonMiddleware',
    'django.middleware.csrf.CsrfViewMiddleware',
    'django.contrib.auth.middleware.AuthenticationMiddleware',
    'django.contrib.messages.middleware.MessageMiddleware',
    'django.middleware.clickjacking.XFrameOptionsMiddleware',
    # 'dbtools.middleware.ReadOnlyMiddleware',
]

ROOT_URLCONF = 'dala.urls'
JQUERY_URL = True

TEMPLATES = [
    {
        'BACKEND': 'django.template.backends.django.DjangoTemplates',
        'DIRS': [os.path.join(BASE_DIR, 'templates')],
        'APP_DIRS': True,
        'OPTIONS': {
            'context_processors': [
                'django.template.context_processors.debug',
                'django.template.context_processors.request',
                'django.template.context_processors.static',
                'django.template.context_processors.media',
                'django.contrib.auth.context_processors.auth',
                'django.contrib.messages.context_processors.messages',
            ],
        },
    },
]

WSGI_APPLICATION = 'dala.wsgi.application'

# Database
# https://docs.djangoproject.com/en/1.10/ref/settings/#databases

DATABASES = {
    'default': {
        'ENGINE': 'django.db.backends.postgresql_psycopg2',
        # 'OPTIONS': {
        #     'options': '-c search_path=power_supply'
        #                'health, public, other_government, education,mining,'
        #                'transport_rail, transport_water, transport_land,transport_air,'
        #                'agri_agrarian, agri_irrigation, agri_livestock, water_supply,'
        #                'housing, telecommunication', 'industry_services'
        # },

        # 'OPTIONS': {
        #     'options': '-c search_path=industry_services'
        # },

        'NAME': 'dala_2018_01_05',
        #'NAME': 'dala_2017_12_14',
        'USER': 'postgres',
    },
}

REST_FRAMEWORK = {
    'DEFAULT_AUTHENTICATION_CLASSES': (
        'rest_framework.authentication.SessionAuthentication',
    )
}

REPORT_BUILDER_INCLUDE = ['health.damage_losses.models.DsnPubPnLmh', 'health.report_builder_report']

# Password validation
# https://docs.djangoproject.com/en/1.10/ref/settings/#auth-password-validators

AUTH_PASSWORD_VALIDATORS = [
    {
        'NAME': 'django.contrib.auth.password_validation.UserAttributeSimilarityValidator',
    },
    {
        'NAME': 'django.contrib.auth.password_validation.MinimumLengthValidator',
    },
    {
        'NAME': 'django.contrib.auth.password_validation.CommonPasswordValidator',
    },
    {
        'NAME': 'django.contrib.auth.password_validation.NumericPasswordValidator',
    },
]

# Internationalization
# https://docs.djangoproject.com/en/1.10/topics/i18n/

LANGUAGE_CODE = 'en-us'

TIME_ZONE = 'Asia/Colombo'

USE_I18N = True

USE_L10N = True

USE_TZ = False

# Static files (CSS, JavaScript, Images)
# https://docs.djangoproject.com/en/1.10/howto/static-files/

STATIC_URL = '/static/'

# table properties
TABLE_PROPERTY_MAPPER = {
    'dashboard': {
        'IncidentTotal': [
            'tot_dmgloss', 'incident', 'reported_date_time', 'name'
        ],
    },
    'health': {
        'Table_1': {
            'BhsPlc': ['children', 'elderly', 'female', 'male', 'id'],
            'BhsComDiseases': ['com_disease', 'male', 'female', 'children', 'elderly', 'id'],
            'BhsVi': ['children', 'elderly', 'female', 'male', 'vital_indicators', 'id'],
            'BhsOi': ['unit_measure', 'other_indicators', 'id']
        },
        'Table_2': {
            'BmfPubMf': ['type_pub_mf', 'number', 'male', 'female', 'id'],
            'BmfPvtMf': ['type_pvt_mf', 'number', 'male', 'female', 'id']
        },
        'Table_3': {
            'BucMarStructure': ['particulars', 'teaching_hospital', 'provincial_general_hospital',
                                'district_general_hospital', 'office', 'other', 'id'],
            'BucMarSupplies': ['particulars', 'teaching_hospital', 'provincial_general_hospital',
                               'district_general_hospital', 'id'],
            'BucMarMequipment': ['particulars', 'teaching_hospital', 'provincial_general_hospital',
                                 'district_general_hospital', 'id'],
            'BucMarOassets': ['particulars', 'teaching_hospital', 'provincial_general_hospital',
                              'district_general_hospital', 'office', 'other', 'id'],
            'BucMarcStructures': ['particulars', 'teaching_hospital', 'provincial_general_hospital',
                                  'district_general_hospital', 'office', 'other', 'id'],
            'BucMarcMequipment': ['particulars', 'teaching_hospital', 'provincial_general_hospital',
                                  'district_general_hospital', 'id'],
            'BucMarcOassets': ['particulars', 'teaching_hospital', 'provincial_general_hospital',
                               'district_general_hospital', 'office', 'other', 'id'],
            'BucMarcCrpm': ['particulars', 'teaching_hospital', 'provincial_general_hospital',
                            'district_general_hospital', 'office', 'other', 'id'],
        },
        'Table_4': {
            'BucOmarStructure': ['particulars', 'base_hospital', 'divisional_hospital', 'rural_hospital', 'central_dispensary',
                                 'pri_med_cunits', 'pri_health_ccenters', 'mat_child_health_clinics', 'id'],
            'BucOmarSupplies': ['particulars', 'base_hospital', 'divisional_hospital', 'rural_hospital', 'central_dispensary',
                                'pri_med_cunits', 'pri_health_ccenters', 'mat_child_health_clinics', 'id'],
            'BucOmarMequipment': ['particulars', 'base_hospital', 'divisional_hospital', 'rural_hospital', 'central_dispensary',
                                  'pri_med_cunits', 'pri_health_ccenters', 'mat_child_health_clinics', 'id'],
            'BucOmarOassets': ['particulars', 'base_hospital', 'divisional_hospital', 'rural_hospital', 'central_dispensary',
                               'pri_med_cunits', 'pri_health_ccenters', 'mat_child_health_clinics', 'id'],
            'BucOmarcCrpm': ['particulars', 'base_hospital', 'divisional_hospital',
                             'rural_hospital', 'central_dispensary', 'pri_med_cunits', 'pri_health_ccenters',
                             'mat_child_health_clinics', 'id'],
            'BucOmarcStructure': ['particulars', 'base_hospital', 'divisional_hospital', 'rural_hospital',
                                  'central_dispensary', 'pri_med_cunits', 'pri_health_ccenters', 'mat_child_health_clinics', 'id'],
            'BucOmarcMequipment': ['particulars', 'base_hospital', 'divisional_hospital', 'rural_hospital', 'central_dispensary',
                                   'pri_med_cunits', 'pri_health_ccenters', 'mat_child_health_clinics', 'id'],
            'BucOmarcOassets': ['particulars', 'base_hospital', 'divisional_hospital', 'rural_hospital', 'central_dispensary',
                                'pri_med_cunits', 'pri_health_ccenters', 'mat_child_health_clinics', 'id']
        },
        'Table_5': {
            'DmhDfNum': ['num_des_facilities', 'teaching_hospital', 'provincial_general_hospital',
                         'district_general_hospital', 'office', 'other', 'total', 'id'],
            'DmhDfPaf': ['num_patients_affected', 'teaching_hospital', 'provincial_general_hospital',
                         'district_general_hospital', 'office', 'other', 'total', 'id'],
            'DmhNdatFacStructure': ['asset', 'teaching_hospital', 'provincial_general_hospital',
                                    'district_general_hospital', 'office', 'total', 'id'],
            'DmhNdatFacSupplies': ['asset', 'teaching_hospital', 'provincial_general_hospital',
                                   'district_general_hospital', 'total', 'id'],
            'DmhNdatFacMequipment': ['asset', 'teaching_hospital', 'provincial_general_hospital',
                                     'district_general_hospital', 'total', 'id'],
            'DmhNdatFacOassets': ['asset', 'teaching_hospital', 'provincial_general_hospital',
                                  'district_general_hospital', 'office', 'other', 'total', 'id'],
            'DmhPdfaNum': ['num_des_facilities', 'teaching_hospital', 'provincial_general_hospital',
                           'district_general_hospital', 'office', 'other', 'total', 'id'],
            'DmhPdfaPaf': ['num_patients_affected', 'teaching_hospital', 'provincial_general_hospital',
                           'district_general_hospital', 'office', 'other', 'total', 'id'],
            'DmhPdfaStructure': ['asset', 'teaching_hospital', 'provincial_general_hospital',
                                 'district_general_hospital', 'office', 'other', 'total', 'id'],
            'DmhPdfaMequipment': ['asset', 'teaching_hospital', 'provincial_general_hospital',
                                  'district_general_hospital', 'total', 'id'],
            'DmhPdfaOassets': ['asset', 'teaching_hospital', 'provincial_general_hospital',
                               'district_general_hospital', 'office', 'other', 'total', 'id'],
            'DmhLosFi': ['type_of_losses', 'teaching_hospital', 'provincial_general_hospital',
                         'district_general_hospital', 'office', 'other', 'total', 'id'],
            'DmhLosCud': ['type_of_losses', 'teaching_hospital', 'provincial_general_hospital',
                          'district_general_hospital', 'office', 'other', 'total', 'id'],
            'DmhLosHoc': ['type_of_losses', 'teaching_hospital', 'provincial_general_hospital',
                          'district_general_hospital', 'office', 'other', 'total', 'id'],
            'DmhLosOue': ['type_of_losses', 'teaching_hospital', 'provincial_general_hospital',
                          'district_general_hospital', 'office', 'other', 'total', 'id'],
        },
        'Table_6': {
            'DmfDfaNum': ['num_des_facilities', 'base_hospital', 'divisional_hospital', 'rural_hospital',
                          'central_dispensary', 'pmcus', 'phccs', 'mchcs', 'total', 'id'],
            'DmfDfaPaf': ['num_patients_affected', 'base_hospital', 'divisional_hospital', 'rural_hospital', 'central_dispensary',
                          'pmcus', 'phccs', 'mchcs', 'total', 'id'],
            'DmfDaStructure': ['asset', 'base_hospital', 'divisional_hospital', 'rural_hospital', 'central_dispensary',
                               'pmcus', 'phccs', 'mchcs', 'total', 'id'],
            'DmfDaSupplies': ['asset', 'base_hospital', 'divisional_hospital', 'rural_hospital', 'central_dispensary',
                              'pmcus', 'phccs', 'mchcs', 'total', 'id'],
            'DmfDaMequipment': ['asset', 'base_hospital', 'divisional_hospital', 'rural_hospital', 'central_dispensary',
                                'pmcus', 'phccs', 'mchcs', 'total', 'id'],
            'DmfDaOassets': ['asset', 'base_hospital', 'divisional_hospital', 'rural_hospital', 'central_dispensary',
                             'pmcus', 'phccs', 'mchcs', 'total', 'id'],
            'DmfPdfaNum': ['num_pdamaged_facilities', 'base_hospital', 'divisional_hospital', 'rural_hospital', 'central_dispensary',
                           'pmcus', 'phccs', 'mchcs', 'total', 'id'],
            'DmfPdfaPaf': ['num_patients_affected', 'base_hospital', 'divisional_hospital', 'rural_hospital', 'central_dispensary', 'pmcus',
                           'phccs', 'mchcs', 'total', 'id'],
            'DmfPdaStructure': ['asset', 'base_hospital', 'divisional_hospital', 'rural_hospital', 'central_dispensary',
                                'pmcus', 'phccs', 'mchcs', 'total', 'id'],
            'DmfPdaMequipment': ['asset', 'base_hospital', 'divisional_hospital', 'rural_hospital', 'central_dispensary',
                                 'pmcus', 'phccs', 'mchcs', 'total', 'id'],
            'DmfPdaOassets': ['asset', 'base_hospital', 'divisional_hospital', 'rural_hospital', 'central_dispensary',
                              'pmcus', 'phccs', 'mchcs', 'total', 'id'],
            'DmfLosFi': ['type_of_losses', 'base_hospital', 'divisional_hospital', 'rural_hospital', 'central_dispensary',
                         'pmcus', 'phccs', 'mchcs', 'total', 'id'],
            'DmfLosCud': ['type_of_losses', 'base_hospital', 'divisional_hospital', 'rural_hospital', 'central_dispensary',
                          'pmcus', 'phccs', 'mchcs', 'total', 'id'],
            'DmfLosHoc': ['type_of_losses', 'base_hospital', 'divisional_hospital', 'rural_hospital', 'central_dispensary',
                          'pmcus', 'phccs', 'mchcs', 'total', 'id'],
            'DmfLosOue': ['type_of_losses', 'base_hospital', 'divisional_hospital', 'rural_hospital', 'central_dispensary',
                          'pmcus', 'phccs', 'mchcs', 'total', 'id']
        },
        'Table_7': {
            'DapNapTmf': ['type_med_fac', 'num_affected_fac', 'male', 'female', 'id'],
            'DapBefOther': ['pvt_clinics', 'est_replacement_cost', 'est_repair_cost', 'total_damages', 'est_losses_y1',
                            'est_losses_y2', 'total_losses', 'id'],
            'DapBefPc': ['pvt_clinics', 'est_replacement_cost', 'est_repair_cost', 'total_damages', 'est_losses_y1',
                         'est_losses_y2', 'total_losses', 'private_clinic', 'id'],
        },
        'Table_8': {
            'DmhLmhMohDistrict': ['teaching_hospital', 'provincial_general_hospital', 'district_general_hospital',
                                  'office', 'other'],
            'DmhPafDistrict': ['num_patients_affected', 'teaching_hospital', 'provincial_general_hospital',
                               'district_general_hospital', 'office', 'other'],
            'DmhDamagesDistrict': ['teaching_hospital', 'provincial_general_hospital',
                                   'district_general_hospital'],
            'DmhLosDistrict': ['teaching_hospital', 'provincial_general_hospital',
                               'district_general_hospital', 'type_of_losses', 'office', 'other'],
            'DmhDamagesMohDistrict': ['office', 'other'],
            'DmfTotAffectedDistrict': ['base_hospital', 'divisional_hospital', 'rural_hospital',
                                       'central_dispensary', 'pmcus', 'phccs', 'mchcs'],
            'DmfOmfTpaDistrict': ['num_patients_affected', 'base_hospital', 'divisional_hospital', 'rural_hospital',
                                  'central_dispensary', 'pmcus', 'phccs', 'mchcs'],
            'DmfDamagesDistrict': ['base_hospital', 'divisional_hospital', 'rural_hospital',
                                   'central_dispensary', 'pmcus', 'phccs', 'mchcs'],
            'DmfLosDistrict': ['type_of_losses', 'base_hospital', 'divisional_hospital', 'rural_hospital',
                               'central_dispensary', 'pmcus', 'phccs', 'mchcs'],
            'DapPvtDistrict': ['type_med_fac', 'num_affected_fac', 'male', 'female'],
            'DapBefPcDistrict': ['est_replacement_cost', 'est_losses_y1', 'est_losses_y2', 'total_damages'],
            'DapBefOtherDistrict': ['est_replacement_cost', 'est_losses_y1', 'est_losses_y2', 'total_damages'],
            'DapNapTmf': ['type_med_fac', 'num_affected_fac', 'male', 'female'],
            'DapBefPcTotDmgDistrict': ['tot_dmg'],
        },
        'Table_10': {
            'DmhLmhMohNational': ['teaching_hospital', 'provincial_general_hospital', 'district_general_hospital',
                'office', 'other'],
            'DmhPafNational': ['teaching_hospital', 'provincial_general_hospital', 'district_general_hospital',
                'office', 'other'],
            'DmhDamagesNational': ['teaching_hospital', 'provincial_general_hospital', 'district_general_hospital'],
            'DmhLosNational': ['teaching_hospital', 'provincial_general_hospital', 'district_general_hospital', 'office',
                'other', 'type_of_losses'],
            'DmhDamagesMohNational': ['office', 'other'],
            'DmfTotAffectedNational': ['base_hospital', 'divisional_hospital', 'rural_hospital', 'central_dispensary',
                'pmcus', 'phccs', 'mchcs'],
            'DmfOmfTpaNational': ['base_hospital', 'divisional_hospital', 'rural_hospital', 'central_dispensary', 'pmcus',
                'phccs', 'mchcs'],
            'DmfDamagesNational': ['base_hospital', 'divisional_hospital', 'rural_hospital', 'central_dispensary',
                'pmcus', 'phccs', 'mchcs'],
            'DmfLosNational': ['base_hospital', 'divisional_hospital', 'rural_hospital', 'central_dispensary', 'pmcus',
                'phccs', 'mchcs'],
            'DapPvtNational': ['type_med_fac', 'num_affected_fac', 'male', 'female'],
            'DapBefPcNational': ['est_replacement_cost', 'est_losses_y1', 'est_losses_y2'],
            'DapBefOtherNational': ['est_replacement_cost', 'est_losses_y1', 'est_losses_y2', 'total_damages'],
        },
    },
    'mining': {
        'Table_1': {
            'BmaImFn': ['name_min_outputs', 'avg_per_year', 'firm_id', 'id'],
            'BmaImFirmNum': ['male', 'female', 'firm_id', 'id'],
        },
        'Table_2': {
            'BmaAmMin': ['minerals', 'avg_per_year', 'id'],
            'BmaAmMinNum': ['male', 'female', 'id'],
        },
        'Table_3': {
            'DloNumEmps': ['male', 'female', 'firm_id', 'id'],
            'DloDmgStructures': ['assets', 'rep_tot_dassets', 'repair_pdmg_assets', 'tot_damages', 'firm_id', 'id'],
            'DloDmgEquipment': ['assets', 'rep_tot_dassets', 'repair_pdmg_assets', 'tot_damages', 'firm_id', 'id'],
            'DloDmgMachinery': ['assets', 'rep_tot_dassets', 'repair_pdmg_assets', 'tot_damages', 'firm_id', 'id'],
            'DloDmgVehicles': ['assets', 'rep_tot_dassets', 'repair_pdmg_assets', 'tot_damages', 'firm_id', 'id'],
            'DloDmgStocks': ['assets', 'rep_tot_dassets', 'repair_pdmg_assets', 'tot_damages', 'firm_id', 'id'],
            'DloLosPlos': ['type_los', 'avg_per_year', 'red_voutput_year1', 'red_voutput_year2', 'los_year1',
                           'los_year2', 'tot_losses', 'firm_id', 'id'],
            'DloLosOlos': ['type_los', 'los_year1', 'los_year2', 'tot_losses', 'firm_id', 'id']
        },
        'Table_4': {
            'DlaDmgStructures': ['assets', 'rep_tot_dassets', 'repair_pdmg_assets', 'tot_damages', 'id'],
            'DlaDmgEquipment': ['assets', 'rep_tot_dassets', 'repair_pdmg_assets', 'tot_damages', 'id'],
            'DlaDmgMachinery': ['assets', 'rep_tot_dassets', 'repair_pdmg_assets', 'tot_damages', 'id'],
            'DlaDmgStocks': ['assets', 'rep_tot_dassets', 'repair_pdmg_assets', 'tot_damages', 'id'],
            'DlaLosPlos': ['type_los', 'avg_per_year', 'red_voutput_year1', 'red_voutput_year2', 'los_year1',
                           'los_year2', 'tot_losses', 'id'],
            'DlaLosOlos': ['type_los', 'avg_per_year', 'red_voutput_year1', 'red_voutput_year2', 'los_year1',
                           'los_year2', 'tot_losses', 'id']
        },
        'Table_5': {
            'DloDmgDistrict': ['rep_tot_dassets', 'repair_pdmg_assets', 'tot_damages', 'firm__name', 'ownership'],
            'DlaDmgDistrict': ['rep_tot_dassets', 'repair_pdmg_assets', 'tot_damages'],
            'DlaLosDistrict': ['los_year1', 'los_year2', 'tot_losses'],
            'DloLosDistrict': ['los_year1', 'los_year2', 'tot_losses', 'firm__name', 'ownership'],
        },
        'Table_6': {
            'DlaDmgNational': ['tot_damages'],
            'DlaLosNational': ['los_year1', 'los_year2', 'tot_losses'],
            'DloDmgNational': ['tot_damages', 'ownership'],
            'DloLosNational': ['los_year1', 'los_year2', 'tot_losses', 'ownership'],
        },
        'Table_7': {
            'DlaDmgProvince': ['rep_tot_dassets', 'repair_pdmg_assets', 'tot_damages'],
            'DlaLosProvince': ['los_year1', 'los_year2', 'tot_losses'],
            'DloDmgProvince': [
                'rep_tot_dassets',
                'repair_pdmg_assets',
                'tot_damages',
                'ownership'
            ],
            'DloLosProvince': [
                'los_year1',
                'los_year2',
                'tot_losses',
                'ownership'
            ],
        }
    },
    'other_govn_services': {
        'Table_1': {
            'BcsMachinery': [
                'asset',
                'avg_rep_cost',
                'avg_repair_cost',
                'id'
            ],
            'BcsOfficeEquipment': [
                'asset',
                'avg_rep_cost',
                'avg_repair_cost',
                'id'
            ],
            'BcsStructure': [
                'asset',
                'avg_rep_cost',
                'avg_repair_cost_roof',
                'avg_repair_cost_wall',
                'avg_repair_cost_flooring',
                'id'
            ],
        },
        'Table_2': {
            'DlagdDmgStructure': [
                'name_dept',
                'td_num_structures',
                'td_total_squarem',
                'pd_num_structures',
                'pd_total_squarem_roof',
                'pd_total_squarem_wall',
                'pd_total_squarem_floor',
                'damages',
                'id'
            ],
            'DlagdDmgOfficeEquipment': [
                'name_dept',
                'num_tot_destroyed',
                'num_partial_damaged',
                'damages',
                'id'
            ],
            'DlagdDmgMachinery': [
                'name_dept',
                'num_tot_destroyed',
                'num_partial_damaged',
                'damages',
                'id'
            ],
            'DlagdLosses': [
                'name_dept',
                'los_year1',
                'los_year2',
                'total_losses',
                'id'
            ]
        },
        'Table_3': {
            'DlagdDmgDistrict': ['damages', 'department__name'],
            'DlagdLossesDistrict': ['los_year1', 'los_year2', 'total_losses', 'department__name'],
            # 'DlagdLossesDistrictn': [
            #     'los_year1',
            #     'los_year2',
            #     'total_losses',
            #     'ownership',
            #     'department__name'
            # ],
        },
        'Table_4': {
            'DlagdDmgProvince': [
                'damages', 'ownership', 'name'
            ],
            'DlagdLossesProvince': [
                'los_year1',
                'los_year2',
                'total_losses',
            ]
        },
        'Table_5': {
            'DlagdDmgNational': [
                'damages', 'name', 'ownership'
            ],
            'DlagdLossesNational': [
                'los_year1', 'los_year2', 'total_losses', 'name', 'ownership'
            ]
        },
    },
    'education': {
        'Table_1': {
            'BefPubSchools': ['type_facilities', 'total_number', 'avg_male', 'avg_female', 'id'],
            'BefPubOffices': ['type_facilities', 'total_number', 'id'],
            'BefPvt': ['type_facilities', 'total_number', 'avg_male', 'avg_female', 'id'],
        },
        'Table_2': {
            'BugArcStructures': [
                'particulars', 'ab1_1c', 'type_2', 'type_3', 'pirivena', 'training_institutes', 'training_colleges',
                'tc_crc_resc', 'min_pzd_offices', 'id'],
            'BugArcSupplies': [
                'particulars',
                'ab1_1c',
                'type_2',
                'type_3',
                'pirivena',
                'training_institutes',
                'training_colleges',
                'tc_crc_resc',
                'min_pzd_offices',
                'id'],
            'BugArcEquipment': [
                'particulars',
                'ab1_1c',
                'type_2',
                'type_3',
                'pirivena',
                'training_institutes',
                'training_colleges',
                'tc_crc_resc',
                'min_pzd_offices',
                'id'],
            'BugArpcStructures': [
                'particulars',
                'ab1_1c',
                'type_2',
                'type_3',
                'pirivena',
                'training_institutes',
                'training_colleges',
                'tc_crc_resc',
                'min_pzd_offices',
                'id'],
            'BugArpcSupplies': [
                'particulars',
                'ab1_1c',
                'type_2',
                'type_3',
                'pirivena',
                'training_institutes',
                'training_colleges',
                'tc_crc_resc',
                'min_pzd_offices',
                'id'],
            'BugArpcEquipment': [
                'particulars',
                'ab1_1c',
                'type_2',
                'type_3',
                'pirivena',
                'training_institutes',
                'training_colleges',
                'tc_crc_resc',
                'min_pzd_offices',
                'id'],
            'BugAfr': [
                'particulars',
                'ab1_1c',
                'type_2',
                'type_3',
                'pirivena',
                'training_institutes',
                'training_colleges',
                'tc_crc_resc',
                'min_pzd_offices',
                'id'],
            'BugCrp': [
                'particulars',
                'ab1_1c',
                'type_2',
                'type_3',
                'pirivena',
                'training_institutes',
                'training_colleges',
                'tc_crc_resc',
                'min_pzd_offices',
                'id']
        },
        'Table_3': {
            'DugDfNdf': [
                'particulars', 'ab1_1c', 'type_2', 'type_3', 'pirivena', 'training_institutes', 'training_colleges',
                'tc_crc_resc', 'min_pzd_offices', 'total', 'id'],
            'DugDfNsa': [
                'particulars', 'ab1_1c', 'type_2', 'type_3', 'pirivena', 'training_institutes', 'training_colleges',
                'tc_crc_resc', 'min_pzd_offices', 'total', 'id'],
            'DugNdafStructure': [
                'particulars', 'ab1_1c', 'type_2', 'type_3', 'pirivena', 'training_institutes', 'training_colleges',
                'tc_crc_resc', 'min_pzd_offices', 'total', 'id'],
            'DugNdafSupplies': [
                'particulars', 'ab1_1c', 'type_2', 'type_3', 'pirivena', 'training_institutes', 'training_colleges',
                'tc_crc_resc', 'min_pzd_offices', 'total', 'id'],
            'DugNdafEquipment': [
                'particulars', 'ab1_1c', 'type_2', 'type_3', 'pirivena', 'training_institutes', 'training_colleges',
                'tc_crc_resc', 'min_pzd_offices', 'total', 'id'],
            'DugPdfaNpdf': [
                'particulars', 'ab1_1c', 'type_2', 'type_3', 'pirivena', 'training_institutes', 'training_colleges',
                'tc_crc_resc', 'min_pzd_offices', 'total', 'id'],
            'DugPdfaNsa': [
                'particulars', 'ab1_1c', 'type_2', 'type_3', 'pirivena', 'training_institutes', 'training_colleges',
                'tc_crc_resc', 'total', 'id'],
            'DugNpdatStructure': [
                'particulars', 'ab1_1c', 'type_2', 'type_3', 'pirivena', 'training_institutes', 'training_colleges',
                'tc_crc_resc', 'min_pzd_offices', 'total', 'id'],
            'DugNpdatSupplies': [
                'particulars', 'ab1_1c', 'type_2', 'type_3', 'pirivena', 'training_institutes', 'training_colleges',
                'tc_crc_resc', 'min_pzd_offices', 'total', 'id'],
            'DugNpdatEquipment': [
                'particulars', 'ab1_1c', 'type_2', 'type_3', 'pirivena', 'training_institutes', 'training_colleges',
                'tc_crc_resc', 'min_pzd_offices', 'total', 'id'],
            'DugLosFi': [
                'particulars', 'ab1_1c', 'type_2', 'type_3', 'pirivena', 'training_institutes', 'training_colleges',
                'tc_crc_resc', 'min_pzd_offices', 'total', 'id'],
            'DugLosCud': [
                'particulars', 'ab1_1c', 'type_2', 'type_3', 'pirivena', 'training_institutes', 'training_colleges',
                'tc_crc_resc', 'min_pzd_offices', 'total', 'id'],
            'DugLosHoc': [
                'particulars', 'ab1_1c', 'type_2', 'type_3', 'pirivena', 'training_institutes', 'training_colleges',
                'tc_crc_resc', 'min_pzd_offices', 'total', 'id'],
            'DugLosOue': [
                'particulars', 'ab1_1c', 'type_2', 'type_3', 'pirivena', 'training_institutes', 'training_colleges',
                'tc_crc_resc', 'min_pzd_offices', 'total', 'id'],
        },
        'Table_4': {
            'DpefNaf': ['edu_facilities', 'num_edu_facilities', 'male', 'female', 'id'],
            'DpefBefPreSchool': ['asset', 'pre_school', 'est_rep_cost', 'est_repair_cost', 'tot_damages',
                                 'est_los_year_1', 'est_los_year_2', 'tot_los', 'id'],
            'DpefBefPrmSchool': ['asset', 'primary_school', 'est_rep_cost', 'est_repair_cost', 'tot_damages',
                                 'est_los_year_1', 'est_los_year_2', 'tot_los', 'id'],
            'DpefBefSecSchool': ['asset', 'secondary_school', 'est_rep_cost', 'est_repair_cost', 'tot_damages',
                                 'est_los_year_1', 'est_los_year_2', 'tot_los', 'id'],
            'DpefBefUnv': ['asset', 'university', 'est_rep_cost', 'est_repair_cost', 'tot_damages', 'est_los_year_1',
                           'est_los_year_2', 'tot_los', 'id'],
            'DpefBefTechInst': ['asset', 'tech_institute', 'est_rep_cost', 'est_repair_cost', 'tot_damages',
                                'est_los_year_1', 'est_los_year_2', 'tot_los', 'id'],
            'DpefBefOtherSchool': ['asset', 'other_school', 'est_rep_cost', 'est_repair_cost', 'tot_damages',
                                   'est_los_year_1', 'est_los_year_2', 'tot_los', 'id']
        },
        'Table_5': {
            'DpefBefDistrict': [
                'ab1_1c',
                'type_2',
                'type_3',
                'pirivena',
                'training_institutes',
                'training_colleges',
                'tc_crc_resc',
                'min_pzd_offices',
            ],
            'DpefBefPreDistrict': [
                'est_rep_cost',
                'est_repair_cost',
                'tot_damages',
                'est_los_year_1',
                'est_los_year_2',
                'tot_los',
            ],
            'DpefBefPrimaryDistrict': [
                'est_rep_cost',
                'est_repair_cost',
                'tot_damages',
                'est_los_year_1',
                'est_los_year_2',
                'tot_los',

            ],
            'DpefBefSecondaryDistrict': [
                'est_rep_cost',
                'est_repair_cost',
                'tot_damages',
                'est_los_year_1',
                'est_los_year_2',
                'tot_los',
            ],
            'DpefBefTechDistrict': [
                'est_rep_cost',
                'est_repair_cost',
                'tot_damages',
                'est_los_year_1',
                'est_los_year_2',
                'tot_los',
            ],
            'DpefBefUnvDistrict': [
                'est_rep_cost',
                'est_repair_cost',
                'tot_damages',
                'est_los_year_1',
                'est_los_year_2',
                'tot_los',

            ],
            'DpefBefOtherDistrict': [
                'est_rep_cost',
                'est_repair_cost',
                'tot_damages',
                'est_los_year_1',
                'est_los_year_2',
                'tot_los',
                'district',
                'incident'
            ],
            'DugDfDistrict': [
                'ab1_1c',
                'type_2',
                'type_3',
                'pirivena',
                'training_institutes',
                'training_colleges',
                'tc_crc_resc',
                'min_pzd_offices',
            ],
            'DugNsaDistrict': [
                'ab1_1c',
                'type_2',
                'type_3',
                'pirivena',
                'training_institutes',
                'training_colleges',
                'tc_crc_resc',
            ],
            'DpefNaf': [
                'edu_facilities',
                'num_edu_facilities',
                'male',
                'female',
                'id',
            ],
            'DugNdafDistrict': [
                'ab1_1c',
                'type_2',
                'type_3',
                'pirivena',
                'training_institutes',
                'training_colleges',
                'tc_crc_resc',
                'min_pzd_offices',
            ],
        },
        'Table_6': {
            'DugDfDistrict': [
                'ab1_1c',
                'type_2',
                'type_3',
                'pirivena',
                'training_institutes',
                'training_colleges',
                'tc_crc_resc',
                'min_pzd_offices',
            ],
            'DugNsaDistrict': [
                'ab1_1c',
                'type_2',
                'type_3',
                'pirivena',
                'training_institutes',
                'training_colleges',
                'tc_crc_resc',
            ],
            'DugNdafDistrict': [
                'ab1_1c',
                'type_2',
                'type_3',
                'pirivena',
                'training_institutes',
                'training_colleges',
                'tc_crc_resc',
                'min_pzd_offices',
            ],
            'DpefBefDistrict': [
                'ab1_1c',
                'type_2',
                'type_3',
                'pirivena',
                'training_institutes',
                'training_colleges',
                'tc_crc_resc',
                'min_pzd_offices',
            ],

            'DpefNaf': [
                'edu_facilities',
                'num_edu_facilities',
                'male',
                'female',
                'id',
            ],
            'DpefBefPreDistrict': [
                'est_rep_cost',
                'est_repair_cost',
                'tot_damages',
                'est_los_year_1',
                'est_los_year_2',
                'tot_los',
            ],
            'DpefBefPrimaryDistrict': [
                'est_rep_cost',
                'est_repair_cost',
                'tot_damages',
                'est_los_year_1',
                'est_los_year_2',
                'tot_los',
            ],
            'DpefBefSecondaryDistrict': [
                'est_rep_cost',
                'est_repair_cost',
                'tot_damages',
                'est_los_year_1',
                'est_los_year_2',
                'tot_los',
            ],
            'DpefBefTechDistrict': [
                'est_rep_cost',
                'est_repair_cost',
                'tot_damages',
                'est_los_year_1',
                'est_los_year_2',
                'tot_los',
            ],
            'DpefBefUnvDistrict': [
                'est_rep_cost',
                'est_repair_cost',
                'tot_damages',
                'est_los_year_1',
                'est_los_year_2',
                'tot_los',
            ],
            'DpefBefOtherDistrict': [
                'est_rep_cost',
                'est_repair_cost',
                'tot_damages',
                'est_los_year_1',
                'est_los_year_2',
                'tot_los',
                'district',
                'incident'
            ],

            'DpefNafDistrict': ['edu_facilities', 'num_edu_facilities', 'male', 'female', 'district', 'incident']
        },
        'Table_7': {
            'DpefBefOtherNational': [
                'est_rep_cost',
                'est_repair_cost',
                'tot_damages',
                'est_los_year_1',
                'est_los_year_2',
                'tot_los',
            ],
            'DpefBefPreNational': [
                'est_rep_cost',
                'est_repair_cost',
                'tot_damages',
                'est_los_year_1',
                'est_los_year_2',
                'tot_los',
            ],
            'DpefBefPrimaryNational': [
                'est_rep_cost',
                'est_repair_cost',
                'tot_damages',
                'est_los_year_1',
                'est_los_year_2',
                'tot_los',
            ],
            'DpefBefSecondaryNational': [
                'est_rep_cost',
                'est_repair_cost',
                'tot_damages',
                'est_los_year_1',
                'est_los_year_2',
                'tot_los',
            ],
            'DpefBefTechNational': [
                'est_rep_cost',
                'est_repair_cost',
                'tot_damages',
                'est_los_year_1',
                'est_los_year_2',
                'tot_los',
            ],
            'DpefBefUnvNational': [
                'est_rep_cost',
                'est_repair_cost',
                'tot_damages',
                'est_los_year_1',
                'est_los_year_2',
                'tot_los',
            ],
            'DpefNafNational': [
                'edu_facilities',
                'num_edu_facilities',
                'male',
                'female',
            ],
            'DpefBefNational': [
                'ab1_1c',
                'type_2',
                'type_3',
                'pirivena',
                'training_institutes',
                'training_colleges',
                'tc_crc_resc',
                'min_pzd_offices',
            ],
            'DugDfNational': [
                'ab1_1c',
                'type_2',
                'type_3',
                'pirivena',
                'training_institutes',
                'training_colleges',
                'tc_crc_resc',
                'min_pzd_offices',
            ],
            'DugNdafNational': [
                'ab1_1c',
                'type_2',
                'type_3',
                'pirivena',
                'training_institutes',
                'training_colleges',
                'tc_crc_resc',
                'min_pzd_offices',
            ],
            'DugNsaNational': [
                'ab1_1c',
                'type_2',
                'type_3',
                'pirivena',
                'training_institutes',
                'training_colleges',
                'tc_crc_resc',
            ]
        },
    },
    'transport_rail': {
        'Table_1': {
            'BsTotEmpRailCompny': ['total_emp', 'particulars', 'no_of_male', 'no_of_female', 'id'],
            'BsMovingAst': ['asset', 'avg_replace_cost', 'avg_repair_cost', 'id'],
            'BsIncAstRailIncome': ['annual_income', 'id' ],
            'BsEquipMachineryAst': ['asset', 'avg_replace_cost', 'avg_repair_cost', 'id'],
            'BsMatSuppliesAst': ['asset', 'avg_replace_cost', 'avg_repair_cost', 'id'],
            'BsStructuresAst': ['asset', 'avg_replace_cost', 'avg_repair_cost', 'id'],
            'BsBuildingAst': [ 'asset', 'avg_replace_cost', 'avg_repair_cost_roof', 'avg_repair_cost_wall', 'avg_repair_cost_floor', 'id'],
        },
        'Table_2': {
            'DlMovingAstLoss': ['asset', 'no_of_tot_destroyed', 'no_of_partially_damaged', 'id'],
            'DlEquipMachineryAstLoss': ['asset','no_of_tot_destroyed','no_of_partially_damaged','tot_damages','id'],
            'DlMatSuppliesAstLoss': ['asset', 'no_of_tot_destroyed', 'no_of_partially_damaged', 'tot_damages', 'id'],
            'DlStructuresAstLoss': ['asset', 'no_of_tot_destroyed', 'no_of_partially_damaged', 'tot_damages', 'id'],
            'DlBuildingAstLoss': ['asset', 'no_of_tot_destroyed', 'no_of_tot_destroyed_sqr_meters', 'no_of_partially_damaged',
                                  'no_of_partially_damaged_roof', 'no_of_partially_damaged_wall', 'no_of_partially_damaged_floor',
                                  'tot_damages', 'id'],
        },
        'Table_3': {
            'TotDmgProvince':['tot_damages'],
        },
        'Table_4': {
            'TotDmgNational': ['tot_damages'],
            # 'DlTypeLos': ['loss_type', 'year_1', 'year_2', 'tot_los', 'id'],
        },
        'Table_5': {
            'DlTypeLos': ['loss_type', 'year_1', 'year_2', 'tot_los', 'id'],
        }
    },
    'transport_water': {
        'Table_1': {
            'BsAstWaterWcrafts':
                ['assets',
                 'public',
                 'private',
                 'avg_replace_cost',
                 'avg_repair_cost',
                 'id'],
            'BsAstWaterEquipment':
                ['assets',
                 'avg_replace_cost',
                 'avg_repair_cost',
                 'id'],
            'BsAstWaterMaterials':
                ['assets',
                 'avg_replace_cost',
                 'avg_repair_cost',
                 'id'],
            'BsAstWaterStructures':
                ['assets',
                 'avg_replace_cost',
                 'avg_repair_cost',
                 'id'],
            'BsAstWaterBuildings':
                ['assets',
                 'avg_replace_cost',
                 'avg_repair_cost_roof',
                 'avg_repair_cost_wall',
                 'avg_repair_cost_floor',
                 'id'],
            'BsAstWaterEmployment':
                ['assets',
                 'male',
                 'female',
                 'total',
                 'id'],

        },
        'Table_2': {
            'DlWaterDmgStructures':
                ['assets',
                 'num_tdestroyed_num',
                 'num_tdestroyed_meters',
                 'num_pdestroyed_num',
                 'num_pdestroyed_meters',
                 'tot_damages',
                 'id'],
            'DlWaterDmgBuildings':
                ['assets',
                 'tdestroyed_num',
                 'tdestroyed_smeters',
                 'pdamaged_num',
                 'pdamaged_roof',
                 'wall',
                 'floor',
                 'tot_damages',
                 'id'],
            'DlWaterDmgEquipment':
                ['assets',
                 'num_tdestroyed_public',
                 'num_tdestroyed_private',
                 'num_pdestroyed_public',
                 'num_pdestroyed_private',
                 'tot_dmg_private',
                 'tot_dmg_public',
                 'id'],
            'DlWaterDmgMaterials':
                ['assets',
                 'num_tdestroyed_public',
                 'num_tdestroyed_private',
                 'num_pdestroyed_public',
                 'num_pdestroyed_private',
                 'tot_dmg_private',
                 'tot_dmg_public',
                 'id'],
            'DlWaterDmgWcrafts':
                ['assets',
                 'num_tdestroyed_public',
                 'num_tdestroyed_private',
                 'num_pdestroyed_public',
                 'num_pdestroyed_private',
                 'tot_dmg_private',
                 'tot_dmg_public',
                 'id'],
            'DlWaterLosFi':
                ['year_1_pub',
                 'year_1_pvt',
                 'year_2_pub',
                 'year_2_pvt',
                 'tot_los_pub',
                 'tot_los_pvt',
                 'type_los',
                 'id'],
            'DlWaterLosOther':
                ['year_1_pub',
                 'year_1_pvt',
                 'year_2_pub',
                 'year_2_pvt',
                 'tot_los_pub',
                 'tot_los_pvt',
                 'type_los',
                 'id'],

        },
        'Table_3': {
            # Views
            'DlAstWaterWcraftsDistrict': ['tot_dmg_private', 'tot_dmg_public', 'incident', 'district'],
            'DlWaterDmgEquipmentDistrict': ['tot_dmg_private', 'tot_dmg_public', 'incident', 'district'],
            'DlWaterDmgMaterialsDistrict': ['tot_dmg_private', 'tot_dmg_public', 'incident', 'district'],
            'DlWaterDmgStructuresDistrict': ['tot_damages', 'incident', 'district'],
            'DlWaterDmgBuildingsDistrict': ['tot_damages', 'incident', 'district'],
            # Tables
            'DlWaterLosFi': ['year_1_pub', 'year_1_pvt', 'year_2_pub', 'year_2_pvt', 'tot_los_pub', 'tot_los_pvt',
                             'type_los', 'incident', 'district'],
            'DlWaterLosOther': ['year_1_pub', 'year_1_pvt', 'year_2_pub', 'year_2_pvt', 'tot_los_pub', 'tot_los_pvt',
                                'type_los', 'incident', 'district'],
        },
        'Table_4': {
            'DlWaterDmgPubProvince':
                ['tot_dmg_public'],
            'DlWaterDmgPvtProvince':
                ['tot_dmg_private'],
            'DlWaterLosProvince':
                ['year_1_pub',
                 'year_2_pub',
                 'year_1_pvt',
                 'year_2_pvt'],

        },
        'Table_5': {
            'DlWaterDmgPubNational':
                ['tot_dmg_public'],
            'DlWaterDmgPvtNational':
                ['tot_dmg_private'],
            'DlWaterLosNational':
                ['year_1_pub',
                 'year_2_pub',
                 'year_1_pvt',
                 'year_2_pvt'],

        }
    },
    'transport_land': {
        'Table_1': {
            'BsRbuRclassificattion':
                ['road_classification',
                 'avg_replace_concrete',
                 'avg_replace_asphalt',
                 'avg_replace_gravel',
                 'avg_replace_earth',
                 'avg_repair_concrete',
                 'avg_repair_asphalt',
                 'avg_repair_gravel',
                 'avg_repair_earth',
                 'id'],
            'BsRbuTbridges':
                ['type_bridges',
                 'avg_replace_2_lanes',
                 'avg_replace_multi_lanes',
                 'avg_repair_2_lanes',
                 'avg_repair_multi_lanes',
                 'id'],
            'BsRbuTrwalls':
                ['type_retain_walls',
                 'avg_replace_cost',
                 'avg_repair_cost',
                 'id'],
            'BsRbuTculverts':
                ['type_culverts',
                 'avg_replace_cost',
                 'avg_repair_cost',
                 'id'],
            'BsRbuTdrains':
                ['type_drains',
                 'avg_replace_cost',
                 'avg_repair_cost',
                 'id'],

        },
        'Table_2': {
            'BsGtlAstBcompanies':
                ['bus_companies',
                 'public',
                 'private',
                 'avg_replace_cost',
                 'avg_repair_cost',
                 'id'],
            'BsGtlAstPvehicles':
                ['private',
                 'avg_replace_cost',
                 'avg_repair_cost',
                 'private_vehicles',
                 'id'],
            'BsGtlAstTcompanies':
                ['public',
                 'private',
                 'avg_replace_cost',
                 'avg_repair_cost',
                 'taxi_companies',
                 'id'],
            'BsGtlAstTrcompanies':
                ['public',
                 'private',
                 'avg_replace_cost',
                 'avg_repair_cost',
                 'truck_companies',
                 'id'],
            'BsGtlAstTucompanies':
                ['public',
                 'private',
                 'avg_replace_cost',
                 'avg_repair_cost',
                 'tuk_companies',
                 'id'],

        },
        'Table_3': {
            'BiaGacLandStructure':
                ['asset',
                 'avg_repair_cost',
                 'id'],
            'BiaGacLandPbuilding':
                ['asset',
                 'avg_repair_cost_floor_1',
                 'avg_repair_cost_floor_2_3',
                 'avg_repair_cost_floor_more_3',
                 'id'],
            'BiaGacLandOequipment':
                ['asset',
                 'avg_replace_cost',
                 'avg_repair_cost',
                 'id'],

            'BiaGacLandMachinery':
                ['asset',
                 'avg_replace_cost',
                 'avg_repair_cost',
                 'id'],
        },
        'Table_4': {
            'DlRbdTbridges':
                ['tot_dest_2_lanes',
                 'tot_dest_multi_lanes',
                 'part_dest_2_lanes',
                 'part_dest_multi_lanes',
                 'part_dest_gravel',
                 'part_dest_earth',
                 'damages',
                 'type_bridges',
                 'id'],
            'DlRbdTculverts':
                ['tot_destroyed',
                 'part_destroyed',
                 'damages',
                 'type_culverts',
                 'id'],
            'DlRbdTrwalls':
                ['tot_destroyed',
                 'part_destroyed',
                 'damages',
                 'type_retain_walls',
                 'id'],
            'DlRbdTdrains':
                ['tot_destroyed',
                 'part_destroyed',
                 'damages',
                 'type_drains',
                 'id'],
            # 'DlOtherDmgsPvehicles':
            #     ['num_tot_dest_pvt',
            #      'num_part_dest_pvt',
            #      'tot_damages_pvt',
            #      'private_vehicles',
            #      'id'],
            'DlRbdRclassification':
                ['tot_dest_concrete',
                 'tot_dest_asphalt',
                 'tot_dest_gravel',
                 'tot_dest_earth',
                 'part_dest_concrete',
                 'part_dest_asphalt',
                 'part_dest_gravel',
                 'part_dest_earth',
                 'damages',
                 'road_classification',
                 'id'],
            'DlRbdLosses':
                ['year_1',
                 'year_2',
                 'part_destroyed',
                 'losses',
                 'loss_type',
                 'id'],

        },
        'Table_5': {
            'DlOtherDmgsPvehicles':
                ['num_tot_dest_pvt',
                 'num_part_dest_pvt',
                 'tot_damages_pvt',
                 'private_vehicles',
                 'id'],
            'DlOtherDmgsBcompanies':
                ['num_tot_dest_pub',
                 'num_tot_dest_pvt',
                 'num_part_dest_pub',
                 'num_part_dest_pvt',
                 'tot_damages_pub',
                 'tot_damages_pvt',
                 'bus_companies',
                 'id'],
            'DlOtherDmgsTcompanies':
                ['num_tot_dest_pub',
                 'num_tot_dest_pvt',
                 'num_part_dest_pub',
                 'num_part_dest_pvt',
                 'tot_damages_pub',
                 'tot_damages_pvt',
                 'taxi_companies',
                 'id'],
            'DlOtherDmgsTrcompanies':
                ['num_tot_dest_pub',
                 'num_tot_dest_pvt',
                 'num_part_dest_pub',
                 'num_part_dest_pvt',
                 'tot_damages_pub',
                 'tot_damages_pvt',
                 'truck_companies',
                 'id'],
            'DlOtherDmgsTucompanies':
                ['num_tot_dest_pub',
                 'num_tot_dest_pvt',
                 'num_part_dest_pub',
                 'num_part_dest_pvt',
                 'tot_damages_pub',
                 'tot_damages_pvt',
                 'tuk_companies',
                 'id'],
            'DlOtherLosPub':
                ['fi_year_1',
                 'fi_year_2',
                 'cl_debris_year_1',
                 'cl_debris_year_2',
                 'hoc_year_1',
                 'hoc_year_2',
                 'oue_year_1',
                 'oue_year_2',
                 'tot_los',
                 'tr_company',
                 'id'],
            'DlOtherLosPvt':
                ['fi_year_1',
                 'fi_year_2',
                 'cl_debris_year_1',
                 'cl_debris_year_2',
                 'hoc_year_1',
                 'hoc_year_2',
                 'oue_year_1',
                 'oue_year_2',
                 'tot_los',
                 'tr_company',
                 'id'],

        },
        'Table_6': {
            'DlGacDmgStructures':
                ['assets',
                 'num_tot_destroyed',
                 'num_square_meters',
                 'damages',
                 'id'],
            'DlGacLosType':
                ['assets',
                 'los_year_1',
                 'los_year_2',
                 'total',
                 'id'],
            'DlGacPdmgEquipment':
                ['assets',
                 'num_tot_destroyed',
                 'num_part_damaged',
                 'damages',
                 'id'],
            'DlGacPdmgMachinery':
                ['assets',
                 'num_tot_destroyed',
                 'num_part_damaged',
                 'damages',
                 'id'],
            'DlGacPdmgStructures':
                ['assets',
                 'num_part_damaged',
                 'damaged_roof',
                 'damaged_walls',
                 'damaged_floors',
                 'damages',
                 'id'],

        },
        'Table_7': {
            'DlRbdRclassificationDistrict':
                ['damages', 'incident', 'district'],
            'DlRbdTbridgesDistrict':
                ['damages', 'incident', 'district'],
            'DlRbdTculvertsDistrict':
                ['damages', 'incident', 'district'],
            'DlRbdTdrainsDistrict':
                ['damages', 'incident', 'district'],
            'DlRbdTrwallsDistrict':
                ['damages', 'incident', 'district'],
            'DlOtherDmgsPvehiclesDistrict':
                ['tot_damages_pvt', 'incident', 'district'],
            'DlOtherDmgsBcompaniesDistrict':
                ['tot_damages_pub', 'tot_damages_pvt', 'incident', 'district'],
            'DlOtherDmgsTcompaniesDistrict':
                ['tot_damages_pub', 'tot_damages_pvt', 'incident', 'district'],
            'DlOtherDmgsTrcompaniesDistrict':
                ['tot_damages_pub', 'tot_damages_pvt', 'incident', 'district'],
            'DlOtherDmgsTucompaniesDistrict':
                ['tot_damages_pub', 'tot_damages_pvt', 'incident', 'district'],
            'DlGacPubDistrict':
                ['damages', 'incident', 'district'],
            'DlRbdLossesDistrict':
                ['year_1', 'year_2', 'incident', 'district'],
            'DlOtherLosPubDistrict':
                ['year_1_pub', 'year_2_pub', 'incident', 'district'],
            'DlOtherLosPvtDistrict':
                ['year_2_pub', 'year_1_pvt', 'incident', 'district'],
            'DlGacLosTypeDistrict':
                ['los_year_1', 'los_year_2', 'incident', 'district'],
        },
        'Table_8': {
            'DlGacPubProvince':
                ['damages'],
            'DlGacPvtProvince':
                ['tot_damages_pvt'],
            'DlYearsPubProvince':
                ['year_1',
                 'year_2',
                 ],
            'DlOtherLosPvtDistrict':
                ['year_1_pvt',
                 'year_2_pub',
                 ],

        },
        'Table_9': {
            'DlGacPubNational':
                ['damages'],
            'DlGacPvtNational':
                ['tot_damages_pvt'],
            'DlOtherLosPvtNational':
                ['year_1_pvt',
                 'year_2_pub',
                 ],
            'DlYearsPubNational':
                ['year_1',
                 'year_2',
                 ],
        },
    },
    'transport_air': {
        'Table_1': {
            'BsAstAirAircrafts':
                ['assets',
                 'num_pub',
                 'num_pvt',
                 'avg_replace_cost',
                 'avg_repair_cost',
                 'id'],
            'BsAstAirEquipment':
                ['assets',
                 'avg_replace_cost',
                 'avg_repair_cost',
                 'id'],
            'BsAstAirSupplies':
                ['assets',
                 'avg_replace_cost',
                 'avg_repair_cost',
                 'id'],
            'BsAstAirOthers':
                ['assets',
                 'avg_replace_cost',
                 'avg_repair_cost',
                 'id'],
            'BsAstAirStructures':
                ['assets',
                 'repc_1_floor',
                 'repc_2_3_floor',
                 'repc_moret_3_floor',
                 'repairc_roof',
                 'repairc_wall',
                 'repairc_floor',
                 'id'],

            'BsAstAirEmployment':
                ['assets',
                 'male',
                 'female',
                 'total',
                 'id'],
        },
        'Table_2': {
            'DlAirDmgAircrafts': ['tot_destroyed_pub', 'tot_destroyed_pvt', 'tot_dmg_pub', 'tot_dmg_pvt',
                                  'part_damaged_pub', 'part_damaged_pvt', 'assets', 'id'],
            'DlAirDmgEquipment': ['tot_destroyed', 'part_damaged', 'tot_dmg_pub', 'assets', 'id'],

            'DlAirDmgSupplies': ['tot_destroyed_pub', 'tot_destroyed_pvt', 'tot_dmg_pub', 'tot_dmg_pvt',
                                 'part_damaged_pub', 'part_damaged_pvt', 'assets', 'id'],
            'DlAirDmgOthers': ['tot_destroyed', 'part_damaged', 'tot_dmg_pub', 'assets', 'id'],

            'DlAirDmgGstructures': ['tdest_floor_1', 'tdest_floor_2_3', 'tdest_floor_than_3', 'pdmg_number',
                                    'pdmg_roof', 'pdmg_wall', 'pdmg_floor', 'tot_pub', 'assets', 'id'],
            'DlAirLosFi': ['year_1_pub', 'year_1_pvt', 'year_2_pub', 'year_2_pvt', 'tot_los_pub', 'tot_los_pvt',
                           'type_los', 'id'],

            'DlAirLosHoc': ['year_1_pub', 'year_1_pvt', 'year_2_pub', 'year_2_pvt', 'tot_los_pub', 'tot_los_pvt',
                            'type_los', 'id'],

            'DlAirLosOther': ['year_1_pub', 'year_1_pvt', 'year_2_pub', 'year_2_pvt', 'tot_los_pub', 'tot_los_pvt',
                              'assets', 'id']
        },
        'Table_3': {
            'DlAirDmgAircraftsDistrict':
                ['tot_destroyed_pub', 'tot_destroyed_pvt', 'incident', 'district'],
            'DlAirDmgGstructuresDistrict':
                ['tot_pub', 'incident', 'district'],
            'DlAirDmgEquipmentDistrict':
                ['tot_dmg_pub', 'incident', 'district'],
            'DlAirDmgSuppliesDistrict':
                ['tot_dmg_pub', 'tot_dmg_pvt', 'incident', 'district'],
            'DlAirDmgOthersDistrict':
                ['tot_dmg_pub', 'incident', 'district'],
            'DlAirLosFiDistrict':
                ['year_1_pub', 'year_1_pvt', 'year_2_pub', 'year_2_pvt', 'tot_los_pub', 'tot_los_pvt', 'incident',
                 'district'],
            'DlAirLosHocDistrict':
                ['year_1_pub', 'year_1_pvt', 'year_2_pub', 'year_2_pvt', 'tot_los_pub', 'tot_los_pvt', 'incident',
                 'district'],
            'DlAirLosOther': ['year_1_pub', 'year_1_pvt', 'year_2_pub', 'year_2_pvt', 'tot_los_pub', 'tot_los_pvt',
                              'assets']
        },
        'Table_4': {
            'DlAirDmgPubProvince':
                ['tot_destroyed_pub'],
            'DlAirDmgPvtProvince':
                ['tot_destroyed_pvt'],
            'DlAirLosProvince':
                ['year_1_pub', 'year_1_pvt', 'year_2_pub', 'year_2_pvt'],
        },
        'Table_5': {
            'DlAirDmgPubNational':
                ['tot_destroyed_pub'],
            'DlAirDmgPvtNational':
                ['tot_destroyed_pvt'],
            'DlAirLosNational':
                ['year_1_pub', 'year_1_pvt', 'year_2_pub', 'year_2_pvt'],
        }
    },
    'agri_irrigation': {
        'Table_1': {
            'BsIfMajor':
                ['irrigation_facility',
                 'capacity',
                 'irrigated_area_paddy',
                 'irrigated_area_ofc',
                 'income_paddy',
                 'income_ofc',
                 'num_farmer_families',
                 'division',
                 'region', 'id'],

            'BsIfMedium':
                ['irrigation_facility',
                 'capacity',
                 'irrigated_area_paddy',
                 'irrigated_area_ofc',
                 'income_paddy',
                 'income_ofc',
                 'num_farmer_families', 'division',
                 'region', 'id'],
            'BsIfAnicuts':
                ['irrigation_facility',
                 'capacity',
                 'irrigated_area_paddy',
                 'irrigated_area_ofc',
                 'income_paddy',
                 'income_ofc',
                 'division',
                 'region',
                 'num_farmer_families', 'id'],
            'BsIfMinor':
                ['irrigation_facility',
                 'capacity',
                 'irrigated_area_paddy',
                 'irrigated_area_ofc',
                 'income_paddy',
                 'income_ofc',
                 'num_farmer_families',
                 'division',
                 'region', 'id']

        },
        'Table_2': {
            'BsRciaMajorTanks':
                ['irrigation_facility',
                 'avg_repair_cost',
                 'avg_replacement_cost',
                 'division',
                 'region',
                 'id'],
            'BsRciaMediumTanks':
                ['irrigation_facility',
                 'avg_repair_cost',
                 'avg_replacement_cost',
                 'id'],
            'BsRciaMinorTanks':
                ['irrigation_facility',
                 'avg_repair_cost',
                 'avg_replacement_cost',
                 'id'],
            'BsRciaAnicuts':
                ['irrigation_facility',
                 'avg_repair_cost',
                 'avg_replacement_cost',
                 'id'],
            'BsRciaOtherStructures':
                ['irrigation_facility',
                 'avg_repair_cost',
                 'avg_replacement_cost',
                 'id'],
            'BsRciRiverEmbankmnt':
                ['irrigation_facility',
                 'avg_repair_cost',
                 'avg_replacement_cost',
                 'id'],
            'BsRciBuildings':
                ['irrigation_facility',
                 'avg_repair_roof',
                 'avg_repair_wall',
                 'avg_repair_floor',
                 'avg_replacement_cost',
                 'id'],

        },
        'Table_3': {
            'DlMajorTanks':
                ['irrigation_assets',
                 'partially_damaged',
                 'totally_destroyed',
                 'damages',
                 'division',
                 'region',
                 'id'],
            'DlMediumTanks':
                ['irrigation_assets',
                 'partially_damaged',
                 'totally_destroyed',
                 'damages',
                 'id'],
            'DlMinorTanks':
                ['irrigation_assets',
                 'partially_damaged',
                 'totally_destroyed',
                 'damages',
                 'id'],
            'DlAnicuts':
                ['irrigation_assets',
                 'partially_damaged',
                 'totally_destroyed',
                 'damages',
                 'id'],
            'DlOtherStructures':
                ['irrigation_assets',
                 'partially_damaged',
                 'totally_destroyed',
                 'damages',
                 'id'],
            'DlRiverEmbankmnt':
                ['irrigation_assets',
                 'partially_damaged',
                 'totally_destroyed',
                 'damages',
                 'id'],
            'DlBuildings':
                ['building',
                 'part_damaged_num',
                 'part_damaged_roof',
                 'part_damaged_wall',
                 'part_damaged_floor',
                 'tot_destroyed_num',
                 'tot_destroyed_area',
                 'damages',
                 'id'],
            'DlLosMajorTanks':
                ['irrigation_assets',
                 'high_operation_cost',
                 'other_unexpected_expenses',
                 'total_los',
                 'id'],
            'DlLosMediumTanks':
                ['irrigation_assets',
                 'high_operation_cost',
                 'other_unexpected_expenses',
                 'total_los',
                 'id'],
            'DlLosMinorTanks':
                ['irrigation_assets',
                 'high_operation_cost',
                 'other_unexpected_expenses',
                 'total_los',
                 'id'],
            'DlLosAnicuts':
                ['irrigation_assets',
                 'high_operation_cost',
                 'other_unexpected_expenses',
                 'total_los',
                 'id'],
            'DlLosOther':
                ['irrigation_assets',
                 'high_operation_cost',
                 'other_unexpected_expenses',
                 'total_los',
                 'id'],

        },
        'Table_4': {
            'DlMajorTanksDistrict':
                ['damages', ],
            'DlLosMajorTanksDistrict':
                ['total_los', ],
            'DlMediumTanksDistrict':
                ['damages', ],
            'DlLosMediumTanksDistrict':
                ['total_los', ],
            'DlMinorTanksDistrict':
                ['damages'],
            'DlLosMinorTanksDistrict':
                ['total_los'],
            'DlIrrigatnLosDistrictNew':
             ['total_los'],
            'DlAnicutsDistrict':
                ['damages'],
            'DlIrrigatnDmgDistrict':
                ['damages'],
            'DlLosAnicutsDistrict':
                ['total_los'],
            'DlOtherStructuresDistrict':
                ['damages', ],
            'DlLosOtherDistrict':
                ['total_los', 'irrigation_assets'],
            'DlRiverEmbankmntDistrict':
                ['damages'],
            # dl_los_other_district
            'DlBuildingsDistrict':
                ['damages'],
            # dl_los_other_district
        },
        'Table_5': {
            'DlMediumTanksDistrict':
                ['damages'],
            'DlLosMediumTanksDistrict':
                ['total_los'],
            'DlMajorTanksDistrict':
                ['damages'],
            'DlLosMajorTanksDistrict':
                ['total_los'],
            'DlMinorTanksDistrict':
                ['damages'],
            'DlLosMinorTanksDistrict':
                ['total_los'],
            'DlAnicutsDistrict':
                ['damages'],
            'DlLosAnicutsDistrict':
                ['total_los'],
            'DlOtherStructuresDistrict':
                ['damages'],
            'DlLosOtherDistrict':
                ['total_los'],
            'DlRiverEmbankmntDistrict':
                ['damages'],
            'DlBuildingsDistrict':
                ['damages'],

        },
        'Table_6': {
            'DlIrrigatnDmgNational':
                ['damages'],
            'DlLosMediumTanksNational':
                ['total_los'],
            'DlMediumTanksNational':
                ['damages'],
            'DlMajorTanksNational':
                ['damages'],
            'DlLosMajorTanksNational':
                ['total_los'],
            'DlMinorTanksNational':
                ['damages'],
            'DlLosMinorTanksNational':
                ['total_los'],
            'DlAnicutsNational':
                ['damages'],
            'DlLosAnicutsNational':
                ['total_los'],
            'DlOtherStructuresNational':
                ['damages'],
            'DlLosOtherNational':
                ['total_los'],
            'DlRiverEmbankmntNational':
                ['damages'],
            'DlLosRiverEmbankmntNational':
                ['total_los'],
            'DlBuildingsNational':
                ['damages'],
            'DlLosBuildingsNational':
                ['total_los'],
            'DlLosPubNational':
                ['total_los'],
        },
    },
    'agri_agrarian': {
        'Table_1': {
            'BcagSeasonalCrops':
                ['seasonal_crops',
                 'areas_cultivated',
                 'avg_val_land',
                 'num_families',
                 'num_male',
                 'num_female',
                 'id'],
            'BcagPlantnCrops':
                ['plantn_crops',
                 'areas_cultivated',
                 'avg_val_land',
                 'num_families',
                 'num_male',
                 'num_female',
                 'id'],
            'BcagExportCrops':
                ['export_crops',
                 'areas_cultivated',
                 'avg_val_land',
                 'num_families',
                 'num_male',
                 'num_female',
                 'id'],
            'BcagForestry':
                ['forestry',
                 'areas_cultivated',
                 'avg_val_land',
                 'num_families',
                 'num_male',
                 'num_female',
                 'id'],
            'BcagOther':
                ['other_products',
                 'areas_cultivated',
                 'avg_val_land',
                 'num_families',
                 'num_male',
                 'num_female',
                 'id'],
        },
        'Table_2': {
            'BacfSeasonalCrops':
                ['seasonal_crops',
                 'avg_value',
                 'productn_pub',
                 'productn_pvt',
                 'productn_cost_nplanted',
                 'productn_cost_mstage',
                 'productn_cost_hstage',
                 'id'],
            'BacfPlantnCrops':
                ['plantn_crops',
                 'avg_value',
                 'productn_pub',
                 'productn_pvt',
                 'productn_cost_nplanted',
                 'productn_cost_mstage',
                 'productn_cost_hstage',
                 'id'],
            'BacfExportCrops':
                ['export_crops',
                 'avg_value',
                 'productn_pub',
                 'productn_pvt',
                 'productn_cost_nplanted',
                 'productn_cost_mstage',
                 'productn_cost_hstage',
                 'id'],
            'BacfForestry':
                ['forestry',
                 'avg_value',
                 'productn_pub',
                 'productn_pvt',
                 'productn_cost_nplanted',
                 'productn_cost_mstage',
                 'productn_cost_hstage',
                 'id'],
            'BacfOther':
                ['other_products',
                 'avg_value',
                 'productn_pub',
                 'productn_pvt',
                 'productn_cost_nplanted',
                 'productn_cost_mstage',
                 'productn_cost_hstage',
                 'id'],
            'BacfFarmEquipment':
                ['assets',
                 'avg_replace_cost',
                 'avg_repair_cost',
                 'id'],
            'BacfStocks':
                ['assets',
                 'avg_value',
                 'id'],
            'BacfAvgrePlantnCrops':
                ['assets',
                 'avg_value',
                 'id'],
            'BacfAvgreExportCrops':
                ['assets',
                 'avg_value',
                 'id'],
            'BacfAvgreForestry':
                ['assets',
                 'avg_value',
                 'id'],

        },
        'Table_3': {
            'BsoeStructure':
                ['assets',
                 'avg_replace_cost',
                 'avg_repair_wall',
                 'avg_repair_roof',
                 'avg_repair_flooring',
                 'id'],
            'BsoeOequipment':
                ['assets',
                 'avg_replace_cost',
                 'avg_repair_cost',
                 'id'],
            'BsoeMachinery':
                ['assets',
                 'avg_replace_cost',
                 'avg_repair_cost',
                 'id'],

        },
        'Table_4': {
            'DcpfFarmEquipment':
                ['assets',
                 'num_dest_pub',
                 'num_dest_pvt',
                 'num_dmg_pub',
                 'num_dmg_pvt',
                 'dmg_pub',
                 'dmg_pvt',
                 'id'],

            'DcpfSeasonalCrops':
                ['assets',
                 'num_dest_pub',
                 'num_dest_pvt',
                 'dmg_pub',
                 'dmg_pvt',
                 'id'],
            'DcpfExportCrops':
                ['assets',
                 'num_dest_pub',
                 'num_dest_pvt',
                 'dmg_pub',
                 'dmg_pvt',
                 'id'],
            'DcpfForestry':
                ['assets',
                 'num_dest_pub',
                 'num_dest_pvt',
                 'dmg_pub',
                 'dmg_pvt',
                 'id'],
            'DcpfOther':
                ['assets',
                 'num_dest_pub',
                 'num_dest_pvt',
                 'dmg_pub',
                 'dmg_pvt',
                 'id'],
            'DcpfStocks':
                ['assets',
                 'num_dest_pub',
                 'num_dest_pvt',
                 'dmg_pub',
                 'dmg_pvt',
                 'id'],
            'DcpfReForestry':
                ['assets',
                 'num_dest_pub',
                 'num_dest_pvt',
                 'dmg_pub',
                 'dmg_pvt',
                 'id'],
            'DcpfReExportCrops':
                ['assets',
                 'num_dest_pub',
                 'num_dest_pvt',
                 'dmg_pub',
                 'dmg_pvt',
                 'id'],
            'DcpfRePlantnCrops':
                ['assets',
                 'num_dest_pub',
                 'num_dest_pvt',
                 'dmg_pub',
                 'dmg_pvt',
                 'id'],
            'DcpfPlantnCrops':
                ['assets',
                 'num_dest_pub',
                 'num_dest_pvt',
                 'dmg_pub',
                 'dmg_pvt',
                 'id'],

        },
        'Table_5': {
            'DsorDestStructures':
                ['assets',
                 'num_dest_pub',
                 'num_dest_pvt',
                 'tot_dest_pub',
                 'tot_dest_pvt',
                 'dmg_pub',
                 'dmg_pvt',
                 'id'],
            'DsorDmgPubStructure':
                ['assets',
                 'num_part_dmg',
                 'tot_dmg_roof',
                 'tot_dmg_walls',
                 'tot_dmg_floors',
                 'damages',
                 'id'],
            'DsorDmgPvtStructures':
                ['assets',
                 'num_part_dmg',
                 'tot_dmg_roof',
                 'tot_dmg_walls',
                 'tot_dmg_floors',
                 'damages',
                 'id'],
            'DsorDmgPvtOequipment':
                ['assets',
                 'num_dest_pub',
                 'num_dest_pvt',
                 'num_dmg_pub',
                 'num_dmg_pvt',
                 'dmg_pub',
                 'dmg_pvt',
                 'id'],
            'DsorDmgPvtMachinery':
                ['assets',
                 'num_dest_pub',
                 'num_dest_pvt',
                 'num_dmg_pub',
                 'num_dmg_pvt',
                 'dmg_pub',
                 'dmg_pvt',
                 'id'],

        },
        'Table_6': {
            'DildSeasonalCrops':
                ['seasonal_crops',
                 'new_plant_pub',
                 'new_plant_pvt',
                 'mid_stage_pub',
                 'mid_stage_pvt',
                 'harvest_stage_pub',
                 'harvest_stage_pvt',
                 'invest_los_pub',
                 'invest_los_pvt',
                 'id'],
            'DildPlantnCrops':
                ['plantn_crops',
                 'new_plant_pub',
                 'new_plant_pvt',
                 'mid_stage_pub',
                 'mid_stage_pvt',
                 'harvest_stage_pub',
                 'harvest_stage_pvt',
                 'invest_los_pub',
                 'invest_los_pvt',
                 'id'],
            'DildExportCrops':
                ['export_crops',
                 'new_plant_pub',
                 'new_plant_pvt',
                 'mid_stage_pub',
                 'mid_stage_pvt',
                 'harvest_stage_pub',
                 'harvest_stage_pvt',
                 'invest_los_pub',
                 'invest_los_pvt',
                 'id'],
            'DildForestry':
                ['forestry',
                 'new_plant_pub',
                 'new_plant_pvt',
                 'mid_stage_pub',
                 'mid_stage_pvt',
                 'harvest_stage_pub',
                 'harvest_stage_pvt',
                 'invest_los_pub',
                 'invest_los_pvt',
                 'id'],

        },
        'Table_7': {
            'PldySeasonalCrops':
                ['seasonal_crops',
                 'redctn_year_1_pub',
                 'redctn_year_1_pvt',
                 'redctn_year_2_pub',
                 'redctn_year_2_pvt',
                 'prod_year_1_pub',
                 'prod_year_1_pvt',
                 'prod_year_2_pub',
                 'prod_year_2_pvt',
                 'tot_prod_pub',
                 'tot_prod_pvt',
                 'id'],
            'PldyPlantnCrops':
                ['plantn_crops',
                 'redctn_year_1_pub',
                 'redctn_year_1_pvt',
                 'redctn_year_2_pub',
                 'redctn_year_2_pvt',
                 'prod_year_1_pub',
                 'prod_year_1_pvt',
                 'prod_year_2_pub',
                 'prod_year_2_pvt',
                 'tot_prod_pub',
                 'tot_prod_pvt',
                 'id'],
            'PldyExportCrops':
                ['export_crops',
                 'redctn_year_1_pub',
                 'redctn_year_1_pvt',
                 'redctn_year_2_pub',
                 'redctn_year_2_pvt',
                 'prod_year_1_pub',
                 'prod_year_1_pvt',
                 'prod_year_2_pub',
                 'prod_year_2_pvt',
                 'tot_prod_pub',
                 'tot_prod_pvt',
                 'id'],
            'PldyForestry':
                ['forestry',
                 'redctn_year_1_pub',
                 'redctn_year_1_pvt',
                 'redctn_year_2_pub',
                 'redctn_year_2_pvt',
                 'prod_year_1_pub',
                 'prod_year_1_pvt',
                 'prod_year_2_pub',
                 'prod_year_2_pvt',
                 'tot_prod_pub',
                 'tot_prod_pvt',
                 'id'],
            'PldyOther':
                ['other_products',
                 'redctn_year_1_pub',
                 'redctn_year_1_pvt',
                 'redctn_year_2_pub',
                 'redctn_year_2_pvt',
                 'prod_year_1_pub',
                 'prod_year_1_pvt',
                 'prod_year_2_pub',
                 'prod_year_2_pvt',
                 'tot_prod_pub',
                 'tot_prod_pvt',
                 'id'],
            'PldyOtherLos':
                ['other_los',
                 'year_1_pub',
                 'year_1_pvt',
                 'year_2_pub',
                 'year_2_pvt',
                 'tot_pub',
                 'tot_pvt',
                 'id'],

        },
        'Table_8': {
            'DsorDmgPubStrusturesDistrict': ['damages', 'incident', 'district'],
            'DsorDmgPvtStrusturesDistrict': ['damages', 'incident', 'district'],
            'DsorDmgPvtOequipmentDistrict': ['dmg_pub', 'dmg_pvt', 'incident', 'district'],
            'DsorDmgPvtMachineryDistrict': ['dmg_pub', 'dmg_pvt', 'incident', 'district'],
            'DcpfFarmEquipmentDistrict': ['dmg_pub', 'dmg_pvt', 'incident', 'district'],
            'DcpfStocksDistrict': ['dmg_pub', 'dmg_pvt', 'incident', 'district'],
            'DcpfSeasonalCropsDistrict': ['dmg_pub', 'dmg_pvt', 'incident', 'district'],
            'DcpfPlantnCropsDistrict': ['dmg_pub', 'dmg_pvt', 'incident', 'district'],
            'DcpfExportCropsDistrict': ['dmg_pub', 'dmg_pvt', 'incident', 'district'],
            'DcpfRrePlantnDistrict': ['dmg_pub', 'dmg_pvt', 'incident', 'district'],
            'DcpfForestryDistrict': ['dmg_pub', 'dmg_pvt', 'incident', 'district'],
            'DcpfOtherDistrict': ['dmg_pub', 'dmg_pvt', 'incident', 'district'],
            'DildSeasonalCropsDistrict': ['invest_los_pub', 'invest_los_pvt', 'incident', 'district'],
            'PldySeasonalCropsDistrict': ['prod_year_1_pub', 'prod_year_1_pvt', 'prod_year_2_pub', 'prod_year_2_pvt', 'incident', 'district'],
            'DildPlantnCropsDistrict': ['invest_los_pub', 'invest_los_pvt', 'incident', 'district'],
            'PldyPlantnCropsDistrict': ['prod_year_1_pub', 'prod_year_1_pvt', 'prod_year_2_pub', 'prod_year_2_pvt', 'incident', 'district'],
            'DildExportCropsDistrict': ['invest_los_pub', 'invest_los_pvt', 'incident', 'district'],
            'PldyExportCropsDistrict': ['prod_year_1_pub', 'prod_year_1_pvt', 'prod_year_2_pub', 'prod_year_2_pvt', 'incident', 'district'],
            'DildForestryDistrict': ['invest_los_pub', 'invest_los_pvt', 'incident', 'district'],
            'PldyForestryDistrict': ['prod_year_1_pub', 'prod_year_1_pvt', 'prod_year_2_pub', 'prod_year_2_pvt', 'incident', 'district'],
            'PldyOtherDistrict': ['prod_year_1_pub', 'prod_year_1_pvt', 'prod_year_2_pub', 'prod_year_2_pvt', 'incident', 'district'],
            'PldyOtherLosDistrict': ['year_1_pub', 'year_1_pvt', 'year_2_pub', 'year_2_pvt', 'incident', 'district'],
        },
        'Table_9': {
            'DsorDmgLosProvince': ['dmg_los_pub', 'dmg_los_pvt'],
            'DsorLosYear1Province': ['dmg_los_pub', 'dmg_los_pvt'],
            'DsorLosYear2Province': ['dmg_los_pub', 'dmg_los_pvt'],
            'DsorDmgPubProvince': ['damages'],
            'DsorDmgPvtProvince': ['damages']
        },
        'Table_10': {
            'DsorDmgPubNational': ['sum'],
            'DsorDmgPvtNational': ['sum'],
            'DsorLosYear1National': ['dmg_los_pub', 'dmg_los_pvt'],
            'DsorLosYear2National': ['dmg_los_pub', 'dmg_los_pvt']
        }
    },
    'agri_livestock': {
        'Table_1': {
            'BelLivestock': [
                'livestock',
                'pub_own_families',
                'pub_own_male',
                'pub_own_female',
                'pvt_own_families',
                'pvt_own_male',
                'pvt_own_female',
                'id',
            ],
            'BelPoultry': [
                'poultry',
                'pub_own_families',
                'pub_own_male',
                'pub_own_female',
                'pvt_own_families',
                'pvt_own_male',
                'pvt_own_female',
                'id',
            ],
        },
        'Table_2': {
            'BlpAnmLivestock': [
                'livestock',
                'young_male',
                'young_female',
                'juvenile_male',
                'juvenile_female',
                'mature_male',
                'mature_female',
                'avg_val_young_male',
                'avg_val_young_female',
                'avg_val_juvenile_female',
                'avg_val_juvenile_male',
                'avg_val_mature_male',
                'avg_val_mature_female',
                'id',
            ],
            'BlpAnmPoultry': [
                'poultry',
                'young_male',
                'young_female',
                'juvenile_male',
                'juvenile_female',
                'mature_male',
                'mature_female',
                'avg_val_young_male',
                'avg_val_young_female',
                'avg_val_juvenile_female',
                'avg_val_juvenile_male',
                'avg_val_mature_male',
                'avg_val_mature_female',
            'id',],
            'BlpAstLivestock': [
                'livestock',
                'avg_replacec_anm_shed',
                'avg_replacec_feeds',
                'avg_replacec_medicines',
                'avg_replacec_tools',
                'avg_replacec_others',
                'avg_repairc_anm_shed',
                'avg_repairc_tools',
                'avg_repairc_others',
                'id',],
            'BlpAstPoultry': [
                'poultry',
                'avg_replacec_anm_shed',
                'avg_replacec_feeds',
                'avg_replacec_medicines',
                'avg_replacec_tools',
                'avg_replacec_others',
                'avg_repairc_anm_shed',
                'avg_repairc_tools',
                'avg_repairc_others',
                'id',
            ],
            'BlpAstStructures': [
                'structures',
                'avg_replace_cost',
                'avg_repair_roof',
                'avg_repair_wall',
                'avg_repair_floor',
                'id',
            ],
            'BlpAstOther': [
                'other_assets',
                'avg_replace_cost',
                'avg_repair_cost',
                'id',

            ],
            'BlpApyLivestock': [
                'livestock',
                'milk',
                'meat',
                'eggs',
                'others',
                'id',
            ],
            'BlpApyPoultry': [
                'poultry',
                'meat',
                'eggs',
                'others',
                'id',
            ],
        },
        'Table_3': {
            'DlpNdaLivestock': [
                'animals', 'dead_young_male', 'dead_young_female', 'dead_juvenile_male', 'dead_juvenile_female',
                'dead_mature_female', 'dead_mature_male', 'damages', 'id',
            ],
            'DlpNdaPoultry': [
                'animals', 'dead_young_male', 'dead_young_female', 'dead_juvenile_male', 'dead_juvenile_female',
                'dead_mature_female', 'dead_mature_male', 'damages', 'id',
            ],
            'DlpPafLivestock': [
                'animals', 'dest_animal_shed', 'dest_feeds', 'dest_medicines', 'dest_tools', 'dest_others',
                'dmg_animal_shed', 'dmg_tools', 'dmg_others', 'damages', 'id',
            ],
            'DlpPafPoultry': [
                'animals', 'dest_animal_shed', 'dest_feeds', 'dest_medicines', 'dest_tools', 'dest_others',
                'dmg_animal_shed', 'dmg_tools', 'dmg_others', 'damages', 'id',
            ],
            'DlpStructStructures': [
                'structures', 'dest_num', 'dest_sqm', 'pdmg_num', 'pdmg_roof', 'pdmg_wall', 'pdmg_floor', 'damages',
                'id',
            ],
            'DlpStructOther': [
                'other_assets', 'num_tot_dest', 'num_part_dmg', 'damages', 'id',
            ],
            'DlpLosLivestock': [
                'animals', 'milk_year_1', 'milk_year_2', 'meat_year_1', 'meat_year_2', 'others_year_1', 'others_year_2',
                'los_year_1', 'los_year_2', 'id',
            ],
            'DlpLosPoultry': [
                'animals', 'meat_year_1', 'meat_year_2', 'others_year_1', 'others_year_2', 'eggs_year_1', 'eggs_year_2',
                'los_year_1', 'los_year_2', 'id',
            ],
            'DlpLosOther': [
                'others', 'los_year_1', 'los_year_2', 'id',
            ],
        },
        'Table_4': {
            'DlpNdaLivestockPubDistrict': [
                'animals', 'damages',
            ],
            'DlpNdaLivestockPvtDistrict': [
                'animals', 'damages',
            ],
            'DlpNdaPoultryPubDistrict': [
                'animals', 'damages',
            ],
            'DlpNdaPoultryPvtDistrict': [
                'animals', 'damages',
            ],
            'DlpLosLivestockPubDistrict': [
                'animals', 'los_year_1', 'los_year_2',
            ],
            'DlpLosLivestockPvtDistrict': [
                'animals', 'los_year_1', 'los_year_2',
            ],
            'DlpLosPoultryPubDistrict': [
                'animals', 'los_year_1', 'los_year_2',
            ],
            'DlpLosPoultryPvtDistrict': [
                'animals', 'los_year_1', 'los_year_2',
            ],
            'DlpLosOtherPubDistrict': [
                'others', 'los_year_1', 'los_year_2',
            ],
            'DlpLosOtherPvtDistrict': [
                'others', 'los_year_1', 'los_year_2',
            ],
            'DlpPafPubDistrict': [
                'damages',
            ],
            'DlpPafPvtDistrict': [
                'damages',
            ],
            'DlpStructProductionPubDistrict': [
                'damages',
            ],
            'DlpStructProductionPvtDistrict': [
                'damages',
            ],
            'DlpStructStructuresPubDistrict': [
                'damages',
            ],
            'DlpStructStructuresPvtDistrict': [
                'damages',
            ],
            'DlpStructOtherPubDistrict': [
                'damages',
            ],
            'DlpStructOtherPvtDistrict': [
                'damages',
            ],
        },
        'Table_5': {
            'DlpNdaPubProvince': [
                'damages',
            ],
            'DlpNdaPvtProvince': [
                'damages',
            ],
            'DlpLosPubProvince': [
                'los_year_1',
                'los_year_2',
            ],
            'DlpLosPvtProvince': [
                'los_year_1',
                'los_year_2',
            ],
        },
        'Table_6': {
            'DlpNdaPubNational': [
                'damages',
            ],
            'DlpNdaPvtNational': [
                'damages',
            ],
            'DlpLosPubNational': [
                'los_year_1',
                'los_year_2',
            ],
            'DlpLosPvtNational': [
                'los_year_1',
                'los_year_2',
            ],
        },
    },
    'agri_fisheries': {
        'Table_1': {
            'BsPeoFisheries': [
                'fisheries',
                'num_families',
                'num_male',
                'num_female',
                'id',
            ],
        },
        'Table_2': {
            'BifProduction': [
                'types',
                'area_pub',
                'area_pvt',
                'avg_yield_pub',
                'avg_yield_pvt',
                'prodc_pub',
                'prodc_pvt',
                'id',
            ],
            'BifAstFequipment': [
                'assets',
                'if_avg_replace_cost',
                'if_avg_repair_cost',
                'rf_avg_replace_cost',
                'rf_avg_repair_cost',
                'mf_avg_replace_cost',
                'mf_avg_repair_cost',
                'id',
            ],
            'BifAstOequipment': [
                'assets',
                'if_avg_replace_cost',
                'if_avg_repair_cost',
                'rf_avg_replace_cost',
                'rf_avg_repair_cost',
                'mf_avg_replace_cost',
                'mf_avg_repair_cost',
                'id',
            ],
            'BifAstMachinery': [
                'assets',
                'if_avg_replace_cost',
                'if_avg_repair_cost',
                'rf_avg_replace_cost',
                'rf_avg_repair_cost',
                'mf_avg_replace_cost',
                'mf_avg_repair_cost',
                'id',
            ],
            'BifAstStructures': [
                'assets',
                'if_avg_replace_cost',
                'if_avg_repair_cost',
                'rf_avg_replace_cost',
                'rf_avg_repair_cost',
                'mf_avg_replace_cost',
                'mf_avg_repair_cost',
                'id',
            ],
            'BifAstBuildings': [
                'assets',
                'avg_replace_cost',
                'avg_repair_cost_roof',
                'avg_repair_cost_wall',
                'avg_repair_cost_floor',
                'id',
            ],

        },
        'Table_3': {
            'DlfDmgFequipment': [
                'assets',
                'dmg_dest_pub',
                'dmg_dst_pvt',
                'dmg_pdmg_pub',
                'dmg_pdmg_pvt',
                'dmg_pub',
                'dmg_pvt',
                'id',
            ],
            'DlfDmgOequipment': [
                'assets',
                'dmg_dest_pub',
                'dmg_dst_pvt',
                'dmg_pdmg_pub',
                'dmg_pdmg_pvt',
                'dmg_pub',
                'dmg_pvt',
                'id',
            ],
            'DlfDmgMachinery': [
                'assets',
                'dmg_dest_pub',
                'dmg_dst_pvt',
                'dmg_pdmg_pub',
                'dmg_pdmg_pvt',
                'dmg_pub',
                'dmg_pvt',
                'id',
            ],
            'DlfDmgStructures': [
                'assets',
                'dmg_dest_pub',
                'dmg_dst_pvt',
                'dmg_pdmg_pub',
                'dmg_pdmg_pvt',
                'dmg_pub',
                'dmg_pvt',
                'id',
            ],
            'DlfDmgPub': [
                'assets',
                'tot_dest_num',
                'tot_dest_sqm',
                'pdmg_num',
                'pdmg_roof',
                'pdmg_wall',
                'pdmg_floor',
                'total',
                'id',
            ],
            'DlfDmgPvt': [
                'assets',
                'tot_dest_num',
                'tot_dest_sqm',
                'pdmg_num',
                'pdmg_roof',
                'pdmg_wall',
                'pdmg_floor',
                'total',
                'id',
            ],
            'DlfLosIfisheries': [
                'assets',
                'los_year_1_pub',
                'los_year_1_pvt',
                'los_year_2_pub',
                'los_year_2_pvt',
                'los_pub',
                'los_pvt',
                'id',
            ],
            'DlfLosRfisheries': [
                'assets',
                'los_year_1_pub',
                'los_year_1_pvt',
                'los_year_2_pub',
                'los_year_2_pvt',
                'los_pub',
                'los_pvt',
                 'id',
            ],
            'DlfLosMfisheries': [
                'assets',
                'los_year_1_pub',
                'los_year_1_pvt',
                'los_year_2_pub',
                'los_year_2_pvt',
                'los_pub',
                'los_pvt',
                'id',
            ],
        },
        'Table_4': {
            'DlfDmgPubDistrict': ['dmg_pub', 'district', 'incident', 'fishing_type'],
            'DlfDmgPvtDistrict': ['dmg_pvt', 'district', 'incident', 'name'],
            'DlfLosIfisheriesDistrict': ['los_year_1_pub', 'los_year_1_pvt', 'los_year_2_pub', 'los_year_2_pvt',
                                         'district', 'incident'],
            'DlfLosRfisheriesDistrict': ['los_year_1_pub', 'los_year_1_pvt', 'los_year_2_pub', 'los_year_2_pvt',
                                         'district', 'incident'],
            'DlfLosMfisheriesDistrict': ['los_year_1_pub', 'los_year_1_pvt', 'los_year_2_pub', 'los_year_2_pvt',
                                         'district', 'incident'],
        },
        'Table_5': {
            'DlfDmgPubDistrict': [
                'fishing_type',
                'dmg_pub',
            ],
            'DlfDmgPvtDistrict': [
                'name',
                'dmg_pvt',
            ],
            'DlfLosIfisheriesDistrict': [
                'los_year_1_pub',
                'los_year_1_pvt',
                'los_year_2_pub',
                'los_year_2_pvt',
            ],
            'DlfLosRfisheriesDistrict': [
                'los_year_1_pub',
                'los_year_1_pvt',
                'los_year_2_pub',
                'los_year_2_pvt',
            ],
            'DlfLosMfisheriesDistrict': [
                'los_year_1_pub',
                'los_year_1_pvt',
                'los_year_2_pub',
                'los_year_2_pvt',
            ],
            'DlfDmgPubProvince': [
                'dmg_pub',
            ],
            'DlfDmgPvtProvince': [
                'dmg_pvt',
            ],
            'DlfLosProvince': [
                'los_year_1_pub',
                'los_year_1_pvt',
                'los_year_2_pub',
                'los_year_2_pvt',
            ],
        },
        'Table_6': {
            'DlfDmgPubNational': [
                'fishing_type',
                'dmg_pub',
            ],
            'DlfDmgPvtNational': [
                'name',
                'dmg_pvt',
            ],
            'DlfLosPubNational': [
                'dmg_pub',
            ],
            'DlfLosPvtNational': [
                'dmg_pvt',
            ],
            'DlfLosIfisheriesNational': [
                'los_year_1_pub',
                'los_year_1_pvt',
                'los_year_2_pub',
                'los_year_2_pvt',
            ],
            'DlfLosRfisheriesNational': [
                'los_year_1_pub',
                'los_year_1_pvt',
                'los_year_2_pub',
                'los_year_2_pvt',
            ],
            'DlfLosMfisheriesNational': [
                'los_year_1_pub',
                'los_year_1_pvt',
                'los_year_2_pub',
                'los_year_2_pvt',
            ],
            'DlfDmgPubNational': [
                'dmg_pub',
            ],
            'DlfDmgPvtNational': [
                'dmg_pvt',
            ],
            'DlfLosNational': [
                'los_year_1_pub',
                'los_year_1_pvt',
                'los_year_2_pub',
                'los_year_2_pvt',
            ],
        },
    },
    'water_supply': {
        'Table_1': {
            'BiaNumEmployees': ['male', 'female', 'id'],
            'BiaWaterUsers': ['type_wusers', 'num_clients', 'daily_demand', 'annual_demand', 'rate', 'id'],
            'BiaWaterIntake': ['components', 'avg_replace_cost', 'avg_repair_cost', 'id'],
            'BiaTreatmentPlant': ['components', 'avg_replace_cost', 'avg_repair_cost', 'id'],
            'BiaWaterDistribution': ['components', 'avg_replace_cost', 'avg_repair_cost', 'id'],
            'BiaMainOffice': ['components', 'avg_replace_cost', 'avg_repair_cost', 'id'],
        },
        'Table_2': {
            'BimRuralWater': ['type_water_supply', 'num_users', 'avg_replace_cost', 'avg_repair_cost', 'id']
        },
        'Table_3': {
            'DlcwNumClients': ['residential', 'commercial', 'industrial', 'others', 'total', 'id', ],
            'DlcwNumEmployees': ['male', 'female', 'total', 'id', ],
            'DlcwDmgWaterIntake': ['assets', 'num_tot_destoyed', 'num_part_damaged', 'total_dmgs', 'id', ],
            'DlcwDmgWaterTreatment': ['assets', 'num_tot_destoyed', 'num_part_damaged', 'total_dmgs', 'id', ],
            'DlcwDmgWaterDisribution': ['assets', 'num_tot_destoyed', 'num_part_damaged', 'total_dmgs', 'id', ],
            'DlcwDmgMainOffice': ['assets', 'num_tot_destoyed', 'num_part_damaged', 'total_dmgs', 'id', ],
            'DlcwLosProduction': ['production_los', 'avg_income', 'est_inc_year_1', 'est_inc_year_2', 'tot_los_year_1',
                                  'tot_los_year_2', 'tot_los', 'id', ],
            'DlcwLosOther': ['other_los', 'tot_los_year_1', 'tot_los_year_2', 'tot_los', 'id', ],
        },
        'Table_4': {
            'DlRuralDmg': ['type_water_supply', 'families_affected', 'tot_destroyed_assets', 'part_damaged_assets',
                           'tot_damages', 'id', ],
            'DlRuralLos': ['type_water_supply', 'cleaning_debris', 'high_ocost', 'other_unexpected_exps', 'tot_los',
                           'id', ],
        },
        'Table_5': {
            'DlRuralDmgDis': ['type_water_supply', 'families_affected'],
            'DlRuralLos': ['type_water_supply', 'cleaning_debris', 'high_ocost', 'other_unexpected_exps', 'tot_los',
                           'id', ],
            'DlcwNumClients': ['residential', 'commercial', 'industrial', 'others', 'total', 'id', ],
            'DlcwLosOther': ['other_los', 'tot_los_year_1', 'tot_los_year_2', 'tot_los', 'id', ],
            'DlcwTotDmgDistrict': ['dlcw_tot_dmg'],
            'DlRuralTotDmgDistrict': ['tot_damages'],
            'DlRuralTotLosDistrict': ['tot_los'],
        },
        'Table_6': {
            'DlRuralDmgProvince': ['type_water_supply', 'families_affected', 'tot_destroyed_assets', 'part_damaged_assets',
                           'tot_damages', ],
            'DlRuralLos': ['type_water_supply', 'cleaning_debris', 'high_ocost', 'other_unexpected_exps', 'tot_los',
                           'id', ],
            'DlcwNumClientsProvince': ['residential', 'commercial', 'industrial', 'others', 'total' ],
            'DlcwLosOther': ['other_los', 'tot_los_year_1', 'tot_los_year_2', 'tot_los', 'id', ],
            'DlcwTotDmgProvince': ['dlcw_tot_dmg','sum_tot'],
            'DlcwTotLosProvince':['tot_los_year1','tot_los_year2'],
            'DlRuralTotDmgDistrict': ['tot_damages'],
            'DlRuralTotLosProvince':['tot_los'],
            'DlRuralTotLosDistrict': ['tot_los'],
        },
        'Table_7': {
            'DlcwNumAfNational': ['type1','type2','type3','others','total'],
            'DlRuralNumAfNational': ['type_water_supply', 'families_affected'],
            'DlcwDmgNational': ['sum'],
            # 'DlcwTotDmgNational': ['sum'],
            'DlcwLosNational': ['tot_los_year1', 'tot_los_year2'],
            'DlRuralDmgNational': ['type_water_supply', 'tot_damages'],
            'DlRuralLosNational': ['tot_los'],
            'DlcwNumClientsNational':['residential', 'commercial', 'industrial', 'others', 'total'],
        }
    },
    'tourism': {
        'Table_1': {
            'BsTouBusiness': ['business', 'num_bis_private', 'num_bis_public', 'num_emp_male', 'num_empfemale', 'id'],
            'BsCultSites': ['site', 'num_bis_private', 'num_bis_public', 'num_emp_male', 'num_empfemale', 'id'],
            'BsNatFormation': ['site', 'num_bis_private', 'num_bis_public', 'num_emp_male', 'num_empfemale', 'id'],
        },
        'Table_2': {
            'DlNumEmpBusiness': ['num_emp_male', 'num_emp_female', 'id'],
            'DmgBusAstStructures': ['assets', 'val_dst', 'val_pdmg', 'tot_dmg', 'id'],
            'DmgBusAstEquipment': ['assets', 'val_dst', 'val_pdmg', 'tot_dmg', 'id'],
            'DmgBusAstMachinery': ['assets', 'val_dst', 'val_pdmg', 'tot_dmg', 'id'],
            'DmgBusAstVehicle': ['assets', 'val_dst', 'val_pdmg', 'tot_dmg', 'id'],
            'DmgBusAstInventories': ['assets', 'val_dst', 'val_pdmg', 'tot_dmg', 'id'],

            'DlBusLosses': ['los_type', 'avg_val_income_year', 'val_income_year1', 'val_income_year2', 'val_los_year1',
                            'val_los_year2', 'tol_losses', 'id'],
        },
        'Table_3': {
            'DmgInfAssets': ['assets', 'tot_dmg', 'val_dst', 'val_pdmg', 'id'],
            'DlInfLosses': ['avg_val_income_year', 'los_type', 'tol_losses', 'val_income_year1', 'val_income_year2',
                            'val_los_year1', 'val_los_year2', 'id']
        },
        'Table_4': {
            'DlDmgBusDistrictN': ['business', 'sumpub', 'sumpvt'],
            'DlDmgInfDistrictNN': ['tot_dst_pvt', 'tot_pdmg_pvt', 'tot_dmg_pvt', 'tot_dst_pub', 'tot_pdmg_pub', 'tot_dmg_pub', 'infrastructure'],
            'DlLosInfDistrictNN': ['loss_year1_pub', 'loss_year1_pvt', 'loss_year2_pub', 'loss_year2_pvt', 'infrastructure'],
            'DlLosBusDistrictN': ['business', 'tot_year1_pub', 'tot_year1_pvt', 'tot_year2_pub', 'tot_year2_pvt'],
            'DlDmgInfDistrictN': ['infrastructure', 'tot_dst', 'tot_pdmg', 'tot_dmg', 'ownership', 'inf_type'],
            'DlLosInfDistrictN': ['infrastructure', 'year1', 'year2', 'ownership', 'inf_type']
        },
        'Table_5': {
            'DlDmgFrmTotProvinceN': ['asset', 'tot_damages_pub', 'tot_damages_pvt'],
            'DlLosFrmTotProvinceN': ['asset', 'los_year1_pub', 'los_year1_pvt', 'los_year2_pub', 'los_year2_pvt'],
            'DlDmgInfTotProvinceN': ['assets', 'los_pub', 'los_pvt'],
            'DlLosInfTotProvinceN': ['asset', 'los_year1_pub', 'los_year1_pvt', 'los_year2_pub', 'los_year2_pvt'],
        },
        'Table_6': {
            'DlDmgFrmNational': ['tot_damages_pub', 'tot_damages_pvt'],
            'DlLosFrmTotNational': ['los_year1_pub', 'los_year1_pvt', 'los_year2_pub', 'los_year2_pvt'],
            'DlDmgInfNational': ['tot_damages_pub', 'tot_damages_pvt'],
            'DlLosInfNational': ['los_year1_pub', 'los_year1_pvt', 'los_year2_pub', 'los_year2_pvt'],
        }
    },
    'housing': {
        'Table_1': {
            'BhClfPermanent': ['components', 'tot_num_house', 'tot_num_house_rent', 'avg_rent_mont',
                               'ang_num_occ_female', 'avg_num_occ_male', 'avg_period_construct', 'avg_period_repair',
                               'id'],
            'BhClfSmiPermanent': ['components', 'tot_num_house', 'tot_num_house_rent', 'avg_rent_mont',
                                  'ang_num_occ_female', 'avg_num_occ_male', 'avg_period_construct', 'avg_period_repair',
                                  'id'],
            'BhClfImprovised': ['components', 'tot_num_house', 'tot_num_house_rent', 'avg_rent_mont',
                                'ang_num_occ_female', 'avg_num_occ_male', 'avg_period_construct', 'avg_period_repair',
                                'id'],
        },
        'Table_2': {
            'BhClfPermanentCost': ['components', 'avg_replace_cost', 'avg_repair_cost_roof', 'avg_repair_cost_wall',
                                   'avg_repair_cost_floor', 'avg_val_content', 'id'],
            'BhClfImprovisedCost': ['components', 'avg_replace_cost', 'avg_repair_cost_roof', 'avg_repair_cost_wall',
                                    'avg_repair_cost_floor', 'avg_val_content', 'id'],
            'BhClfSmiPermanentCost': ['components', 'avg_replace_cost', 'avg_repair_cost_roof', 'avg_repair_cost_wall',
                                      'avg_repair_cost_floor', 'avg_val_content', 'id'],
        },
        'Table_3': {
            'DlDesPermanent':
                ['assets',
                 'tot_num_houses',
                 'per_cent_tot_rent',
                 'tot_sqm_destroyed',
                 'house_val_affected',
                 'damages', 'id'],
            'DlDesSemiPermanent':
                ['assets',
                 'tot_num_houses',
                 'per_cent_tot_rent',
                 'tot_sqm_destroyed',
                 'house_val_affected',
                 'damages', 'id'],
            'DlDesImprovised':
                ['assets',
                 'tot_num_houses',
                 'per_cent_tot_rent',
                 'tot_sqm_destroyed',
                 'house_val_affected',
                 'damages', 'id'],
            'DlPdesPermanent':
                ['assets',
                 'tot_num_houses',
                 'per_cent_tot_rent',
                 'tot_sqm_roof',
                 'tot_sqm_wall',
                 'tot_sqm_floor',
                 'house_val_affected', 'id'],
            'DlPdesSemiPermanent':
                ['assets',
                 'tot_num_houses',
                 'per_cent_tot_rent',
                 'tot_sqm_roof',
                 'tot_sqm_wall',
                 'tot_sqm_floor',
                 'house_val_affected', 'id'],
            'DlPdesImprovised':
                ['assets',
                 'tot_num_houses',
                 'per_cent_tot_rent',
                 'tot_sqm_roof',
                 'tot_sqm_wall',
                 'tot_sqm_floor',
                 'house_val_affected', 'id'],
            'DlLosPermanent':
                ['assets',
                 'tot_num_des_houses',
                 'tot_num_dmg_houses',
                 'frg_income',
                 'avg_cost_clean',
                 'avg_un_expenses',
                 'losses', 'id'],
            'DlLosSemiPermanent':
                ['assets',
                 'tot_num_des_houses',
                 'tot_num_dmg_houses',
                 'frg_income',
                 'avg_cost_clean',
                 'avg_un_expenses',
                 'losses', 'id'],
            'DlLosImprovised':
                ['assets',
                 'tot_num_des_houses',
                 'tot_num_dmg_houses',
                 'frg_income',
                 'avg_cost_clean',
                 'avg_un_expenses',
                 'losses', 'id'],
        },
        'Table_4': {
            'DlDmgImpDistrict':
                ['assets',
                 'tot_damages',
                 ],
            'DlDmgPerDistrict':
                ['assets',
                 'tot_damages',
                 ],
            'DlDmgSemiPerDistrict':
                ['assets',
                 'tot_damages',
                 ],
            'DlLosImpDistrict':
                ['assets',
                 'tot_losses',
                 ],
            'DlLosPerDistrict':
                ['assets',
                 'tot_losses',
                 ],
            'DlLosSemiPerDistrict':
                ['assets',
                 'tot_losses',
                 ],
            'DlNumDesImpDistrict':
                ['assets',
                 'tot_num_houses',
                 ],
            'DlNumDesPerDistrict':
                ['assets',
                 'tot_num_houses',
                 ],
            'DlNumDesSemiPerDistrict':
                ['assets',
                 'tot_num_houses',
                 ],
            'DlNumPdesPerDistrict':
                ['assets',
                 'tot_num_houses',
                 ],
            'DlNumPdesImpDistrict':
                ['assets',
                 'tot_num_houses',
                 ],
            'DlNumPdesSemiPerDistrict':
                ['assets',
                 'tot_num_houses',
                 ],
        },
        'Table_5': {
            'DlDmgImpProvince':
                [
                    'tot_damages',
                ],
            'DlDmgPerProvince':
                [
                    'tot_damages',
                ],
            'DlDmgSemiPerProvince':
                [
                    'tot_damages',
                ],
            'DlLosImpProvince':
                [
                    'tot_losses',
                ],
            'DlLosPerProvince':
                [
                    'tot_losses',
                ],
            'DlLosSemiPerProvince':
                [
                    'tot_losses',
                ],
            'DlNumDesImpProvince':
                [
                    'tot_num_houses',
                ],
            'DlNumDesPerProvince':
                [
                    'tot_num_houses',
                ],
            'DlNumDesSemiPerProvince':
                [
                    'tot_num_houses',
                ],
            'DlNumPdesPerProvince':
                [
                    'tot_num_houses',
                ],
            'DlNumPdesImpProvince':
                [
                    'tot_num_houses',
                ],
            'DlNumPdesSemiPerProvince':
                [
                    'tot_num_houses',
                ],
        },
        'Table_6': {
            'DlDmgImpNational':
                [
                    'tot_damages',
                ],
            'DlDmgPerNational':
                [
                    'tot_damages',
                ],
            'DlDmgSemiPerNational':
                [
                    'tot_damages',
                ],
            'DlLosImpNational':
                [
                    'tot_losses',
                ],
            'DlLosPerNational':
                [
                    'tot_losses',
                ],
            'DlLosSemiPerNational':
                [
                    'tot_losses',
                ],
            'DlNumDesImpNational':
                [
                    'tot_num_houses',
                ],
            'DlNumDesPerNational':
                [
                    'tot_num_houses',
                ],
            'DlNumDesSemiPerNational':
                [
                    'tot_num_houses',
                ],
            'DlNumPdesPerNational':
                [
                    'tot_num_houses',
                ],
            'DlNumPdesImpNational':
                [
                    'tot_num_houses',
                ],
            'DlNumPdesSemiPerNational':
                [
                    'tot_num_houses',
                ],
        }
    },
    'telecommunication': {
        'Table_1': {
            'BsTelCompany': ['fixed_voice', 'fixed_tv', 'fixed_data', 'mobile_voice', 'mobile_data', 'ownership',
                             'company', 'company_name', 'id'],
        },
        'Table_2': {
            'DlNumEmpDistrict': ['num_emp_male', 'mun_emp_female', 'tot_emp', 'num_clients', 'id'],
            'DmgAstTelStructure': ['assets', 'dmg_val_replace', 'pdmg_val_repair', 'tot_dmg', 'id'],
            'DmgAstTelEquipment': ['assets', 'dmg_val_replace', 'pdmg_val_repair', 'tot_dmg', 'id'],
            'DmgAstTelMachinery': ['assets', 'dmg_val_replace', 'pdmg_val_repair', 'tot_dmg', 'id'],
            'DmgAstTelVehicles': ['assets', 'dmg_val_replace', 'pdmg_val_repair', 'tot_dmg', 'id'],
            'DmgAstTelOthers': ['assets', 'dmg_val_replace', 'pdmg_val_repair', 'tot_dmg', 'id'],
            'DlLosses': ['assets', 'year1_los', 'year2_los', 'tot_losses', 'id'],
        },
        'Table_3': {
            'DlDmgFirmDistrict': ['tot_damages', 'incident', 'district', 'firm', 'ownership', 'company_name'],
            'LosFirmYear1District': ['year1_los', 'incident', 'district', 'firm', 'ownership'],
            'LosFirmYear2District': ['year2_los', 'incident', 'district', 'firm', 'ownership'],
        },
        'Table_4': {
            'DlDmgFirmDistrict': ['tot_damages', 'incident', 'district', 'firm', 'ownership', 'company_name'],
            'LosFirmYear1District': ['year1_los', 'incident', 'district', 'firm', 'ownership'],
            'LosFirmYear2District': ['year2_los', 'incident', 'district', 'firm', 'ownership'],
        },
        'Table_5': {
            'DlDmgBusTotNational': ['tot_damages', 'incident', 'ownership', 'province', 'company_name'],
            'DlDmgBusTotGroupNational': ['tot_damages', 'incident', 'ownership', 'province', 'company_name'],
            'DlDmgFirmNational': ['tot_damages', 'incident', 'firm', 'ownership', 'province', 'company_name'],
            'DlDmgFirmGroupNational': ['tot_damages', 'incident', 'ownership', 'province', 'company_name'],
            'LosFirmYear1National': ['year1_los', 'incident', 'firm', 'ownership', 'province'],
            'LosFirmYear1GroupsNational': ['year1_los', 'incident', 'ownership', 'province'],
            'LosFirmYear2National': ['year2_los', 'incident', 'firm', 'ownership', 'province'],
            'LosFirmYear2GroupsNational': ['year2_los', 'incident', 'ownership', 'province'],
        },
    },
    'power_supply': {
        'Table_1': {
            'BsPwGenFirm':
                ['ownership',
                 'assets',
                 'description',
                 'num_hydro',
                 'num_coal',
                 'num_diesel',
                 'num_other',
                 'tot_capacity',
                 'avg_income',
                 'id'],
        },
        'Table_2': {
            'CebNumEmp':
                ['num_male',
                 'num_female',
                 'tot_emp', 'id'],
            'CebNumCusAff':
                ['num_domestic',
                 'num_industrial',
                 'num_commercial',
                 'num_other',
                 'num_total', 'id'],
            'CebDmgAstGeneration':
                ['assets',
                 'num_dst_ast',
                 'tot_replace_cost',
                 'num_dmg_ast',
                 'to_repair_cost',
                 'tot_dmg', 'id'],
            'CebDmgAstTransmision':
                ['assets',
                 'num_dst_ast',
                 'tot_replace_cost',
                 'num_dmg_ast',
                 'to_repair_cost',
                 'tot_dmg', 'id'],
            'CebDmgAstDistribution':
                ['assets',
                 'num_dst_ast',
                 'tot_replace_cost',
                 'num_dmg_ast',
                 'to_repair_cost',
                 'tot_dmg', 'id'],
            'CebDmgAstStructures':
                ['assets',
                 'num_dst_ast',
                 'tot_replace_cost',
                 'num_dmg_ast',
                 'to_repair_cost',
                 'tot_dmg', 'id'],
            'CebLosAstIncome':
                ['assets',
                 'avg_income',
                 'reduction_y1',
                 'reduction_y2',
                 'losses_y1',
                 'losses_y2',
                 'tot_losses', 'id'],
            'CebLosAstOther':
                ['assets',
                 'avg_income',
                 'reduction_y1',
                 'reduction_y2',
                 'losses_y1',
                 'losses_y2',
                 'tot_losses', 'id'],
            'CebDmgAstOffEquipment':
                ['assets',
                 'num_dst_ast',
                 'tot_replace_cost',
                 'num_dmg_ast',
                 'to_repair_cost',
                 'tot_dmg', 'id'],
            'CebDmgAstOther':
                ['assets',
                 'num_dst_ast',
                 'tot_replace_cost',
                 'num_dmg_ast',
                 'to_repair_cost',
                 'tot_dmg', 'id'],
        },
        'Table_3': {
            'PvtNumEmp': ['num_male', 'num_female', 'tot_emp', 'id'],
            'PvtDmgAst': ['assets', 'num_dst_ast', 'tot_replace_cost', 'num_pdmg_ast', 'tot_repair_cost',
                          'tot_damaged_cost', 'id'],
            'PvtDmgLosses': ['los_year1', 'los_year2', 'losses_type', 'id'],
        },
        'Table_4': {
            'DlNumAffDistrict': ['domestic', 'industrial', 'commercial', 'other', 'incident', 'district'],
            'TotDmgCebDistrictNew': ['tot_dmg', 'incident', 'district'],
            'TotLosCebDistrict': ['losses_y1', 'losses_y2', 'incident', 'district'],
            'TotDmgPvtDistrict': ['tot_replace_cost', 'district', 'incident', 'pw_gen_firm', 'ownership','assets'],
            'TotLossesPvtDistrict': ['los_year1', 'los_year2', 'district', 'incident', 'pw_gen_firm', 'ownership',
                                     'losses_type','assets'],
        },
        'Table_5': {
            'DlNumAffProvince': ['domestic', 'industrial', 'commercial', 'other'],
            'TotDmgCebProvince': ['tot_dmg'],
            'TotLosCebProvince': ['losses_y1', 'losses_y2'],
            'TotDmgPvtProvince': ['tot_dmg', 'ownership'],
            'TotLossesPvtProvince': ['los_year1', 'los_year2', 'ownership'],
            'DlNumAffProvinceNew': ['domestic', 'industrial', 'commercial', 'other'],
        },
        'Table_6': {
            'DlNumAffNational': ['domestic', 'industrial', 'commercial', 'other'],
            'TotDmgCebNational': ['tot_dmg'],
            'TotLosCebNational': ['losses_y1', 'losses_y2'],
            'TotDmgPvtNational': ['tot_dmg', 'ownership'],
            'TotLossesPvtNational': ['los_year1', 'los_year2', 'ownership'],
        },
    },
    'industry_services': {
        'Table_1': {
            'BsFrmNumBusIndustry': ['industry', 'num_male', 'num_female', 'num_large', 'num_medium', 'num_micro',
                                    'num_small', 'id'],
            'BsFrmNumBusServices': ['service', 'num_male', 'num_female', 'num_large', 'num_medium', 'num_micro', 'num_small', 'id'],
        },
        'Table_2': {
            'BsNumBusSector': ['avg_num_emp_female', 'avg_num_emp_male', 'components', 'num_businesses', 'id'],
        },
        'Table_3': {
            'DmgAstStructures': ['assets', 'replace_val_destroyed', 'repair_val_damaged', 'tot_damaged', 'ownership', 'id'],
            'DmgAstEquipment': ['assets', 'replace_val_destroyed', 'repair_val_damaged', 'tot_damaged', 'ownership', 'id'],
            'DmgAstMachinery': ['assets', 'replace_val_destroyed', 'repair_val_damaged', 'tot_damaged', 'ownership', 'id'],
            'DmgAstVehicles': ['assets', 'replace_val_destroyed', 'repair_val_damaged', 'tot_damaged', 'ownership', 'id'],
            'DmgAstStocks': ['assets', 'replace_val_destroyed', 'repair_val_damaged', 'tot_damaged', 'ownership', 'id', ],
            'LosTypeLossses': ['assets', 'avg_val_output_year', 'est_val_output_year1', 'est_val_output_year2',
                               'los_year1', 'los_year2', 'tot_losses', 'ownership', 'id'],
        },
        'Table_4': {
            'DlInfDmgTypBusiness': ['assets', 'repair_val_ast_damaged', 'replace_val_ast_destroyed', 'tot_damages',
                                    'tot_num_bus_affected', 'id'],
            'DlInfLosTypFood': ['assets', 'avg_val_output_year', 'est_val_output_year1', 'est_val_output_year2',
                                'los_year1', 'los_year2', 'tot_losses', 'id'],
            'DlInfLosTypOther': ['assets', 'avg_val_output_year', 'est_val_output_year1', 'est_val_output_year2',
                                 'los_year1', 'los_year2', 'tot_losses', 'id'],
            'DlInfLosTypServices': ['assets', 'avg_val_output_year', 'est_val_output_year1', 'est_val_output_year2',
                                    'los_year1', 'los_year2', 'tot_losses', 'id'],
            'DlInfLosTypTrading': ['assets', 'avg_val_output_year', 'est_val_output_year1', 'est_val_output_year2',
                                   'los_year1', 'los_year2', 'tot_losses', 'id'],
        },
        'Table_5': {
            'DlNuAffBisIndDistrict': ['sector', 'count_no_pub', 'count_no_pvt', 'firm_type'],
            'DlNuAffBisSerDistrict': ['sector', 'count_no_pub', 'count_no_pvt', 'firm_type'],
            'DmgFrmYear1IndDistrict': ['firm_type', 'sector', 'tot_dmg_pub', 'tot_dmg_pvt'],
            'DmgFrmYear1SerDistrict': ['firm_type', 'sector', 'tot_dmg_pub', 'tot_dmg_pvt'],
            'LosFrmYear1IndDistrict': ['sector', 'firm_type_name', 'los_year1_pub', 'los_year1_pvt'],
            'LosFrmYear1SerDistrict': ['sector', 'firm_type_name', 'los_year1_pub', 'los_year1_pvt'],
            'LosFrmYear2IndDistrict': ['sector', 'firm_type_name', 'los_year2_pub', 'los_year2_pvt'],
            'LosFrmYear2SerDistrict': ['sector', 'firm_type_name', 'los_year2_pub', 'los_year2_pvt'],
            'DlInfNumBusDistrict': ['assets', 'tot_num_bus_affected'],
            'DlInfDmgDistrict': ['assets', 'tot_damages'],
            'DlInfTotLosFoodY1District': ['tot_los_year1'],
            'DlInfTotLosFoodY2District': ['tot_los_year2'],
            'DlInfTotLosOthY1District': ['tot_los_year1'],
            'DlInfTotLosOthY2District': ['tot_los_year2'],
            'DlInfTotLosSerY1District': ['tot_los_year1'],
            'DlInfTotLosSerY2District': ['tot_los_year2'],
            'DlInfTotLosTrdY1District': ['tot_los_year1'],
            'DlInfTotLosTrdY2District': ['tot_los_year2'],
            'DmgFrmIndYear1TotDis': ['firm_type_name', 'tot_damages_pub', 'tot_damages_pvt'],
            'DmgFrmSerYear1TotDis': ['firm_type_name', 'tot_damages_pub', 'tot_damages_pvt'],
            'LosFrmIndTotDis': ['firm_type_name', 'los_year1_pub', 'los_year1_pvt', 'los_year2_pub', 'los_year2_pvt'],
            'LosFrmSerTotDis': ['firm_type_name', 'los_year1_pub', 'los_year1_pvt', 'los_year2_pub', 'los_year2_pvt'],
        },
        'Table_6': {
            'DmgTotFrmYear1SumProvince': ['tot_damages_pub', 'tot_damages_pvt'],
            'LosTotFrmSumProvince': ['los_year1_pub', 'los_year1_pvt', 'los_year2_pub', 'los_year2_pvt'],
            'DmgTotInfY1SumProvince': ['tot_damages_pvt'],
            'LosTotInfY1SumProvince': ['tot_los_year1_pvt'],
            'LosTotInfY2SumProvince': ['tot_los_year2_pvt'],
        },
        'Table_7': {
            'DmgTotFrmYear1SumNational': ['tot_damages_pub', 'tot_damages_pvt'],
            'DmgTotInfY1SumNational': ['tot_damages_pvt'],
            'LosTotFrmSumNational': ['los_year1_pub', 'los_year1_pvt', 'los_year2_pub', 'los_year2_pvt'],
            'LosTotInfY1SumNational': ['tot_los_year1_pvt'],
            'LosTotInfY2SumNational': ['tot_los_year2_pvt']
        },
    },
    'reports': {
        'Table_1': {
            'health': {
                'DmgHealthTot': ['tot_dmg'],
                'HealthTotPub': ['tot_pub'],
                'HealthTotPvt': ['tot_pvt'],
                'LosHealthTot': ['tot_loss'],
            },
            'education': {
                'DmgEducationTot': ['tot_dmg'],
                'EducationTotPub': ['tot_pub'],
                'EducationTotPvt': ['tot_pvt'],
                'LosEducationTot': ['tot_dmg'],
            },
            'mining': {
                'DmgMiningTot': ['tot_dmg'],
                'LosMiningTot': ['tot_loss'],
                'MiningTotPub': ['tot_pub'],
                'MiningTotPvt': ['tot_pvt'],
            },
            'other_government': {
                'DmgOthGovSerTot': ['tot_dmg'],
                'LosOthGovSerTot': ['tot_loss'],
                'OthGovSerTotPub': ['tot_pub'],
            },
            'transport_air': {
                'AirTransportationTotPub': ['tot_destroyed'],
                'AirTransportationTotPvt': ['tot_destroyed'],
                'DmgAirTransportationTot': ['tot_destroyed'],
                'LosAirTransportationTot': ['tot_los'],
            },
            'transport_land': {
                'DmgLandTransportationTot': ['damages'],
                'LandTransportationTotPub': ['damages'],
                'LandTransportationTotPvt': ['tot_damages_pvt'],
                'LosLandTransportationTot': ['loss'],
            },
            'transport_rail': {
                'DmgRailTransportationTot': ['tot_damages'],
                'LosRailTransportationTot': ['tot_los'],
                'RailTransportationTotPub': ['dmg_tot_pub'],
            },
            'transport_water': {
                'DmgWaterTransportationTot': ['tot_destroyed'],
                'LosWaterTransportationTot': ['tot_los'],
                'WaterTransportationTotPub': ['tot_destroyed'],
                'WaterTransportationTotPvt': ['tot_destroyed'],
            },
            'agri_agrarian': {
                'AgrarianTotPub': ['tot_damages_pub'],
                'AgrarianTotPvt': ['tot_damages_pub'],
                'DmgAgrarianTot': ['tot_damages'],
                'LosAgrarianTot': ['tot_damages']
            },
            'agri_fisheries': {
                'DmgFisheriesTot': ['tot_damages_pvt'],
                'FisheriesTotPub': ['tot_damages_pub'],
                'FisheriesTotPvt': ['tot_damages_pvt'],
                'LosFisheriesTot': ['los_year_2_pvt']
            },
            'agri_irrigation': {
                'DmgIrrigationTot': ['damages'],
                'IrrigationTotPub': ['tot_damages_pub'],
                'LosIrrigationTot': ['total_los']
            },
            'agri_livestock': {
                'DmgLivestockTot': ['tot_damages_pub'],
                'LivestockTotPub': ['tot_damages_pub'],
                'LivestockTotPvt': ['tot_damages_pvt'],
                'LosLivestockTot': ['tot_damages_pub']
            },
            'housing': {
                'DmgHousingTot': ['tot_dmg'],
                'LosHousingTot': ['tot_loss'],
                'HousingTotPvt': ['tot_pvt'],
            },
            'industry_services': {
                'DmgIndustryServicesTot': ['tot_damages_pub'],
                'IndustryServicesTotPub': ['tot_damages_pub'],
                'IndustryServicesTotPvt': ['tot_damages_pvt'],
                'LosIndustryServicesTot': ['tot_damages_pub'],
            },
            'power_supply': {
                'DmgPowerSupplyTot': ['tot_destroyed'],
                'LosPowerSupplyTot': ['tot_los'],
                'PowerSupplyTotPub': ['dmg_tot_pub'],
                'PowerSupplyTotPvt': ['dmg_tot_pvt'],
            },
            'telecommunication': {
                'CommunicationTotPub': ['tot_damages_pub'],
                'CommunicationTotPvt': ['tot_damages_pvt'],
                'DmgCommunicationTot': ['tot_damages'],
                'LosCommunicationTot': ['tot_los'],
            },
            'tourism': {
                'DmgTourismTot': ['tot_damages'],
                'LosTourismTot': ['tot_loss'],
                'TourismTotPub': ['tot_pub'],
                'TourismTotPvt': ['tot_pvt'],
            },
            'water_supply': {
                'DmgWaterSupplyTot': ['dmg_tot_pub'],
                'LosWaterSupplyTot': ['tot_los'],
                'WaterSupplyTotPub': ['tot_dmg_pub'],
            },
        },
        'Table_2': {
            'province': {
                'SumProvinceDmg': ['tot_dmg', 'province', 'name'],
                'SumProvinceLoss': ['tot_loss', 'province', 'name'],
                'SumProvincePub': ['tot_pub', 'province', 'name'],
                'SumProvincePvt': ['tot_pvt', 'province', 'name'],
            },
        }
    }
}

AUTH_USER_MODEL = 'users.MyUser'

AUTHENTICATION_BACKENDS = (
    'django.contrib.auth.backends.RemoteUserBackend',
    'django.contrib.auth.backends.ModelBackend',
)
