Creación de las Restricciones (Constraints)

ALTER TABLE tb_accesorios
ADD CONSTRAINT XPKtb_accesorios PRIMARY KEY CLUSTERED Cod_acce ASC)
go

ALTER TABLE tb_asegurado
ADD CONSTRAINT XPKtb_asegurado PRIMARY KEY CLUSTERED (Cod_ase ASC)
go

ALTER TABLE tb_auto
ADD CONSTRAINT XPKtb_auto PRIMARY KEY CLUSTERED (Plac_aut ASC)
go

ALTER TABLE tb_certificado
ADD CONSTRAINT XPKtb_certificado PRIMARY KEY CLUSTERED (Num_cer ASC, Num_pol ASC)
go

ALTER TABLE tb_cInformacion
ADD CONSTRAINT XPKtb_cInformacion PRIMARY KEY CLUSTERED (Cod_ci ASC)
go

ALTER TABLE tb_cobertura
ADD CONSTRAINT XPKtb_cobertura PRIMARY KEY CLUSTERED (Cod_cob ASC)
go


ALTER TABLE tb_combustible
ADD CONSTRAINT XPKtb_combustible PRIMARY KEY CLUSTERED (Tipo_comb ASC)
go

ALTER TABLE tb_contratante
ADD CONSTRAINT XPKtb_contratante PRIMARY KEY CLUSTERED (Cod_con ASC)
go

ALTER TABLE tb_courrier
ADD CONSTRAINT XPKtb_courrier PRIMARY KEY CLUSTERED (Cod_cou ASC)
go

ALTER TABLE tb_departamento
ADD CONSTRAINT XPKtb_departamento PRIMARY KEY CLUSTERED (Cod_dep ASC)
go

ALTER TABLE tb_detalleAccesorios
ADD CONSTRAINT XPKtb_detalleAccesorios PRIMARY KEY CLUSTERED (Cod_acce ASC, Plac_aut ASC)
go

ALTER TABLE tb_detalleCI
ADD CONSTRAINT XPKtb_detalleCI PRIMARY KEY CLUSTERED (Cod_ci ASC, Cod_emp ASC)
go

ALTER TABLE tb_detalleCobetura
ADD CONSTRAINT XPKtb_detalleCobetura PRIMARY KEY CLUSTERED (Cod_cob ASC, Num_pol ASC)
go

ALTER TABLE tb_detalleMoneda
ADD CONSTRAINT XPKtb_detalleMoneda PRIMARY KEY CLUSTERED (Tipo_mon ASC, Cod_cob ASC)
go

ALTER TABLE tb_distrito
ADD CONSTRAINT XPKtb_distrito PRIMARY KEY CLUSTERED (Cod_dis ASC)
go

ALTER TABLE tb_documento
ADD CONSTRAINT XPKtb_documento PRIMARY KEY CLUSTERED (Tipo_doc ASC)
go

ALTER TABLE tb_empleados
ADD CONSTRAINT XPKtb_empleados PRIMARY KEY CLUSTERED (Cod_emp ASC)
go

ALTER TABLE tb_hojaInspeccion
ADD CONSTRAINT XPKtb_hojaInspeccion PRIMARY KEY CLUSTERED (Num_hi ASC)
go

ALTER TABLE tb_moneda
ADD CONSTRAINT XPKtb_moneda PRIMARY KEY CLUSTERED (Tipo_mon ASC)
go

ALTER TABLE tb_poliza
ADD CONSTRAINT XPKtb_poliza PRIMARY KEY CLUSTERED (Num_pol ASC)
go

ALTER TABLE tb_propietario
ADD CONSTRAINT XPKtb_propietario PRIMARY KEY CLUSTERED (Cod_pro ASC)
go

ALTER TABLE tb_provincia
ADD CONSTRAINT XPKtb_provincia PRIMARY KEY CLUSTERED (Cod_prov ASC)
go

ALTER TABLE tb_solicitud
ADD CONSTRAINT XPKtb_solicitud PRIMARY KEY CLUSTERED (Num_sol ASC)
go

