Opened 8 years ago

Closed 8 years ago

#227 closed defect (fixed)

Modification contrainte c_fk_ope_dic_identifiant

Reported by: marion Owned by:
Priority: minor Milestone: 5 Release stacomiR_0.5
Component: database Version: 0.5
Keywords: Cc:

Description

Modification de la contrainte c_fk_ope_dic_identifiant qui ne permet pas de garantir qu'on met bien un identifiant de DC dans ope_dic_identifiant (puisque table tg_dispositif_dis mélange DF et DC).

Lancer ces 2 lignes pour modifier la contrainte (à lancer sur tous les schémas) :
alter table logrami.t_operation_ope drop constraint c_fk_ope_dic_identifiant;
alter table logrami.t_operation_ope add constraint c_fk_ope_dic_identifiant FOREIGN KEY (ope_dic_identifiant, ope_org_code) REFERENCES logrami.t_dispositifcomptage_dic (dic_dis_identifiant, dic_org_code) MATCH SIMPLE ON UPDATE CASCADE ON DELETE NO ACTION;

Change History (1)

comment:1 Changed 8 years ago by cedric

  • Resolution set to fixed
  • Status changed from new to closed
Note: See TracTickets for help on using tickets.