CREATE TABLE mytable ( id integer primary key autoincrement NOT NULL, age integer NULL, year_of_birth integer NULL, name text NULL, weight real NULL, is_married integer NULL );