Python-сообщество

comp_empl_link = Table('comp_empl_link', Base.metadata,
                       Column('company_id', Integer, ForeignKey('company.id')),
                       Column('employee_id', Integer, ForeignKey('employee.id')))
class Company(Base):
    __tablename__ = 'company'
    id = Column(Integer, primary_key=True)
    name = Column(String)
    address = Column(String)
    employee = relationship('Employee', secondary=comp_empl_link)
    occupation = relationship('Occupation')
    def __init__(self, name, address):
        self.name = name
        self.address = address
    def __repr__(self):
        return "<Company name: %s; Address: %s>" % (self.name, self.address)
class Employee(Base):
    __tablename__ = 'employee'
    id = Column(Integer, primary_key=True)
    first_name = Column(String)
    last_name = Column(String)
    patronymic = Column(String)
    birthday = Column(Date)
    company = Column(Integer, ForeignKey('company.id'))
    position = relationship('Position')
    def __init__(self, first_name, last_name, patronymic, birthday):
        self.first_name = first_name
        self.last_name = last_name
        self.patronymic = patronymic
        self.birthday = birthday
    def __repr__(self):
        return "<Employee: %s %s %s; birth - %s" % (self.first_name, self.last_name, self.patronymic, self.birthday)
class Occupation(Base):
    __tablename__ = 'occupation'
    id = Column(Integer, primary_key=True)
    name = Column(String)
    desc = Column(String)
    company_id = Column(Integer, ForeignKey('company.id'))
class Position(Base):
    __tablename__ = 'position'
    id = Column(Integer, primary_key=True)
    name = Column(String)
    desc = Column(String)
    employee_id = Column(Integer, ForeignKey('employee.id'))