Advertisement
Guest User

Untitled

a guest
Mar 4th, 2015
233
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.08 KB | None | 0 0
  1. wi_individual_g(ind_id,ind_name,ind_father_name,ind_spouse_name,is_employee,org_id,ind_dob,...)
  2. wi_individual_p(ind_id,prg_id,...)
  3. wi_program(prg_id,prg_name)
  4. wi_group(grp_id,grp_name,...)
  5. wi_organization(org_id,org_name,...)
  6. wi_training(trn_id,trn_name,...)
  7. wi_indv_org(ind_id,grp_id)
  8. wi_indv_training(ind_id,trn_id)
  9.  
  10. Organization -> defined in wi_individual_g if is_employee='yes'
  11. Group -> defined in wi_indv_org
  12. Training -> defined in wi_indv_training
  13. Program -> defined in wi_individual_p
  14.  
  15. wi_individual_g
  16. ind_id ind_name ind_father_name ind_spouse_name is_employee org_id
  17. 20150203000X ABC CDE EFG yes 2015040001
  18. 20150203000Y ABC CDE EFG yes 2015040001
  19. 20150203000Z ABC CDE EFG yes 2015040001
  20.  
  21. wi_indv_training
  22. ind_id trn_id
  23. 20150203000X 2015010001
  24.  
  25. wi_indv_org
  26. ind_id grp_id
  27. 20150203000Y 2015050001
  28.  
  29. 1) Delete all duplicates from wi_individual_g except one
  30. 2) Update all other tables to one ind_id that are referenced by duplicate data
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement