wastewater_structure_symbol

-1 rows


Columns

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

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

classname text 2147483647 null

Name of class that symbol class is related to / Name der Klasse zu der die Symbolklasse gehört / nom de la classe à laquelle appartient la classe de symbole

plantype int4 10 null
wastewater_structure_symbol_plantype.code fkey_vl_wastewater_structure_symbol_plantype R
symbol_scaling_height numeric 2,1 null
symbol_scaling_width numeric 2,1 null
symbolori numeric 4,1 null

Default: 90 Degree / Default: 90 Grad / Default: 90 degree

symbolpos_geometry geometry 2147483647 null
last_modification timestamp 29,6 now()

Last modification / Letzte_Aenderung / Derniere_modification: INTERLIS_1_DATE

fk_wastewater_structure varchar 16 null
wastewater_structure.obj_id rel_wastewater_structure_symbol_wastewater_structure C

Indexes

Constraint Name Type Sort Column(s)
pkey_tww_od_wastewater_structure_symbol_obj_id Primary key Asc obj_id
in_tww_wastewater_structure_symbol_symbolpos_geometry Performance Asc symbolpos_geometry

Check Constraints

Constraint Name Constraint
bx_classname_length_max_50 ((char_length(classname) <= 50))

Relationships