Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| id | serial | 10 | √ | nextval('oc_circles_circle_id_seq'::regclass) |
|
|
||
| unique_id | varchar | 31 | null |
|
|
|||
| name | varchar | 127 | null |
|
|
|||
| display_name | varchar | 255 | √ | ''::character varying |
|
|
||
| sanitized_name | varchar | 127 | √ | ''::character varying |
|
|
||
| instance | varchar | 255 | √ | ''::character varying |
|
|
||
| config | int4 | 10 | √ | null |
|
|
||
| source | int4 | 10 | √ | null |
|
|
||
| settings | text | 2147483647 | √ | null |
|
|
||
| description | text | 2147483647 | √ | null |
|
|
||
| creation | timestamp | 22 | √ | NULL::timestamp without time zone |
|
|
||
| contact_addressbook | int4 | 10 | √ | null |
|
|
||
| contact_groupname | varchar | 127 | √ | NULL::character varying |
|
|
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| oc_circles_circle_pkey | Primary key | Asc | id |
| dname | Performance | Asc | display_name |
| idx_8195f5484230b1de | Performance | Asc | instance |
| idx_8195f5485f8a7f73 | Performance | Asc | source |
| idx_8195f548c317b362 | Performance | Asc | sanitized_name |
| idx_8195f548d48a2f7c | Performance | Asc | config |
| uniq_8195f548e3c68343 | Must be unique | Asc | unique_id |