Defines asset information by the user for the system, the asset can be file, folder etc
| Column Name | Column Datatype | Column Null Option | Column Comment |
| asset_id | varchar(50) | not null | Asset ID |
| asset_parent_id | varchar(50) | with null | Asset Parent ID |
| is_folder | integer | with null | Defines the asset type - true: folder asset, false: file asset |
| path | nvarchar(256) | with null | File or folder path for the asset resource |
| url | varchar(256) | with null | For the asset resource, if it has one |
| file_name | nvarchar(128) | with null | Defines the name for the asset |
| description | nvarchar(128) | with null | Description of the asset |
| created_date | date | with null | Asset create date |
| modified_date | date | with null | Asset modified date |
| is_system | integer | with null | Defines wheither the asset is a system created one |
| icon_used | varchar(256) | with null | Defines the icon information for the user defined. |
| keywords | nvarchar(256) | with null | Keywords for the asset |
| mime_type | varchar(32) | with null | Information the type for the file asset |
| file_size | integer | with null | Size of the file asset |
| tenant_id | varchar(64) | with null | Tenant ID who created asset |
| parent_tenant_id | varchar(64) | with null | Parent tenant ID of the tenant who created the asset |
| user_id | nvarchar(100) | with null | User ID who created the asset |
| locked | integer | with null | Defines the lock status, whether the other user can claim the asset or not. |
| lockout_time | date | with null | Defines the lockout_time if the asset has been locked. |
| owner | nvarchar(128) | with null | Asset owner |
Product Name: Unicenter Service Management
Table Type: Table
Relationships:
| Primary Key | Related Table | Related Column |
| asset_id | usm_asset | asset_parent_id |
| asset_id | usm_portal_template | asset_id |