| Name | Type | Default | Nullable | Children | Parents | Comment |
|---|---|---|---|---|---|---|
| SavedSearchID | STRING(36) | false | SavedSearches | |||
| UserID | STRING(MAX) | false | ||||
| UserRole | STRING(MAX) | false |
| Name | Type | Definition |
|---|---|---|
| PRIMARY_KEY | PRIMARY_KEY | PRIMARY KEY(UserID, SavedSearchID) |
| FK_SavedSearchUserRoles_SavedSearches_295EC75D4972EDF7_1 | FOREIGN KEY | FOREIGN KEY (SavedSearchID) REFERENCES SavedSearches (ID) ON DELETE CASCADE |
| Name | Definition |
|---|---|
| IDX_SavedSearchUserRoles_SavedSearchID_181FBCF745675390 | CREATE INDEX IDX_SavedSearchUserRoles_SavedSearchID_181FBCF745675390 ON SavedSearchUserRoles (SavedSearchID) |
Generated by tbls