IHFS DATABASE (VERSION OB-4  BASELINE)
Relative to IHFS Database Version OB-3 Baseline
(REVISED: 06/18/2004)

Unmodified Views = 17
Deleted Views = 4
New Views = 0
Modified Views = 3
View Count = 16

Unmodified Stored Procedures = 10
Deleted Stored Procedures = 0
New Stored Procedures = 0
Modified Stored Procedures = 2
Procedure Count = 12

Unmodified Triggers = 6
Deleted Triggers = 0
New Triggers = 0
Modified Triggers = 0
Trigger Count = 6
 

Dam Catalogue table no longer used

Added column "email" (char(60));

removed foreign key referencing RiverStat;  added foreign key (lid) references Location;

Renamed column "old" to "olddatum"; old is a reserved word for PostgreSQL.

Modified prelim field's value.  All "X" set to "P" for preliminary; all " " set to "O" for official.  Then the max stage has its prelim value set to "R" for record.  This change was actually implemented for OB3.3.

Added columns "beam_width" (smallfloat), "blockage_thresh" (smallfloat), "clutter_thresh" (smallfloat), "weight_thresh" (smallfloat), "hybrid_scan_thresh" (smallfloat), "low_reflect_thresh" (smallfloat), "detect_reflect_thr" (smallfloat), "detect_area_thr" (smallfloat), "detect_time_thresh" (smallfloat), "exclusion_zones" (smallfloat)

Added columns "block_bins_reject" (int), "clutter_bins_rej" (int), "bins_smoothed" (int), "scan_bins_filled" (smallfloat), "high_elev_angle" (smallfloat), "scan_rain_area" (smallfloat)

Dam Catalogue table no longer used

Dam Catalogue table no longer used

Dam Catalogue table no longer used

Dam Catalogue table no longer used

Added field office_id (char(6)) to indicate the office which is responsible for the forecast point forecast represented in the product issuance.  Note that this change was actually implemented with OB3.3.

Dam Catalogue table no longer used

Stage2 table no longer used

Stage2 table no longer used

table contains columns "lid" (char(8)), "pe" (char(2)), "dur" (smallint), "ts" (char(2)), "extremum" (char(1)), "adjustment" (char(1)), "postingtime" (datetime year to sec), "jan_value" (float), "feb_value" (float), "mar_value" (float), "apr_value" (float), "may_value" (float), "jun_value" (float), "jul_value" (float), "aug_value" (float), "sep_value" (float), "oct_value" (float), "nov_value" (float), "dec_value" (float); used by SiteSpecific application;

Dam Catalogue table no longer used

Dam Catalogue table no longer used

Dam Catalogue table no longer used

Dam Catalogue table no longer used

Dam Catalogu table no longer used

Dam Catalogue table no longer used

Dam Catalogue table no longer used

Dam Catalogue table no longer used

Dam Catalogue table no longer used

Dam Catalogue table no longer used

Dam Catalogue table no longer used

Dam Catalogue table no longer used

Dam Catalogue table no longer used

Dam Catalogue table no longer used

Added column "email" (char(60));

Stage2/Stage3 table no longer used

no structural change; added record for new SacSmaState table; removed records for LatestBiasLong, LatestBiasShort, Stage2Result, RWVerif and PseudoGageRadarVal tables;

unused table

Added columns "primary_back" (char(3)) and "secondary_back" (char(3)).  Note that this changes was actually implemented with OB3.3.

Stage2 table no longer used

Stage2 table no longer used

Stage2 table no longer used

Stage2 table no longer used

table contains columns "basin_id" (char (8)), "source" (char (20)), "validtime" (datetime year to sec), "postingtime" (datetime year to sec), "uztwm" (float), "uzfwm" (float), "uzk" (float), "pctim" (float), "adimp" (float), "riva" (float), "zperc" (float),  "rexp" (float), "lztwm" (float), "lzfsm" (float), "lzfpm" (float), "lzsk" (float), "lzpk" (float), "pfree" (float), "rserv" (float), "side" (float), "peadj" (float), "pxadj" (float), "efc" (float);  each record contains one set of parameters for the Sacramento Soil Moisture Accounting Model for a particular location and time; used by SiteSpecific application;

table contains columns "basin_id" (char (8)), "source" (char (20)), "validtime" (datetime year to sec), "basistime" (datetime year to sec), "postingtime" (datetime year to sec), "uztwc" (float), "uzfwc" (float), "lztwc" (float), "lzfsc" (float), "lzfpc" (float), "adimc" (float); each record contains one set of state (carryover) variables for the Sacramento Soil Moisture Accounting Model for a particular location and time; used by SiteSpecific application;

table contains columns "lid" (char(8)), "basin_id" (char(8)), "postingtime" (datetime year to sec), "model_pref" (char(20)), "auto_process" (char(1)), "source_pref" (char(20)), "use_static_evap" (char(1)); used by SiteSpecific application;

Stage2 table no longer used

Stage3 table no longer used

Stage3 table no longer used

Dam Catalogue table no longer used

removed foreign key referencing RiverStat; added foreign key (lid) references Location;

Dam Catalogue view no longer used

Dam Catalogue view no longer used

Dam Catalogue view no longer used

Added columns primary_back and secondary_back from RpfFcstPoint table.  Note that this changes was actually implemented with OB3.3.

Added hsa field to select list;

Dam Catalogue view no longer used

Modified where clause associated with view to include all products that are not O, F, or C (observed, forecast, contingency).  Note that this changes was actually implemented with OB3.3.

removed RWVerif table from list of tables;

removed PseudoGageRadarVal, Stage2Result, LatestBiasLong, LatestBiasShort, S2BiasCalcParams, S2GeneralParams, S2ggGridParams and S2mlGridParams tables from list of tables;