Previous Topic: Business_Management_Repository TableNext Topic: ca_company Table


ca_asset_type Table

Asset types defined in the CA-MDB.

Field

Data Type

Reference

Remarks

asset_type_ configuration

STRING 1

 

 

asset_type_id

INTEGER

UNIQUE NOT_NULL KEY

 

key id

asset_type_ name

STRING 255

 

 

creation_date

LOCAL_TIME

 

Indicates the timestamp indicating when this record was created.

creation_user

STRING 64

 

Specifies the name of the person who created this record. Should be in form: LastName, FirstName

delete_time

LOCAL_TIME

 

 

exclude_ registration

INTEGER

 

 

last_update_ date

LOCAL_TIME

 

Indicates the timestamp of when this record was last modified.

last_update_ user

STRING 64

 

Specifies the contact who last modified this record. Should be in form: LastName, FirstName

version_ number

INTEGER