CREATE TABLE "testsessions" (
sessionregistry character varying NOT NULL,
stampmoment timestamp without time zone NOT NULL,
devscope USER-DEFINED NULL,
cpuusepct numeric NULL,
memusemb integer NULL,
driverstatus USER-DEFINED NULL,
fwupdur smallint NULL,
wlsignal numeric NULL,
battlevel smallint NULL,
battcapmah integer NULL,
battlifeh numeric NULL,
chgtimemin numeric NULL,
qchgflag boolean NULL,
usbpwrline character varying NULL,
latms numeric NULL,
inplagms numeric NULL,
pollratehz smallint NULL,
dbtimems numeric NULL,
resptimems numeric NULL,
clkregms numeric NULL,
    PRIMARY KEY (sessionregistry)
);

First 3 rows:
sessionregistry    stampmoment                 devscope      cpuusepct    memusemb  driverstatus      fwupdur    wlsignal    battlevel    battcapmah    battlifeh    chgtimemin  qchgflag    usbpwrline      latms    inplagms    pollratehz    dbtimems    resptimems    clkregms
-----------------  --------------------------  ----------  -----------  ----------  --------------  ---------  ----------  -----------  ------------  -----------  ------------  ----------  ------------  -------  ----------  ------------  ----------  ------------  ----------
GPT287164          2024-09-26 17:36:53.795502  Keyboard           3.14          78  Stable                202      -67              33          1939           38           150  True        7.5W             3.35        9.94          1000        2.28          2.53       0.827
GPT831546          2024-11-26 19:47:28.795502  Headset            4.15          27  Beta                   93       80.62            9          1115           54            64  True        5W              12.61        5.98           125        9.11          1.39       1.138
GPT573068          2024-10-12 10:19:04.795502  Keyboard           4.04          81  Experimental           79       71.61           17          1026           84            76  False       10W              5.24        1.15          1000        0.14          3.59       1.656
...


CREATE TABLE "interactionandcontrol" (
interactregistry character varying NOT NULL,
interactphysref character varying NOT NULL,
interactdevref character varying NOT NULL,
amblight boolean NULL,
tempsense boolean NULL,
accelsense boolean NULL,
gyrosense boolean NULL,
hapfeed character varying NULL,
hapstr smallint NULL,
vibmodes smallint NULL,
forcefeed character varying NULL,
trigres smallint NULL,
trigtravmm numeric NULL,
joydead numeric NULL,
joyprec numeric NULL,
btnspcmm numeric NULL,
btnszmm numeric NULL,
dpadvar character varying NULL,
dpadacc numeric NULL,
astickvar character varying NULL,
driftres numeric NULL,
    PRIMARY KEY (interactregistry),
    FOREIGN KEY (interactdevref) REFERENCES deviceidentity(devregistry),
    FOREIGN KEY (interactphysref) REFERENCES physicaldurability(physregistry)
);

First 3 rows:
interactregistry    interactphysref    interactdevref    amblight    tempsense    accelsense    gyrosense    hapfeed      hapstr    vibmodes  forcefeed      trigres    trigtravmm    joydead    joyprec    btnspcmm    btnszmm  dpadvar      dpadacc  astickvar      driftres
------------------  -----------------  ----------------  ----------  -----------  ------------  -----------  ---------  --------  ----------  -----------  ---------  ------------  ---------  ---------  ----------  ---------  ---------  ---------  -----------  ----------
INT_X42CX3          PHYS_GHOT80        DEV_RQ33OK        True        True         False         True         Basic             4           5  Advanced             7           7.1       0.11       94.9         4.8       17.5  Hybrid          95.2  Standard           98.5
INT_UHLDYQ          PHYS_3F7AUT        DEV_UPPRRQ        False       True         False         False        Advanced          4           4  None                10           7.2       0.19       94.4         2.5       16.7  Standard        99.9  Standard           98.9
INT_HTXID6          PHYS_2Q0KFG        DEV_E2VRHA        True        False        True          True         None              1           4  None                10           6.6       0.13       93.9         3.1       18.4  Standard        92.3  Magnetic           93.9
...


