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

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

      Purpose EMS incident details for NFIRS reporting. Relationships v_incident_report_people: Many-to-One (N:1) Many EMS records link to one person Referenced through incident_report_people_id v_nfirs_ems_medication: One-to-Many (1:N) One EMS record can ...

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