Spaces:
Sleeping
Sleeping
| 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") | |