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

from database.sqlalchemy import Base


class Finca(Base):
    __tablename__ = "fincas"

    id = Column(Integer, primary_key=True, index=True, autoincrement=True)
    station_code = Column(String, primary_key=True, unique=True, index=True)
    title = Column(String)
    last_synced = Column(DateTime, nullable=True)

    companies = relationship("FincaCompany", back_populates="finca")