Data types

Data types in SQL

 * INTEGER, a positive or negative whole number
 * TEXT, a text string
 * DATE, the date formatted as YYYY-MM-DD
 * REAL, a decimal value