Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| linkid | int8 | 19 | 0 |
|
|
|||
| objecttype | int4 | 10 | null |
|
|
|||
| objectid | int8 | 19 | null |
|
|
|||
| targetlinktype | int4 | 10 | null |
|
|
|||
| targetobjecttype | int4 | 10 | √ | null |
|
|
||
| targetobjectid | int8 | 19 | √ | null |
|
|
||
| targetattachmentid | int8 | 19 | √ | null |
|
|
||
| targeturl | varchar | 3500 | √ | null |
|
|
||
| targettext | varchar | 3500 | √ | null |
|
|
||
| targetdescription | varchar | 3500 | √ | null |
|
|
||
| targetanchortext | varchar | 3500 | √ | null |
|
|
||
| creationdate | int8 | 19 | 0 |
|
|
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| jivewl_id_pk | Primary key | Asc | linkid |
| jivewl_otypid_idx | Performance | Asc/Asc | objecttype + objectid |
| jivewl_ttypid_idx | Performance | Asc/Asc | targetobjecttype + targetobjectid |
Diagram producer might be missing
No diagrams were produced please see application output for any errors