sqlalchemy db relationship code example

Example 1: sqlalchemy one to many

class Parent(Base):
    __tablename__ = 'parent'
    id = Column(Integer, primary_key=True)
    children = relationship("Child", back_populates="parent")

class Child(Base):
    __tablename__ = 'child'
    id = Column(Integer, primary_key=True)
    parent_id = Column(Integer, ForeignKey('parent.id'))
    parent = relationship("Parent", back_populates="children")

Example 2: foreign key sqlalchemy

t = Table("remote_table", metadata,
    Column("remote_id", ForeignKey("main_table.id"))
)