Schema F_54
Oracle Version 11.2.0.4.0
As Of 2022/09/19 13:58:07
Prior Table | Table ST_DOW_ST | Next Table |
Comment |
---|
Tablica krzyżowa łącząca ze sobą środki trwałe |
Column ID | Column Name | Datatype | Not Null | Data Default | Comments |
---|---|---|---|---|---|
1 | ID_ST_DOW_ST | NUMBER | Y | Klucz główny z sekwencji SEQ_ST_DOW_ST_ID | |
2 | ID_DOWODU_ST_PIER | NUMBER | Y | Id pierwszego z powiązanych środków trwałych | |
3 | ID_DOWODU_ST_DRUG | NUMBER | Y | Id drugiego z powiązanych środków trwałych |
Uniqueness | Index Name | Type | Columns | Partitions | Partition Type | Partition Columns | Subpartition Type | Subpartition Columns |
---|---|---|---|---|---|---|---|---|
NON-UNIQUE | INDX_ST_DOW_ST_IDDOWODUSTDRUG | NORMAL | ID_DOWODU_ST_DRUG | <none> | ||||
UNIQUE | PK_ST_DOW_ST_ID | NORMAL | ID_ST_DOW_ST | <none> | ||||
UNIQUE | UQ_ST_DOW_ST_ID_DOW_ST | NORMAL | ID_DOWODU_ST_PIER, ID_DOWODU_ST_DRUG | <none> |
Constraint Name | Columns | Ref Table Owner | Referenced Table Name | Referenced Columns | Delete Rule | Status | Deferrable | Deferred |
---|---|---|---|---|---|---|---|---|
FK_ST_DOW_ST_ID_DOW_ST_DRUG | ID_DOWODU_ST_DRUG | F_54 | ST_DOWODY | ID | NO ACTION | ENABLED | No | No |
FK_ST_DOW_ST_ID_DOW_ST_PIER | ID_DOWODU_ST_PIER | F_54 | ST_DOWODY | ID | NO ACTION | ENABLED | No | No |
Constraint Name | Type | Condition | Status | Columns |
---|---|---|---|---|
NN_ST_DOW_ST_ID_DOW_ST_DRUG | Check | "ID_DOWODU_ST_DRUG" IS NOT NULL | ENABLED | ID_DOWODU_ST_DRUG |
NN_ST_DOW_ST_ID_DOW_ST_PIER | Check | "ID_DOWODU_ST_PIER" IS NOT NULL | ENABLED | ID_DOWODU_ST_PIER |
PK_ST_DOW_ST_ID | Primary Key | ENABLED | ID_ST_DOW_ST | |
UQ_ST_DOW_ST_ID_DOW_ST | Unique | ENABLED | ID_DOWODU_ST_PIER, ID_DOWODU_ST_DRUG |
Partitions |
Redaction Policies |