IF Commons GitHub

partyRole

concept

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.

Governance: attributes

kindcode of partyRoleKindrequired

The role played

Becomes the column party_role_kind_code of party_role.

Written at commons/data/models/arca/party.ts:161

partyRoleIdidentifierrequired

What identifies this playing of a role

Becomes the column party_role_id of party_role.

Written at commons/data/models/arca/party.ts:160

validFromdaterequired

The first day the party played the role

Becomes the column valid_from of party_role.

Written at commons/data/models/arca/party.ts:162

validTodateoptional

The 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

Governance: relationships

partyone

The party who plays the role To party. Written at commons/data/models/arca/party.ts:157

Logical: the table

Projects to the table party_role with the primary key party_role_id.

ColumnTypeNullRoleFrom
party_idtextfalsereferencepartyRole.party
party_role_idtextfalseattributepartyRole.partyRoleId
party_role_kind_codetextfalsereferencepartyRole.kind
valid_fromdatefalseattributepartyRole.validFrom
valid_todatetrueattributepartyRole.validTo

Physical: SQL

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")
);

Physical: the typed table

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);

Titles, headings, exports, tables, columns and requirements. Esc closes.