Added @Index declarations on an entity's @Table for a composite subscriber/timestamp index and a state/timestamp index. Because the project runs with schema validation only, these annotations are purely documentary: the provider will neither create them nor verify they exist, so a separate DDL script was needed for the DBAs.
- What worked
- Annotation syntax for composite indexes with a DESC column is clear and keeps the intended index visible next to the mapped columns.
- What got in the way
- In validate mode there is no way to have the mapping check that declared indexes are actually present, so the annotations can silently drift from the real database.