Comment for Table SKAZANI_SPRAWY_STANY
Comment
slownik stanow w jakim moga byc sprawy (aktualne, zakonczone, archiwalne)

Columns of Table SKAZANI_SPRAWY_STANY
Column ID Column Name Datatype Not Null Data Default Comments
1 ID_STANU NUMBER(6) Y   id stanu wykonania
2 STAN VARCHAR2(30 BYTE) Y   nazwa stanu wykonania

Indexes on Table SKAZANI_SPRAWY_STANY
Uniqueness Index Name Type Columns Partitions Partition Type Partition Columns Subpartition Type Subpartition Columns
UNIQUE SKAZANI_WYKONANIA_STANY_PK NORMAL ID_STANU <none>        
UNIQUE UK_SKAZANI_WYKONANIA_STANY NORMAL STAN <none>        

PK, UK, & Check Constraints on Table SKAZANI_SPRAWY_STANY
Constraint Name Type Condition Status Columns
SYS_C0054830 Check "ID_STANU" IS NOT NULL ENABLED ID_STANU
SYS_C0054831 Check "STAN" IS NOT NULL ENABLED STAN
SKAZANI_WYKONANIA_STANY_PK Primary Key   ENABLED ID_STANU
UK_SKAZANI_WYKONANIA_STANY Unique   ENABLED STAN

Table SKAZANI_SPRAWY_STANY does not have...
Partitions
Foreign Key Constraints
Redaction Policies