app.custom_object_values
TableRow level security on
One value of one field of one custom object record (Section 4.6.3), in the typed column of the field's data type. NULL money is unpriced, never zero.
Primary key: id
| Column | Type | Nullable | Description |
|---|---|---|---|
| id | uuid | No | Primary key, UUID v7. |
| org_id | uuid | No | Owning org, derived from app.custom_object_records on insert; never accepted from the caller and never changed.References app.organizations.id |
| custom_object_record_id | uuid | No | Record.References app.custom_object_records.id |
| custom_object_field_id | uuid | No | Field the value is for.References app.custom_object_fields.id |
| value_text | text | Yes | Text, Email and URL values. |
| value_number | numeric | Yes | Number values. |
| value_money_minor | bigint | Yes | Money values in minor units of value_currency. |
| value_currency | character(3) | Yes | ISO 4217 currency of a money value.References private.currencies.currency_code |
| value_date | date | Yes | Date values. |
| value_timestamp | timestamp with time zone | Yes | Timestamp values. |
| value_boolean | boolean | Yes | Boolean values. |
| value_choice_id | uuid | Yes | Choice values: an option of the field.References app.custom_object_field_choices.id |
| value_person_id | uuid | Yes | Person values.References app.people.id |
| created_at | timestamp with time zone | No | When the row was inserted. Set by the database. |
| created_by | uuid | Yes | Person who inserted the row, or null for a platform process. Set by the database.References app.people.id |
| updated_at | timestamp with time zone | No | When the row last changed. Set by the database. |
| updated_by | uuid | Yes | Person who last changed the row, or null for a platform process. Set by the database.References app.people.id |
| deleted_at | timestamp with time zone | Yes | Soft delete time. A row with deleted_at set is ignored by every access helper. |