debate-map / app

Monorepo for the client, server, etc. of the Debate Map website.
https://debatemap.app
MIT License
73 stars 16 forks source link

Add new table "nodeAggregateRatings", and move the ratings-summaries from node.extras to this new table #310

Open Venryx opened 5 months ago

Venryx commented 5 months ago

Table structure draft:

CREATE TABLE app."nodeAggregateRatings" (
    process text NOT NULL PRIMARY KEY,
    node text NOT NULL PRIMARY KEY,
    type text NOT NULL,
    value real NOT NULL,
    "aggregationInfo" JSONB,
    "accessPolicy" text NOT NULL,
    "c_accessPolicyTargets" text[] NOT NULL
);