Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | |||
|---|---|---|---|---|---|---|---|---|---|---|---|
| id | uuid | 2147483647 | gen_random_uuid() |
|
|
||||||
| matchValue | text | 2147483647 | null |
|
|
||||||
| matchType | "growth"."SeoNegativeKeywordMatchType" | 2147483647 | null |
|
|
Matching strategy: EXACT - Match the word only if it appears by itself (e.g., “ass” matches only “ass”, not “class”, “assistant”, “passion”) PHRASE - Match the word if it appears by itself or as part of another word (e.g., “porn” matches “porn”, “pornHub”, “softporn”, “gayporn”) PATTERN - Custom smart rules to match words using patterns (e.g., pattern to match all words containing numbers) |
|||||
| createdByUserId | uuid | 2147483647 | √ | null |
|
|
|||||
| createdAt | timestamptz | 35,6 | now() |
|
|
||||||
| updatedAt | timestamptz | 35,6 | now() |
|
|
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| SeoNegativeKeywords_pkey | Primary key | Asc | id |
| SeoNegativeKeywords_matchValue_matchType_unique_idx | Must be unique | Asc/Asc | matchValue + matchType |
Relationships
Close relationships within degrees of separation
