Translations:Kexi/Tutorials/Importing SQLite database into Kexi/15/en
From KDE UserBase Wiki
Type a name for every column presented by the schema in the step 3.
Use the Property Editor on the right hand to give each column in this table proper data type.
For INTEGER types, eg. dateTime INTEGER as seen on the schema, select Integer Number in the Data Type column of the Table Designer.
For REAL types, eg. barometer REAL as seen on the schema, select Floating Point Number in the Data Type column of the Table Designer.
In addition, set the dateTime column as the primary key for the table in the Property Editor.
Also, usUnits and interval columns have NOT NULL specifier assigned. To do the same in Kexi, set Required property to Yes for these columns in the Property Editor.