CREATE TABLE "plant" (
growregistry uuid NOT NULL,
growalias character varying NULL,
gencapmw numeric NULL,
initdate date NULL,
    PRIMARY KEY (growregistry)
);

First 3 rows:
growregistry                          growalias                     gencapmw  initdate
------------------------------------  --------------------------  ----------  ----------
34671e50-c3dc-4acb-af54-ccde16eb0ea6  Solar Plant West Davidport      257.58  2018-02-28
34d240f4-6ed9-43bc-b7a8-24b56fdd315a  Solar Plant Dillonmouth         437.71  2023-08-06
e00b3472-780b-490f-941b-a4f298882d7f  Solar Plant North Xavier        397.96  2022-06-18
...


CREATE TABLE "inverter" (
invertregistry character varying NOT NULL,
siteref uuid NULL,
invertmoment timestamp without time zone NULL,
inverttempc numeric NULL,
gridvolt numeric NULL,
gridfreqhz numeric NULL,
pwrqualidx numeric NULL,
power_metrics jsonb NULL,
    PRIMARY KEY (invertregistry),
    FOREIGN KEY (siteref) REFERENCES plant(growregistry)
);

First 3 rows:
invertregistry                        siteref                               invertmoment                  inverttempc    gridvolt    gridfreqhz    pwrqualidx  power_metrics
------------------------------------  ------------------------------------  --------------------------  -------------  ----------  ------------  ------------  -----------------------------------------------------------------------------------------
657d7976-fb98-45f4-a916-4315352d235d  657d7976-fb98-45f4-a916-4315352d235d  2022-07-14 06:51:30.052646           48.8       223.2         50.49         0.778  {'harmdistpct': 0.75, 'reacpwrkvar': 75.46, 'inverteffpct': 98.09, 'invertpowfac': 0.928}
7da8ce5b-0710-48ac-ae70-cfd4c2bda1fa  7da8ce5b-0710-48ac-ae70-cfd4c2bda1fa  2022-07-16 15:18:16.052646           30.3       225.3         49.95         0.714  {'harmdistpct': 0.89, 'reacpwrkvar': 80.82, 'inverteffpct': 98.78, 'invertpowfac': 0.988}
fa1e0808-8e5c-4044-bbaf-4a17fbad26f2  fa1e0808-8e5c-4044-bbaf-4a17fbad26f2  2016-08-02 03:08:36.052646           30.5       233.1         49.87         0.007  {'harmdistpct': 0.93, 'reacpwrkvar': 64.01, 'inverteffpct': 97.36, 'invertpowfac': 0.983}
...


CREATE TABLE "panel" (
panemark character varying NOT NULL,
hubregistry uuid NULL,
panemfr character varying NULL,
paneline character varying NULL,
panetype character varying NULL,
powratew smallint NULL,
paneeffpct numeric NULL,
nomtempc numeric NULL,
tempcoef numeric NULL,
    PRIMARY KEY (panemark),
    FOREIGN KEY (hubregistry) REFERENCES plant(growregistry)
);

First 3 rows:
panemark                              hubregistry                           panemfr    paneline    panetype      powratew    paneeffpct    nomtempc    tempcoef
------------------------------------  ------------------------------------  ---------  ----------  ----------  ----------  ------------  ----------  ----------
34671e50-c3dc-4acb-af54-ccde16eb0ea6  34671e50-c3dc-4acb-af54-ccde16eb0ea6  Longi      Model-102   Mono-PERC          650         20.86        45.7      -0.389
34d240f4-6ed9-43bc-b7a8-24b56fdd315a  34d240f4-6ed9-43bc-b7a8-24b56fdd315a  Longi      Model-892   HJT                650         21.65        45.5      -0.446
e00b3472-780b-490f-941b-a4f298882d7f  e00b3472-780b-490f-941b-a4f298882d7f  Longi      Model-677   Poly-PERC          450         21.93        46.7      -0.432
...


CREATE TABLE "alerts" (
alertreg character varying NOT NULL,
compreg uuid NULL,
deviceref character varying NULL,
incidentref character varying NULL,
alertmoment timestamp without time zone NULL,
alertstat character varying NULL,
alertcnt smallint NULL,
maintprior character varying NULL,
replaceprior character varying NULL,
optpotential character varying NULL,
    PRIMARY KEY (alertreg),
    FOREIGN KEY (compreg) REFERENCES plant(growregistry),
    FOREIGN KEY (deviceref) REFERENCES panel(panemark),
    FOREIGN KEY (incidentref) REFERENCES performance(perfregistry)
);

