Table testdb.public.tms_rsrv_action 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_pid varchar 255
c_action_type varchar 255
c_description varchar 255
c_enabled bool 1  √  null
c_flex_1 varchar 255  √  null
c_flex_2 varchar 255  √  null
c_flex_3 varchar 255  √  null
c_flex_4 varchar 255  √  null
c_flex_5 varchar 255  √  null
c_location_group_name varchar 255  √  null
c_location_key varchar 255  √  null
c_name varchar 255
c_program_name varchar 255
c_route_id int8 19
tms_rsrv_route.c_pk fk10nrvtkx9s6wdox86gi0ysnxk R

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_action_pkey
c_pid Must be unique Asc uk_gygdi15e08na90j27mponyxlg
c_name Must be unique Asc uk_j0ogef2lldn07epwgdj4cak9u

Close relationships  within of separation: