Schema F_54
Oracle Version 11.2.0.4.0
As Of 2022/09/19 13:58:07
Prior Table | Table FAKTURY_KOMPENSATA | Next Table |
Comment |
---|
Tablica przechowuje informacje o kompensatach obciążeń |
Column ID | Column Name | Datatype | Not Null | Data Default | Comments |
---|---|---|---|---|---|
1 | ID_FAK_KOM | NUMBER | Y | Klucz główny z sekwencji SQ_FAKTURY_KOMPENSATA_ID | |
2 | ID_FAK_NAL | NUMBER | Y | Id kompensowanej należności z FAKTURY | |
3 | ID_FAK_ZOB | NUMBER | Y | Id kompensowanego zobowiązania z FAKTURY | |
4 | ID_ZAP_NAL | NUMBER | Y | Id zapłaty należności z FAKTURY_ZAP2 | |
5 | ID_ZAP_ZOB | NUMBER | Y | Id zapłaty zobowiązania z FAKTURY_ZAP2 | |
6 | KWOTA | NUMBER | Y | Kwota kompensaty | |
7 | DATA_KOMPENSATY | DATE | Y | Data kompensaty | |
8 | DEKRET | VARCHAR2(2 CHAR) | Dekret | ||
9 | ID_DOWODU_FK | NUMBER | Id dowodu FK z DOWODY_KS |
Uniqueness | Index Name | Type | Columns | Partitions | Partition Type | Partition Columns | Subpartition Type | Subpartition Columns |
---|---|---|---|---|---|---|---|---|
NON-UNIQUE | FK_FAK_KOMPENSATA_DOW_KS | NORMAL | ID_DOWODU_FK | <none> | ||||
NON-UNIQUE | FK_FAK_KOMPENSATA_FAK_NAL | NORMAL | ID_FAK_NAL | <none> | ||||
NON-UNIQUE | FK_FAK_KOMPENSATA_FAK_ZOB | NORMAL | ID_FAK_ZOB | <none> | ||||
NON-UNIQUE | FK_FAK_KOMPENSATA_ZAP_NAL | NORMAL | ID_ZAP_NAL | <none> | ||||
NON-UNIQUE | FK_FAK_KOMPENSATA_ZAP_ZOB | NORMAL | ID_ZAP_ZOB | <none> | ||||
UNIQUE | PK_FAK_KOMPENSATA_ID | NORMAL | ID_FAK_KOM | <none> |
Constraint Name | Columns | Ref Table Owner | Referenced Table Name | Referenced Columns | Delete Rule | Status | Deferrable | Deferred |
---|---|---|---|---|---|---|---|---|
FK_FAK_KOMPENSATA_DOW_KS | ID_DOWODU_FK | F_54 | DOWODY_KS | ID_DOWODU | NO ACTION | ENABLED | No | No |
FK_FAK_KOMPENSATA_FAK_NAL | ID_FAK_NAL | F_54 | FAKTURY | ID_FAK | NO ACTION | ENABLED | No | No |
FK_FAK_KOMPENSATA_FAK_ZOB | ID_FAK_ZOB | F_54 | FAKTURY | ID_FAK | NO ACTION | ENABLED | No | No |
FK_FAK_KOMPENSATA_ZAP_NAL | ID_ZAP_NAL | F_54 | FAKTURY_ZAP2 | ID | NO ACTION | ENABLED | No | No |
FK_FAK_KOMPENSATA_ZAP_ZOB | ID_ZAP_ZOB | F_54 | FAKTURY_ZAP2 | ID | NO ACTION | ENABLED | No | No |
Constraint Name | Type | Condition | Status | Columns |
---|---|---|---|---|
NN_FAK_KOMPENSATA_DATA | Check | "DATA_KOMPENSATY" IS NOT NULL | ENABLED | DATA_KOMPENSATY |
NN_FAK_KOMPENSATA_ID_FAK_NAL | Check | "ID_FAK_NAL" IS NOT NULL | ENABLED | ID_FAK_NAL |
NN_FAK_KOMPENSATA_ID_FAK_ZOB | Check | "ID_FAK_ZOB" IS NOT NULL | ENABLED | ID_FAK_ZOB |
NN_FAK_KOMPENSATA_ID_ZAP_NAL | Check | "ID_ZAP_NAL" IS NOT NULL | ENABLED | ID_ZAP_NAL |
NN_FAK_KOMPENSATA_ID_ZAP_ZOB | Check | "ID_ZAP_ZOB" IS NOT NULL | ENABLED | ID_ZAP_ZOB |
NN_FAK_KOMPENSATA_KWOTA | Check | "KWOTA" IS NOT NULL | ENABLED | KWOTA |
PK_FAK_KOMPENSATA_ID | Primary Key | ENABLED | ID_FAK_KOM |
Partitions |
Redaction Policies |