Table testdb.public.tms_rsrv_location 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
tms_rsrv_route.c_source_location fkislk84iqptnxmuqbtl4apc7ec R
tms_rsrv_route.c_target_location fkt90es27r26228uxrirwoteeew 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_foreign_pid varchar 255  √  null
c_location_group_name varchar 255  √  null
c_location_id varchar 255
c_marked_deletion bool 1  √  null

Table contained 0 rows at Tue Nov 19 14:56 UTC 2024

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

Close relationships  within of separation: