Skip to content

app.required_additional_insureds

TableRow level security on

Parties an org requires its vendors' certificates to name (finding A38-001): org-wide when project_id is NULL, otherwise for vendors engaged on that project as well.

Primary key: id

Columns of app.required_additional_insureds
ColumnTypeNullableDescription
iduuidNoPrimary key, UUID v7.
org_iduuidNoOwning org. A row never moves to another org.References app.organizations.id
project_iduuidYesProject the requirement adds to; NULL for every project of the org.References app.projects.id
insured_nametextNoParty that must be named, for example the venue owner.
endorsement_kindapp.endorsement_kindNoEndorsement the party must hold.
deleted_attimestamp with time zoneYesSoft delete time. A row with deleted_at set is ignored by every access helper.
created_attimestamp with time zoneNoWhen the row was inserted. Set by the database.
created_byuuidYesPerson who inserted the row, or null for a platform process. Set by the database.References app.people.id
updated_attimestamp with time zoneNoWhen the row last changed. Set by the database.
updated_byuuidYesPerson who last changed the row, or null for a platform process. Set by the database.References app.people.id