# ProjectFieldOptions ## Documentation The options of the choice fields of a project. Each request costs 10 tokens of the daily budget of the company. - Catalog: `Pipedrive` - Schema: `Fields` - Primary Keys: `id` Can retrieve data and change data using insert, update and delete. ## Table Columns The columns of the table `ProjectFieldOptions` are shown below. Each column has an SQL data type. A new non-null value must be provided for every required column at all times during insert and update. | Name | Data Type | Label | Required | Documentation | |---|:---:|---|:---:|---| | `add_time` | `datetime` | | ☐ | When the option was created. | | `color` | `varchar2` | | ☐ | Optional color code for the option. | | `field_code` | `varchar2` | | ☐ | The code of the field the option belongs to. | | `id` | `varchar2` | | ☑ | The id. | | `label` | `varchar2` | | ☐ | The option display label. | | `update_time` | `datetime` | | ☐ | When the option was last updated. | ## Foreign Keys The values of these columns refer to a row of another table. | Columns | Referenced Table | Referenced Columns | Guarantee | |---|---|---|---| | `field_code` | [[Fields-ProjectFields\|Fields.ProjectFields]] | `field_code` | Declared by the connector, not enforced by the platform |