Asset table features provide tabular format storage to store information, for example user can use it to store maintenance record of an asset. Below is configurable item of asset table.
Configurable Items | Description | |
---|---|---|
Identifier | Unique identifier of asset table | |
Name | Name of asset table, user can create multiple asset table under one asset element | |
Tag | Tag is for categorizing entities in the system. User can apply new tags or available tags for the entity | |
Description | Description of asset table. | |
Column Name | Column name of specific table | |
Data Type |
Data type of specific column of table, it supports below data type: Double Double (double-precision floating-point) variables are stored as IEEE 64-bit (8-byte) floating-point numbers, for example -1.79769313486231E308 to -4.94065645841247E-324 Bigint - An 8-byte integer data type, for example -9223372036854775808 to 9223372036854775807 Boolean - Representing logical values, for example FALSE, TRUE Int - Integers are digits that account for whole numbers only, for example 1, 83, 398, 5431 Text - This data type store alphanumeric characters, for example "Hello world! 123" Datetime - This data type stores calendar date and time information with specific defined format. Timestamp - This data type stores calendar date and time information with unixtimestamp format. Varchar(25) – String with maximum 25 characters length (can contain letters, numbers, and special characters) Varchar(50) – String with maximum 50 characters length (can contain letters, numbers, and special characters) Varchar(255) – String with maximum 255 characters length (can contain letters, numbers, and special characters) |
|
Default Value | The default value of specific column while adding new record, it is editable during new record insertion | |
Allow Null | It used to check NULL value is it allow for specific column during record insertion. If it is enabled, user can leave the specific column value empty during record insertion. | |
Primary | The index key of table record |