This is the schema used by the example queries throughout the docs, and also in the playground.
Band are most commonly used:
from piccolo.table import Table from piccolo.columns import ForeignKey, Integer, Varchar class Manager(Table): name = Varchar(length=100) class Band(Table): name = Varchar(length=100) manager = ForeignKey(references=Manager) popularity = Integer()
We sometimes use these other tables in the examples too:
class Venue(Table): name = Varchar() capacity = Integer() class Concert(Table): band_1 = ForeignKey(references=Band) band_2 = ForeignKey(references=Band) venue = ForeignKey(references=Venue) starts = Timestamp() duration = Interval() class Ticket(Table): concert = ForeignKey(references=Concert) price = Numeric() class RecordingStudio(Table): name = Varchar() facilities = JSONB()
To understand more about defining your own schemas, see Defining a Schema.