In this example we create a table with an ID field (INTEGER) auto-value, a text field (VARCHAR) , a date field (DATE) and a numeric field (NUMERIC) .