CREATE TABLE "beneficiariesandassessments" (
beneregistry character varying NOT NULL,
benedistref character varying NULL,
beneopsref character varying NULL,
beneregister USER-DEFINED NULL,
vulnerabilityreview USER-DEFINED NULL,
needsassessstatus USER-DEFINED NULL,
distequityidx numeric NULL,
benefeedbackscore numeric NULL,
commengagelvl USER-DEFINED NULL,
localcapacitygrowth USER-DEFINED NULL,
    PRIMARY KEY (beneregistry),
    FOREIGN KEY (benedistref) REFERENCES disasterevents(distregistry),
    FOREIGN KEY (beneopsref) REFERENCES operations(opsregistry)
);

First 3 rows:
beneregistry    benedistref    beneopsref    beneregister    vulnerabilityreview    needsassessstatus      distequityidx    benefeedbackscore  commengagelvl    localcapacitygrowth
--------------  -------------  ------------  --------------  ---------------------  -------------------  ---------------  -------------------  ---------------  ---------------------
BENE_4NZJ       DIST_SB6K7     OPS_76ZOW     Complete        Complete               Due                             0.54                  2.3  High             Limited
BENE_FJSN       DIST_PGACZ     OPS_QXWBZ     Pending         Complete               Overdue                         0.87                  1.3  Low              Limited
BENE_RCD9       DIST_HJ1BQ     OPS_GGBVJ     Complete        Pending                Overdue                         0.88                  1.5  Medium           Active
...


CREATE TABLE "disasterevents" (
distregistry character varying NOT NULL,
timemark timestamp without time zone NOT NULL,
haztype USER-DEFINED NOT NULL,
hazlevel USER-DEFINED NULL,
affectedarea character varying NULL,
regiontag character NULL,
latcoord numeric NULL,
loncoord numeric NULL,
impactmetrics jsonb NULL,
    PRIMARY KEY (distregistry)
);

First 3 rows:
distregistry    timemark                    haztype     hazlevel    affectedarea      regiontag      latcoord    loncoord  impactmetrics
--------------  --------------------------  ----------  ----------  ----------------  -----------  ----------  ----------  ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
DIST_SB6K7      2024-12-21 19:49:09.720370  Wildfire    Level 3     East Jeremy       RC7250          51.2036     36.2211  {'population': {'injured': 4524, 'missing': 212, 'affected': 228943, 'displaced': 38806, 'casualties': 174}, 'damage_level': 'Severe', 'communication': 'Limited', 'infrastructure': {'damage_percent': 19.0, 'power_outage_percent': 93.2, 'water_damage_percent': 77}, 'transportation': 'Full'}
DIST_PGACZ      2024-03-13 16:56:26.720370  Earthquake  Level 5     Lake Mariah       RC2170         -89.8906     62.0815  {'population': {'injured': 4304, 'missing': 363, 'affected': 241273, 'displaced': 31578, 'casualties': 8}, 'damage_level': 'Moderate', 'communication': 'Operational', 'infrastructure': {'damage_percent': 68.9, 'power_outage_percent': 22.5, 'water_damage_percent': 40}, 'transportation': 'Full'}
DIST_HJ1BQ      2024-12-08 06:09:09.720370  Earthquake  Level 5     New Kellychester  RC8678          80.0269   -146.007   {'population': {'injured': 4333, 'missing': 222, 'affected': 389569, 'displaced': 66484, 'casualties': 355}, 'damage_level': 'Minor', 'communication': 'Limited', 'infrastructure': {'damage_percent': 79.7, 'power_outage_percent': 83.8, 'water_damage_percent': 27}, 'transportation': 'Limited'}
...


CREATE TABLE "distributionhubs" (
hubregistry character varying NOT NULL,
disteventref character varying NULL,
hubcaptons numeric NULL,
hubutilpct numeric NULL,
storecapm3 numeric NULL,
storeavailm3 numeric NULL,
coldstorecapm3 numeric NULL,
coldstoretempc numeric NULL,
warehousestate USER-DEFINED NULL,
invaccpct numeric NULL,
stockturnrate numeric NULL,
    PRIMARY KEY (hubregistry),
    FOREIGN KEY (disteventref) REFERENCES disasterevents(distregistry)
);

First 3 rows:
hubregistry    disteventref      hubcaptons    hubutilpct    storecapm3    storeavailm3    coldstorecapm3    coldstoretempc  warehousestate      invaccpct    stockturnrate
-------------  --------------  ------------  ------------  ------------  --------------  ----------------  ----------------  ----------------  -----------  ---------------
HUB_HS0I       DIST_SB6K7              5101           9.4         93293            7279               249               6.6  Fair                     91.3             3.31
HUB_UGZM       DIST_PGACZ              1825          52.3         45603            9050               151               5.9  Excellent                98.4             0.63
HUB_05ZL       DIST_HJ1BQ              7553          79.7          2908            9396               395               4    Good                     92.9             1.14
...