First 3 rows:
alertreg                              compreg                               deviceref                             incidentref                           alertmoment                 alertstat      alertcnt  maintprior    replaceprior    optpotential
------------------------------------  ------------------------------------  ------------------------------------  ------------------------------------  --------------------------  -----------  ----------  ------------  --------------  --------------
34671e50-c3dc-4acb-af54-ccde16eb0ea6  34671e50-c3dc-4acb-af54-ccde16eb0ea6  34671e50-c3dc-4acb-af54-ccde16eb0ea6  34671e50-c3dc-4acb-af54-ccde16eb0ea6  2018-08-03 12:21:20.051523                        6  High          High            Medium
34d240f4-6ed9-43bc-b7a8-24b56fdd315a  34d240f4-6ed9-43bc-b7a8-24b56fdd315a  34d240f4-6ed9-43bc-b7a8-24b56fdd315a  34d240f4-6ed9-43bc-b7a8-24b56fdd315a  2023-03-05 14:10:48.052345  Warning               2  High          High            High
e00b3472-780b-490f-941b-a4f298882d7f  e00b3472-780b-490f-941b-a4f298882d7f  e00b3472-780b-490f-941b-a4f298882d7f  e00b3472-780b-490f-941b-a4f298882d7f  2023-01-30 02:55:15.052451  Critical              9  High          High            Low
...


CREATE TABLE "performance" (
perfregistry character varying NOT NULL,
solmodref character varying NULL,
perfmoment timestamp without time zone NULL,
measpoww numeric NULL,
powlossw numeric NULL,
efficiency_profile jsonb NULL,
    PRIMARY KEY (perfregistry),
    FOREIGN KEY (solmodref) REFERENCES panel(panemark)
);

First 3 rows:
perfregistry                          solmodref                             perfmoment                    measpoww    powlossw  efficiency_profile
------------------------------------  ------------------------------------  --------------------------  ----------  ----------  --------------------------------------------------------------------------------------------------------------------------
61881c67-e019-431b-92f4-540d018ce556  61881c67-e019-431b-92f4-540d018ce556  2023-04-24 05:22:00.052646      587.22       12.78  {'degradation': {'cumdegpct': 2.13, 'anndegrate': 0.71}, 'current_efficiency': {'curreffpct': 19.36, 'efflosspct': 2.96}}
d0e8b043-26a7-44a0-92aa-8d8719e49e10  d0e8b043-26a7-44a0-92aa-8d8719e49e10  2020-12-10 14:06:40.053132      518.82       31.18  {'degradation': {'cumdegpct': 5.67, 'anndegrate': 1.01}, 'current_efficiency': {'curreffpct': 20.05, 'efflosspct': 1.28}}
e2324feb-31cd-417a-ba69-86c74e8e65c0  e2324feb-31cd-417a-ba69-86c74e8e65c0  2016-07-08 20:40:53.053213      384.03       65.97  {'degradation': {'cumdegpct': 14.66, 'anndegrate': 0.47}, 'current_efficiency': {'curreffpct': 19.53, 'efflosspct': 0.71}}
...


CREATE TABLE "electrical" (
elecregistry character varying NOT NULL,
engyunitref character varying NULL,
efflogref character varying NULL,
iscinita numeric NULL,
isccurra numeric NULL,
vocinitv numeric NULL,
voccurrv numeric NULL,
impinita numeric NULL,
impcurra numeric NULL,
vmpinitv numeric NULL,
vmpcurrv numeric NULL,
ffactorinit numeric NULL,
ffactorcurr numeric NULL,
seriesresohm numeric NULL,
shuntresohm numeric NULL,
    PRIMARY KEY (elecregistry),
    FOREIGN KEY (efflogref) REFERENCES performance(perfregistry),
    FOREIGN KEY (engyunitref) REFERENCES panel(panemark)
);

First 3 rows:
elecregistry                          engyunitref                           efflogref                               iscinita    isccurra    vocinitv    voccurrv    impinita    impcurra    vmpinitv    vmpcurrv    ffactorinit    ffactorcurr    seriesresohm    shuntresohm
------------------------------------  ------------------------------------  ------------------------------------  ----------  ----------  ----------  ----------  ----------  ----------  ----------  ----------  -------------  -------------  --------------  -------------
34671e50-c3dc-4acb-af54-ccde16eb0ea6  34671e50-c3dc-4acb-af54-ccde16eb0ea6  34671e50-c3dc-4acb-af54-ccde16eb0ea6        9.09        8.51       49.74       43.32        9.17        7.21       38.48       36.98          0.773          0.71            0.174          437.3
34d240f4-6ed9-43bc-b7a8-24b56fdd315a  34d240f4-6ed9-43bc-b7a8-24b56fdd315a  34d240f4-6ed9-43bc-b7a8-24b56fdd315a       10.85        8.41       45.3        43.1         9.93        7.3        38.25       36.73          0.775          0.788           0.349          880.7
e00b3472-780b-490f-941b-a4f298882d7f  e00b3472-780b-490f-941b-a4f298882d7f  e00b3472-780b-490f-941b-a4f298882d7f       10.78        9.03       46.07       43.28        8.47        8.05       37.87       36.78          0.836          0.706           0.995          703.9
...


