ud_rpt_cat_result - Giswater/giswater_dbmodel GitHub Wiki
Description:
Catalog of SWMM modelling process.
Fields:
| Column name | Data type | Description |
|---|---|---|
| result_id | character varying(30) | Id of a model result |
| flow_units | character varying(3) | Choice of flow units |
| rain_runof | character varying(3) | Rain runoff calculations was performed |
| snowmelt | character varying(3) | Snowmelt calculations was performed |
| groundw | character varying(3) | Groundwater calculations was performed |
| flow_rout | character varying(3) | Flow routing calculations was performed |
| pond_all | character varying(3) | Allows excess water to collect atop nodes and be reintroduced into the system as conditions permit |
| water_q | character varying(3) | Water quality calculations was performed |
| infil_m | character varying(18) | Controls how infiltration of rainfall into the upper soil zone of subcatchments is modeled |
| flowrout_m | character varying(18) | Determines which method is used to route flows through the drainage system |
| start_date | character varying(25) | Model start date |
| end_date | character varying(25) | Model end date |
| dry_days | numeric (12,4) | The number of days with no rainfall prior to the start of the simulation. |
| rep_tstep | character varying(10) | The time interval for reporting of computed results |
| wet_tstep | character varying(10) | The time step length used to compute runoff from subcatchments during periods of rainfall or when ponded water still remains on the surface |
| dry_tstep | character varying(10) | The time step length used for runoff computations during periods when there is no rainfall and no ponded water |
| rout_tstep | character varying(10) | The time step length in seconds used for routing flows and water quality constituents through the conveyance system |
| var_time_step | character varying(3) | |
| max_trials | numeric (4,2) | Maximum number of trials used to solve the nonlinear equations that govern network hydraulics at a given point in time |
| head_tolerance | character varying(12) | |
| exec_date | timestamp(6) without time zone | Data of process execution, now by default |
| cur_user | text | Name of user |
| inp_options | json | Simulation options |
| rpt_stats | json | Result statistics |
| export_options | json | Export options |
| network_stats | json | Network statistics |
| status | smallint | Simulation status |