SQLite docs: http://www.sqlite.org/docs.html
Date Types: http://www.sqlite.org/datatype3.html
- null, inteteger, real, text, blob
SQLite does not have a date/time time – dates stored in either text, real or integer columns are converted appropriately to that type.
Table relationships
create table person (id integer primary key asc, name text); create table address( id integer primary key asc, person_id references person( id ), add_line1 text );