small_treatment_plant

-1 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
obj_id varchar 16 tww_app.generate_oid('tww_od'::text, 'small_treatment_plant'::text)
wastewater_structure.obj_id oorel_od_small_treatment_plant_wastewater_structure C

INTERLIS STANDARD OID (with Postfix/Präfix), see www.interlis.ch
approval_number text 2147483647 √ null

yyy_Bewilligungsnummer der Aufsichtsbehörde / Bewilligungsnummer der Aufsichtsbehörde / Numéro d’autorisation de l’autorité de surveillance
function int4 10 √ null
small_treatment_plant_function.code fkey_vl_small_treatment_plant_function R

yyy_Art des Verfahrens / Art des Verfahrens / Genre de procédé
installation_number int4 10 √ null

yyy_ARA-Nummer gemäss BAFU / ARA-Nummer gemäss BAFU / Numéro de la STEP selon l’OFEV
remote_monitoring int4 10 √ null
small_treatment_plant_remote_monitoring.code fkey_vl_small_treatment_plant_remote_monitoring R

Indexes

Constraint Name Type Sort Column(s)
pkey_tww_od_small_treatment_plant_obj_id Primary key Asc obj_id

Check Constraints

Constraint Name Constraint
sm_approval_number_length_max_50 ((char_length(approval_number) <= 50))

Relationships

Close relationships within degrees of separation