transit_copy

-1 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id serial 10 √ nextval('action.transit_copy_id_seq'::regclass)
transit_copy.prev_hop transit_copy_prev_hop_fkey R
source_send_time timestamptz 35,6 √ null
dest_recv_time timestamptz 35,6 √ null
target_copy int8 19 null
source int4 10 null
org_unit.id transit_copy_source_fkey R
dest int4 10 null
org_unit.id transit_copy_dest_fkey R
prev_hop int4 10 √ null
transit_copy.id transit_copy_prev_hop_fkey R
copy_status int4 10 null
copy_status.id transit_copy_copy_status_fkey R
persistant_transfer bool 1 false
prev_dest int4 10 √ null
org_unit.id transit_copy_prev_dest_fkey R
cancel_time timestamptz 35,6 √ null

Indexes

Constraint Name Type Sort Column(s)
transit_copy_pkey Primary key Asc id
active_transit_cp_idx Performance Asc target_copy
active_transit_dest_idx Performance Asc dest
active_transit_for_copy Performance Asc target_copy
active_transit_source_idx Performance Asc source

Relationships

Close relationships within degrees of separation