extending create_tables.sql

create_tables now takes in consideration the remaining tables described
on the schema. foreign key linkage remains to be done.