CREATE TABLE "environmentandhealth" (
envhealthregistry character varying NOT NULL,
envdistref character varying NULL,
envimpactrate USER-DEFINED NULL,
wastemanagementstate USER-DEFINED NULL,
recyclepct numeric NULL,
carbontons numeric NULL,
renewenergypct numeric NULL,
waterqualityindex numeric NULL,
sanitationcoverage numeric NULL,
diseaserisk USER-DEFINED NULL,
medicalemergencycapacity USER-DEFINED NULL,
vaccinationcoverage numeric NULL,
mentalhealthaid USER-DEFINED NULL,
    PRIMARY KEY (envhealthregistry),
    FOREIGN KEY (envdistref) REFERENCES disasterevents(distregistry)
);

First 3 rows:
envhealthregistry    envdistref    envimpactrate    wastemanagementstate      recyclepct    carbontons    renewenergypct    waterqualityindex    sanitationcoverage  diseaserisk    medicalemergencycapacity      vaccinationcoverage  mentalhealthaid
-------------------  ------------  ---------------  ----------------------  ------------  ------------  ----------------  -------------------  --------------------  -------------  --------------------------  ---------------------  -----------------
ENV_XU4H             DIST_SB6K7    Low              Adequate                        68.4         793.5              43.3                 85.6                  53.5  High           Adequate                                     14.8  Limited
ENV_NO2C             DIST_PGACZ    Low              Adequate                        62.4         403.3              27.5                 90.9                  65.5  High           Critical                                     77.7  Available
ENV_U9JR             DIST_HJ1BQ    High             Adequate                        18.1         270.2              27.7                 11.7                   6.6  Medium         Adequate                                     24.6  Limited
...


CREATE TABLE "operations" (
opsregistry character varying NOT NULL,
opsdistref character varying NULL,
opshubref character varying NULL,
emerglevel USER-DEFINED NULL,
respphase USER-DEFINED NULL,
opsstatus USER-DEFINED NULL,
coordcenter character varying NULL,
opsstartdate date NULL,
estdurationdays integer NULL,
priorityrank USER-DEFINED NULL,
resourceallocstate USER-DEFINED NULL,
supplyflowstate USER-DEFINED NULL,
    PRIMARY KEY (opsregistry),
    FOREIGN KEY (opsdistref) REFERENCES disasterevents(distregistry),
    FOREIGN KEY (opshubref) REFERENCES distributionhubs(hubregistry)
);

First 3 rows:
opsregistry    opsdistref    opshubref    emerglevel    respphase       opsstatus     coordcenter    opsstartdate      estdurationdays  priorityrank    resourceallocstate    supplyflowstate
-------------  ------------  -----------  ------------  --------------  ------------  -------------  --------------  -----------------  --------------  --------------------  -----------------
OPS_76ZOW      DIST_SB6K7    HUB_HS0I     Black         Reconstruction  Completed     CC7649         2025-01-26                     12  High            Limited               Disrupted
OPS_QXWBZ      DIST_PGACZ    HUB_UGZM     Black         Recovery        Completed     CC6010         2025-02-08                    362  Medium          Limited               Stable
OPS_GGBVJ      DIST_HJ1BQ    HUB_05ZL     Orange        Emergency       Scaling Down  CC3314         2025-02-17                    291  Medium          Critical              Strained
...


CREATE TABLE "coordinationandevaluation" (
coordevalregistry character varying NOT NULL,
coorddistref character varying NULL,
coordopsref character varying NULL,
secincidentcount integer NULL,
safetyranking USER-DEFINED NULL,
accesslimitation USER-DEFINED NULL,
coordeffectlvl USER-DEFINED NULL,
partnerorgs text NULL,
infosharingstate USER-DEFINED NULL,
reportcompliance numeric NULL,
dataqualityvalue integer NULL,
monitoringfreq USER-DEFINED NULL,
evaluationstage USER-DEFINED NULL,
lessonslearnedstage USER-DEFINED NULL,
contingencyplanstage USER-DEFINED NULL,
riskmitigationsteps USER-DEFINED NULL,
insurancescope USER-DEFINED NULL,
compliancestate USER-DEFINED NULL,
auditstate USER-DEFINED NULL,
qualitycontrolsteps USER-DEFINED NULL,
stakeholdersatisf numeric NULL,
mediacoversentiment USER-DEFINED NULL,
publicperception numeric NULL,
documentationstate USER-DEFINED NULL,
lessonsrecorded text NULL,
bestpracticeslisted text NULL,
improvementrecs text NULL,
nextreviewdate date NULL,
notes text NULL,
    PRIMARY KEY (coordevalregistry),
    FOREIGN KEY (coorddistref) REFERENCES disasterevents(distregistry),
    FOREIGN KEY (coordopsref) REFERENCES operations(opsregistry)
);

