from sqlalchemy import Column, String, Integer, Boolean, DateTime, Text, Numeric, ForeignKey
from sqlalchemy.orm import relationship
from ..base import BaseModel_


class ApparatusModel(BaseModel_):
    __tablename__ = "apparatus"

    apparatuskey = Column(String(14), primary_key=True, index=True)
    incidentkey = Column(String(14), ForeignKey("incident.incidentkey"))
    apsid = Column(String(14), nullable=True)
    apparatusid = Column(String(8), nullable=True)
    priorityresponseflag = Column(Boolean, nullable=True)
    arrivaldate = Column(DateTime, nullable=True)
    scenedate = Column(DateTime, nullable=True)
    enroutedate = Column(DateTime, nullable=True)
    facilitydate = Column(DateTime, nullable=True)
    cleardate = Column(DateTime, nullable=True)
    dispatchdate = Column(DateTime, nullable=True)
    inservicedate = Column(DateTime, nullable=True)
    cancelledenrouteflag = Column(Boolean, nullable=True)
    numberpeople = Column(Integer, nullable=True)
    usecode = Column(String(4), nullable=True)
    actiontaken1 = Column(String(4), nullable=True)
    actiontaken2 = Column(String(4), nullable=True)
    actiontaken3 = Column(String(4), nullable=True)
    actiontaken4 = Column(String(4), nullable=True)
    apparatustype = Column(String(4), nullable=True)
    amount1 = Column(Numeric(10, 2), nullable=True)
    amount2 = Column(Numeric(10, 2), nullable=True)
    otherinfo = Column(String(20), nullable=True)
    logcomments = Column(Text, nullable=True)
    fdid_no = Column(String(20), nullable=True)
    paramedicdispatch = Column(String(6), nullable=True)
    firstarrivingunit = Column(Boolean, nullable=True)
    inservicetime = Column(DateTime, nullable=True)
    respondfromquarters = Column(Boolean, nullable=True)
    changedate = Column(DateTime, nullable=True)
    rowguid = Column(String(36), nullable=True)
    hydrant_idnumber = Column(String(20), nullable=True)
    hydrant_location = Column(String(116), nullable=True)
    alarms = Column(String(10), nullable=True)
    llosap_credit = Column(Boolean, nullable=True)
    emsrun = Column(Boolean, nullable=True)
    emsrunnumber = Column(String(14), nullable=True)
    lprocessepcr = Column(Boolean, nullable=True)
    nepcrrun = Column(Integer, nullable=True)
    stagingdate = Column(DateTime, nullable=True)
    isepcr = Column(Boolean, nullable=True)
    unit_exc = Column(String(10), nullable=True)
    aedtype = Column(String(10), nullable=True)
    odometeronscene = Column(Numeric(12, 2), nullable=True)
    odometerdestination = Column(Numeric(12, 2), nullable=True)
    mileagetransport = Column(Numeric(12, 2), nullable=True)
    atpatientsidetime = Column(DateTime, nullable=True)
    aerialdeviceused = Column(Integer, nullable=True)
    gmtoffset = Column(String(6), nullable=True)
    firsteffectiveunit = Column(Integer, nullable=True)
    lnfirsexported = Column(Boolean, nullable=True)
    nfirsexporteddate = Column(DateTime, nullable=True)
    infirssequence = Column(Integer, nullable=True)
    nfirsttransactiontype = Column(String(1), nullable=True)
    hydrant_used = Column(Integer, nullable=True)
    defaultdispatchcode = Column(String(25), nullable=True)
    responsetime = Column(String(20), nullable=True)
    turntime = Column(String(20), nullable=True)
    
    incident = relationship("IncidentModel", back_populates="apparatus")
    personnel = relationship("PersonnelModel", back_populates="apparatus")