tbl_assets_custom_field_mapping

-1 rows


Description

Module: Asset Management - Asset Custom Field Values
Purpose: Stores the specific data or values entered for the custom fields that are associated with individual assets. This is the operational data store for all non-standard asset attributes.
Data: Captures the unique combination of an Asset ID and a Custom Field ID, along with the actual value (e.g., Serial Number, Warranty End Date) entered by the user.
Process Usage:
- Data Retrieval: Used to fetch all extended/custom details of a specific asset when viewing its profile.
- Reporting/Filtering: Allows for searching and reporting on asset data using organization-specific custom fields.
- Changes to this table are logged in tbl_assets_custom_field_mapping_history.
Key Points:
- Transactional Data: This is the table that holds the dynamic data collected via the flexible custom field configuration.
- It represents a many-to-many relationship where the value is the payload.
Business Impact: Provides a flexible and powerful way to track detailed, organization-specific information for every managed asset.

Columns

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

Primary key
Format: Long (auto-increment)
Used as: Unique identifier for this specific custom field value record.
asset_id int8 19 null

FK: public.tbl_asset.id (Implied)
Meaning: The ID of the specific asset to which this custom field value applies.
custom_field_id int8 19 null

FK: public.tbl_assets_custom_field.id
Meaning: The ID of the master custom field definition (e.g., “Monitor Size,” “License Key”) that this value is for.
custom_field_value text 2147483647 √ null

The actual value entered for the custom field for the specific asset (e.g., “A12345B” for a Serial Number field, “2025-12-31” for a Date field).
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_mapping Primary key Asc id

Relationships

Close relationships within degrees of separation