webco_8.0
Database
Tables
(current)
Columns
Constraints
Relationships
Orphan Tables
Anomalies
Routines
check_resource_schedule_allocation_oid
Parameters
Name
Type
Mode
Definition
BEGIN PERFORM true FROM resource_schedule where NEW.type not in ( 'OFFLINE', 'SCHEDULED-OFFLINE', 'OFFLINE-COMPLETED') and NEW.allocation_oid IS NULL; IF FOUND THEN RAISE EXCEPTION 'Non offline schedules must have an allocation'; END IF; RETURN NEW; END