app.custom_object_values
TablaSeguridad a nivel de fila activa
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.
Clave primaria: id
| Columna | Tipo | Admite nulos | Descripción |
|---|---|---|---|
| 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.Hace referencia a app.organizations.id |
| custom_object_record_id | uuid | No | Record.Hace referencia a app.custom_object_records.id |
| custom_object_field_id | uuid | No | Field the value is for.Hace referencia a app.custom_object_fields.id |
| value_text | text | Sí | Text, Email and URL values. |
| value_number | numeric | Sí | Number values. |
| value_money_minor | bigint | Sí | Money values in minor units of value_currency. |
| value_currency | character(3) | Sí | ISO 4217 currency of a money value.Hace referencia a private.currencies.currency_code |
| value_date | date | Sí | Date values. |
| value_timestamp | timestamp with time zone | Sí | Timestamp values. |
| value_boolean | boolean | Sí | Boolean values. |
| value_choice_id | uuid | Sí | Choice values: an option of the field.Hace referencia a app.custom_object_field_choices.id |
| value_person_id | uuid | Sí | Person values.Hace referencia a app.people.id |
| created_at | timestamp with time zone | No | When the row was inserted. Set by the database. |
| created_by | uuid | Sí | Person who inserted the row, or null for a platform process. Set by the database.Hace referencia a app.people.id |
| updated_at | timestamp with time zone | No | When the row last changed. Set by the database. |
| updated_by | uuid | Sí | Person who last changed the row, or null for a platform process. Set by the database.Hace referencia a app.people.id |
| deleted_at | timestamp with time zone | Sí | Soft delete time. A row with deleted_at set is ignored by every access helper. |