The following picture shows the the tables that make up the data model, with the columns for each field, and the relations among them.