organisation

-1 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
obj_id varchar 16 tww_app.generate_oid('tww_od'::text, 'organisation'::text)
building_group.fk_dataowner rel_od_building_group_fk_dataowner R
building_group.fk_provider rel_od_building_group_fk_dataprovider R
building_group_baugwr.fk_dataowner rel_od_building_group_baugwr_fk_dataowner R
building_group_baugwr.fk_provider rel_od_building_group_baugwr_fk_dataprovider R
catchment_area.fk_dataowner rel_od_catchment_area_fk_dataowner R
catchment_area.fk_provider rel_od_catchment_area_fk_dataprovider R
catchment_area_totals.fk_dataowner rel_od_catchment_area_totals_fk_dataowner R
catchment_area_totals.fk_provider rel_od_catchment_area_totals_fk_dataprovider R
connection_object.fk_dataowner rel_od_connection_object_fk_dataowner R
connection_object.fk_provider rel_od_connection_object_fk_dataprovider R
control_center.fk_dataowner rel_od_control_center_fk_dataowner R
control_center.fk_provider rel_od_control_center_fk_dataprovider R
damage.fk_dataowner rel_od_damage_fk_dataowner R
damage.fk_provider rel_od_damage_fk_dataprovider R
data_media.fk_dataowner rel_od_data_media_fk_dataowner R
data_media.fk_provider rel_od_data_media_fk_dataprovider R
disposal.fk_dataowner rel_od_disposal_fk_dataowner R
disposal.fk_provider rel_od_disposal_fk_dataprovider R
dss15_aquifer.fk_dataowner rel_od_dss15_aquifer_fk_dataowner R
dss15_aquifer.fk_provider rel_od_dss15_aquifer_fk_dataprovider R
farm.fk_dataowner rel_od_farm_fk_dataowner R
farm.fk_provider rel_od_farm_fk_dataprovider R
file.fk_dataowner rel_od_file_fk_dataowner R
file.fk_provider rel_od_file_fk_dataprovider R
hq_relation.fk_dataowner rel_od_hq_relation_fk_dataowner R
hq_relation.fk_provider rel_od_hq_relation_fk_dataprovider R
hydr_geom_relation.fk_dataowner rel_od_hydr_geom_relation_fk_dataowner R
hydr_geom_relation.fk_provider rel_od_hydr_geom_relation_fk_dataprovider R
hydr_geometry.fk_dataowner rel_od_hydr_geometry_fk_dataowner R
hydr_geometry.fk_provider rel_od_hydr_geometry_fk_dataprovider R
hydraulic_char_data.fk_dataowner rel_od_hydraulic_char_data_fk_dataowner R
hydraulic_char_data.fk_provider rel_od_hydraulic_char_data_fk_dataprovider R
log_card.fk_agency rel_log_card_agency N
log_card.fk_dataowner rel_od_log_card_fk_dataowner R
log_card.fk_location_municipality rel_log_card_location_municipality N
log_card.fk_provider rel_od_log_card_fk_dataprovider R
maintenance_event.fk_dataowner rel_od_maintenance_event_fk_dataowner R
maintenance_event.fk_operating_company rel_maintenance_event_operating_company N
maintenance_event.fk_provider rel_od_maintenance_event_fk_dataprovider R
measure.fk_dataowner rel_od_measure_fk_dataowner R
measure.fk_provider rel_od_measure_fk_dataprovider R
measure.fk_responsible_entity rel_measure_responsible_entity N
measure.fk_responsible_start rel_measure_responsible_start N
measurement_result.fk_dataowner rel_od_measurement_result_fk_dataowner R
measurement_result.fk_provider rel_od_measurement_result_fk_dataprovider R
measurement_series.fk_dataowner rel_od_measurement_series_fk_dataowner R
measurement_series.fk_provider rel_od_measurement_series_fk_dataprovider R
measuring_device.fk_dataowner rel_od_measuring_device_fk_dataowner R
measuring_device.fk_provider rel_od_measuring_device_fk_dataprovider R
measuring_point.fk_dataowner rel_od_measuring_point_fk_dataowner R
measuring_point.fk_operator rel_measuring_point_operator N
measuring_point.fk_provider rel_od_measuring_point_fk_dataprovider R
mechanical_pretreatment.fk_dataowner rel_od_mechanical_pretreatment_fk_dataowner R
mechanical_pretreatment.fk_provider rel_od_mechanical_pretreatment_fk_dataprovider R
mutation.fk_dataowner rel_od_mutation_fk_dataowner R
mutation.fk_provider rel_od_mutation_fk_dataprovider R
organisation.fk_dataowner rel_od_organisation_fk_dataowner R
organisation.fk_provider rel_od_organisation_fk_dataprovider R
overflow.fk_dataowner rel_od_overflow_fk_dataowner R
overflow.fk_provider rel_od_overflow_fk_dataprovider R
overflow_char.fk_dataowner rel_od_overflow_char_fk_dataowner R
overflow_char.fk_provider rel_od_overflow_char_fk_dataprovider R
pipe_profile.fk_dataowner rel_od_pipe_profile_fk_dataowner R
pipe_profile.fk_provider rel_od_pipe_profile_fk_dataprovider R
profile_geometry.fk_dataowner rel_od_profile_geometry_fk_dataowner R
profile_geometry.fk_provider rel_od_profile_geometry_fk_dataprovider R
reach_point.fk_dataowner rel_od_reach_point_fk_dataowner R
reach_point.fk_provider rel_od_reach_point_fk_dataprovider R
retention_body.fk_dataowner rel_od_retention_body_fk_dataowner R
retention_body.fk_provider rel_od_retention_body_fk_dataprovider R
sia405cc_cable.fk_dataowner rel_od_sia405cc_cable_fk_dataowner R
sia405cc_cable.fk_owner rel_cable_owner N
sia405cc_cable.fk_provider rel_od_sia405cc_cable_fk_dataprovider R
sia405cc_cable_point.fk_dataowner rel_od_sia405cc_cable_point_fk_dataowner R
sia405cc_cable_point.fk_owner rel_sia405cc_cable_point_owner N
sia405cc_cable_point.fk_provider rel_od_sia405cc_cable_point_fk_dataprovider R
sludge_treatment.fk_dataowner rel_od_sludge_treatment_fk_dataowner R
sludge_treatment.fk_provider rel_od_sludge_treatment_fk_dataprovider R
structure_part.fk_dataowner rel_od_structure_part_fk_dataowner R
structure_part.fk_provider rel_od_structure_part_fk_dataprovider R
surface_runoff_parameters.fk_dataowner rel_od_surface_runoff_parameters_fk_dataowner R
surface_runoff_parameters.fk_provider rel_od_surface_runoff_parameters_fk_dataprovider R
throttle_shut_off_unit.fk_dataowner rel_od_throttle_shut_off_unit_fk_dataowner R
throttle_shut_off_unit.fk_provider rel_od_throttle_shut_off_unit_fk_dataprovider R
waste_water_treatment.fk_dataowner rel_od_waste_water_treatment_fk_dataowner R
waste_water_treatment.fk_provider rel_od_waste_water_treatment_fk_dataprovider R
waste_water_treatment_plant.fk_dataowner rel_od_waste_water_treatment_plant_fk_dataowner R
waste_water_treatment_plant.fk_provider rel_od_waste_water_treatment_plant_fk_dataprovider R
wastewater_networkelement.fk_dataowner rel_od_wastewater_networkelement_fk_dataowner R
wastewater_networkelement.fk_provider rel_od_wastewater_networkelement_fk_dataprovider R
wastewater_structure.fk_dataowner rel_od_wastewater_structure_fk_dataowner R
wastewater_structure.fk_operator rel_wastewater_structure_operator N
wastewater_structure.fk_owner rel_wastewater_structure_owner N
wastewater_structure.fk_provider rel_od_wastewater_structure_fk_dataprovider R
wwtp_energy_use.fk_dataowner rel_od_wwtp_energy_use_fk_dataowner R
wwtp_energy_use.fk_provider rel_od_wwtp_energy_use_fk_dataprovider R
zone.fk_dataowner rel_od_zone_fk_dataowner R
zone.fk_provider rel_od_zone_fk_dataprovider R

INTERLIS STANDARD OID (with Postfix/Präfix), see www.interlis.ch

identifier text 2147483647 null

The designation for municipalities is adopted according to the FSO list; for private individuals according to the UID register, if necessary with the addition of the location of the branch if no separate UID exists for it. / Die Bezeichnung für Gemeinden wird gemäss BFS-Liste übernommen; für Private gemäss UID-Register, allenfalls mit Zusatz des Ortes der Filiale, falls keine separate UID dafür besteht. / La désignation pour les communes est reprise selon la liste de l’OFS ; pour les particuliers, selon le registre UID, éventuellement avec l’ajout du lieu de la filiale s’il n’existe pas d’UID séparé pour celle-ci.

identifier_short text 2147483647 null

/ Kurzbezeichnung / désignation abrégée

municipality_number int2 5 null

Official number of municipality of federal office for statistics, mandatory for the municipalities. / Offizielle Gemeinde Nummer gemäss Bundesamt für Statistik, bei Gemeinden zwingend, sonst leer lassen. / Numéro officiel de la commune selon l’Office fédéral de la statistique, obligatoire pour les communes. Sinon, laissez vide.

organisation_type int4 10 null
organisation_organisation_type.code fkey_vl_organisation_organisation_type R

Type of organisatoin / Art der Organisation / Genre d’organisation

