Laserfiche WebLink
<br />Structure <br />i structure nurn I <br />rolodex_num <br />wctwater_num <br />drv <br />wd <br />;d <br />stf_mite I. <br />i du <br />,stUvpe I <br />sir name I; <br />STRTYPE <br />dafd <br />, <br /> <br />River Network <br />node_id <br />effective date <br /> <br />structure_type <br />upstream_node <br />downstream_node <br />length <br />lag_loss_type <br />pCupstream <br />pCdownstream <br />current call <br />previous_call <br /> <br />Meas type <br />station_num <br />meas nurn <br /> <br />meas_type <br />time_step <br />start_year <br />endj'ear .t <br /> <br />SCOPE ERD <br /> <br />- ~ <br /> <br />:DMINISTRATIVE ) <br />structure num (FK) ), <br />--1, <br />.... I <br />// <br /> <br />/ <br /> <br />\ <br /> <br />WIS Comments <br />sheeLname <br />set date <br /> <br />comment ~ <br /> <br />""""""''I'T'rT'''''''''''''''''''''.''; <br /> <br />WIS Data <br />structure_num (fK) <br />set dale <br /> <br />oat_flow <br />delivery_flow <br />toLflow <br />repl_f1ow <br />dry_river <br />In.pri~rity-direct <br />1 tn.prioritLstorage <br />I Exchange_direct _ <br />i Exchange_storage <br />" Delivery_direct <br />Delivery_storage <br />I ;reS_Change <br />res_storage <br />comments <br /> <br />Calfs <br />structure_num (FK) <br />call num <br />date time set <br />date-time -released <br />admlnno - <br />set_comments <br />release_comments <br />release_call_num <br />deleted <br /> <br />Lag 10$$ name <br />la9-lo$$ num <br />I Description <br /> <br />.~;"---;-_._-,.....,,.,., <br /> <br />real time <br />meastype_num m <br />station_num (FK) ~ <br />meas num (FK) -t <br />datatype <br />VAX_field <br /> <br />, <br />I <br /> <br />Priority Divr <br />(structure_num (FK) <br />il! seLdate (Ft<) <br />adminno <br />amount <br />I why <br /> <br />Delivery_Oivr <br />structure_num (FK) <br />set_date (FK) <br />from_structure_num <br />adminno <br /> <br />from_type <br />I ~~h.~unt <br />"") <br />I l comments <br /> <br />Res release <br /> <br />L( structure_num (FK) <br />seCdate (FK) <br />divert structure num <br />adminno - <br /> <br />delivery_type <br />amount <br />why <br />comments <br /> <br />! <br /> <br />-,."";rr.-c;-,,','-,,-,,,-.. <br /> <br />Lag loss type <br />lag_loss_num (FK) <br />lower_flow_boundary <br />upper flow_boundary <br />velocity <br />loss <br />hot <br />cold <br />wet <br />freeze <br /> <br />j <br />'#ti.,+t,_.....,..,.,.,..'''"..........~ <br /> <br />A data type can be a FLOW. <br />ElEV, or STOR. <br />A measurement station can have <br />more than one datatype associated <br />with it. AND a specific datatype can <br />have more than 1 measUfement_ <br /> <br />4/24/97 <br /> <br />J <br /> <br />RTmeas <br />meastype_"um (FK) <br />station_num (FK) <br />meas num (FK) <br />date_time <br />amI <br />unit <br /> <br />WIS Format <br />sheet name <br />WIS row id <br />effective date <br />write_flag <br />row_type <br />row_label <br />structure_num <br />first fOW flag <br />next-:='WIS_row_id <br /> <br />'1,) 4\ <br />\) ... <br /> <br />WIS Formula' <br />j - --- <br />I sheet_name <br />WIS_row_id <br />column num <br />: start d.rte <br />rtO(n1~la --. -. <br />, <br />; end date <br />~ ------ --.-.- <br /> <br />10 <br />