more complete schema. simplifying it for the book. sql,tables