tbl_assets_custom_field_options

-1 rows


Description

Module: Asset Management - Custom Field Options Master
Purpose: Stores the pre-defined, selectable options (e.g., choices for a dropdown or radio buttons) for custom fields where the field_type in tbl_assets_custom_field is a selection type (Dropdown, Multi-select, etc.).
Data: Captures the display value of the option, links it to its parent custom field definition, and specifies its active/default status.
Process Usage:
- Form Rendering: Used to populate the list of choices presented to the user when filling out a custom field for an asset.
- Data Standardization: Ensures that asset data is captured using a controlled set of standardized values (e.g., only “Windows 10” or “Mac OS” for an “Operating System” field).
Key Points:
- Detail Configuration: Acts as a detail table for the custom field definition master.
- The option_value is the actual text/value that is stored or displayed.
Business Impact: Improves data consistency and quality in asset records by restricting input to approved choices.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id bigserial 19 √ nextval('tbl_assets_custom_field_options_id_seq'::regclass)

Primary key
Format: Long (auto-increment)
Used as: Unique identifier for this specific option.
custom_field_id int8 19 null

FK: public.tbl_assets_custom_field.id
Meaning: The ID of the master custom field definition this option belongs to.
option_value varchar 200 null

The text value or display label of the selectable option (e.g., “Good,” “Fair,” “Poor” for a “Condition” field).
is_active bool 1 √ null

Boolean flag: Indicates if this option is currently available for selection in asset forms.
is_default bool 1 √ null

Boolean flag: If TRUE, this option is the default selection when the form is initially loaded.
createdby varchar 50 √ null
createddate timestamp 29,6 √ null
modifiedby varchar 50 √ null
modifieddate timestamp 29,6 √ null

Indexes

Constraint Name Type Sort Column(s)
pk_tbl_assets_custom_field_options Primary key Asc id

Relationships

Close relationships within degrees of separation