create index index_tenant_user_credential_tenant_user_id on tenant_user_credentials(tenant_user_id);


create index index_tenant_user_selected_credential_id on tenant_users(selected_credential_id);
create index index_tenant_user_telephone on tenant_users(telephone);
create index index_tenant_user_name on tenant_users(`name`);


create index index_tenant_employee_organization_id on tenant_employees(organization_id);
create index index_tenant_employee_department_id on tenant_employees(department_id);
create index index_tenant_employee_tenant_user_id on tenant_employees(tenant_user_id);

create index index_identity_userpassword_userName on identity_userpassword(user_name);
create index index_identity_principal_identity_user_id on identity_principals(identity_user_id);

create index index_t_user_loginno on t_user(LOGINNO);

create index  index_tenant_contract_organization_id on tenant_contracts(organization_id);
create index  index_tenant_contract_employee_id on tenant_contracts(employee_id);

create index  index_tenant_department_employee_relation_employee_id on tenant_department_employee_relations(employee_id);
create index  index_tenant_department_employee_relation_department_id on tenant_department_employee_relations(department_id);

create index  index_tenant_department_admin_organization_id on tenant_department_admins(organization_id);
create index  index_tenant_department_admin_department_id on tenant_department_admins(department_id);
create index  index_tenant_department_admin_employee_id on tenant_department_admins(employee_id);

create index  index_tenant_department_organization_id on tenant_departments(organization_id);

create index  index_tenant_user_credential_number on tenant_user_credentials(number);

create index index_tlk_attendance_site_arrange_info_ITEM_securityId on tlk_attendance_site_arrange_info(ITEM_securityId);

create index  index_tenant_event_subscribed_action_logs_ref_event_id on tenant_event_subscribed_action_logs(ref_event_id);
create index  index_tenant_event_subscribed_action_logs_subscriber_id on tenant_event_subscribed_action_logs(subscriber_id);

create index  index_tlk_certification_DOMAINID on tms.tlk_certification(DOMAINID);
create index  index_tlk_certification_ITEM_PERSONID on tms.tlk_certification(ITEM_PERSONID);