Table testdb.public.com_transport_unit_type Generated by
SchemaSpy
Legend:
Primary key columns
Columns with indexes
Implied relationships
Excluded column relationships
< n > number of related tables
 
Column Type Size Nulls Auto Default Children Parents Comments
c_pk int8 19
com_transport_unit.c_transport_unit_type com_tu_fk_tut R
com_type_placing_rule.c_tut_id fkexme0g9srxcxt8m3jv2101k1d R
com_type_stacking_rule.c_allowed_transport_unit_type fk9wojgpvaignw39k200ha80eug R
com_type_stacking_rule.c_transport_unit_type fk6pn2579hr73ige890tnrtlids R
c_created timestamp 29,6  √  null
c_created_by varchar 255  √  null
c_updated_by varchar 255  √  null
c_updated timestamp 29,6  √  null
c_ol int8 19  √  null
c_pid varchar 255
c_compatibility varchar 255  √  null
c_description varchar 255  √  null
c_height int4 10  √  null
c_length int4 10  √  null
c_payload numeric 38,2  √  null
c_type varchar 255
c_weight_max numeric 38,2  √  null
c_weight_tare numeric 38,2  √  null
c_width int4 10  √  null

Table contained 2 rows at Mon Sep 02 15:06 UTC 2024

Indexes:
Column(s) Type Sort Constraint Name
c_pk Primary key Asc com_transport_unit_type_pkey
c_type Must be unique Asc uc_tut_type
c_pid Must be unique Asc uk_kk3jrppqflukplca8502pwkf7

Close relationships  within of separation: