1 DROP TABLE IF EXISTS "user_contracts";
2 DROP TYPE IF EXISTS "contractType";
3 CREATE TYPE "contractType" AS ENUM ('RA Agent Contract', 'Org RA Agent Contract');
5 CREATE TABLE "user_contracts" (
7 "token" varchar(32) NOT NULL,
9 "document" "contractType" NOT NULL,
10 "agentname" varchar(255) NOT NULL,
11 "datesigned" timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
12 "daterevoked" timestamp DEFAULT NULL,
15 CREATE INDEX ON "user_contracts" ("memid");
16 CREATE INDEX ON "user_contracts" ("document");
17 CREATE INDEX ON "user_contracts" ("datesigned");
18 CREATE INDEX ON "user_contracts" ("daterevoked");