WTP
Tables (17)
CopyOfCopyOfCopyOftreatment_process2
- Key — VARCHAR(255) — Primary key — NOT NULL
- id — int4 — Foreign key → water_plant.id — NOT NULL
- Field — VARCHAR(255)
- Field2 — VARCHAR(255)
- Field3 — VARCHAR(255)
- Field4 — VARCHAR(255)
- Field5 — VARCHAR(255)
- Field6 — VARCHAR(255)
- Field7 — VARCHAR(255)
CopyOfCopyOftreatment_process
- Key — VARCHAR(255) — Primary key — NOT NULL
- Field — VARCHAR(255)
- Field2 — VARCHAR(255)
- Field3 — VARCHAR(255)
- Field4 — VARCHAR(255)
- Field5 — VARCHAR(255)
- Field6 — VARCHAR(255)
- Field7 — VARCHAR(255)
CopyOfCopyOftreatment_process2
- Key — VARCHAR(255) — Primary key — NOT NULL
- id — int4 — Foreign key → water_plant.id — NOT NULL
- Field — VARCHAR(255)
- Field2 — VARCHAR(255)
- Field3 — VARCHAR(255)
- Field4 — VARCHAR(255)
- Field5 — VARCHAR(255)
- Field6 — VARCHAR(255)
- Field7 — VARCHAR(255)
CopyOftreatment_process
- Key — VARCHAR(255) — Primary key — NOT NULL
- Field — VARCHAR(255)
- Field2 — VARCHAR(255)
- Field3 — VARCHAR(255)
- Field4 — VARCHAR(255)
- Field5 — VARCHAR(255)
- Field6 — VARCHAR(255)
- Field7 — VARCHAR(255)
CopyOftreatment_process2
- Key — VARCHAR(255) — Primary key — NOT NULL
- id — int4 — Foreign key → water_plant.id — NOT NULL
- Field — VARCHAR(255)
- Field2 — VARCHAR(255)
- Field3 — VARCHAR(255)
- Field4 — VARCHAR(255)
- Field5 — VARCHAR(255)
- Field6 — VARCHAR(255)
- Field7 — VARCHAR(255)
CopyOfwater_large_areas
- address — int4 — Primary key — NOT NULL
- small_name — varchar(10) — Foreign key → water_small_areas.small_name — NOT NULL
- name — varchar(10) — NOT NULL
- date — VARCHAR(255)
- num_cell — VARCHAR(255)
- chl_a — VARCHAR(255)
- version — varchar(20) — NOT NULL
emd_areas
- id — int4 — Primary key — NOT NULL
- sigg_id — int4 — Foreign key → sigg_areas.id — NOT NULL
- adm_code — varchar(2) — NOT NULL
- name — varchar(50) — NOT NULL
- version — varchar(20) — NOT NULL
emd_water
- id — int4 — Primary key — NOT NULL
- small_name — varchar(10) — Foreign key → water_small_areas.small_name — NOT NULL
- id2 — int4 — Foreign key → emd_areas.id — NOT NULL
sido_areas
- id — int4 — Primary key — NOT NULL
- adm_code — varchar(2) — NOT NULL
- name — varchar(50) — NOT NULL
- version — varchar(20) — NOT NULL
sigg_areas
- id — int4 — Primary key — NOT NULL
- sido_id — int4 — Foreign key → sido_areas.id — NOT NULL
- adm_code — varchar(2)
- name — varchar(50)
- version — varchar(20)
target_advanced_water
- id2 — int4 — Foreign key → water_plant.id — NOT NULL
target_standard_water
- id2 — int4 — Foreign key → water_plant.id — NOT NULL
treatment_process
- Key — VARCHAR(255) — Primary key — NOT NULL
- Field — VARCHAR(255)
- Field2 — VARCHAR(255)
- Field3 — VARCHAR(255)
- Field4 — VARCHAR(255)
- Field5 — VARCHAR(255)
- Field6 — VARCHAR(255)
- Field7 — VARCHAR(255)
water_large_areas
- id — int4 — Primary key — NOT NULL
- name — varchar(10) — NOT NULL
- version — varchar(20) — NOT NULL
water_plant
- id — int4 — Primary key — NOT NULL
- id2 — int4 — Foreign key → emd_areas.id — NOT NULL
- small_name — varchar(10) — Foreign key → water_small_areas.small_name — NOT NULL
- Quantity — VARCHAR(255)
- standard_process — json — NOT NULL
- advanced_process — json — NOT NULL
water_quality
- id — VARCHAR(255) — Primary key — NOT NULL
- large_id — int4 — Foreign key → water_large_areas.id — NOT NULL
- name — VARCHAR(255)
- date — VARCHAR(255) — NOT NULL
- do — VARCHAR(255)
- ph — VARCHAR(255)
- temperature — VARCHAR(255)
- bod — VARCHAR(255)
- cod — VARCHAR(255)
- tn — varchar(20) — NOT NULL
- tp — VARCHAR(255)
- toc — VARCHAR(255)
- nh3n — VARCHAR(255)
- no3n — VARCHAR(255)
- ss — VARCHAR(255)
- h_ion_con — VARCHAR(255)
- MPN — VARCHAR(255)
- annxe_MPN — VARCHAR(255)
- version — varchar(20) — NOT NULL
water_small_areas
- small_name — varchar(10) — Primary key — NOT NULL
- id — int4 — Foreign key → water_large_areas.id — NOT NULL
- version — varchar(20) — NOT NULL