v_work_order

v_work_order

Purpose

  1. Equipment/apparatus work order records.

Relationships

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

    • Many work orders link to one apparatus

    • Referenced through apparatus_id

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

    • Many work orders link to one equipment item

    • Referenced through equipment_id

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

    • Many work orders created by one personnel

    • Referenced through created_by



Table



Column

Type

Description

id

integer

Primary key

summary

varchar(255)

Work summary

description

text

Full description

client_code

varchar(28)

Organization ID

apparatus_id

integer

Apparatus reference

apparatus_name

varchar(40)

Apparatus name

equipment_id

integer

Equipment reference

equipment_name

varchar(100)

Equipment name

fire_station_id

integer

Station reference

station_num

varchar(64)

Station number

board_id

integer

Board reference

board_name

varchar(255)

Board name

created_at

timestamp

Creation time

work_order_status

varchar(255)

Status

work_order_type

varchar(255)

Order type

created_by

integer

Creator reference

created_by_name

varchar(255)

Creator name

is_archived

boolean

Archive status

parts_cost

numeric

Parts cost

labor_hours

numeric

Labor hours

labor_cost

numeric

Labor cost





    • Related Articles

    • v_apparatus

      Purpose 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 ...

    • v_equipment

      Purpose Equipment inventory and tracking. Relationships v_work_order: One-to-Many (1:N) One equipment item can have many work orders Referenced through equipment_id v_asset_inspection_completed: One-to-Many (1:N) One equipment item can have many ...

    • Work Order Boards: General Navigation

      Purpose Statement The Work Order Boards within the Assets module provide a centralized Kanban-style interface for creating, tracking, and managing maintenance work orders across all department assets. Background Information Work Order Boards serve as ...

    • Work Orders: Modifying an Existing Work Order

      Purpose The purpose of this article is to inform users how to make modifications/changes to and existing work order for an apparatus, station, equipment item, or kit in the First Due Assets Module. Video Directions There are three locations to ...

    • Work Orders: Modifying an Existing Work Order

      Purpose The purpose of this article is to inform users how to make modifications/changes to and existing work order for an apparatus, station, equipment item, or kit in the First Due Assets Module. Video Directions There are three locations to ...