Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| id | bigserial | 19 | √ | nextval('blocklist_id_seq'::regclass) |
|
|
||
| uuid | uuid | 2147483647 | null |
|
|
|||
| type | text | 2147483647 | null |
|
|
|||
| value | varchar | 255 | null |
|
|
|||
| archived | bool | 1 | √ | false |
|
|
||
| created_at | timestamptz | 35,6 | √ | CURRENT_TIMESTAMP |
|
|
||
| updated_at | timestamptz | 35,6 | √ | CURRENT_TIMESTAMP |
|
|
||
| note | text | 2147483647 | √ | null |
|
|
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| blocklist_pkey | Primary key | Asc | id |
| blocklist_type_value_archived_index | Performance | Asc/Asc/Asc | type + value + archived |
| blocklist_type_value_unique | Must be unique | Asc/Asc | type + value |
Check Constraints
| Constraint Name | Constraint |
|---|---|
| blocklist_type_check | ((type = ANY (ARRAY['agent_hash'::text, 'email'::text, 'domain'::text]))) |
Diagram producer might be missing
No diagrams were produced please see application output for any errors