Schema F_54
Oracle Version 11.2.0.4.0
As Of 2022/09/19 13:58:07
Prior Table | Table ST_LOKALIZACJE_KDR_JEDN | Next Table |
Comment |
---|
Tablica łącząca lokalizację w środkach trwałych ze strukturą organizacyjną firmy |
Column ID | Column Name | Datatype | Not Null | Data Default | Comments |
---|---|---|---|---|---|
1 | ID_ST_LOK_KDR_JEDN | NUMBER | Y | Klucz główny z sekwencji SEQ_ST_LOKALIZACJE_KDR_JEDN_ID | |
2 | ID_ST_LOK | NUMBER | Y | Lokalizacja środków trwałych z tabeli ST_LOKALIZACJE | |
3 | ID_JEDN | NUMBER | Y | Jednostka organizacyjna z tabeli KDR_JEDN |
Uniqueness | Index Name | Type | Columns | Partitions | Partition Type | Partition Columns | Subpartition Type | Subpartition Columns |
---|---|---|---|---|---|---|---|---|
NON-UNIQUE | INDX_ST_LOKALIZ_IDJEDN | NORMAL | ID_JEDN | <none> | ||||
UNIQUE | PK_ST_LOK_KDR_JEDN_ID | NORMAL | ID_ST_LOK_KDR_JEDN | <none> | ||||
UNIQUE | UQ_ST_LOK_KDR_JEDN_LOK | NORMAL | ID_ST_LOK, ID_JEDN | <none> |
Constraint Name | Columns | Ref Table Owner | Referenced Table Name | Referenced Columns | Delete Rule | Status | Deferrable | Deferred |
---|---|---|---|---|---|---|---|---|
FK_ST_LOK_KDR_JEDN_JEDN | ID_JEDN | F_54 | KDR_JEDN | ID_JEDN | NO ACTION | ENABLED | No | No |
FK_ST_LOK_KDR_JEDN_LOK | ID_ST_LOK | F_54 | ST_LOKALIZACJE | ID | NO ACTION | ENABLED | No | No |
Constraint Name | Type | Condition | Status | Columns |
---|---|---|---|---|
NN_ST_LOK_KDR_JEDN_JEDN | Check | "ID_JEDN" IS NOT NULL | ENABLED | ID_JEDN |
NN_ST_LOK_KDR_JEDN_LOK | Check | "ID_ST_LOK" IS NOT NULL | ENABLED | ID_ST_LOK |
PK_ST_LOK_KDR_JEDN_ID | Primary Key | ENABLED | ID_ST_LOK_KDR_JEDN | |
UQ_ST_LOK_KDR_JEDN_LOK | Unique | ENABLED | ID_ST_LOK, ID_JEDN |
Partitions |
Redaction Policies |