search

rssidlowski / Hydrants

City of Baltimore Fire Hydrant Inspections
0 stars 0 forks source link

Database: changes to hydrant_inspections table #1

Closed rssidlowski closed 9 years ago

rssidlowski commented 9 years ago

Environment: vm-1108s08 Make the following changes to the hydrant_inspections table

  1. Rename to HYDRANT_STATUS
  2. Rename WORK_REQ to CSR_SR_NUM
  3. Add CW_SR_NUM
  4. Remove LOCATION_DESC
  5. Remove CUSTODIAL_LOCK_TYPE
  6. Remove SURFACE_COVER_TYPE
  7. Add INSP_TYPE
  8. Add BROKEN_FLANGE_YN Add flow test fields to HYDRANT_STATUS
  9. FLOW_STATIC_PSI
  10. FLOW_RESID_PSI
  11. FLOW_AT_20PSI
rssidlowski commented 9 years ago

hyd_insp_fields1

gerrykelly commented 9 years ago

this was done