alter table bb_company_branch_mapping add constraint fk_bb_company_branch_mapping_sender_mst foreign key (sender_auto_id) references sender_mst (sender_auto_id);
alter table bb_company_branch_mapping add constraint fk_bb_company_branch_mapping_sub_agent foreign key (parent_agent_cd, sub_agent_cd) references sub_agent (parent_agent_cd, sub_agent_cd);
alter table bb_company_branch_mapping alter column created_by varchar(30);
alter table bb_company_branch_mapping alter column modified_by varchar(30);
alter table bb_company_branch_mapping add constraint fk_bb_company_branch_mapping_created_by foreign key (cre_parent_agent_cd, created_by) references remit_user (parent_agent_cd, remit_user_cd);
alter table bb_company_branch_mapping add constraint fk_bb_company_branch_mapping_modified_by foreign key (mod_parent_agent_cd, modified_by) references remit_user (parent_agent_cd, remit_user_cd);

-- bb_company_branch_mapping_hist

alter table bb_company_document drop constraint pk_bb_company_document;
alter table bb_company_document add constraint pk_bb_company_document primary key (sender_auto_id, document_no);

alter table bb_company_document add constraint fk_bb_company_document_sender foreign key (sender_auto_id) references sender_mst (sender_auto_id);
alter table bb_company_document alter column created_by varchar(30);
alter table bb_company_document add constraint fk_bb_company_document_created_by foreign key (cre_parent_agent_cd, created_by) references remit_user (parent_agent_cd, remit_user_cd);

alter table bb_company_nature_business add constraint fk_bb_company_nature_business_sender foreign key (sender_auto_id) references sender_mst (sender_auto_id);

-- bb_company_nature_business_hist

alter table bb_company_person add constraint fk_bb_company_person foreign key (sender_auto_id) references sender_mst (sender_auto_id);
create index ix_bb_company_person_sender on bb_company_person (sender_auto_id);

-- bb_company_person_hist

alter table bb_company_person_temp_edit add constraint fk_bb_company_person_temp_edit_sender foreign key (sender_auto_id) references sender_mst (sender_auto_id);

alter table bb_tran_company_document_amount add constraint fk_bb_tran_company_document_amount foreign key (sender_auto_id, document_no) references bb_company_document (sender_auto_id, document_no);

alter table bb_tran_company_document_amount  add constraint fk_bb_tran_company_document_amount_tran foreign key (tran_id) references tran_master (tran_id);


alter table bb_authorised_personnel add constraint fk_bb_authorised_personnel foreign key (sender_auto_id) references sender_mst (sender_auto_id);

alter table bb_authorised_personnel alter column created_by varchar(30);
alter table bb_authorised_personnel alter column modified_by varchar(30);
alter table bb_authorised_personnel alter column is_approve_by varchar(30);
alter table bb_authorised_personnel add constraint fk_bb_authorised_personnel_created_by foreign key (cre_parent_agent_cd, created_by) references remit_user (parent_agent_cd, remit_user_cd);
alter table bb_authorised_personnel add constraint fk_bb_authorised_personnel_modifired_by foreign key (mod_parent_agent_cd, modified_by) references remit_user (parent_agent_cd, remit_user_cd);