v_apparatus

v_apparatus

Purpose

  1. Apparatus / vehicle information view. 

Relationships


  • v_incident_report_apparatus: One-to-Many (1:N)

    • One apparatus can be on many incident reports

    • Referenced through apparatus_id

  • v_fire_station: Many-to-One (N:1)

    • Many apparatus belong to one station

    • Referenced through fire_station_id

  • v_work_order: One-to-Many (1:N)

    • One apparatus can have many work orders

    • Referenced through apparatus_id


Table


Column

Type

Description

id

integer

Primary key

name

varchar(40)

Apparatus name

apparatus_type_code

varchar(3)

Type code

vehicle_number

varchar(25)

Vehicle number

primary_use_code

varchar(2)

Primary use

vehicle_id

varchar(25)

Vehicle ID

unit_call_sign

varchar(40)

Call sign

vin_number

varchar(17)

VIN

model

varchar(40)

Model

engine

varchar(40)

Engine details

tank_volume

integer

Tank volume

pump_type

varchar(40)

Pump type

fire_station_id

integer

Station reference

odometer

numeric(8,2)

Odometer reading

apparatus_group_id

integer

Group reference

manufacturer

varchar(40)

Manufacturer

manufacture_year

smallint

Year made

pto_hours

numeric(8,2)

PTO hours

pump_hours

numeric(8,2)

Pump hours

engine_hours

numeric(8,2)

Engine hours





    • Related Articles

    • v_incident_report_apparatus

      Purpose Apparatus response details for incidents. Relationships v_incident_report: Many-to-One (N:1) Many apparatus responses link to one incident Referenced through incident_report_id v_apparatus: Many-to-One (N:1) Many responses link to one ...

    • v_dispatch

      Purpose Emergency dispatch records view. Relationship v_incident_report: One-to-Many (1:N) One dispatch can have many incident reports Referenced through xref_id v_apparatus: Many-to-Many (N:M) Many dispatches can involve many apparatus Referenced ...

    • v_personnel

      Purpose Personnel information and assignments. Relationships v_fire_dept_user: One-to-One (1:1) One personnel links to one user account Referenced through id/personnel_id f_all_schedule: One-to-Many (1:N) One personnel can have many schedules ...

    • v_asset_inspection_completed

      Purpose Completed asset inspection records view. Relationships v_apparatus: Many-to-One (N:1) Many inspections link to one apparatus Referenced through apparatus_id v_equipment: Many-to-One (N:1) Many inspections link to one equipment item Referenced ...

    • v_incident_report_personnel

      Purpose Personnel response records for incidents. Relationships v_incident_report_apparatus: Many-to-One (N:1) Many personnel link to one apparatus response Referenced through incident_report_apparatus_id v_personnel: Many-to-One (N:1) Many responses ...