nearly have foreign key table constraints
create generation basics working