First 3 rows:
coordevalregistry    coorddistref    coordopsref      secincidentcount  safetyranking    accesslimitation    coordeffectlvl      partnerorgs  infosharingstate      reportcompliance    dataqualityvalue  monitoringfreq    evaluationstage    lessonslearnedstage    contingencyplanstage    riskmitigationsteps    insurancescope    compliancestate    auditstate    qualitycontrolsteps      stakeholdersatisf  mediacoversentiment      publicperception  documentationstate      lessonsrecorded    bestpracticeslisted    improvementrecs  nextreviewdate    notes
-------------------  --------------  -------------  ------------------  ---------------  ------------------  ----------------  -------------  ------------------  ------------------  ------------------  ----------------  -----------------  ---------------------  ----------------------  ---------------------  ----------------  -----------------  ------------  ---------------------  -------------------  ---------------------  ------------------  --------------------  -----------------  ---------------------  -----------------  ----------------  -------------------------------------------------------
COORD_D3PK           DIST_SB6K7      OPS_76ZOW                      83  Safe             Partial             Medium                        9  Poor                              91                     4  Monthly           Overdue            In Progress            Overdue                 Insufficient           Full              Partial            Completed     Moderate                               4    Positive                              3.5  Partial                               5                      2                 25  2025-04-22        Record item between direction program media bed across.
COORD_Z5NY           DIST_PGACZ      OPS_QXWBZ                      45  Safe             Partial             Low                          36  Limited                           77.4                   3  Daily             Overdue            Documented             Due                     Insufficient           Partial           Partial            Due           Moderate                               2.1  Positive                              1.5  Partial                              22                      4                 16  2025-03-09
COORD_67A3           DIST_HJ1BQ      OPS_GGBVJ                      49  Moderate         Severe              Low                          21  Limited                           77.1                   4  Monthly           Due                Pending                Overdue                 Partial                Full              Partial            Completed     Strong                                 3.8  Neutral                               2.1  Incomplete                           19                      4                 26  2025-07-05        Recent discuss part seven fact.
...


CREATE TABLE "humanresources" (
hrregistry character varying NOT NULL,
hrdistref character varying NULL,
hropsref character varying NULL,
staffingprofile jsonb NULL,
    PRIMARY KEY (hrregistry),
    FOREIGN KEY (hrdistref) REFERENCES disasterevents(distregistry),
    FOREIGN KEY (hropsref) REFERENCES operations(opsregistry)
);

First 3 rows:
hrregistry    hrdistref    hropsref    staffingprofile
------------  -----------  ----------  -----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
HR_HV7U       DIST_SB6K7   OPS_76ZOW   {'personnel': {'total': 140, 'medical': 52, 'security': 90, 'logistics': 99, 'volunteers': 435}, 'readiness': {'ppe_status': 'Limited', 'comm_equipment': 'Sufficient', 'training_status': 'Complete', 'availability_percent': 94.1}}
HR_ZZXC       DIST_PGACZ   OPS_QXWBZ   {'personnel': {'total': 55, 'medical': 30, 'security': 53, 'logistics': 197, 'volunteers': 541}, 'readiness': {'ppe_status': 'Critical', 'comm_equipment': 'Sufficient', 'training_status': 'In Progress', 'availability_percent': 87.7}}
HR_JA87       DIST_HJ1BQ   OPS_GGBVJ   {'personnel': {'total': 234, 'medical': 38, 'security': 46, 'logistics': 93, 'volunteers': 781}, 'readiness': {'ppe_status': 'Adequate', 'comm_equipment': 'Sufficient', 'training_status': 'In Progress', 'availability_percent': 82.5}}
...


CREATE TABLE "supplies" (
supplyregistry character varying NOT NULL,
supplydistref character varying NULL,
supplyhubref character varying NULL,
resourceinventory jsonb NULL,
    PRIMARY KEY (supplyregistry),
    FOREIGN KEY (supplydistref) REFERENCES disasterevents(distregistry),
    FOREIGN KEY (supplyhubref) REFERENCES distributionhubs(hubregistry)
);

