Constraints

7 Foreign Key Constraints

Constraint Name

Child Column

Parent Column

Delete Rule

buildnote_releaseid_fkey

buildnote.releaseid

release.releaseid

Cascade on delete

fkew2pigx0nxlxtueu0lm4met2n

buildnote.release_releaseid

release.releaseid

Restrict delete

userroleassignment_userid_fkey

userroleassignment.userid

users.userid

Cascade on delete

userroleassignment_roleid_fkey

userroleassignment.roleid

role.roleid

Cascade on delete

promoterequest_buildnoteid_fkey

promoterequest.buildnoteid

buildnote.buildnoteid

Cascade on delete

promoteitem_promoterequestid_fkey

promoteitem.promoterequestid

promoterequest.promoterequestid

Cascade on delete

fk_buildnote

releaseitem.buildnoteid

buildnote.buildnoteid

Cascade on delete

Check Constraints

Table	Constraint Name	Constraint
role	role_rolename_check	(((rolename)::text = ANY ((ARRAY['ReleaseManagement'::character varying, 'ReleaseContentManagement'::character varying, 'PromoteManagement'::character varying])::text[])))
promoterequest	promoterequest_status_check	(((status)::text = ANY ((ARRAY['REQUESTED'::character varying, 'PREPARED'::character varying, 'STARTED'::character varying, 'DONE'::character varying])::text[])))
promoterequest	promoterequest_targetenvironment_check	(((targetenvironment)::text = ANY ((ARRAY['TST'::character varying, 'GTU'::character varying, 'UAT'::character varying, 'PTP'::character varying, 'PRD'::character varying])::text[])))
promoteitem	promoteitem_platform_check	(((platform)::text = ANY ((ARRAY['Manual'::character varying, 'ChangeMan'::character varying, 'Jenkins'::character varying, 'Azure'::character varying, 'ARCAD'::character varying])::text[])))
promoteitem	promoteitem_status_check	(((status)::text = ANY ((ARRAY['WAITING'::character varying, 'BUSY'::character varying, 'ERROR'::character varying, 'DONE'::character varying])::text[])))