问如何在限制复合索引的同时，在Firestore中建模复杂的关系数据？

EN

| /sales_reps        //SalesReps Collection
|   /docId          //Document ID
|   + salesRepId (document id)
|   + firstName
|   + lastName
|   + other employee/salesRep related info etc.

| /customers            //Customers Collection
|   /docId              //Document ID
|   + customerId (document id)
|   + firstName
|   + lastName
|   + address + other customer specific related info such as contact info (phone, email) etc.

| /sales_leads          //SalesLeads Collection
|   /docId              //Document ID
|   + customerId (document id) <- this is what I would query by to look for leads for a specific customer
|   + salesRepId (document id) <- this is what I would query by to look for leads for a specific sales Rep
|   + status <- (String: "Open", "Sold", "Lost", "On Hold)
|   + progress <- (String: "Started", "Appointment scheduled", "Estimates created", etc. etc., )
|   + type <- (String: New Construction or Service/Repair)
|   + jobTye <- (String: Different Types job Jobs related to what type of structures they are; 8-10 types right now)
|   + reference <- (String: How the lead was referred to the company, i.e. Facebook, Google, etc. etc. );
|   + many other (non queryable) data related to a lead, but not relevant here...

| /sales_estimates      //SalesEstimates Collection
|   /docId              //Document ID
|   + salesLeadId (document id) <- this is what I would query by to look for estimates for a specific lead
|   + customerId (document id) <- this is what I would query by to look for estimates for a specific customer
|   + salesRepId (document id) <- this is what I would query by to look for estimates for a specific sales Rep
|   + specific sales Lead related data etc....

Query query = db.collection("sales_leads");

//Rep
if (!salesRepFilter.equals("All")) { //Typically only Managers/Supervisors woujld be able to see "all leads" whereas for a SalesRep this would be set on his own ID by default.
    query = query = query.whereEqualTo("salesRepId", salesRepId);  
}
//Lead Status (Open, Sold, Lost, On Hold)
if (!statusFilter.contains("All")) {
    query = query.whereEqualTo("status", statusFilter);
}
//Lead Progress
if (!progressFilter.contains("All")) {
    query = query.whereEqualTo("progress", progressFilter);
}
//Lead Type
if (!typeFilter.contains("All")) {
    query = query.whereEqualTo("leadType", typeFilter);
}
//Job Type
if (!jobTypeFilter.contains("All")) {
    query = query.whereArrayContains("jobTypes", jobTypeFilter);
}
//Reference
if (!referenceFilter.contains("All")) {
    query = query.whereEqualTo("reference", referenceFilter);
}

//Filter by Customer (when entering my SalesLead List from a Customer Card/Page where user clicked on "Show Leads for this Customer")
if (filterByCustomer) {
    query = query.whereEqualTo("customerId", customerFilter);
}

//And at last I want to be able to query the date Range (when the lead was created) and also sort by "oldest" or "newest"

//Date Range
query = query.whereGreaterThan("leadCreatedOnDate", filterFromDate); 
        .whereLessThan("leadCreatedOnDate", filterToDate;

//Sort Newest vs Oldest

if (sortByNewest) { //either newest or oldest
    query = query.orderBy("leadCreatedOnDate", Query.Direction.ASCENDING);
} else {
    query = query.orderBy("leadCreatedOnDate", Query.Direction.DESCENDING);
}