CREATE TABLE "observatories" (
observstation character NOT NULL,
weathprofile character varying NULL,
seeingprofile character varying NULL,
atmostransparency numeric NULL,
lunarstage character varying NULL,
lunardistdeg numeric NULL,
solarstatus character varying NULL,
geomagstatus character varying NULL,
sidereallocal character NULL,
airtempc numeric NULL,
humidityrate numeric NULL,
windspeedms numeric NULL,
presshpa numeric NULL,
    PRIMARY KEY (observstation)
);

First 3 rows:
observstation                weathprofile    seeingprofile      atmostransparency  lunarstage       lunardistdeg  solarstatus    geomagstatus      sidereallocal    airtempc    humidityrate    windspeedms    presshpa
---------------------------  --------------  ---------------  -------------------  -------------  --------------  -------------  --------------  ---------------  ----------  --------------  -------------  ----------
Observatory-East Darrenport  Clear           Good                            0.04  First Quarter          125.94  High           Quiet                   17.2762        37.6            21.5           26.7      1028
Observatory-Pearsonstad      Clear           Poor                            0.25  Full                   100.56  Low            Quiet                   17.5804       -16.9            67.7           22        1022.3
Observatory-New Lindastad    Cloudy          Good                            0.21  Last Quarter            98.09  High           Storm                   10.9481       -12.5            25.7            4.4      1011
...


CREATE TABLE "signaldynamics" (
signalref character NOT NULL,
sigintegrity character varying NULL,
sigrecurr character varying NULL,
sigevolve character varying NULL,
tempstab character varying NULL,
spatstab character varying NULL,
freqstab character varying NULL,
phasestab character varying NULL,
ampstab character varying NULL,
modstab character varying NULL,
sigcoherence character varying NULL,
sigdisp character varying NULL,
sigscint character varying NULL,
    PRIMARY KEY (signalref),
    FOREIGN KEY (signalref) REFERENCES signals(signalregistry)
);

First 3 rows:
No data available in this table.


CREATE TABLE "telescopes" (
telescregistry character NOT NULL,
observstation character NOT NULL,
equipstatus character varying NULL,
calibrstatus character varying NULL,
pointaccarc numeric NULL,
trackaccarc numeric NULL,
focusquality character varying NULL,
detecttempk numeric NULL,
coolsysstatus character varying NULL,
powerstatus character varying NULL,
datastorstatus character varying NULL,
netstatus character varying NULL,
bandusagepct numeric NULL,
procqueuestatus character varying NULL,
    PRIMARY KEY (telescregistry),
    FOREIGN KEY (observstation) REFERENCES observatories(observstation)
);

First 3 rows:
telescregistry    observstation                equipstatus    calibrstatus      pointaccarc    trackaccarc  focusquality      detecttempk  coolsysstatus    powerstatus    datastorstatus    netstatus       bandusagepct  procqueuestatus
----------------  ---------------------------  -------------  --------------  -------------  -------------  --------------  -------------  ---------------  -------------  ----------------  ------------  --------------  -----------------
T4621             Observatory-East Darrenport  Operational    Current                  3.85           5.47  Poor                   227.34  Critical         Main           Available         Limited                 77.2  Full
T3182             Observatory-Pearsonstad      Degraded       Due                      3.96           1.58  Good                    94.66  Warning          Backup         Available         Disconnected             8.5  Empty
T6585             Observatory-New Lindastad    Degraded       Current                  6.93           9.4   Good                   233.2   Normal           Main           Available         Disconnected            48.2  Normal
...


CREATE TABLE "researchprocess" (
signalref character NOT NULL,
analysisprio text NULL,
followstat character varying NULL,
peerrevstat character varying NULL,
pubstat character NULL,
resprio character varying NULL,
fundstat character NULL,
collabstat character NULL,
secclass character NULL,
discstat character varying NULL,
notesmemo text NULL,
    PRIMARY KEY (signalref),
    FOREIGN KEY (signalref) REFERENCES signals(signalregistry)
);

