Model to SQLite Data Types

Based on model variable type Core decides the data type of column.

1. Siminov Data-Types

• string: String class data type is converted to TEXT SQLite data type.

    <attribute>
        <property name="type">string</property>
    </attribute>

• primitive-integer: Primitive Integer data type is converted to INTEGER SQLite data type.

    <attribute>
        <property name="type">primitive-integer</property>
    </attribute>

• integer: Integer class data type is converted to INTEGER SQLite data type.

    <attribute>
        <property name="type">integer</property>
    </attribute>

• primitive-long: Primitive Long data type is converted to INTEGER SQLite data type.

    <attribute>
        <property name="type">primitive-long</property>
    </attribute>

• long: Long class data type is converted to INTEGER SQLite data type.

    <attribute>
        <property name="type">long</property>
    </attribute>

• primitive-float: Primitive Float data type is converted to REAL SQLite data type.

    <attribute>
        <property name="type">primitive-float</property>
    </attribute>

• float: Float class data type is converted to REAL SQLite data type.

    <attribute>
        <property name="type">float</property>
    </attribute>

• primitive-boolean: Primitive Boolean data type is converted to NUMERIC SQLite data type.

    <attribute>
        <property name="type">primitive-boolean</property>
    </attribute>

• boolean: Boolean class data type is converted to NUMERIC SQLite data type.

    <attribute>
        <property name="type">boolean</property>
    </attribute>

• primitive-byte: Primitive Byte array data type is converted to NONE SQLite data type.

    <attribute>
        <property name="type">primitive-byte</property>
    </attribute>

• byte: Byte class data type is converted to NONE SQLite data type.

    <attribute>
        <property name="type">byte</property>
    </attribute>

2. SQLite Data-Types

• INTEGER: This SQLite data type generally contain INT, INTEGER, TINYINT, SMALLINT, MEDIUMINT, BIGINT, UNSIGNED BIG INT, INT2, INT8.

• TEXT: This SQLite data type generally contain CHARACTER(20), VARCHAR(255), VARYING CHARACTER(255), NCHAR(55), NATIVE CHARACTER(70), NVARCHAR(100), TEXT, CLOB.

• REAL: This SQLite data type generally contain REAL, DOUBLE, DOUBLE PRECISION, FLOAT.

• NONE: This SQLite data type generally contain BLOB, NO DATA TYPE SPECIFIED.

• NUMERIC: This SQLite data type generally contain NUMERIC, DECIMAL(10,5), BOOLEAN, DATE, DATETIME.