종합평가 관련
테이블 (4)
tbl_comp_eval_mng
- eval_id — serial — 기본 키 — NOT NULL
- eval_nm — varchar(70)
- user_id — varchar(30)
- reg_dttm — timestamp
- updt_dttm — timestamp
- eval_stat — varchar
- area_id — int4
tbl_eval_area_mng
- area_id — serial — 기본 키 — NOT NULL
- area_nm — varchar(20)
tbl_water_qlty
- qlty_id — serial — 기본 키 — NOT NULL
- inspec_cd — varchar
- inspec_nm — varchar
- inspec_ym — varchar
- inspec_addr — varchar
- area_cd — varchar
- area_nm — varchar
- river_cd — varchar
- river_nm — varchar
- wt_ph — float4
- wt_do — float4
- wt_cod — float4
- wt_bod — float4
- wt_ss — float4
- wt_tn — float4
- wt_tp — float4
- wt_colif — float4
- wt_chl_a — float4
- ori_yn — varchar
- eval_id — int4
tbl_water_qlty_mapp
- qlty_mapp_id — serial — 기본 키 — NOT NULL
- qlty_id — int4