Schema F_54
Oracle Version 11.2.0.4.0
As Of 2022/09/19 13:58:07
Prior Table | Table REGULY_KS_PW | Next Table |
Comment |
---|
Ksiega glowna, tabela z pozycjami warunkowymi regul ksiegowania |
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 |
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> |
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 |
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 |
Partitions |
Redaction Policies |