1. Copy authority table from central tenant to newly created member tenant
insert into {member_tenant_id}_mod_entities_links.authority( SELECT id, natural_id, source_file_id, 'CONSORTIUM-' || source, heading, heading_type, _version, subject_heading_code, sft_headings, saft_headings, identifiers, notes, deleted, created_date, updated_date, created_by_user_id, updated_by_user_id FROM {central_tenant_id}_mod_entities_links.authority);
2. Copy authority_data_stat table from central tenant to newly created member tenant
insert into {member_tenant_id}_mod_entities_links.authority_data_stat( SELECT id, authority_id, action::text::{member_tenant_id}_mod_entities_links.authoritydatastataction, authority_natural_id_old, authority_natural_id_new, heading_old, heading_new, heading_type_old, heading_type_new, authority_source_file_old, authority_source_file_new, lb_total, lb_updated, lb_failed, status::text::{member_tenant_id}_mod_entities_links.authoritydatastatstatus, fail_cause, started_by_user_id, started_at, completed_at, updated_at FROM {central_tenant_id}_mod_entities_links.authority_data_stat);
Notice 2 {member_tenant_id} placeholders in select