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

from ..database import Base


class Reagendamento(Base):
    __tablename__ = "reagendamento"

    id = Column(Integer, primary_key=True, name="reag_id", autoincrement=True)
    data_da_visita = Column(TIMESTAMP, name="reag_data_da_visita")
    visita_comercial_id = Column(Integer, ForeignKey("visita_comercial.vis_id"), name="vis_id")

    visita_comercial = relationship("VisitaComercial", back_populates="reagendamentos")