from sqlalchemy import Column, ForeignKey, Integer, String
from sqlalchemy.orm import relationship

from database.sqlalchemy import Base


class FincaCompany(Base):
    __tablename__ = "finca_organizacion"

    id = Column(Integer, primary_key=True, index=True, autoincrement=True)
    company_id = Column(Integer, ForeignKey("organizaciones.id"))
    finca_station_code = Column(String, ForeignKey("fincas.station_code"))

    company = relationship("Company", back_populates="fincas")
    finca = relationship("Finca", back_populates="companies")