v_hydrant
Table Name: v_hydrant
Last Updated: June 01, 2026 at 01:22 AM
Columns
| Column Name | Data Type | Nullable | Default |
|---|---|---|---|
| id | integer | Yes | - |
| client_code | character | Yes | - |
| facility_code | character | Yes | - |
| hydrant_type_code | character | Yes | - |
| year | smallint | Yes | - |
| fort_lauderdale_owner_code | character | Yes | - |
| latitude | numeric(9 | Yes | - |
| longitude | numeric(10 | Yes | - |
| hydrant_status_code | character | Yes | - |
| inspected_at | timestamp | Yes | - |
| area_ids_cache | text | Yes | - |
| static_pressure | numeric(10 | Yes | - |
| residual_pressure | numeric(10 | Yes | - |
| xref_id | character | Yes | - |
| base_color_code | character | Yes | - |
| manufacturer | character | Yes | - |
| num_outlet | integer | Yes | - |
| steamer_port | character | Yes | - |
| outlet_size2 | character | Yes | - |
| outlet_size3 | character | Yes | - |
| source | character | Yes | - |
| location | text | Yes | - |
| cistern_capacity_gallons | integer | Yes | - |
| main_size | integer | Yes | - |
| barrel_size | numeric | Yes | - |
| calculated_flow_rate | numeric(10 | Yes | - |
| residual_flow_rate | numeric(10 | Yes | - |
| last_flow_tested_at | timestamp | Yes | - |
| route | numeric | Yes | - |
| water_department | character | Yes | - |
| model | character | Yes | - |
| notes | text | Yes | - |
| is_private | boolean | Yes | - |
| created_by | integer | Yes | - |
| inspected_by | integer | Yes | - |
| address | character | Yes | - |
| fire_station_id | integer | Yes | - |
| apparatus_id | integer | Yes | - |
| batt_dept_shift_id | integer | Yes | - |
| assigned_user_id | integer | Yes | - |
| fire_zone_id | integer | Yes | - |
| hydrant_type_name | character | Yes | - |
| closest_address | text | Yes | - |
| fire_zone_name | character | Yes | - |
| inspected_name | character | Yes | - |
| created_by_name | character | Yes | - |
| hydrant_zone | character | Yes | - |
| place_id | integer | Yes | - |
| apparatus_name | character | Yes | - |
| batt_dept_shift_name | character | Yes | - |
| reason_out_of_service | text | Yes | - |
| responsible_occupancy_address | text | Yes | - |
| days_since_last_service | numeric | Yes | - |
| days_since_last_flow_test | numeric | Yes | - |
This documentation is automatically generated from the ODBC Data Warehouse schema.