Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| objectid | varchar | 64 | ''::character varying |
|
|
|||
| objecttype | varchar | 64 | ''::character varying |
|
|
|||
| systemtagid | int8 | 19 | 0 |
|
|
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| oc_systemtag_object_mapping_pkey | Primary key | Asc/Asc/Asc | objecttype + objectid + systemtagid |
| memories_type_tagid | Performance | Asc/Asc | objecttype + systemtagid |
| systag_by_objectid | Performance | Asc | objectid |
| systag_by_tagid | Performance | Asc/Asc | systemtagid + objecttype |
| systag_objecttype | Performance | Asc | objecttype |