kindcode of partyRoleKindrequiredThe role played
Becomes the column party_role_kind_code of party_role.
Written at commons/data/models/arca/party.ts:161
A role a party plays for a time: the same party may be a customer and a supplier at once
Model arcaParty. Written in commons/data/models/arca/party.ts:157. Identified by partyRoleId.
kindcode of partyRoleKindrequiredThe role played
Becomes the column party_role_kind_code of party_role.
Written at commons/data/models/arca/party.ts:161
partyRoleIdidentifierrequiredWhat identifies this playing of a role
Becomes the column party_role_id of party_role.
Written at commons/data/models/arca/party.ts:160
validFromdaterequiredThe first day the party played the role
Becomes the column valid_from of party_role.
Written at commons/data/models/arca/party.ts:162
validTodateoptionalThe last day the party played the role; empty while they still do
Becomes the column valid_to of party_role.
Written at commons/data/models/arca/party.ts:163
partyoneThe party who plays the role To party. Written at commons/data/models/arca/party.ts:157
Projects to the table party_role with the primary key party_role_id.
| Column | Type | Null | Role | From |
|---|---|---|---|---|
party_id | text | false | reference | partyRole.party |
party_role_id | text | false | attribute | partyRole.partyRoleId |
party_role_kind_code | text | false | reference | partyRole.kind |
valid_from | date | false | attribute | partyRole.validFrom |
valid_to | date | true | attribute | partyRole.validTo |
CREATE TABLE IF NOT EXISTS "party_role" (
"party_role_id" VARCHAR NOT NULL PRIMARY KEY,
"party_role_kind_code" VARCHAR NOT NULL,
"valid_from" DATE NOT NULL,
"valid_to" DATE,
"party_id" VARCHAR NOT NULL,
CONSTRAINT "party_role_party_role_kind_code_fk" FOREIGN KEY ("party_role_kind_code") REFERENCES "party_role_kind" ("code"),
CONSTRAINT "party_role_party_id_fk" FOREIGN KEY ("party_id") REFERENCES "party" ("party_id")
);CREATE TABLE IF NOT EXISTS "party_role" (
"party_role_id" TEXT NOT NULL PRIMARY KEY,
"party_role_kind_code" TEXT NOT NULL,
"valid_from" DATE NOT NULL,
"valid_to" DATE,
"party_id" TEXT NOT NULL,
CONSTRAINT "party_role_party_role_kind_code_fk" FOREIGN KEY ("party_role_kind_code") REFERENCES "party_role_kind" ("code"),
CONSTRAINT "party_role_party_id_fk" FOREIGN KEY ("party_id") REFERENCES "party" ("party_id")
);CREATE TABLE IF NOT EXISTS "party_role" (
"party_role_id" TEXT NOT NULL PRIMARY KEY,
"party_role_kind_code" TEXT NOT NULL,
"valid_from" TEXT NOT NULL,
"valid_to" TEXT,
"party_id" TEXT NOT NULL,
CONSTRAINT "party_role_party_role_kind_code_fk" FOREIGN KEY ("party_role_kind_code") REFERENCES "party_role_kind" ("code"),
CONSTRAINT "party_role_party_id_fk" FOREIGN KEY ("party_id") REFERENCES "party" ("party_id")
);Read and written from TypeScript with the types the model gives: import { partyRole } from "@intellectual-frontiers/data/sql/typed/models". Generated in commons/data/sql/typed/models/arca-party.auto.ts: do not edit.
import { from } from "@intellectual-frontiers/data/sql/typed";
import { partyRole } from "@intellectual-frontiers/data/sql/typed/models";
const rows = await from(partyRole).select((s) => ({ partyRoleId: s.partyRole.partyRoleId, partyRoleKindCode: s.partyRole.partyRoleKindCode })).run(runner);