OpenSearch Profile Mappings

{
  "mappings": {
    "dynamic": "false",
    "properties": {
      "investor_data": {
        "properties": {
          "check_size": {
            "type": "keyword"
          },
          "geography_focus": {
            "type": "keyword"
          },
          "industry_focus": {
            "type": "keyword"
          },
          "portfolio_companies": {
            "type": "nested",
            "properties": {
              "company_id": {
                "type": "keyword"
              }
            }
          },
          "stage_focus": {
            "type": "keyword"
          },
          "type": {
            "type": "keyword"
          }
        }
      },
      "profile_info": {
        "properties": {
          "all_time_job_title": {
            "type": "text",
            "fields": {
              "raw": {
                "type": "keyword"
              }
            }
          },
          "all_time_title": {
            "type": "alias",
            "path": "profile_info.all_time_job_title"
          },
          "created_at": {
            "type": "date"
          },
          "current_company_id": {
            "type": "alias",
            "path": "profile_info.job_company_id"
          },
          "current_company_industry": {
            "type": "alias",
            "path": "profile_info.job_company_industry"
          },
          "current_company_linkedin_slugs": {
            "type": "alias",
            "path": "profile_info.job_company_linkedin_slugs"
          },
          "current_company_location": {
            "type": "alias",
            "path": "profile_info.job_company_location_name"
          },
          "current_company_location_country": {
            "type": "alias",
            "path": "profile_info.job_company_location_country"
          },
          "current_company_name": {
            "type": "alias",
            "path": "profile_info.job_company_name"
          },
          "current_company_size": {
            "type": "alias",
            "path": "profile_info.job_company_size"
          },
          "current_company_website": {
            "type": "alias",
            "path": "profile_info.job_company_website"
          },
          "current_company_websites": {
            "type": "keyword",
            "normalizer": "lowercase_acsiifold_normalizer"
          },
          "current_job_function": {
            "type": "alias",
            "path": "profile_info.job_title_role"
          },
          "current_job_updated_at": {
            "type": "date"
          },
          "current_location": {
            "type": "alias",
            "path": "profile_info.location_name"
          },
          "current_seniority": {
            "type": "alias",
            "path": "profile_info.job_seniority"
          },
          "current_start_date": {
            "type": "alias",
            "path": "profile_info.job_start_date"
          },
          "current_title": {
            "type": "alias",
            "path": "profile_info.job_title"
          },
          "data_updated_at": {
            "type": "date"
          },
          "education": {
            "type": "nested",
            "properties": {
              "degrees": {
                "type": "text"
              },
              "end_date": {
                "type": "date"
              },
              "majors": {
                "type": "text"
              },
              "school": {
                "properties": {
                  "id": {
                    "type": "keyword"
                  },
                  "linkedin_slugs": {
                    "type": "keyword",
                    "normalizer": "lowercase_trim_normalizer"
                  },
                  "location": {
                    "properties": {
                      "name": {
                        "type": "text",
                        "fields": {
                          "raw": {
                            "type": "keyword"
                          }
                        }
                      }
                    }
                  },
                  "name": {
                    "type": "text",
                    "fields": {
                      "raw": {
                        "type": "keyword"
                      }
                    }
                  },
                  "type": {
                    "type": "keyword"
                  },
                  "website": {
                    "type": "keyword",
                    "normalizer": "lowercase_acsiifold_normalizer"
                  }
                }
              },
              "start_date": {
                "type": "date"
              }
            }
          },
          "emails": {
            "type": "keyword",
            "normalizer": "lowercase_trim_normalizer"
          },
          "experience": {
            "type": "nested",
            "properties": {
              "company": {
                "properties": {
                  "id": {
                    "type": "keyword"
                  },
                  "industry": {
                    "type": "keyword",
                    "normalizer": "lowercase_acsiifold_normalizer"
                  },
                  "linkedin_slugs": {
                    "type": "keyword",
                    "normalizer": "lowercase_trim_normalizer"
                  },
                  "location": {
                    "properties": {
                      "continent": {
                        "type": "text",
                        "fields": {
                          "raw": {
                            "type": "keyword"
                          }
                        }
                      },
                      "country": {
                        "type": "keyword",
                        "normalizer": "lowercase_acsiifold_normalizer"
                      },
                      "name": {
                        "type": "text",
                        "fields": {
                          "raw": {
                            "type": "keyword"
                          }
                        }
                      }
                    }
                  },
                  "name": {
                    "type": "text",
                    "fields": {
                      "raw": {
                        "type": "keyword"
                      }
                    }
                  },
                  "size": {
                    "type": "keyword"
                  },
                  "website": {
                    "type": "keyword",
                    "normalizer": "lowercase_acsiifold_normalizer"
                  },
                  "websites": {
                    "type": "keyword",
                    "normalizer": "lowercase_acsiifold_normalizer"
                  }
                }
              },
              "end_date": {
                "type": "date"
              },
              "is_current": {
                "type": "alias",
                "path": "profile_info.experience.is_primary"
              },
              "is_primary": {
                "type": "boolean"
              },
              "location": {
                "properties": {
                  "name": {
                    "type": "text",
                    "fields": {
                      "raw": {
                        "type": "keyword"
                      }
                    }
                  }
                }
              },
              "start_date": {
                "type": "date"
              },
              "title": {
                "properties": {
                  "name": {
                    "type": "text",
                    "fields": {
                      "raw": {
                        "type": "keyword"
                      }
                    }
                  }
                }
              }
            }
          },
          "first_name": {
            "type": "keyword",
            "normalizer": "lowercase_trim_normalizer"
          },
          "full_name": {
            "type": "text"
          },
          "id": {
            "type": "keyword"
          },
          "industry": {
            "type": "keyword",
            "normalizer": "lowercase_acsiifold_normalizer"
          },
          "interests": {
            "type": "text"
          },
          "job_company_id": {
            "type": "keyword"
          },
          "job_company_industry": {
            "type": "keyword",
            "normalizer": "lowercase_acsiifold_normalizer"
          },
          "job_company_linkedin_slugs": {
            "type": "keyword",
            "normalizer": "lowercase_trim_normalizer"
          },
          "job_company_location_country": {
            "type": "keyword",
            "normalizer": "lowercase_acsiifold_normalizer"
          },
          "job_company_location_name": {
            "type": "text",
            "fields": {
              "raw": {
                "type": "keyword"
              }
            }
          },
          "job_company_name": {
            "type": "text",
            "fields": {
              "raw": {
                "type": "keyword"
              }
            }
          },
          "job_company_size": {
            "type": "keyword"
          },
          "job_company_website": {
            "type": "keyword",
            "normalizer": "lowercase_acsiifold_normalizer"
          },
          "job_seniority": {
            "type": "keyword",
            "normalizer": "lowercase_acsiifold_normalizer"
          },
          "job_start_date": {
            "type": "date"
          },
          "job_title": {
            "type": "text",
            "fields": {
              "raw": {
                "type": "keyword"
              }
            }
          },
          "job_title_role": {
            "type": "keyword",
            "normalizer": "lowercase_acsiifold_normalizer"
          },
          "last_name": {
            "type": "keyword",
            "normalizer": "lowercase_trim_normalizer"
          },
          "latest_company_change_at": {
            "type": "date"
          },
          "latest_role_change_at": {
            "type": "date"
          },
          "linkedin_accounts": {
            "properties": {
              "connections": {
                "type": "integer"
              },
              "followers": {
                "type": "integer"
              },
              "join_date": {
                "type": "date"
              },
              "username": {
                "type": "keyword",
                "normalizer": "lowercase_trim_normalizer"
              }
            }
          },
          "linkedin_usernames": {
            "type": "keyword",
            "normalizer": "lowercase_trim_normalizer"
          },
          "location_continent": {
            "type": "text",
            "fields": {
              "raw": {
                "type": "keyword"
              }
            }
          },
          "location_country": {
            "type": "keyword",
            "normalizer": "lowercase_acsiifold_normalizer"
          },
          "location_locality": {
            "type": "text",
            "fields": {
              "raw": {
                "type": "keyword"
              }
            }
          },
          "location_name": {
            "type": "text",
            "fields": {
              "raw": {
                "type": "keyword"
              }
            }
          },
          "location_region": {
            "type": "text",
            "fields": {
              "raw": {
                "type": "keyword"
              }
            }
          },
          "recent_job_title": {
            "type": "text",
            "fields": {
              "raw": {
                "type": "keyword"
              }
            }
          },
          "recent_title": {
            "type": "alias",
            "path": "profile_info.recent_job_title"
          },
          "skills": {
            "type": "text",
            "fields": {
              "raw": {
                "type": "keyword"
              }
            }
          },
          "smart_tags": {
            "type": "keyword",
            "normalizer": "lowercase_trim_normalizer"
          },
          "updated_at": {
            "type": "date"
          }
        }
      }
    }
  }
}