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