Foreign Keys, Not Nullable Columns, and Indexes

[will-clark]

Take a pass at reviewing the schema to date to build foreign key, not null constraints, and indexes