Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| id | uuid | 2147483647 | public.gen_random_uuid() |
|
|
Primary key. |
||
| createdAt | timestamptz | 35,6 | now() |
|
|
Time created at. |
||
| emailSentAt | timestamptz | 35,6 | √ | null |
|
|
Time email sent at. Null if email not yet sent. |
|
| varchar | 255 | null |
|
|
Email registered to the searchCondition and searchType. |
|||
| searchType | enum_search_type | 2147483647 | null |
|
|
Type of search: Can be JOB, EXPERT_CLASS or QNA_QUESTION. |
||
| searchCondition | jsonb | 2147483647 | null |
|
|
Conditions of the search. |
||
| language | varchar | 255 | null |
|
|
Language email is to be sent in |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| SearchConditionEmails_pkey | Primary key | Asc | id |
| SearchConditionEmails_email_searchType_searchCondition_lang_key | Must be unique | Asc/Asc/Asc/Asc | email + searchType + searchCondition + language |
| SearchConditionEmails_searchType_idx | Performance | Asc | searchType |
Relationships
Close relationships within degrees of separation
