Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| id | serial | 10 | √ | nextval('oc_recent_contact_id_seq'::regclass) |
|
|
||
| actor_uid | varchar | 64 | null |
|
|
|||
| uid | varchar | 64 | √ | NULL::character varying |
|
|
||
| varchar | 255 | √ | NULL::character varying |
|
|
|||
| federated_cloud_id | varchar | 255 | √ | NULL::character varying |
|
|
||
| card | bytea | 2147483647 | null |
|
|
|||
| last_contact | int4 | 10 | null |
|
|
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| oc_recent_contact_pkey | Primary key | Asc | id |
| recent_contact_actor_uid | Performance | Asc | actor_uid |
| recent_contact_email | Performance | Asc | |
| recent_contact_fed_id | Performance | Asc | federated_cloud_id |
| recent_contact_id_uid | Performance | Asc/Asc | id + actor_uid |
| recent_contact_last_contact | Performance | Asc | last_contact |
| recent_contact_uid | Performance | Asc | uid |