First 3 rows:
signalref    analysisprio    followstat    peerrevstat    pubstat    resprio    fundstat    collabstat     secclass    discstat    notesmemo
-----------  --------------  ------------  -------------  ---------  ---------  ----------  -------------  ----------  ----------  ----------------------------------------
AS796980     Low             Completed     Completed      Submitted  Medium     Unfunded    International  Classified
AS745021     Medium          Completed     In Progress    Published  Low        Pending     Team           Public      Full
AS499555     Urgent          Scheduled     Completed      Published  High       Pending     Solo           Classified              While why recognize what probably sport.
...


CREATE TABLE "signals" (
signalregistry character NOT NULL,
timemark timestamp with time zone NULL,
telescref character NOT NULL,
detectinstr character varying NULL,
signalclass character varying NULL,
sigstrdb numeric NULL,
freqmhz numeric NULL,
bwhz numeric NULL,
centerfreqmhz numeric NULL,
freqdrifthzs numeric NULL,
doppshifthz double precision NULL,
sigdursec numeric NULL,
pulsepersec numeric NULL,
pulsewidms numeric NULL,
modtype character varying NULL,
modindex numeric NULL,
carrierfreqmhz numeric NULL,
phaseshiftdeg numeric NULL,
polarmode character varying NULL,
polarangledeg numeric NULL,
snrratio numeric NULL,
noisefloordbm double precision NULL,
interflvl character varying NULL,
rfistat character varying NULL,
atmointerf character varying NULL,
    PRIMARY KEY (signalregistry),
    FOREIGN KEY (telescref) REFERENCES telescopes(telescregistry)
);

First 3 rows:
signalregistry    timemark                          telescref    detectinstr        signalclass      sigstrdb    freqmhz    bwhz    centerfreqmhz    freqdrifthzs    doppshifthz    sigdursec    pulsepersec    pulsewidms  modtype      modindex    carrierfreqmhz    phaseshiftdeg  polarmode      polarangledeg    snrratio    noisefloordbm  interflvl    rfistat       atmointerf
----------------  --------------------------------  -----------  -----------------  -------------  ----------  ---------  ------  ---------------  --------------  -------------  -----------  -------------  ------------  ---------  ----------  ----------------  ---------------  -----------  ---------------  ----------  ---------------  -----------  ------------  ------------
AS796980          2021-04-16 13:21:19.864197+08:00  T4621        Quantum Detector   Narrowband        -186.96    95636.3  401.34          4363.09           0.072         143.65      2660.7           4.286        480.95  FM              0.384           65710.4           268.84  Unknown                127.4       26.19          -140.27  High         Unknown       Severe
AS745021          2022-06-15 16:04:26.868816+08:00  T3182        Optical Telescope  Broadband         -154.72    43019.4  316.03         82505.9            2.204         777.42      3513.05          9.047        695.24  Unknown         0.532           81576.6           343.61  Linear                  16.4       18.01          -105.55  High         Contaminated  Moderate
AS499555          2019-01-18 07:53:35.868816+08:00  T6585        Radio Telescope    Modulated         -111.19    28682.2  563.64          6161.35           5.668        -665.39      1627.84          1.072          6.78  Unknown         0.893           52348.2           339.52  Elliptical             119.6       20.82          -128.04  High         Unknown       Moderate
...


CREATE TABLE "observationalconditions" (
signalref character NOT NULL,
obstime time without time zone NULL,
obsdate date NULL,
obsdurhrs numeric NULL,
    PRIMARY KEY (signalref),
    FOREIGN KEY (signalref) REFERENCES signals(signalregistry)
);

First 3 rows:
signalref    obstime    obsdate       obsdurhrs
-----------  ---------  ----------  -----------
AS796980     00:00:00   2018-11-27        22.04
AS745021     00:00:00   2024-09-02         2.35
AS499555     00:00:00   2023-03-15         6.88
...


CREATE TABLE "signalprobabilities" (
signalref character NOT NULL,
falseposprob numeric NULL,
sigunique numeric NULL,
simindex numeric NULL,
corrscore numeric NULL,
anomscore double precision NULL,
techsigprob numeric NULL,
biosigprob numeric NULL,
natsrcprob numeric NULL,
artsrcprob numeric NULL,
    PRIMARY KEY (signalref),
    FOREIGN KEY (signalref) REFERENCES signals(signalregistry)
);

First 3 rows:
signalref      falseposprob    sigunique    simindex    corrscore    anomscore    techsigprob    biosigprob    natsrcprob    artsrcprob
-----------  --------------  -----------  ----------  -----------  -----------  -------------  ------------  ------------  ------------
AS796980              0.033        0.73        0.198        0.937        0.941          0.317          0.88         0.574           0.1
AS745021              0.758        0.744       0.986       -0.109        0.488          0.179          0            0.14            0.9
AS499555              0.467        0.301       0.803        0.333        0.139          0.273          0.33         0.226           0.8
...


CREATE TABLE "sourceproperties" (
signalref character NOT NULL,
sourceradeg numeric NULL,
sourcedecdeg numeric NULL,
sourcedistly numeric NULL,
gallong numeric NULL,
gallat numeric NULL,
celestobj character varying NULL,
objtype character varying NULL,
objmag numeric NULL,
objtempk integer NULL,
objmasssol numeric NULL,
objagegyr numeric NULL,
objmetal numeric NULL,
objpropmotion numeric NULL,
objradvel numeric NULL,
    PRIMARY KEY (signalref),
    FOREIGN KEY (signalref) REFERENCES signals(signalregistry)
);

First 3 rows:
No data available in this table.


CREATE TABLE "signaladvancedphenomena" (
signalref character NOT NULL,
intermedeffects character varying NULL,
gravlens character varying NULL,
quanteffects character varying NULL,
encryptevid character varying NULL,
langstruct text NULL,
msgcontent text NULL,
cultsig character varying NULL,
sciimpact character varying NULL,
    PRIMARY KEY (signalref),
    FOREIGN KEY (signalref) REFERENCES signals(signalregistry)
);

First 3 rows:
signalref    intermedeffects    gravlens    quanteffects    encryptevid    langstruct    msgcontent    cultsig    sciimpact
-----------  -----------------  ----------  --------------  -------------  ------------  ------------  ---------  -----------
AS796980     Severe             Weak        Significant     Strong         Complex       Identified    High       Major
AS745021     Minimal                        Significant     Strong         Simple                                 Major
AS499555     Minimal            Weak                        Strong         Simple        Possible                 Major
...


CREATE TABLE "signalclassification" (
signalref character NOT NULL,
sigclasstype character varying NULL,
sigpattern character varying NULL,
repeatcount smallint NULL,
periodsec numeric NULL,
complexidx numeric NULL,
entropyval numeric NULL,
infodense numeric NULL,
classconf numeric NULL,
    PRIMARY KEY (signalref),
    FOREIGN KEY (signalref) REFERENCES signals(signalregistry)
);

First 3 rows:
No data available in this table.


CREATE TABLE "signaldecoding" (
signalref character NOT NULL,
encodetype character varying NULL,
compressratio numeric NULL,
errcorrlvl character varying NULL,
decodeconf numeric NULL,
decodemethod character varying NULL,
decodestat character varying NULL,
decodeiters smallint NULL,
proctimehrs numeric NULL,
compresources character varying NULL,
analysisdp character varying NULL,
veriflvl character varying NULL,
confirmstat character varying NULL,
    PRIMARY KEY (signalref),
    FOREIGN KEY (signalref) REFERENCES signals(signalregistry)
);

First 3 rows:
signalref    encodetype      compressratio  errcorrlvl      decodeconf  decodemethod    decodestat      decodeiters    proctimehrs  compresources    analysisdp     veriflvl    confirmstat
-----------  ------------  ---------------  ------------  ------------  --------------  ------------  -------------  -------------  ---------------  -------------  ----------  -------------
AS796980     Unknown                  5.03  Medium                98.6  Wavelet         Completed               103         193.8   High             Comprehensive  Partially   Pending
AS745021     Unknown                  1.28  Medium                76.3  FFT             In Progress             684         276.22  Low              Detailed       Partially   Confirmed
AS499555     Unknown                  9.2   Low                   25.6  FFT             Completed               486         796.01  High             Comprehensive  Unverified  Pending
...