ALTER TABLE tb_tipoEmpleado
ADD CONSTRAINT XPKtb_tipoEmpleado PRIMARY KEY CLUSTERED (Tipo_emp ASC)
go

ALTER TABLE tb_asegurado
ADD CONSTRAINT R_48 FOREIGN KEY (Tipo_doc) REFERENCES tb_documento(Tipo_doc)
ON DELETE NO ACTION
ON UPDATE NO ACTION
go

ALTER TABLE tb_asegurado
ADD CONSTRAINT R_49 FOREIGN KEY (Cod_prov) REFERENCES tb_provincia(Cod_prov)
ON DELETE NO ACTION
ON UPDATE NO ACTION
go

ALTER TABLE tb_asegurado
ADD CONSTRAINT R_50 FOREIGN KEY (Cod_dep) REFERENCES tb_departamento(Cod_dep)
ON DELETE NO ACTION
ON UPDATE NO ACTION
go

ALTER TABLE tb_asegurado
ADD CONSTRAINT R_51 FOREIGN KEY (Cod_dis) REFERENCES tb_distrito(Cod_dis)
ON DELETE NO ACTION
ON UPDATE NO ACTION
go

ALTER TABLE tb_asegurado
ADD CONSTRAINT R_52 FOREIGN KEY (Cod_con) REFERENCES tb_contratante(Cod_con)
ON DELETE NO ACTION
ON UPDATE NO ACTION
go

ALTER TABLE tb_auto
ADD CONSTRAINT R_79 FOREIGN KEY (Cod_emp) REFERENCES tb_empleados(Cod_emp)
ON DELETE NO ACTION
ON UPDATE NO ACTION
go

ALTER TABLE tb_auto
ADD CONSTRAINT R_85 FOREIGN KEY (Tipo_comb) REFERENCES tb_combustible(Tipo_comb)
ON DELETE NO ACTION
ON UPDATE NO ACTION
go

ALTER TABLE tb_auto
ADD CONSTRAINT R_95 FOREIGN KEY (Cod_pro) REFERENCES tb_propietario(Cod_pro)
ON DELETE NO ACTION
ON UPDATE NO ACTION
go

ALTER TABLE tb_certificado
ADD CONSTRAINT R_74 FOREIGN KEY (Num_pol) REFERENCES tb_poliza(Num_pol)
ON DELETE NO ACTION
ON UPDATE NO ACTION
go

ALTER TABLE tb_certificado
ADD CONSTRAINT R_83 FOREIGN KEY (Plac_aut) REFERENCES tb_auto(Plac_aut)
ON DELETE NO ACTION
ON UPDATE NO ACTION
go

ALTER TABLE tb_certificado
ADD CONSTRAINT R_84 FOREIGN KEY (Cod_ase) REFERENCES tb_asegurado(Cod_ase)
ON DELETE NO ACTION
ON UPDATE NO ACTION
go

ALTER TABLE tb_contratante
ADD CONSTRAINT R_44 FOREIGN KEY (Tipo_doc) REFERENCES tb_documento(Tipo_doc)
ON DELETE NO ACTION
ON UPDATE NO ACTION
go

ALTER TABLE tb_contratante
ADD CONSTRAINT R_45 FOREIGN KEY (Cod_prov) REFERENCES tb_provincia(Cod_prov)
ON DELETE NO ACTION
ON UPDATE NO ACTION
go

ALTER TABLE tb_contratante
ADD CONSTRAINT R_46 FOREIGN KEY (Cod_dep) REFERENCES tb_departamento(Cod_dep)
ON DELETE NO ACTION
ON UPDATE NO ACTION
go

ALTER TABLE tb_contratante
ADD CONSTRAINT R_47 FOREIGN KEY (Cod_dis) REFERENCES tb_distrito(Cod_dis)
ON DELETE NO ACTION
ON UPDATE NO ACTION
go

ALTER TABLE tb_contratante
ADD CONSTRAINT R_69 FOREIGN KEY (Cod_emp) REFERENCES tb_empleados(Cod_emp)
ON DELETE NO ACTION
ON UPDATE NO ACTION
go

ALTER TABLE tb_courrier
ADD CONSTRAINT R_53 FOREIGN KEY (Tipo_doc) REFERENCES tb_documento(Tipo_doc)
ON DELETE NO ACTION
ON UPDATE NO ACTION
go

ALTER TABLE tb_courrier
ADD CONSTRAINT R_54 FOREIGN KEY (Cod_prov) REFERENCES tb_provincia(Cod_prov)
ON DELETE NO ACTION
ON UPDATE NO ACTION
go

ALTER TABLE tb_courrier
ADD CONSTRAINT R_55 FOREIGN KEY (Cod_dep) REFERENCES tb_departamento(Cod_dep)
ON DELETE NO ACTION
ON UPDATE NO ACTION
go

ALTER TABLE tb_courrier
ADD CONSTRAINT R_56 FOREIGN KEY (Cod_dis) REFERENCES tb_distrito(Cod_dis)
ON DELETE NO ACTION
ON UPDATE NO ACTION
go

ALTER TABLE tb_detalleAccesorios
ADD CONSTRAINT R_93 FOREIGN KEY (Cod_acce) REFERENCES tb_accesorios(Cod_acce)
ON DELETE NO ACTION
ON UPDATE NO ACTION
go

ALTER TABLE tb_detalleAccesorios
ADD CONSTRAINT R_94 FOREIGN KEY (Plac_aut) REFERENCES tb_auto(Plac_aut)
ON DELETE NO ACTION
ON UPDATE NO ACTION
go

ALTER TABLE tb_detalleCI
ADD CONSTRAINT R_80 FOREIGN KEY (Cod_emp) REFERENCES tb_empleados(Cod_emp)
ON DELETE NO ACTION
ON UPDATE NO ACTION
go

ALTER TABLE tb_detalleCI
ADD CONSTRAINT R_81 FOREIGN KEY (Cod_ci) REFERENCES tb_cInformacion(Cod_ci)
ON DELETE NO ACTION
ON UPDATE NO ACTION
go

ALTER TABLE tb_detalleCobetura
ADD CONSTRAINT R_86 FOREIGN KEY (Cod_cob) REFERENCES tb_cobertura(Cod_cob)
ON DELETE NO ACTION
ON UPDATE NO ACTION
go

ALTER TABLE tb_detalleCobetura
ADD CONSTRAINT R_87 FOREIGN KEY (Num_pol) REFERENCES tb_poliza(Num_pol)
ON DELETE NO ACTION
ON UPDATE NO ACTION
go

ALTER TABLE tb_detalleMoneda
ADD CONSTRAINT R_88 FOREIGN KEY (Tipo_mon) REFERENCES tb_moneda(Tipo_mon)
ON DELETE NO ACTION
ON UPDATE NO ACTION
go

ALTER TABLE tb_detalleMoneda
ADD CONSTRAINT R_90 FOREIGN KEY (Cod_cob) REFERENCES tb_cobertura(Cod_cob)
ON DELETE NO ACTION
ON UPDATE NO ACTION
go

ALTER TABLE tb_empleados
ADD CONSTRAINT R_39 FOREIGN KEY (Tipo_emp) REFERENCES tb_tipoEmpleado(Tipo_emp)
ON DELETE NO ACTION
ON UPDATE NO ACTION
go

ALTER TABLE tb_empleados
ADD CONSTRAINT R_40 FOREIGN KEY (Cod_dis) REFERENCES tb_distrito(Cod_dis)
ON DELETE NO ACTION
ON UPDATE NO ACTION
go

ALTER TABLE tb_empleados
ADD CONSTRAINT R_41 FOREIGN KEY (Cod_dep) REFERENCES tb_departamento(Cod_dep)
ON DELETE NO ACTION
ON UPDATE NO ACTION
go

ALTER TABLE tb_empleados
ADD CONSTRAINT R_42 FOREIGN KEY (Cod_prov) REFERENCES tb_provincia(Cod_prov)
ON DELETE NO ACTION
ON UPDATE NO ACTION
go

ALTER TABLE tb_empleados
ADD CONSTRAINT R_43 FOREIGN KEY (Tipo_doc) REFERENCES tb_documento(Tipo_doc)
ON DELETE NO ACTION
ON UPDATE NO ACTION
go

ALTER TABLE tb_hojaInspeccion
ADD CONSTRAINT R_71 FOREIGN KEY (Cod_emp) REFERENCES tb_empleados(Cod_emp)
ON DELETE NO ACTION
ON UPDATE NO ACTION
go

ALTER TABLE tb_hojaInspeccion
ADD CONSTRAINT R_72 FOREIGN KEY (Plac_aut) REFERENCES tb_auto(Plac_aut)
ON DELETE NO ACTION
ON UPDATE NO ACTION
go

ALTER TABLE tb_hojaInspeccion
ADD CONSTRAINT R_75 FOREIGN KEY (Cod_ase) REFERENCES tb_asegurado(Cod_ase)
ON DELETE NO ACTION
ON UPDATE NO ACTION
go

ALTER TABLE tb_hojaInspeccion
ADD CONSTRAINT R_77 FOREIGN KEY (Cod_con) REFERENCES tb_contratante(Cod_con)
ON DELETE NO ACTION
ON UPDATE NO ACTION
go

ALTER TABLE tb_poliza
ADD CONSTRAINT R_82 FOREIGN KEY (Cod_con) REFERENCES tb_contratante(Cod_con)
ON DELETE NO ACTION
ON UPDATE NO ACTION
go

ALTER TABLE tb_poliza
ADD CONSTRAINT R_91 FOREIGN KEY (Cod_cou) REFERENCES tb_courrier(Cod_cou)
ON DELETE NO ACTION
ON UPDATE NO ACTION
go

ALTER TABLE tb_poliza
ADD CONSTRAINT R_92 FOREIGN KEY (Num_sol) REFERENCES tb_solicitud(Num_sol)
ON DELETE NO ACTION
ON UPDATE NO ACTION
go

ALTER TABLE tb_poliza
ADD CONSTRAINT R_96 FOREIGN KEY (Cod_emp) REFERENCES tb_empleados(Cod_emp)
ON DELETE NO ACTION
ON UPDATE NO ACTION
go

ALTER TABLE tb_propietario
ADD CONSTRAINT R_57 FOREIGN KEY (Tipo_doc) REFERENCES tb_documento(Tipo_doc)
ON DELETE NO ACTION
ON UPDATE NO ACTION
go

ALTER TABLE tb_propietario
ADD CONSTRAINT R_58 FOREIGN KEY (Cod_prov) REFERENCES tb_provincia(Cod_prov)
ON DELETE NO ACTION
ON UPDATE NO ACTION
go

ALTER TABLE tb_propietario
ADD CONSTRAINT R_59 FOREIGN KEY (Cod_dep) REFERENCES tb_departamento(Cod_dep)
ON DELETE NO ACTION
ON UPDATE NO ACTION
go

ALTER TABLE tb_propietario
ADD CONSTRAINT R_60 FOREIGN KEY (Cod_dis) REFERENCES tb_distrito(Cod_dis)
ON DELETE NO ACTION
ON UPDATE NO ACTION
go

ALTER TABLE tb_propietario
ADD CONSTRAINT R_61 FOREIGN KEY (Cod_ase) REFERENCES tb_asegurado(Cod_ase)
ON DELETE NO ACTION
ON UPDATE NO ACTION
go

ALTER TABLE tb_solicitud
ADD CONSTRAINT R_66 FOREIGN KEY (Cod_con) REFERENCES tb_contratante(Cod_con)
ON DELETE NO ACTION
ON UPDATE NO ACTION
go

ALTER TABLE tb_solicitud
ADD CONSTRAINT R_68 FOREIGN KEY (Cod_emp) REFERENCES tb_empleados(Cod_emp)
ON DELETE NO ACTION
ON UPDATE NO ACTION
go

ALTER TABLE tb_solicitud
ADD CONSTRAINT R_70 FOREIGN KEY (Plac_aut) REFERENCES tb_auto(Plac_aut)
ON DELETE NO ACTION
ON UPDATE NO ACTION
go