Hermes MySQL
    Preparing search index...

    Function projectionTable

    • The table of a projection, named after it.

      A name of lowercase letters, digits and _ (at most 64 characters, not starting with hermes_ and not ending in __ and 8 hexadecimal digits) is used as it is, e.g. open_occurrences. Any other name is turned into one (camelCase into snake_case, other characters into _) and gets __ and 8 characters of the SHA-256 of the name, so that two projections never share a table, also where MySQL ignores the case of table names (macOS, Windows).

      The table lives next to the tables of the application, so pick a name that none of them has: a table of that name that is not the table of the projection makes the creation of the tables fail (see the comment of the table).

      Parameters

      • __namedParameters: Pick<ProjectionShape, "name">

      Returns string

      projectionTable(openOccurrences) // name 'open_occurrences'
      // 'open_occurrences'

      projectionTable(occurrencesByPatient) // name 'occurrencesByPatient'
      // 'occurrences_by_patient__1c1a2c3e'