Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- wi_individual_g(ind_id,ind_name,ind_father_name,ind_spouse_name,is_employee,org_id,ind_dob,...)
- wi_individual_p(ind_id,prg_id,...)
- wi_program(prg_id,prg_name)
- wi_group(grp_id,grp_name,...)
- wi_organization(org_id,org_name,...)
- wi_training(trn_id,trn_name,...)
- wi_indv_org(ind_id,grp_id)
- wi_indv_training(ind_id,trn_id)
- Organization -> defined in wi_individual_g if is_employee='yes'
- Group -> defined in wi_indv_org
- Training -> defined in wi_indv_training
- Program -> defined in wi_individual_p
- wi_individual_g
- ind_id ind_name ind_father_name ind_spouse_name is_employee org_id
- 20150203000X ABC CDE EFG yes 2015040001
- 20150203000Y ABC CDE EFG yes 2015040001
- 20150203000Z ABC CDE EFG yes 2015040001
- wi_indv_training
- ind_id trn_id
- 20150203000X 2015010001
- wi_indv_org
- ind_id grp_id
- 20150203000Y 2015050001
- 1) Delete all duplicates from wi_individual_g except one
- 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