src/entities/incident/_model.py

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


class IncidentModel(BaseModel_):
    __tablename__ = "incident"

    incidentkey = Column(String(14), primary_key=True, index=True)
    incidentdate = Column(DateTime)
    incidentnumber = Column(String(10))
    exposure = Column(String(3))
    incidentstatus = Column(String(20))
    reviewstatusflag = Column(Boolean, nullable=True)
    publicreleaseflag = Column(Boolean, nullable=True)
    completed = Column(Boolean, nullable=True)
    transactiontype = Column(String(4))
    district = Column(String(10))
    station = Column(String(30))
    shift = Column(String(2))
    company = Column(String(64))
    incidenttype = Column(String(4), nullable=True)
    initialdispatchcode = Column(String(25))
    mutualaidcode = Column(String(4), nullable=True)
    alarmdate = Column(DateTime)
    arrivaldate = Column(DateTime)
    didnotarriveflag = Column(Boolean, nullable=True)
    controlleddate = Column(DateTime)
    lastunitcleareddate = Column(DateTime)
    includemutualaidflag = Column(Boolean, nullable=True)
    madepartment = Column(String(30))
    madeptincidentno = Column(String(9))
    alarms = Column(Integer)
    actiontaken1 = Column(String(4))
    actiontaken2 = Column(String(4))
    actiontaken3 = Column(String(4))
    resourceformusedflag = Column(Boolean, nullable=True)
    apparatussuppression = Column(Integer)
    apparatusems = Column(Integer)
    apparatusother = Column(Integer)
    personnelsuppression = Column(Integer)
    personnelems = Column(Integer)
    personnelother = Column(Integer)
    lossproperty = Column(Numeric)
    losscontents = Column(Numeric)
    valueproperty = Column(Numeric)
    valuecontents = Column(Numeric)
    fatalfireservice = Column(Integer)
    fatalother = Column(Integer)
    nonfatalfireservice = Column(Integer)
    nonfatalother = Column(Integer)
    detector = Column(String(4))
    hazardmaterialreleased = Column(String(4))
    mixeduse = Column(String(4))
    propertyuse = Column(String(4))
    emsprovidedflag = Column(Boolean, nullable=True)
    casualtiesflag = Column(Integer)
    priorityresponseflag = Column(Boolean)
    vendorid = Column(String(20))
    locationtype = Column(Float)
    censustract = Column(String(7))
    numberormile = Column(String(8))
    streetprefix = Column(String(2))
    streethighway = Column(String(30))
    streettype = Column(String(4))
    streetsuffix = Column(String(2))
    apartment = Column(String(15))
    city = Column(String(20))
    state = Column(String(2))
    postalcode = Column(String(20))
    directions = Column(Text)
    latitude = Column(String(20))
    longitude = Column(String(20))
    compositeaddress = Column(String(50), nullable=True)
    county = Column(String(20))
    occupancykey = Column(String(14))
    occupancynumber = Column(String(16))
    occupancyname = Column(String(40))
    runcard = Column(String(8))
    mappage = Column(String(20))
    descrip = Column(String(30))
    addressvalidated = Column(Integer)
    CADCompleted = Column(Boolean)
    changedate = Column(DateTime)
    rowguid = Column(String(50))
    LogComments = Column(Text)
    Incident_ID = Column(Integer, nullable=True)
    loss_not_known = Column(Boolean, nullable=True)
    collecteddate = Column(DateTime)
    DispatchIncType = Column(String(80))
    nfscasualtycnt = Column(Integer)
    ncivcasualtycnt = Column(Integer)
    psaptime = Column(DateTime)
    ResponseType = Column(String(10))
    CADText1 = Column(String(50))
    CADText2 = Column(String(50))
    CADText3 = Column(String(50))
    CADCombo1 = Column(String(50))
    CADCombo2 = Column(String(50))
    CADCombo3 = Column(String(50))
    GMTOffSet = Column(String(6))
    CADDate1 = Column(DateTime)
    CADDate2 = Column(DateTime)
    CADDate3 = Column(DateTime)
    responseTime = Column(String(20))
    turnTime = Column(String(20))
    Mapset = Column(String(6))
    Easting = Column(String(5))
    Northing = Column(String(5))
    
    # relationships
    apparatus = relationship("ApparatusModel", back_populates="incident")
    personnel = relationship("PersonnelModel", back_populates="incident")
    incident_apparatus = relationship("IncidentApparatusModel", back_populates="incident")