tbl_assets_custom_field_mapping_history

-1 rows


Description

Module: Asset Management - Custom Field Value History/Audit Log
Purpose: Stores an immutable, time-stamped log of all changes made to the values of custom fields associated with specific company assets (e.g., changing the asset’s location, updating a license key).
Data: Captures the linkage IDs, the specific asset ID, the custom field ID, and the value (custom_field_value) of that field at the time the change occurred.
Process Usage:
- Auditing: Provides a complete timeline of how an asset’s descriptive data has changed over its lifecycle (e.g., who updated the service tag, when a warranty date was extended).
- Data Integrity: Used to track data modifications and ensure accountability for changes to critical asset details.
Key Points:
- Value Tracking: This table tracks the content of the asset data, unlike other history tables which track configuration changes.
- Acts as a snapshot of the record from the master tbl_assets_custom_field_mapping table.
Business Impact: Critical for asset compliance, warranty tracking, and maintaining a verifiable history of all asset specifications and statuses.

Columns

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

Primary key
Format: Long (auto-increment)
Used as: Unique identifier for this specific historical entry/snapshot.
assets_custom_field_mapping_id int8 19 null

FK: public.tbl_assets_custom_field_mapping.id (Implied)
Meaning: The ID of the master custom field value record that this history entry pertains to.
asset_id int8 19 null

FK: public.tbl_asset.id (Implied)
Meaning: The ID of the specific asset whose custom field value was changed.
custom_field_id int8 19 null

FK: public.tbl_assets_custom_field.id (Implied)
Meaning: The ID of the master custom field definition (e.g., “Serial Number”) to which this value belongs.
custom_field_value text 2147483647 √ null

The recorded value of the custom field at the time this history entry was created.
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_history Primary key Asc id

Relationships

Close relationships within degrees of separation