tbl_assets_custom_field

-1 rows


Description

Module: Asset - Custom Field Master
Purpose: Stores the definitions and rules for dynamic, non-standard fields that administrators can add to asset registration and tracking forms.
Data: Captures the internal field name, the user-facing label, the data type (text, number, date), validation rules (regex), and active status.
Process Usage:
- Form Generation: Used to dynamically render extra fields when HR/Admin creates or edits an asset record.
- Validation: Enforces data quality through regex_expression and displays error_message when validation fails.
- Provides flexibility to track unique asset characteristics (e.g., “Monitor Size,” “License Key”).
Key Points:
- Extensibility: Enables the system to adapt to varied organizational asset tracking needs.
- This table defines the custom fields themselves, not the values (values are stored in a separate asset value table).
Business Impact: Ensures comprehensive and accurate tracking of all relevant data points for company assets, improving inventory management and audit readiness.

Columns

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

Primary key
Format: Long (auto-increment)
Used as: Unique identifier for this custom field definition.
field_name varchar 200 null

The internal, programmatic name for the custom field.
field_type varchar 20 null

The data type expected for this field (e.g., TEXT, NUMBER, DATE, DROPDOWN).
is_active bool 1 √ null

Boolean flag: Indicates if this custom field is currently available and active for use in asset forms.
label varchar 200 null

The user-facing label or display name for the custom field (e.g., “Service Tag”).
remarks varchar 1000 √ null

Any help text or notes provided to the user filling out this custom field.
error_message varchar 200 √ null

The error message displayed to the user if the input fails the regex_expression validation.
regex_expression varchar 200 √ null

The Regular Expression used for validating the input value in this custom field, ensuring data consistency (e.g., specific format for a serial number).
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 Primary key Asc id

Relationships

Close relationships within degrees of separation