Table testdb.public.tms_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
tms_rsrv_action.c_route_id fk10nrvtkx9s6wdox86gi0ysnxk R
tms_rsrv_route_details.c_route_id fki580j15ivtcsipm949xgnfpel 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
tms_rsrv_location.c_pk fkislk84iqptnxmuqbtl4apc7ec R
c_target_location int8 19  √  null
tms_rsrv_location.c_pk fkt90es27r26228uxrirwoteeew R

Table contained 0 rows at Mon Dec 23 18:09 UTC 2024

Indexes:
Column(s) Type Sort Constraint Name
c_pk Primary key Asc tms_rsrv_route_pkey
c_pid Must be unique Asc uk_eon5lqu190tlqies2xepaboqm
c_name Must be unique Asc uk_fnvl866vjkxv79b9os7cntu63

Close relationships: