Columns of Table PRAC_ROLE
Column ID |
Column Name |
Datatype |
Not Null |
Data Default |
Comments |
1 |
LOGIN1 |
VARCHAR2(30 BYTE) |
Y |
|
|
2 |
ROLA2 |
VARCHAR2(20 BYTE) |
Y |
|
|
Indexes on Table PRAC_ROLE
Uniqueness |
Index Name |
Type |
Columns |
Partitions |
Partition Type |
Partition Columns |
Subpartition Type |
Subpartition Columns |
NON-UNIQUE |
IX_PRACROPRACR_ROLA |
NORMAL |
ROLA |
<none> |
|
|
|
|
UNIQUE |
PK_PRACROLE |
NORMAL |
LOGIN, ROLA |
<none> |
|
|
|
|
Foreign Key Constraints on Table PRAC_ROLE
Constraint Name |
Columns |
Ref Table Owner |
Referenced Table Name |
Referenced Columns |
Delete Rule |
Status |
Deferrable |
Deferred |
FK_PRACROLE_PRAC_HASLA |
LOGIN |
F_54 |
PRAC_HASLA |
LOGIN |
NO ACTION |
ENABLED |
No |
No |
FK_PRACROLE_SLROLE |
ROLA |
F_54 |
SL_ROLE |
ROLA |
NO ACTION |
ENABLED |
No |
No |
PK, UK, & Check Constraints on Table PRAC_ROLE
Constraint Name |
Type |
Condition |
Status |
Columns |
PK_PRACROLE |
Primary Key |
|
ENABLED |
LOGIN, ROLA |
Table PRAC_ROLE does not have...
Comments |
Partitions |
Redaction Policies |