Familiarize yourself with the .sq file format, used by SQLDelight to describe a table in the generated database. From the scope of the sample app, introduce the intended database relationships and construct the CREATE TABLE statements that make up these models.
This is a companion discussion topic for the original entry at https://www.raywenderlich.com/21631179-sqldelight-in-android-getting-started/lessons/3