Columns of Table EXP_LOG_P
Column ID |
Column Name |
Datatype |
Not Null |
Data Default |
Comments |
1 |
ID_EXP |
NUMBER(8) |
Y |
|
|
2 |
ID_PRAC |
NUMBER(8) |
Y |
|
|
Indexes on Table EXP_LOG_P
Uniqueness |
Index Name |
Type |
Columns |
Partitions |
Partition Type |
Partition Columns |
Subpartition Type |
Subpartition Columns |
NON-UNIQUE |
IX_EXPLOG_IDEXP |
NORMAL |
ID_EXP |
<none> |
|
|
|
|
NON-UNIQUE |
IX_EXPLOG_IDPRAC |
NORMAL |
ID_PRAC |
<none> |
|
|
|
|
Foreign Key Constraints on Table EXP_LOG_P
Constraint Name |
Columns |
Ref Table Owner |
Referenced Table Name |
Referenced Columns |
Delete Rule |
Status |
Deferrable |
Deferred |
FK_EXPLOGP_EXPLOG |
ID_EXP |
F_54 |
EXP_LOG |
ID_EXP |
NO ACTION |
ENABLED |
No |
No |
FK_EXPLOGP_PRACOWNICY |
ID_PRAC |
F_54 |
PRACOWNICY |
ID_PRAC |
NO ACTION |
ENABLED |
No |
No |
PK, UK, & Check Constraints on Table EXP_LOG_P
Constraint Name |
Type |
Condition |
Status |
Columns |
SYS_C0054579 |
Check |
"ID_EXP" IS NOT NULL |
ENABLED |
ID_EXP |
SYS_C0054580 |
Check |
"ID_PRAC" IS NOT NULL |
ENABLED |
ID_PRAC |
Table EXP_LOG_P does not have...
Comments |
Partitions |
Redaction Policies |