Table testdb.public.com_location_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_location.c_location_type fk_loc_lt R
com_type_placing_rule.c_allowed_location_type fkb1he5781gaupx0napfkoy09iy 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_description varchar 255  √  null
c_height int4 10  √  null
c_length int4 10  √  null
c_type varchar 255
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_location_type_pkey
c_pid Must be unique Asc uk_d5qkbwvvprcfa266xjoqneb54
c_type Must be unique Asc uk_h6r9kr990ufge67kp6g1p8kcw

Close relationships  within of separation: