Skip to content

app.profile_share_fields

TableRow level security on

The fields of a profile share, one row per field the owner chose to share, with the value at the time of sharing.

Primary key: id

Columns of app.profile_share_fields
ColumnTypeNullableDescription
iduuidNoPrimary key, UUID v7.
org_iduuidNoOwning org, derived from app.profile_shares on insert; never accepted from the caller and never changed.References app.organizations.id
profile_share_iduuidNoProfile share.References app.profile_shares.id
field_keytextNoProfile field key, for example headline or skills.0000.01.01.
field_valuetextYesValue shared; NULL when the field was shared empty.
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