Comment for Table KDR_JEDN
Comment
Jednostki organizacyjne przedsiębiorstwa, wszystkie poziomy w hierarchii

Columns of Table KDR_JEDN
Column ID Column Name Datatype Not Null Data Default Comments
1 ID_JEDN NUMBER Y   ID
2 NAZWA VARCHAR2(50 BYTE)     Nazwa
3 ID_JEDN_NADRZ NUMBER     ID jednostki nadrzędnej
4 ID_JEDN_TYP NUMBER     ID typu jednostki
5 USUNIETY NUMBER(1)   0 Czy wiersz został usunięty.

Indexes on Table KDR_JEDN
Uniqueness Index Name Type Columns Partitions Partition Type Partition Columns Subpartition Type Subpartition Columns
NON-UNIQUE IDX_KDR_JEDN_PK NORMAL ID_JEDN <none>        
NON-UNIQUE IX_KDRJED_IDJEDNNADRZ NORMAL ID_JEDN_NADRZ <none>        
NON-UNIQUE IX_KDRJED_IDJEDNTYP NORMAL ID_JEDN_TYP <none>        

Foreign Key Constraints on Table KDR_JEDN
Constraint Name Columns Ref Table Owner Referenced Table Name Referenced Columns Delete Rule Status Deferrable Deferred
FK_KDR_JEDN_JEDN ID_JEDN_NADRZ F_54 KDR_JEDN ID_JEDN NO ACTION ENABLED No No
FK_KDR_JEDN_JEDN_TYP ID_JEDN_TYP F_54 KDR_JEDN_TYP ID_JEDN_TYP NO ACTION ENABLED No No

PK, UK, & Check Constraints on Table KDR_JEDN
Constraint Name Type Condition Status Columns
NN_KDR_JEDN_ID Check "ID_JEDN" IS NOT NULL ENABLED ID_JEDN
PK_KDR_JEDN Primary Key   ENABLED ID_JEDN

Table KDR_JEDN does not have...
Partitions
Redaction Policies