Comment for Table KDR_HARM
Comment
Harmonogramy

Columns of Table KDR_HARM
Column ID Column Name Datatype Not Null Data Default Comments
1 ID_HARM NUMBER Y   ID
2 DATA_OD DATE     Data ważności od
3 DATA_DO DATE     Data ważności do
4 SKROT VARCHAR2(20 BYTE) Y   Skrót
5 OPIS VARCHAR2(50 BYTE)     Opis
6 UWAGI VARCHAR2(250 BYTE)     Uwagi
7 TMP NUMBER(22,1)   0 Czy harmonogram tymczasowy (niezapisany)

Indexes on Table KDR_HARM
Uniqueness Index Name Type Columns Partitions Partition Type Partition Columns Subpartition Type Subpartition Columns
NON-UNIQUE IDX_KDR_HARM_PK NORMAL ID_HARM <none>        
NON-UNIQUE IDX_KDR_HARM_UQ NORMAL SKROT <none>        

PK, UK, & Check Constraints on Table KDR_HARM
Constraint Name Type Condition Status Columns
NN_KDR_HARM_ID_HARM Check "ID_HARM" IS NOT NULL ENABLED ID_HARM
NN_KDR_HARM_SKROT Check "SKROT" IS NOT NULL ENABLED SKROT
PK_KDR_HARM Primary Key   ENABLED ID_HARM
UQ_KDR_HARM Unique   ENABLED SKROT

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