update_notification


Description

A notification received from Quest of extract process completion

Columns

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 null

The Quest process ID of the notification

process_code text 2147483647 null
update_run_notification.process_code update_notification_run_id_fkeyR

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_fkeyR

The run_id, if any, this notification contributes to making ready

Table contained 6616 rows

Indexes

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

Relationships