Table testdb.public.rsrv_route_details 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
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_next_location varchar 255  √  null
c_pos int4 10  √  null
c_source_location varchar 255  √  null
c_route_id int8 19  √  null
rsrv_route.c_pk fksb26oisxtw8yc72ur7d0pqxym R

Table contained 0 rows at Tue Apr 16 13:44 UTC 2024

Indexes:
Column(s) Type Sort Constraint Name Anomalies
c_pk Primary key Asc rsrv_route_details_pkey  
c_route_id + c_pos Must be unique Asc/Asc uc_route_pos These unique columns are also nullable

Close relationships  within of separation: