| Name | Type | Default | Nullable | Children | Parents | Comment |
|---|---|---|---|---|---|---|
| EventId | STRING(36) | false | ||||
| SavedSearchId | STRING(36) | false | SavedSearchState | |||
| SnapshotType | STRING(MAX) | false | SavedSearchState | |||
| Timestamp | TIMESTAMP (allow_commit_timestamp=TRUE) | false | ||||
| EventType | STRING(MAX) | false | ||||
| BlobPath | STRING(MAX) | false | ||||
| Summary | JSON | true | ||||
| DiffBlobPath | STRING(MAX) | true | ||||
| Reasons | ARRAY<STRING(MAX)> | true |
| Name | Type | Definition |
|---|---|---|
| PRIMARY_KEY | PRIMARY_KEY | PRIMARY KEY(EventId) |
| FK_Events_State | FOREIGN KEY | FOREIGN KEY (SavedSearchId, SavedSearchId, SnapshotType, SnapshotType) REFERENCES SavedSearchState (SavedSearchId, SnapshotType, SavedSearchId, SnapshotType) ON DELETE CASCADE |
| Name | Definition |
|---|---|
| SavedSearchNotificationEvents_BySearchAndType | CREATE INDEX SavedSearchNotificationEvents_BySearchAndType ON SavedSearchNotificationEvents (SavedSearchId, EventType, Timestamp) |
| SavedSearchNotificationEvents_BySearchAndSnapshotType | CREATE INDEX SavedSearchNotificationEvents_BySearchAndSnapshotType ON SavedSearchNotificationEvents (SavedSearchId, SnapshotType, Timestamp) |
| IDX_SavedSearchNotificationEvents_SavedSearchId_SnapshotType_DA904570C69F9709 | CREATE INDEX IDX_SavedSearchNotificationEvents_SavedSearchId_SnapshotType_DA904570C69F9709 ON SavedSearchNotificationEvents (SavedSearchId, SnapshotType) |
Generated by tbls