v_equipment

v_equipment

Purpose

  1. 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 inspections

    • Referenced through equipment_id

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

    • Many equipment items assigned to one personnel

    • Referenced through assigned_user_name



Table



Column

Type

Description

id

integer

Primary key

name

varchar(100)

Equipment name

model

varchar(255)

Model number

make

varchar(255)

Manufacturer

serial_number

varchar(255)

Serial number

description

varchar(255)

Description

created_at

timestamp

Creation time

in_service

boolean

Service status

manufacture_year

integer

Year made

equipment_type

varchar(20)

Type code

equipment_group_name

varchar(100)

Group name

client_code

varchar(28)

Organization ID

assigned_user_name

varchar(255)

Assigned to

size_inseam

numeric(5,2)

Size inseam

weight

integer

Weight

inventory_count

integer

Count

inventory_min

integer

Min threshold

inventory_max

integer

Max threshold

estimated_replacement_cost

numeric(9,2)

Replace cost




    • Related Articles

    • 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_work_order

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

    • v_checklist_question_answers

      Purpose Checklist completion records view. Relationships v_personnel: Many-to-One (N:1) Many answers link to one personnel Referenced through personnel_id v_equipment: Many-to-One (N:1) Many answers link to one equipment Referenced through asset ...

    • Equipment List: Editing Equipment

      Purpose The purpose of this article is to inform users how to edit an existing equipment item in the First Due system. Video Directions 1. Click on Assets. 2. Click on Equipment List. 3. Locate the equipment item that is to be edited. 4. Click the ...

    • v_nfirs_firefighter_casualty_equipment

      Purpose Equipment related to firefighter casualties. Relationships v_nfirs_firefighter_casualty: Many-to-One (N:1) Many equipment records link to one casualty Referenced through nfirs_firefighter_casualty_id Table Column Type Description id integer ...