CREATE TABLE "performance" (
perfregistry character varying NOT NULL,
perfsessionref character varying NOT NULL,
accelmax smallint NULL,
speedips smallint NULL,
liftdistmm numeric NULL,
angsnap boolean NULL,
btntens USER-DEFINED NULL,
clklat numeric NULL,
clkdur bigint NULL,
screnctyp USER-DEFINED NULL,
scrsteps smallint NULL,
scraccy numeric NULL,
    PRIMARY KEY (perfregistry),
    FOREIGN KEY (perfsessionref) REFERENCES testsessions(sessionregistry)
);

First 3 rows:
perfregistry    perfsessionref      accelmax    speedips    liftdistmm  angsnap    btntens      clklat    clkdur  screnctyp      scrsteps    scraccy
--------------  ----------------  ----------  ----------  ------------  ---------  ---------  --------  --------  -----------  ----------  ---------
PERF_F82J4K     GPT287164                 36         360           0.8  False      Light          0.49  52679106  Optical              20       91.8
PERF_UFXS4T     GPT831546                 32         396           1.6  False      Medium         1.83  36886488  Optical              23       96.8
PERF_3PQ3KQ     GPT573068                 38         273           1.2  False      Light          0.51  32306990  Optical              20       90.2
...


CREATE TABLE "deviceidentity" (
devregistry character varying NOT NULL,
devsessionref character varying NOT NULL,
makername character varying NULL,
modnum character varying NULL,
fwver character varying NULL,
conntype character varying NULL,
wlrangem numeric NULL,
wlinterf character varying NULL,
wlchanhop boolean NULL,
wllatvar numeric NULL,
pwridlemw integer NULL,
pwractmw integer NULL,
pwrrgbmw integer NULL,
brdmemmb smallint NULL,
profcount smallint NULL,
mcresptime numeric NULL,
mcexecspeed numeric NULL,
mctimacc numeric NULL,
dpires integer NULL,
dpisteps smallint NULL,
senstype character varying NULL,
sensres integer NULL,
    PRIMARY KEY (devregistry),
    FOREIGN KEY (devsessionref) REFERENCES testsessions(sessionregistry)
);

First 3 rows:
devregistry    devsessionref    makername    modnum    fwver    conntype           wlrangem  wlinterf    wlchanhop      wllatvar    pwridlemw    pwractmw    pwrrgbmw    brdmemmb    profcount    mcresptime    mcexecspeed    mctimacc    dpires    dpisteps  senstype      sensres
-------------  ---------------  -----------  --------  -------  ---------------  ----------  ----------  -----------  ----------  -----------  ----------  ----------  ----------  -----------  ------------  -------------  ----------  --------  ----------  ----------  ---------
DEV_RQ33OK     GPT287164        HyperX       MDL7333   6.6.9    Wireless 2.4GHz           8  Low         False              1.3            90         143         113           8            2          1.51           0.24        92.7      9774           4  PMW3389         22986
DEV_UPPRRQ     GPT831546        Corsair      MDL8501   5.3.7    Wired                     6  Low         False              1.45           21         335         149          64            4          2.32           0.36        92.8     24096           1  Optical         16401
DEV_E2VRHA     GPT573068        Logitech     MDL8929   7.0.3    Bluetooth                16  High        False              1.96           45         345         136           8            3          4.63           0.63        96.8      5125           1  Optical         20417
...


CREATE TABLE "mechanical" (
mechregistry character varying NOT NULL,
mechperfref character varying NOT NULL,
mechdevref character varying NOT NULL,
keyforceg numeric NULL,
keytravmm numeric NULL,
swtchvar character varying NULL,
swtchdur bigint NULL,
ghostkeys smallint NULL,
keyrollo character varying NULL,
swtchcons numeric NULL,
ghosteff numeric NULL,
keychatter numeric NULL,
actpointmm numeric NULL,
respointmm numeric NULL,
tacbumpmm numeric NULL,
tottravmm numeric NULL,
stabrattle USER-DEFINED NULL,
stabtype character varying NULL,
capthkmm numeric NULL,
capmat character varying NULL,
caplegmeth character varying NULL,
kbdangle smallint NULL,
wristflag boolean NULL,
palmangle smallint NULL,
ergorate smallint NULL,
    PRIMARY KEY (mechregistry),
    FOREIGN KEY (mechdevref) REFERENCES deviceidentity(devregistry),
    FOREIGN KEY (mechperfref) REFERENCES performance(perfregistry)
);

