tbl_assets

-1 rows


Description

Module: Asset
Purpose: Stores information about company assets.
Data: One row per asset, including details on purchase, allocation, warranty, and status.
Process Usage:
- Tracks asset lifecycle: from purchase to allocation, return, and expiration.
- Supports multiple asset types and vendors.
- Includes allocation to individual or shared users.
Key Points:
- Stores attachments like warranty documents.
- Tracks asset depreciation and maintenance status.
Business Impact: Ensures proper asset management, compliance, and auditing.

Columns

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

Primary key
Format: BIGSERIAL
Used as: Unique identifier for each asset record.
asset_type_id int8 19 null

Asset Type ID
Format: BIGINT
FK: public.tbl_assets_type.id
Meaning: Type/category of the asset.
Usage: Helps classify assets for reporting and management.
serial_number varchar 30 null

Asset Serial Number
Format: VARCHAR(30)
Meaning: Unique identifier assigned by vendor or internally for the asset.
Usage: Used to track individual assets.
asset_name varchar 100 null

Asset Name
Format: VARCHAR(100)
Meaning: Human-readable name of the asset.
Usage: Displayed in UI and reports.
brand_name varchar 100 √ null

Brand Name
Format: VARCHAR(100)
Meaning: Manufacturer or brand of the asset.
Usage: Optional metadata for asset tracking.
status varchar 20 √ null

Asset Status
Format: VARCHAR(20)
Possible Values: TRASH, AVAILABLE, IN_USE, UNDER_MAINTENANCE, LOST
Usage: Tracks current condition and usability of the asset.
non_recoverable bool 1 √ null

Non-Recoverable Flag
Format: BOOLEAN
Meaning: True if asset cannot be recovered once lost or allocated incorrectly.
Usage: Used for accounting and compliance purposes.
allocation_type varchar 20 null

Allocation Type
Format: VARCHAR(20)
Possible Values: SHARED, INDIVIDUAL, BACKUP, COMMON
Usage: Defines how the asset can be allocated.
branch_location_id int8 19 √ null

Branch Location
Format: BIGINT
Meaning: Branch to which the asset belongs or is stored.
Usage: Optional, used for multi-branch asset management.
purchase_date date 13 √ null

Purchase Date
Format: DATE
Meaning: When the asset was purchased.
Usage: For asset lifecycle and depreciation calculations.
purchase_cost numeric 0 √ null

Purchase Cost
Format: NUMERIC
Meaning: Cost of asset at purchase.
Usage: Used for financial tracking.
depreciation_percentage numeric 0 √ null

Depreciation Percentage
Format: NUMERIC
Meaning: Asset depreciation rate.
Usage: Used for asset accounting.
depreciation_frequency varchar 20 √ null

Depreciation Frequency
Format: VARCHAR(20)
Possible Values: monthly, yearly
Usage: Defines how depreciation is applied.
vendor_id int8 19 √ null

Vendor ID
Format: BIGINT
Meaning: Company/vendor from which the asset was purchased.
Usage: Optional, used for procurement tracking.
renewal_date date 13 √ null

Renewal Date
Format: DATE
Meaning: Date to renew or review asset maintenance/contract.
Usage: Optional, helps schedule renewals.
expiration_date date 13 √ null

Asset Expiration Date
Format: DATE
Meaning: When asset is no longer valid for use.
Usage: Asset lifecycle tracking.
warranty_end_date date 13 √ null

Warranty End Date
Format: DATE
Meaning: Expiration of asset warranty.
Usage: For maintenance and claims.
insurance_expiration_date date 13 √ null

Insurance Expiration Date
Format: DATE
Meaning: End of asset insurance coverage.
Usage: Risk management.
description varchar 1000 √ null

Asset Description
Format: VARCHAR(1000)
Meaning: Optional descriptive information about the asset.
attachments text 2147483647 √ null

Asset Attachments
Format: TEXT
Meaning: JSON string storing file references (e.g., warranty docs).
Usage: Links relevant asset documents.
allocation_date date 13 √ null

Allocation Date
Format: DATE
Meaning: When asset was allocated to employee(s).
allocated_to text 2147483647 √ null

Allocated Employees
Format: TEXT
Meaning: Employee IDs who received the asset, comma-separated.
return_date date 13 √ null

Return Date
Format: DATE
Meaning: Date asset is returned from allocated employee(s).
allocation_remarks varchar 1000 √ null

Allocation Remarks
Format: VARCHAR(1000)
Meaning: Notes added during allocation.
allocation_attachments text 2147483647 √ null

Allocation Attachments
Format: TEXT
Meaning: Files attached at allocation time, stored as JSON string.
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 Primary key Asc id

Relationships

Close relationships within degrees of separation