class Band(Table):
manager = ForeignKey("..example_app.tables.Manager", null=True)
class Band1(Table):
manager = ForeignKey(references=Manager)
class Concert(Table):
band_1 = ForeignKey(Band)
band_2 = ForeignKey(Band)
venue = ForeignKey(Venue)
starts = Timestamp()
duration = Interval()
class Ticket(Table):
concert = ForeignKey(Concert)
price = Numeric(digits=(5, 2))
class Role(Table):
movie = ForeignKey(Movie)
name = Varchar(length=100)
class Band(Table):
name = Varchar(length=50)
manager = ForeignKey(references=Manager, null=True)
popularity = Integer()
class BandD(Table):
manager = ForeignKey(references=f"{__name__}.Manager")
class BandRelative(Table, tablename="band"):
manager = ForeignKey("..example_app.tables.Manager", null=True)
class Concert(Table):
band_1 = ForeignKey(Band)
band_2 = ForeignKey(Band)
venue = ForeignKey(Venue)
class BandC(Table):
manager = ForeignKey(references=LazyTableReference(
table_class_name="Manager", module_path=__name__))
class Band(Table):
name = Varchar(length=50)
manager = ForeignKey(Manager, null=True)
popularity = Integer(default=0)
class BandA(Table):
name = Varchar()
manager = ForeignKey(ManagerA, target_column=ManagerA.name)
class Band(Table):
name = Varchar()
manager = ForeignKey(Manager, target_column="name")
class Band2(Table):
manager = ForeignKey(references="Manager")
class Manager(Table):
name = Varchar()
manager = ForeignKey("self")
class Band4(Table):
manager = ForeignKey(references="tests.columns.test_foreignkey.Manager")
class BandC(Table, tablename="band"):
manager = ForeignKey(references=f"{__name__}.Manager")