finca_company.py 549 B

123456789101112131415
  1. from sqlalchemy import Column, ForeignKey, Integer, String
  2. from sqlalchemy.orm import relationship
  3. from database.sqlalchemy import Base
  4. class FincaCompany(Base):
  5. __tablename__ = "finca_organizacion"
  6. id = Column(Integer, primary_key=True, index=True, autoincrement=True)
  7. company_id = Column(Integer, ForeignKey("organizaciones.id"))
  8. finca_station_code = Column(String, ForeignKey("fincas.station_code"))
  9. company = relationship("Company", back_populates="fincas")
  10. finca = relationship("Finca", back_populates="companies")