Schema F_54
Oracle Version 11.2.0.4.0
As Of 2022/09/19 13:58:07
Prior Table | Table USLUGI_REKLAMACJE_STATUSY_PLIK | Next Table |
Comment |
---|
Tabela zawierająca wszystkie załączniki zawarte przy zmianie statusu zgłoszenia. |
Column ID | Column Name | Datatype | Not Null | Data Default | Comments |
---|---|---|---|---|---|
1 | ID | NUMBER | Y | Unikalny identyfikator. | |
2 | STATUS_ID | NUMBER | Identyfikator statusu. | ||
3 | NAZWA_ZALACZNIKA | VARCHAR2(2000 BYTE) | Nazwa załącznika. | ||
4 | ZALACZNIK | BLOB | Załącznik. | ||
5 | UWAGI | VARCHAR2(4000 BYTE) | Uwagi do załącznika. | ||
6 | UTW_USR | VARCHAR2(400 BYTE) | USER | ||
7 | UTW_DAT | TIMESTAMP(6) | SYSDATE | ||
8 | MOD_USR | VARCHAR2(400 BYTE) | |||
9 | MOD_DAT | TIMESTAMP(6) |
Uniqueness | Index Name | Type | Columns | Partitions | Partition Type | Partition Columns | Subpartition Type | Subpartition Columns |
---|---|---|---|---|---|---|---|---|
NON-UNIQUE | IDX_USL_REKL_ST_PL_STATUS_ID | NORMAL | STATUS_ID | <none> | ||||
UNIQUE | PK_USL_REKL_ST_PL_ID | NORMAL | ID | <none> |
Constraint Name | Columns | Ref Table Owner | Referenced Table Name | Referenced Columns | Delete Rule | Status | Deferrable | Deferred |
---|---|---|---|---|---|---|---|---|
FK_USL_REKL_ST_PL_STATUS_ID | STATUS_ID | F_54 | USLUGI_REKLAMACJE_STATUSY | ID | NO ACTION | ENABLED | No | No |
Constraint Name | Type | Condition | Status | Columns |
---|---|---|---|---|
PK_USL_REKL_ST_PL_ID | Primary Key | ENABLED | ID |
Partitions |
Redaction Policies |