First 3 rows:
supplyregistry    supplydistref    supplyhubref    resourceinventory
----------------  ---------------  --------------  ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
SUP_4BZN3         DIST_SB6K7       HUB_HS0I        {'power': {'generators': 568, 'fuel_liters': 86011.0}, 'medical': 50590, 'shelter': {'units': 7534, 'blankets': 46019}, 'essentials': {'food_tons': 479.4, 'water_liters': 283596.0}, 'hygiene_kits': 46981}
SUP_ZJ88H         DIST_PGACZ       HUB_UGZM        {'power': {'generators': 733, 'fuel_liters': 59156.0}, 'medical': 51298, 'shelter': {'units': 1968, 'blankets': 26671}, 'essentials': {'food_tons': 187.1, 'water_liters': 139603.0}, 'hygiene_kits': 99277}
SUP_MCBWM         DIST_HJ1BQ       HUB_05ZL        {'power': {'generators': 881, 'fuel_liters': 46825.0}, 'medical': 15593, 'shelter': {'units': 6390, 'blankets': 78690}, 'essentials': {'food_tons': 640.8, 'water_liters': 878396.0}, 'hygiene_kits': 31061}
...


CREATE TABLE "transportation" (
transportregistry character varying NOT NULL,
transportdistref character varying NULL,
transporthubref character varying NULL,
transportsupref character varying NULL,
vehiclecount integer NULL,
trucksavailable integer NULL,
helosavailable integer NULL,
boatsavailable bigint NULL,
totaldeliverytons numeric NULL,
dailydeliverytons numeric NULL,
lastmilestatus USER-DEFINED NULL,
distributionpoints integer NULL,
avgdeliveryhours numeric NULL,
deliverysuccessrate numeric NULL,
routeoptstatus USER-DEFINED NULL,
fuelefficiencylpk numeric NULL,
maintenancestate USER-DEFINED NULL,
vehiclebreakrate numeric NULL,
    PRIMARY KEY (transportregistry),
    FOREIGN KEY (transportdistref) REFERENCES disasterevents(distregistry),
    FOREIGN KEY (transporthubref) REFERENCES distributionhubs(hubregistry),
    FOREIGN KEY (transportsupref) REFERENCES supplies(supplyregistry)
);

First 3 rows:
transportregistry    transportdistref    transporthubref    transportsupref      vehiclecount    trucksavailable    helosavailable    boatsavailable    totaldeliverytons    dailydeliverytons  lastmilestatus      distributionpoints    avgdeliveryhours    deliverysuccessrate  routeoptstatus      fuelefficiencylpk  maintenancestate      vehiclebreakrate
-------------------  ------------------  -----------------  -----------------  --------------  -----------------  ----------------  ----------------  -------------------  -------------------  ----------------  --------------------  ------------------  ---------------------  ----------------  -------------------  ------------------  ------------------
TRANS_B6EA6          DIST_SB6K7          HUB_HS0I           SUP_4BZN3                     141                 88                 7                 7                  368                  227  On Track                            35                52.6                   79.4  In Progress                      10.6  Overdue                            9.2
TRANS_0870R          DIST_PGACZ          HUB_UGZM           SUP_ZJ88H                      50                 87                 8                 2                 2771                  364  On Track                            14                20.7                   92.6  Optimized                        17.7  Overdue                            6.9
TRANS_FGSRQ          DIST_HJ1BQ          HUB_05ZL           SUP_MCBWM                      20                 77                 4                 4                 1505                  150  Delayed                              6                17.8                   79.9  Optimized                        18.7  Up to Date                         5
...


CREATE TABLE "financials" (
financeregistry character varying NOT NULL,
findistref character varying NULL,
finopsref character varying NULL,
budgetallotusd numeric NULL,
fundsutilpct numeric NULL,
costbeneusd numeric NULL,
opscostsusd numeric NULL,
transportcostsusd integer NULL,
storagecostsusd numeric NULL,
personnelcostsusd numeric NULL,
fundingstate USER-DEFINED NULL,
donorcommitmentsusd numeric NULL,
resourcegapsusd integer NULL,
    PRIMARY KEY (financeregistry),
    FOREIGN KEY (findistref) REFERENCES disasterevents(distregistry),
    FOREIGN KEY (finopsref) REFERENCES operations(opsregistry)
);

First 3 rows:
financeregistry    findistref    finopsref      budgetallotusd    fundsutilpct    costbeneusd    opscostsusd    transportcostsusd    storagecostsusd    personnelcostsusd  fundingstate      donorcommitmentsusd    resourcegapsusd
-----------------  ------------  -----------  ----------------  --------------  -------------  -------------  -------------------  -----------------  -------------------  --------------  ---------------------  -----------------
FIN_OMQ1           DIST_SB6K7    OPS_76ZOW         4.22709e+06             9.8         844.12          88256               976202             111548               364821  Critical                  7.69918e+06              95367
FIN_W50I           DIST_PGACZ    OPS_QXWBZ         3.62534e+06            35            18.76         919777                77922             272650               470856  Adequate                  4.06898e+06             442493
FIN_5B9D           DIST_HJ1BQ    OPS_GGBVJ         7.98724e+06            42.5         837.72         594338               811935             492222               906025  Adequate                  6.77819e+06             426146
...
