Table testdb.public.rsrv_route 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
rsrv_action.c_route_id fklxix4fythi8yy6eornb00m6ud R
rsrv_route_details.c_route_id fksb26oisxtw8yc72ur7d0pqxym 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_enabled bool 1  √  null
c_name varchar 255
c_source_loc_group_name varchar 255  √  null
c_target_loc_group_name varchar 255  √  null
c_source_location int8 19  √  null
rsrv_location.c_pk fkh6pwflfvy0ek6nt9odqahmng0 R
c_target_location int8 19  √  null
rsrv_location.c_pk fkev0msagl6aloybhfdrqd0lu2q R

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

Indexes:
Column(s) Type Sort Constraint Name
c_pk Primary key Asc rsrv_route_pkey
c_name Must be unique Asc uk_f8h0uuf0xc0ev98q2lj07uq2x
c_pid Must be unique Asc uk_o3t7beeh3lxgtcr5cnj89m4ap

Close relationships: