pipe_section

-1 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
obj_id varchar 16 tdh_app.generate_oid('tdh_od'::text, 'pipe_section'::text)
sia405pt_protection_tube.fk_pipe_section rel_od_sia405pt_protection_tube_fk_pipe_section R

INTERLIS STANDARD OID (with Postfix/Präfix), see www.interlis.ch
name_number text 2147483647 √ null
geometry3d_geometry geometry 2147483647 √ null
horizontal_positioning int4 10 √ null
pipe_section_horizontal_positioning.code fkey_vl_pipe_section_horizontal_positioning R
status int4 10 √ null
pipe_section_status.code fkey_vl_pipe_section_status R

Operating and planning status of the structure / Betriebs- bzw. Planungszustand des Bauwerks / Etat de fonctionnement et de planification de l’ouvrage
function int4 10 √ null
pipe_section_function.code fkey_vl_pipe_section_function R
pipe_type int4 10 √ null
pipe_section_pipe_type.code fkey_vl_pipe_section_pipe_type R
fluent int4 10 √ null
pipe_section_fluent.code fkey_vl_pipe_section_fluent R
temperature int4 10 √ null
nominal_pressure int2 5 √ null
operating_pressure int2 5 √ null
insulation_thickness int2 5 √ null
insulation_kind int4 10 √ null
pipe_section_insulation_kind.code fkey_vl_pipe_section_insulation_kind R
coating int4 10 √ null
pipe_section_coating.code fkey_vl_pipe_section_coating R
diameter_inner int2 5 √ null
diameter_outer int2 5 √ null
diameter_nominal text 2147483647 √ null

as TEXT, as in some cases double values with slash (eg. 1500/800) / als TEXT, da zum Teil auch Doppelwerte mit Schrägstrich (z.B. 1500/800) / comme TEXTE, parcequ’on a aussi des valeurs doubles (par example 1500/800)
length1 int4 10 √ null

yyy_Laenge_abgewickelt / Laenge_abgewickelt / longueur développée
length2 int4 10 √ null

yyy_Laenge_berechnet / Laenge_berechnet / longueur calculée
pipe_brand text 2147483647 √ null
pipeline_quality int4 10 √ null
pipe_section_pipeline_quality.code fkey_vl_pipe_section_pipeline_quality R
installation_year int2 5 √ null
documentation text 2147483647 √ null

yyy_Zeichnungsnummer / Dossiernummer / Zeichnungsnummer / Dossiernummer / numéro de dessin / numéro de dossier
mandate text 2147483647 √ null

zzz_désignation du mandat / Bezeichnung des Auftrags / désignation du mandat
remark text 2147483647 √ null

General remarks
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_pipe_section_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_pipe_section_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
fk_owner varchar 16 √ null
organisation.obj_id rel_pipe_section_owner N
fk_pipeline_company varchar 16 √ null
organisation.obj_id rel_pipe_section_pipeline_company N
mg_material int4 10 √ null
pipe_section_mg_material.code fkey_vl_pipe_section_mg_material R

Categories of materials Morges / Kategorien Material Morges / Categories des materiaux Morges
mg_diameter int4 10 √ null
pipe_section_mg_diameter.code fkey_vl_pipe_section_mg_diameter R

Linked to table of specified (nominal) diameters and material Morges for simplified recording / Verknüpft mit Tabelle der vorgegebenen (Nenn-)weiten und Material Morges zur vereinfachten Erfassung / Lier au tableau des diamètres (nominaux) prescrits et du matériau Morges pour simplifier la saisie
mg_trench_type int4 10 √ null
pipe_section_mg_trench_type.code fkey_vl_pipe_section_mg_trench_type R
trench_width int2 5 √ null
mg_remark_civil_eng text 2147483647 √ null

Extension Morges - Remarks from civil engineering / Erweiterung Morges - Zusatzbemerkungen Bauingenieur / Extension Morges - Remarques complémentaires ingénieur civil
mg_signaling_band int4 10 √ null
pipe_section_mg_signaling_band.code fkey_vl_pipe_section_mg_signaling_band R

/ Les conduites sont marquées par une bande de signalisation de couleur

Indexes

Constraint Name Type Sort Column(s)
pkey_tdh_od_pipe_section_obj_id Primary key Asc obj_id
in_od_pipe_section_name_number Must be unique Asc/Asc name_number + fk_dataowner
in_tdh_pipe_section_geometry3d_geometry Performance Asc geometry3d_geometry

Check Constraints

Constraint Name Constraint
ps_pipe_brand_length_max_40 ((char_length(pipe_brand) <= 40))
ps_documentation_length_max_40 ((char_length(documentation) <= 40))
ps_name_number_length_max_40 ((char_length(name_number) <= 40))
ps_remark_length_max_80 ((char_length(remark) <= 80))
ps_diameter_nominal_length_max_10 ((char_length(diameter_nominal) <= 10))
ps_mandate_length_max_40 ((char_length(mandate) <= 40))
ps_mg_remark_civil_eng_length_max_80 ((char_length(mg_remark_civil_eng) <= 80))

Relationships

Close relationships within degrees of separation