Table odyssey_test._quest.update_notification
A notification received from Quest of extract process completion

Generated by
SchemaSpy
Legend: SourceForge.net
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
notification_id serial 10  √  nextval('_quest.update_notification_notification_id_seq'::regclass)
process_id int4 10 The Quest process ID of the notification
process_code text 2147483647
update_run_notification.process_code update_notification_run_id_fkey R
The Quest process code of the notification
notification_time timestamp 29,6 now() When the notification was recorded
run_id int4 10  √  null
update_run_notification.run_id update_notification_run_id_fkey R
The run_id, if any, this notification contributes to making ready

Table contained 0 rows at Wed Feb 19 10:30 EST 2014

Indexes:
Column(s) Type Sort Constraint Name
notification_id Primary key Asc update_notification_pkey
run_id + process_code Must be unique Asc/Asc update_notification_run_id_process_code_key

Close relationships  within of separation: