Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| creationdate | int8 | 19 | null |
|
|
|||
| description | varchar | 1000 | √ | null |
|
|
||
| filename | varchar | 127 | null |
|
|
|||
| modificationdate | int8 | 19 | null |
|
|
|||
| placeobjectid | int8 | 19 | null |
|
|
|||
| placeobjecttype | int4 | 10 | null |
|
|
|||
| staticid | int8 | 19 | null |
|
|
|||
| userid | int8 | 19 | null |
|
|
|||
| statictypeid | int4 | 10 | 1 |
|
|
|||
| status | int4 | 10 | 2 |
|
|
|||
| crypthash | varchar | 64 | √ | null |
|
|
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| jivestaticpk | Primary key | Asc | staticid |
| jivestaticfk | Performance | Asc/Asc/Asc | placeobjecttype + placeobjectid + filename |
Diagram producer might be missing
No diagrams were produced please see application output for any errors