requisition_fields


Description

A row in this table represents a value of a custom field on a requisition.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
requisition_field_id varchar 2147483647 null

Primary key.

account_id varchar 2147483647 null

ID of the account the record belongs to.

requisition_id varchar 2147483647 null
requisitions.requisition_id requisition_fields_requisition_id_fkeyC

ID of the requisition associated with this entity.

form_field_type_id varchar 2147483647 null
form_field_type_enum.form_field_type_id requisition_fields_form_field_type_id_fkeyN

The type of the field on the requisition.

index int4 10 null

The numeric order of the field as it appears on the requisition, starting at 0.

identifier varchar 2147483647 null

The string identifier of the field.

label varchar 2147483647 null

Label of the field in a requisition. This is the name visible in the product’s UI.

field_value_index int4 10 null

The numeric order of the field value. Always 0 for single value fields, starts at 0 for fields with multiple values.

field_value varchar 2147483647 null

The value of the field if it is textual.

field_value_number numeric 131089 null

The value of the field if it is a number.

field_value_date timestamp 29,6 null

The value of the field if it is a date.

created_at timestamp 29,6 null

Date the object referred to in this entity was created.

row_updated_at timestamp 29,6 CURRENT_TIMESTAMP

Date this entity was updated in the database. Useful to setup incremental refreshes of the data in your periodic ETL job.

Indexes

Constraint Name Type Sort Column(s)
requisition_fields_pkey Primary key Asc requisition_field_id
requisition_fields_acc_identifier_idx Performance Asc/Asc account_id + identifier
requisition_fields_account_id_idx Performance Asc account_id
requisition_fields_form_field_type_id_idx Performance Asc form_field_type_id
requisition_fields_requisition_id_idx Performance Asc requisition_id

Relationships