remark text 2147483647 null

General remarks / Allgemeine Bemerkungen / Remarques générales

status int4 10 null
organisation_status.code fkey_vl_organisation_status R

yyy_Status der Organisation, damit untergegangende Organisationen nicht einfach gelöscht werden müssen und kontrolliert werden kann, ob noch Beziehungen auf untergegangene Organisationen, z.B. bei Gemeindefusion oder Konkurs einer Firma vorhanden sind / Status der Organisation, damit untergegangende Organisationen nicht einfach gelöscht werden müssen und kontrolliert werden kann, ob noch Beziehungen auf untergegangene Organisationen, z.B. bei Gemeindefusion oder Konkurs einer Firma vorhanden sind / Statut de l’organisation, pour que les organisations disparues ne soient pas simplement supprimées et qu’il soit possible de contrôler s’il existe encore des relations avec les organisations disparues, par exemple en cas de fusion de communes ou de faillite d’une société

uid text 2147483647 null

Reference to the company identification of the Federal Office for Statistics (www.uid.admin.ch), e.g. CHE123456789 / Referenz zur Unternehmensidentifikation des Bundesamts fuer Statistik (www.uid.admin.ch), z.B. CHE123456789 / Référence pour l’identification des entreprises selon l’Office fédéral de la statistique OFS (www.uid.admin.ch), par exemple: CHE123456789

last_modification timestamp 29,6 now()

Last modification / Letzte_Aenderung / Derniere_modification: INTERLIS_1_DATE

fk_dataowner varchar 16 null
organisation.obj_id rel_od_organisation_fk_dataowner R

Foreignkey to Metaattribute dataowner (as an organisation) - this is the person or body who is allowed to delete, change or maintain this object / Metaattribut Datenherr ist diejenige Person oder Stelle, die berechtigt ist, diesen Datensatz zu löschen, zu ändern bzw. zu verwalten / Maître des données gestionnaire de données, qui est la personne ou l’organisation autorisée pour gérer, modifier ou supprimer les données de cette table/classe

fk_provider varchar 16 null
organisation.obj_id rel_od_organisation_fk_dataprovider R

Foreignkey to Metaattribute provider (as an organisation) - this is the person or body who delivered the data / Metaattribut Datenlieferant ist diejenige Person oder Stelle, die die Daten geliefert hat / FOURNISSEUR DES DONNEES Organisation qui crée l’enregistrement de ces données

tww_active bool 1 false

not part of the VSA-DSS data model added solely for TEKSI Wastewater & GEP used to filter organisations

tww_local_extension bool 1 false

not part of the VSA-DSS data model added solely for TEKSI Wastewater & GEP used to map non-harmonized organisations to private on export

Indexes

Constraint Name Type Sort Column(s)
pkey_tww_od_organisation_obj_id Primary key Asc obj_id
in_od_organisation_identifier Must be unique Asc/Asc/Asc identifier + uid + organisation_type

Check Constraints

Constraint Name Constraint
og_identifier_short_length_max_12 ((char_length(identifier_short) <= 12))
og_remark_length_max_255 ((char_length(remark) <= 255))
og_uid_length_max_12 ((char_length(uid) <= 12))
og_identifier_length_max_255 ((char_length(identifier) <= 255))

Relationships