The _jobstatus field in the _jobevents table is currently defined as an enum of the possible job execution statuses. Job events need to be generalized to incorporate non-execution status, such as the resource type being shared. The approach is to change the _jobstatus column name to event_detail and change its type to character varying(64). Null values are not valid in the modified column. The index on the _jobstatus column should be dropped and recreated under an appropriate name for new field. Much of the code that interacts with the _jobevents table will need to change. This incudes model, DAO and DTO objects.
The _jobstatus field in the _jobevents table is currently defined as an enum of the possible job execution statuses. Job events need to be generalized to incorporate non-execution status, such as the resource type being shared. The approach is to change the _jobstatus column name to event_detail and change its type to character varying(64). Null values are not valid in the modified column. The index on the _jobstatus column should be dropped and recreated under an appropriate name for new field. Much of the code that interacts with the _jobevents table will need to change. This incudes model, DAO and DTO objects.