First 3 rows:
mechregistry    mechperfref    mechdevref      keyforceg    keytravmm  swtchvar      swtchdur    ghostkeys  keyrollo      swtchcons    ghosteff    keychatter    actpointmm    respointmm    tacbumpmm    tottravmm  stabrattle    stabtype      capthkmm  capmat    caplegmeth      kbdangle  wristflag      palmangle    ergorate
--------------  -------------  ------------  -----------  -----------  ----------  ----------  -----------  ----------  -----------  ----------  ------------  ------------  ------------  -----------  -----------  ------------  ----------  ----------  --------  ------------  ----------  -----------  -----------  ----------
MECH_JOL75L     PERF_F82J4K    DEV_RQ33OK           75.8          3.3  Membrane      74090272           65  2KRO               97          95.2          1.72           1.4           2.4          1.9          3.4  Minimal       PCB Mount          1.4  ABS       Double Shot            1  True                   0           6
MECH_0WBA9L     PERF_UFXS4T    DEV_UPPRRQ           79.9          2.4  Mechanical    27318594           68  6KRO               99.3        95.2          1.17           2.4           1.4          1.6          3.7  Minimal       PCB Mount          1.4  ABS       Dye Sub                1  False                 15           9
MECH_Q9PD87     PERF_3PQ3KQ    DEV_E2VRHA           79.3          1.9  Mechanical    76894521          102  6KRO               92.6        94.8          0.85           1.6           1.5          2.3          4    Minimal       Screw-in           1    ABS       Double Shot            1  False                  8           8
...


CREATE TABLE "audioandmedia" (
audregistry character varying NOT NULL,
auddevref character varying NOT NULL,
audperfref character varying NOT NULL,
sndleveldb numeric NULL,
sndsig character varying NULL,
noiseisodb smallint NULL,
audlatms numeric NULL,
micsensedb numeric NULL,
micfreqresp character varying NULL,
spkimpohm smallint NULL,
spksensedb smallint NULL,
thdpct numeric NULL,
freqresp character varying NULL,
drvszmm smallint NULL,
surrsnd character varying NULL,
eqcount smallint NULL,
micmon boolean NULL,
noisecanc USER-DEFINED NULL,
btversion character varying NULL,
btrangem smallint NULL,
btlatms numeric NULL,
multidev boolean NULL,
autoslpmin smallint NULL,
wakems numeric NULL,
    PRIMARY KEY (audregistry),
    FOREIGN KEY (auddevref) REFERENCES deviceidentity(devregistry),
    FOREIGN KEY (audperfref) REFERENCES performance(perfregistry)
);

First 3 rows:
audregistry    auddevref    audperfref      sndleveldb  sndsig      noiseisodb    audlatms    micsensedb  micfreqresp      spkimpohm    spksensedb    thdpct  freqresp      drvszmm  surrsnd      eqcount  micmon    noisecanc      btversion    btrangem    btlatms  multidev      autoslpmin    wakems
-------------  -----------  ------------  ------------  --------  ------------  ----------  ------------  -------------  -----------  ------------  --------  ----------  ---------  ---------  ---------  --------  -----------  -----------  ----------  ---------  ----------  ------------  --------
AUD_62KLBY     DEV_RQ33OK   PERF_F82J4K           54.4  Silent              26        15             -34  87-14667Hz              16           108      1.82  17-22680Hz         53  Stereo             9  False     Passive              4            21      217.7  True                   6     771.6
AUD_HN6IA9     DEV_UPPRRQ   PERF_UFXS4T           37.2  Silent              21         3.1           -42  38-19153Hz              64           108      1.11  18-28862Hz         50  5.1                6  False     Active               5            25      147    False                 11     979.7
AUD_QYXW48     DEV_E2VRHA   PERF_3PQ3KQ           63.6  Thocky              15        11.5           -38  42-10348Hz              16            99      0.81  19-20571Hz         53  7.1                4  False     Active               5.1          19      200.2  False                  9     373.9
...