CREATE TABLE "environment" (
envregistry character varying NOT NULL,
arearegistry uuid NULL,
envmoment timestamp without time zone NULL,
celltempc numeric NULL,
ambtempc numeric NULL,
soillosspct numeric NULL,
dustdengm2 numeric NULL,
cleancycledays smallint NULL,
lastcleandt date NULL,
relhumpct numeric NULL,
windspdms numeric NULL,
winddirdeg numeric NULL,
preciptmm numeric NULL,
airpresshpa numeric NULL,
uv_idx numeric NULL,
cloudcovpct numeric NULL,
snowcovpct numeric NULL,
irradiance_conditions jsonb NULL,
    PRIMARY KEY (envregistry),
    FOREIGN KEY (arearegistry) REFERENCES plant(growregistry)
);

First 3 rows:
envregistry                           arearegistry                          envmoment                     celltempc    ambtempc    soillosspct    dustdengm2    cleancycledays  lastcleandt      relhumpct    windspdms    winddirdeg    preciptmm    airpresshpa    uv_idx    cloudcovpct    snowcovpct  irradiance_conditions
------------------------------------  ------------------------------------  --------------------------  -----------  ----------  -------------  ------------  ----------------  -------------  -----------  -----------  ------------  -----------  -------------  --------  -------------  ------------  -----------------------------------------------------------------------
34671e50-c3dc-4acb-af54-ccde16eb0ea6  34671e50-c3dc-4acb-af54-ccde16eb0ea6  2018-08-03 12:21:20.051523         47.3        41.2          13.41         0.056                38  2025-01-14            76.1         11.6         249.3         41.3         1099.2       1.1           12.4          24.8  {'specmisfac': 1.005, 'irradiance_types': [530.4, 169.3, 44.1, 135.1]}
34d240f4-6ed9-43bc-b7a8-24b56fdd315a  34d240f4-6ed9-43bc-b7a8-24b56fdd315a  2023-03-05 14:10:48.052345         36.1        22.7          11.27         3.519                52  2025-01-23            50           22.6          29.8         36.2          958.3       3.6           93.8          59.7  {'specmisfac': 0.996, 'irradiance_types': [556.4, 686.2, 81.9, 500.1]}
e00b3472-780b-490f-941b-a4f298882d7f  e00b3472-780b-490f-941b-a4f298882d7f  2023-01-30 02:55:15.052451         59.2        26.2           1.12         3.3                  17  2025-02-05            98.5         18.3         179.3         18.1         1050.6       1.7           69.2          92.7  {'specmisfac': 1.047, 'irradiance_types': [637.1, 656.6, 71.4, 1155.0]}
...


CREATE TABLE "maintenance" (
maintregistry character varying NOT NULL,
powerref uuid NULL,
compref character varying NULL,
obsref character varying NULL,
inspectmeth character varying NULL,
inspectres character varying NULL,
inspectdate date NULL,
maintsched character varying NULL,
wtystatus character varying NULL,
wtyclaimcnt smallint NULL,
maintcostusd numeric NULL,
cleancostusd numeric NULL,
replacecostusd numeric NULL,
revlossusd numeric NULL,
    PRIMARY KEY (maintregistry),
    FOREIGN KEY (compref) REFERENCES panel(panemark),
    FOREIGN KEY (obsref) REFERENCES performance(perfregistry),
    FOREIGN KEY (powerref) REFERENCES plant(growregistry)
);

First 3 rows:
maintregistry                         powerref                              compref                               obsref                                inspectmeth    inspectres    inspectdate    maintsched    wtystatus      wtyclaimcnt    maintcostusd    cleancostusd    replacecostusd    revlossusd
------------------------------------  ------------------------------------  ------------------------------------  ------------------------------------  -------------  ------------  -------------  ------------  -----------  -------------  --------------  --------------  ----------------  ------------
34671e50-c3dc-4acb-af54-ccde16eb0ea6  34671e50-c3dc-4acb-af54-ccde16eb0ea6  34671e50-c3dc-4acb-af54-ccde16eb0ea6  34671e50-c3dc-4acb-af54-ccde16eb0ea6  Visual         Minor Issues  2024-08-24     Delayed       Claimed                  2          178.82         1034.89          31529.1        13375.6
34d240f4-6ed9-43bc-b7a8-24b56fdd315a  34d240f4-6ed9-43bc-b7a8-24b56fdd315a  34d240f4-6ed9-43bc-b7a8-24b56fdd315a  34d240f4-6ed9-43bc-b7a8-24b56fdd315a  IR Thermal     Major Issues  2024-12-23     Overdue       Active                   4         9549.83         2957.08          15984.1        17065.2
e00b3472-780b-490f-941b-a4f298882d7f  e00b3472-780b-490f-941b-a4f298882d7f  e00b3472-780b-490f-941b-a4f298882d7f  e00b3472-780b-490f-941b-a4f298882d7f  Visual         Major Issues  2025-01-30     Overdue       Claimed                  2         9298.61         1934.67           3604.59       14035.9
...
