Table testdb.public.mvm_movement 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
mvm_problem_history.c_fk_movement fk_phistory_mvm 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_end_date timestamp 22  √  null
c_initiator varchar 255
c_latest_due timestamp 22  √  null
c_no varchar 255  √  null
c_message varchar 1024  √  null
c_occurred timestamp 29,6  √  null
c_mode varchar 255
c_priority varchar 255
c_sku varchar 255  √  null
c_source_location varchar 255  √  null
c_source_location_group_name varchar 255  √  null
c_start_date timestamp 22  √  null
c_start_earliest_date timestamp 22  √  null
c_state varchar 255  √  null
c_target_location varchar 255  √  null
c_target_location_group_name varchar 255
c_transport_unit_bk varchar 255
c_type varchar 255
c_group_pk int8 19  √  null
mvm_movement_group.c_pk fk_mvm_grp R

Table contained 3 rows at Tue Mar 05 14:32 UTC 2024

Indexes:
Column(s) Type Sort Constraint Name
c_pk Primary key Asc mvm_movement_pkey
c_pid Must be unique Asc uk_sfau14y9h3jidh9gf5202665e

Close relationships: