Example Schema

This is the schema used by the example queries throughout the docs, and also in the playground.

Manager and 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.