Columns
Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
---|---|---|---|---|---|---|---|---|
OBJECT_ID | VARCHAR2 | 30 | null |
|
|
|||
ENTITY | VARCHAR2 | 30 | √ | null |
|
|
||
ENTITY_OBJECT_ID | VARCHAR2 | 30 | √ | null |
|
|
||
DESCRIPTION | VARCHAR2 | 100 | √ | null |
|
|
||
CODE | VARCHAR2 | 50 | √ | null |
|
|
||
ACTIVE | CHAR | 1 | √ | null |
|
|
||
LAST_CHANGED | TIMESTAMP(6) | 11,6 | √ | null |
|
|
||
LONG_DESCRIPTION | VARCHAR2 | 1000 | √ | null |
|
|
||
COUNTRY_ID | VARCHAR2 | 30 | √ | null |
|
|
||
HUMAN_SYSTEM | CHAR | 1 | √ | null |
|
|
||
SECURITY_LEVEL | NUMBER | 0 | √ | null |
|
|
||
AUTHORITY_TYPE | VARCHAR2 | 100 | √ | null |
|
|
||
AUTHORITY_TYPE_ID | VARCHAR2 | 30 | √ | null |
|
|
||
ALPHACODE2 | VARCHAR2 | 2 | √ | null |
|
|
||
ALPHACODE3 | VARCHAR2 | 3 | √ | null |
|
|
||
URL | VARCHAR2 | 1000 | √ | null |
|
|
||
CREDENTIALS | VARCHAR2 | 100 | √ | null |
|
|
||
CREATED_ON | TIMESTAMP(6) | 11,6 | √ | null |
|
|
Indexes
Constraint Name | Type | Sort | Column(s) |
---|---|---|---|
SYS_C00113549 | Primary key | Asc | OBJECT_ID |
Diagram producer might be missing
No diagrams were produced please see application output for any errors