Comment for Table POSESJA_USLUGI_HARM_WST_ZAB
Comment
Tabela z informacjami kiedy pojemnik ma zosatć wstawiony/zabrany

Columns of Table POSESJA_USLUGI_HARM_WST_ZAB
Column ID Column Name Datatype Not Null Data Default Comments
1 ID_HARM NUMBER(8) Y   ID harmonogramu
2 DATA_WST_ZAB DATE Y   Data wstawienia lub zabrania
3 WST_ZAB VARCHAR2(1 BYTE) Y   W- wstawienie, Z -zabranie
4 ID_OPISU NUMBER(6)     Id opisu powdów wstaw/zabrania
5 UWAGI VARCHAR2(255 BYTE)     Dodatkowe uwagi
6 OPERATOR VARCHAR2(60 BYTE)     Operator dokonujący zmiany
7 DATA DATE      

Indexes on Table POSESJA_USLUGI_HARM_WST_ZAB
Uniqueness Index Name Type Columns Partitions Partition Type Partition Columns Subpartition Type Subpartition Columns
NON-UNIQUE IX_POSESJRMWST_IDHARM NORMAL ID_HARM <none>        
NON-UNIQUE IX_POSESJRMWST_IDOPISU NORMAL ID_OPISU <none>        

Foreign Key Constraints on Table POSESJA_USLUGI_HARM_WST_ZAB
Constraint Name Columns Ref Table Owner Referenced Table Name Referenced Columns Delete Rule Status Deferrable Deferred
FK_HARM_WST_ZAB_OPIS ID_OPISU F_54 SL_OPIS_WST_ZAB ID_OPISU NO ACTION ENABLED No No
FK_POSESJA_USLUGI_HARM_WST_ZAB ID_HARM F_54 POSESJA_USLUGI_HARM ID_HARM NO ACTION ENABLED No No

PK, UK, & Check Constraints on Table POSESJA_USLUGI_HARM_WST_ZAB
Constraint Name Type Condition Status Columns
SYS_C0054720 Check "ID_HARM" IS NOT NULL ENABLED ID_HARM
SYS_C0054721 Check "DATA_WST_ZAB" IS NOT NULL ENABLED DATA_WST_ZAB
SYS_C0054722 Check "WST_ZAB" IS NOT NULL ENABLED WST_ZAB

Table POSESJA_USLUGI_HARM_WST_ZAB does not have...
Partitions
Redaction Policies