pipe_section

-1 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
obj_id varchar 16 tdh_sys.generate_oid('tdh_od'::text, 'pipe_section'::text)

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
nominal_diameter text 2147483647 √ null

yyy_als TEXT, da zum Teil auch Doppelwerte mit Schrägstrich (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

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_documentation_length_max_40 ((char_length(documentation) <= 40))
ps_nominal_diameter_length_max_10 ((char_length(nominal_diameter) <= 10))
ps_remark_length_max_80 ((char_length(remark) <= 80))
ps_pipe_brand_length_max_40 ((char_length(pipe_brand) <= 40))
ps_name_number_length_max_40 ((char_length(name_number) <= 40))
ps_mandate_length_max_40 ((char_length(mandate) <= 40))

Relationships

Close relationships within degrees of separation