Comment for Table REGULY_KS_PW
Comment
Ksiega glowna, tabela z pozycjami warunkowymi regul ksiegowania

Columns of Table REGULY_KS_PW
Column ID Column Name Datatype Not Null Data Default Comments
1 ID_REGULY NUMBER(8)     Id reguly z REGULY_KS_P
2 NR_KOL NUMBER(8)     Nr kolejny wykonywania z REGULY_KS_P
3 ZNAK_W VARCHAR2(2 BYTE)     Rodzaj operacji porownania AA - "=", BB - "<>", CC - ">", DD - "<", CA - ">=", DA - "<=", EE - "IS NOT NULL", FF - "IS NULL", XX - w przeciwym wypadku
4 WARTOSC_W VARCHAR2(30 BYTE)     Wartosc do porownania
5 STALA VARCHAR2(30 BYTE)     Stala do porownania
6 MASKA VARCHAR2(30 BYTE)     Maska dla stalej
7 KONTO VARCHAR2(32 BYTE)     Fragment konta
8 ID_REGULYP NUMBER(8)     Id reguly z REGULY_KS do ktorej trafimy po spelnieniu warunku
9 CZY_STALA CHAR(1 BYTE)   'N' Czy porownujemy ze stala. T - Tak, N - Nie

Indexes on Table REGULY_KS_PW
Uniqueness Index Name Type Columns Partitions Partition Type Partition Columns Subpartition Type Subpartition Columns
NON-UNIQUE IDX_REGULY_KS_PW_KOL_ID NORMAL NR_KOL, ID_REGULY <none>        
NON-UNIQUE IX_REGULYGULYK_IDREGULYNRKOL NORMAL ID_REGULY, NR_KOL <none>        
NON-UNIQUE IX_REGULYGULYK_IDREGULYP NORMAL ID_REGULYP <none>        
NON-UNIQUE IX_REGULYGULYK_STALA NORMAL STALA <none>        

Foreign Key Constraints on Table REGULY_KS_PW
Constraint Name Columns Ref Table Owner Referenced Table Name Referenced Columns Delete Rule Status Deferrable Deferred
FK_REGULYKSPW_REGULYKS ID_REGULYP F_54 REGULY_KS ID_REGULY NO ACTION ENABLED No No
FK_REGULYKSPW_REGULYKSP ID_REGULY, NR_KOL F_54 REGULY_KS_P ID_REGULY,NR_KOL NO ACTION ENABLED No No
FK_REGULYKSPW_STALE STALA F_54 STALE STALA NO ACTION DISABLED No No

PK, UK, & Check Constraints on Table REGULY_KS_PW
Constraint Name Type Condition Status Columns
CH_REGULYKSPW_CZY_STALA Check "CZY_STALA" IN ('T', 'N') ENABLED CZY_STALA
CH_REGULYKSPW_ZNAK_W Check "ZNAK_W" IN ('AA', 'BB', 'CC', 'DD', 'CA', 'DA', 'EE', 'FF', 'XX') ENABLED ZNAK_W

Table REGULY_KS_PW does not have...
Partitions
Redaction Policies