Comment for Table KDR_STAN
Comment
Stanowiska w przedsiębiorstwie, wszystkie poziomy w hierarchii

Columns of Table KDR_STAN
Column ID Column Name Datatype Not Null Data Default Comments
1 ID_STAN NUMBER Y   ID
2 NAZWA VARCHAR2(200 BYTE)     Nazwa
3 ID_STAN_NADRZ NUMBER     ID stanowiska nadrzędnego
4 ID_STAN_TYP NUMBER     ID typu stanowiska
5 USUNIETY NUMBER(1)   0 Czy usuniety wiersz

Indexes on Table KDR_STAN
Uniqueness Index Name Type Columns Partitions Partition Type Partition Columns Subpartition Type Subpartition Columns
NON-UNIQUE IDX_KDR_STAN_PK NORMAL ID_STAN <none>        
NON-UNIQUE IX_KDRSTA_IDSTANNADRZ NORMAL ID_STAN_NADRZ <none>        
NON-UNIQUE IX_KDRSTA_IDSTANTYP NORMAL ID_STAN_TYP <none>        

Foreign Key Constraints on Table KDR_STAN
Constraint Name Columns Ref Table Owner Referenced Table Name Referenced Columns Delete Rule Status Deferrable Deferred
FK_KDR_STAN_STAN ID_STAN_NADRZ F_54 KDR_STAN ID_STAN NO ACTION ENABLED No No
FK_KDR_STAN_STAN_TYP ID_STAN_TYP F_54 KDR_STAN_TYP ID_STAN_TYP NO ACTION ENABLED No No

PK, UK, & Check Constraints on Table KDR_STAN
Constraint Name Type Condition Status Columns
NN_KDR_STAN_ID Check "ID_STAN" IS NOT NULL ENABLED ID_STAN
PK_KDR_STAN Primary Key   ENABLED ID_STAN

Table KDR_STAN does not have...
Partitions
Redaction Policies