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
Example
projectionTable(openOccurrences) // name 'open_occurrences' // 'open_occurrences'
projectionTable(occurrencesByPatient) // name 'occurrencesByPatient' // 'occurrences_by_patient__1c1a2c3e'
The table of a projection, named after it.
A name of lowercase letters, digits and
_(at most 64 characters, not starting withhermes_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).