How does Smile public schema work?

In SQL terms, Smile public schema is a set of database views created specifically to provide information from the internal “private” Smile schema tables. Most, but not all, of the tables documented here are simplified or restricted views of the raw database tables.

Providing you with access to views instead of the raw database tables allows us to more easily maintain future compatibility with scripts you write today, and lets us present the data in a manner which hides some of the complexity of the underlying SQL tables.