Schema F_54
Oracle Version 11.2.0.4.0
As Of 2022/09/19 13:58:07
Prior Table | Table FAKTURY_PISMA | Next Table |
Comment |
---|
zalaczniki do faktur |
Column ID | Column Name | Datatype | Not Null | Data Default | Comments |
---|---|---|---|---|---|
1 | ID_PISMA | NUMBER | Y | zalacznik (PK) | |
2 | DT_PISMA | DATE | data ktorej dotyczy pismo | ||
3 | TRESC | VARCHAR2(2000 CHAR) | nazwa | ||
4 | PISMO | BLOB | zalacznik | ||
5 | NAZWA_PLIKU | VARCHAR2(2000 CHAR) | nazwa pliku zalcznika | ||
6 | DATA | DATE | data zalaczenia | ||
7 | ID_FAK | NUMBER | faktura (FK) | ||
8 | SKROT_TYPU_FAKTURY_PISMA | VARCHAR2(1 CHAR) | Y | 'F' | FK do sl_typy_faktury_pisma - wskazuje na typ dokumentu / domyślnie F - faktura |
Uniqueness | Index Name | Type | Columns | Partitions | Partition Type | Partition Columns | Subpartition Type | Subpartition Columns |
---|---|---|---|---|---|---|---|---|
UNIQUE | FAKTURY_PISMA_PK | NORMAL | ID_PISMA | <none> | ||||
NON-UNIQUE | INDX_FAKY_PI_TYPUFAKTISMA | NORMAL | SKROT_TYPU_FAKTURY_PISMA | <none> | ||||
NON-UNIQUE | IX_FAKTURURYPI_IDFAK | NORMAL | ID_FAK | <none> |
Constraint Name | Columns | Ref Table Owner | Referenced Table Name | Referenced Columns | Delete Rule | Status | Deferrable | Deferred |
---|---|---|---|---|---|---|---|---|
FAKTURY_PISMA_FAKTURY_FK1 | ID_FAK | F_54 | FAKTURY | ID_FAK | NO ACTION | ENABLED | No | No |
FK_FAK_PISMA_SK_TYP_FAK_PISM | SKROT_TYPU_FAKTURY_PISMA | F_54 | SL_TYPY_FAKTURY_PISMA | SKROT | NO ACTION | ENABLED | No | No |
Constraint Name | Type | Condition | Status | Columns |
---|---|---|---|---|
CH_NN_FAKTURY_PIS_ID_PISMA | Check | "ID_PISMA" IS NOT NULL | ENABLED | ID_PISMA |
NN_FAK_PISMA_SK_TYP_FAK_PISM | Check | "SKROT_TYPU_FAKTURY_PISMA" IS NOT NULL | ENABLED | SKROT_TYPU_FAKTURY_PISMA |
FAKTURY_PISMA_PK | Primary Key | ENABLED | ID_PISMA |
Partitions |
Redaction Policies |