Search Results for

    Show / Hide Table of Contents

    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
    In This Article
    Back to top Generated by Asset Health Insights