create or replace table procedure_instance_protocol
(
	procedure_instance_protocol_id bigint auto_increment
		primary key,
	procedure_instance_id bigint not null,
	protocol_number varchar(255) not null,
	constraint procedure_ins_protocol_proc_ins_id_protocol_uindex
		unique (procedure_instance_id, protocol_number),
	constraint proc_ins_protocol_proc_ins_proc_ins_id_fk
		foreign key (procedure_instance_id) references procedure_instance (procedure_instance_id)
			on delete cascade
);