tbl_assets_type

-1 rows


Description

Module: Asset
Purpose: Stores asset type details.
Data: One row is created for each type of asset available in the system.
Process Usage:
- Users can create assets based on the defined asset types.
- Defines metadata and criteria for asset creation.
Key Points:
- Stores descriptive information about each asset type.
- Can define assignment criteria in JSON format.
- Tracks whether the asset type is active and available for use.
Business Impact: Ensures proper categorization, management, and controlled creation of assets.

Columns

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

Primary key
Format: BIGSERIAL (auto-increment)
Used as: Unique identifier for each asset type record.
asset_type_name varchar 200 null

Meaning: Name of the asset type.
Usage: Used when creating and categorizing assets in the system.
description varchar 1000 √ null

Meaning: Optional additional information or notes about the asset type.
Usage: Provides context or details for users and administrators.
assign_criteria text 2147483647 √ null

Assignment criteria
Format: TEXT (JSON)
Meaning: Specifies rules or conditions for applying this asset type.
Usage: If NULL, the asset type is applicable to all users; otherwise, used to filter eligible users based on criteria.
is_active bool 1 √ null

Meaning: Indicates whether this asset type is currently active and available for asset creation.
Usage: Only active asset types can be used to create new assets.
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_type Primary key Asc id

Relationships

Close relationships within degrees of separation