CREATE TABLE "rgb" (
rgbregistry character varying NOT NULL,
rgbmechref character varying NOT NULL,
rgbaudref character varying NOT NULL,
rgbbright smallint NULL,
rgbcoloracc numeric NULL,
rgbrfrate smallint NULL,
rgbmodes character varying NULL,
rgbzones smallint NULL,
rgbcolors integer NULL,
    PRIMARY KEY (rgbregistry),
    FOREIGN KEY (rgbaudref) REFERENCES audioandmedia(audregistry),
    FOREIGN KEY (rgbmechref) REFERENCES mechanical(mechregistry)
);

First 3 rows:
rgbregistry    rgbmechref    rgbaudref      rgbbright    rgbcoloracc    rgbrfrate    rgbmodes    rgbzones    rgbcolors
-------------  ------------  -----------  -----------  -------------  -----------  ----------  ----------  -----------
RGB_33D8M7     MECH_JOL75L   AUD_62KLBY            88           84.3          166          18           1      3461298
RGB_INHK9M     MECH_0WBA9L   AUD_HN6IA9            12           87.1          847          11           3      3206043
RGB_0P73NA     MECH_Q9PD87   AUD_QYXW48            23           97.2          159          14           1     11826339
...


CREATE TABLE "physicaldurability" (
physregistry character varying NOT NULL,
physrgbref character varying NOT NULL,
physperfref character varying NOT NULL,
wgtgram smallint NULL,
wgtdist character varying NULL,
cablegram smallint NULL,
cabledrag character varying NULL,
feetmat character varying NULL,
feetthkmm numeric NULL,
glidecons numeric NULL,
fricstatic numeric NULL,
frickinetic numeric NULL,
surfcompat character varying NULL,
gripsty character varying NULL,
gripcoat character varying NULL,
gripdur smallint NULL,
sweatres character varying NULL,
tempres USER-DEFINED NULL,
humidres USER-DEFINED NULL,
dustres character varying NULL,
waterres character varying NULL,
impres character varying NULL,
drophtm numeric NULL,
bendforce smallint NULL,
twistdeg smallint NULL,
cablebend integer NULL,
usbconndur integer NULL,
    PRIMARY KEY (physregistry),
    FOREIGN KEY (physperfref) REFERENCES performance(perfregistry),
    FOREIGN KEY (physrgbref) REFERENCES rgb(rgbregistry)
);

First 3 rows:
physregistry    physrgbref    physperfref      wgtgram  wgtdist        cablegram  cabledrag    feetmat        feetthkmm    glidecons    fricstatic    frickinetic  surfcompat          gripsty    gripcoat      gripdur  sweatres    tempres    humidres    dustres    waterres    impres      drophtm    bendforce    twistdeg    cablebend    usbconndur
--------------  ------------  -------------  ---------  -----------  -----------  -----------  -----------  -----------  -----------  ------------  -------------  ------------------  ---------  ----------  ---------  ----------  ---------  ----------  ---------  ----------  --------  ---------  -----------  ----------  -----------  ------------
PHYS_GHOT80     RGB_33D8M7    PERF_F82J4K           83  Front Heavy           62  Moderate     Glass                1.2         85.4          0.41           0.27  Cloth Preferred     Palm       Rubberized         17  Low         Standard   Premium     IPX1       IPX1        Standard        1            106          30         4036          2814
PHYS_3F7AUT     RGB_INHK9M    PERF_UFXS4T           84  Back Heavy            74  Minimal      Virgin PTFE          1           91.1          0.48           0.12  Hard Pad Preferred  Palm       Matte              22  Medium      Premium    Enhanced    IPX2       IPX1        Standard        1.9          350          32         3626          1975
PHYS_2Q0KFG     RGB_0P73NA    PERF_3PQ3KQ          116  Back Heavy            99  Minimal      Virgin PTFE          0.6         90.7          0.44           0.22  Cloth Preferred     Hybrid     Rubberized         24  Low         Enhanced   Enhanced    IPX3       IPX3        Standard        1.7          346          34         2085          1742
...
