--#############################################################		
        ALTER TABLE prd_apontamento_producao 
     ADD CONSTRAINT fk_prd_apontamento_producao_filial
	    FOREIGN KEY (filial) 
		 REFERENCES bas_filial (codigo) MATCH SIMPLE
ON UPDATE NO ACTION
ON DELETE RESTRICT;

--#############################################################		
		
        ALTER TABLE prd_apontamento_producao 
     ADD CONSTRAINT fk_prd_apontamento_producao_ordem_producao 
	    FOREIGN KEY (filial, ordem_producao) 
		 REFERENCES prd_ordem_producao (filial, ordem_producao) MATCH SIMPLE
ON UPDATE NO ACTION
ON DELETE RESTRICT;

--#############################################################		
		
        ALTER TABLE prd_apontamento_producao 
     ADD CONSTRAINT fk_prd_apontamento_producao_operador 
	    FOREIGN KEY (operador) 
		 REFERENCES prd_operador_producao (codigo) MATCH SIMPLE
ON UPDATE NO ACTION
ON DELETE RESTRICT;

--#############################################################		
		
        ALTER TABLE prd_apontamento_producao 
     ADD CONSTRAINT fk_prd_apontamento_producao_etapa 
	    FOREIGN KEY (filial, etapa) 
		 REFERENCES prd_etapa (filial, etapa) MATCH SIMPLE
ON UPDATE NO ACTION
ON DELETE RESTRICT;

--#############################################################		
		
        ALTER TABLE prd_apontamento_producao 
     ADD CONSTRAINT fk_prd_apontamento_producao_recurso
	    FOREIGN KEY (recurso) 
		 REFERENCES prd_recurso_producao (codigo) MATCH SIMPLE
ON UPDATE NO ACTION
ON DELETE RESTRICT;

--#############################################################		
		
        ALTER TABLE prd_apontamento_producao 
     ADD CONSTRAINT fk_prd_apontamento_producao_filial_usu
	    FOREIGN KEY (filial_usu) 
		 REFERENCES bas_filial (codigo) MATCH SIMPLE
ON UPDATE NO ACTION
ON DELETE RESTRICT;

--#############################################################	
		
        ALTER TABLE prd_apontamento_producao 
     ADD CONSTRAINT fk_prd_apontamento_producao_usuario
	    FOREIGN KEY (filial_usu, usuario) 
		 REFERENCES ctl_usuario (usufilial, usucod) MATCH SIMPLE
ON UPDATE NO ACTION
ON DELETE RESTRICT;

--#############################################################