Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | |||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| id | serial | 10 | √ | nextval('angles_id_seq'::regclass) |
|
|
|||||||||||
| slug | text | 2147483647 | null |
|
|
||||||||||||
| persona | text | 2147483647 | null |
|
|
||||||||||||
| situation | text | 2147483647 | null |
|
|
||||||||||||
| emotional_state | text | 2147483647 | null |
|
|
||||||||||||
| search_intent | text | 2147483647 | null |
|
|
||||||||||||
| positioning_hook | text | 2147483647 | null |
|
|
||||||||||||
| title_seed | text | 2147483647 | √ | null |
|
|
|||||||||||
| status | text | 2147483647 | 'active'::text |
|
|
||||||||||||
| created_at | timestamptz | 35,6 | now() |
|
|
||||||||||||
| updated_at | timestamptz | 35,6 | now() |
|
|
||||||||||||
| persona_quant | jsonb | 2147483647 | √ | null |
|
|
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| angles_pkey | Primary key | Asc | id |
| angles_slug_key | Must be unique | Asc | slug |
Check Constraints
| Constraint Name | Constraint |
|---|---|
| angles_status_check | (status = ANY (ARRAY['draft'::text, 'active'::text, 'retired'::text])) |