-- Datetime format : https://www.sqlite.org/lang_datefunc.html -- %Y-%m-%d %H:%M:%S -- https://www.tutorialspoint.com/sqlite/sqlite_data_types.htm insert into tablechild( propstr) values("child lib 1"); insert into tablechild( propstr) values("child lib 2"); insert into tablechild( propstr) values("child lib 3"); insert into tablemaster( propstr, propint, propdate, propstrnotnull, tablechild_id) values( "master lib 1" , 1, "01/01/1971", "lib not null 1", 1 ); insert into tablemaster( propstr, propint, propdate, propstrnotnull, tablechild_id) values( "master lib 2" , 1, "02/02/1972", "lib not null 2", 2 );