Schema F_54
Oracle Version 11.2.0.4.0
As Of 2022/09/19 13:58:07
Prior Table | Table MAIL_MESSAGE_SENT_ATTACH | Next Table |
Comment |
---|
Tabela z załącznikami do wysyłanych mail |
Column ID | Column Name | Datatype | Not Null | Data Default | Comments |
---|---|---|---|---|---|
1 | MSG_SENT_ID | VARCHAR2(4000 BYTE) | ID wiadomości | ||
2 | FILENAME | VARCHAR2(200 BYTE) | Nazwa pliku załącznika | ||
3 | CONTENT_TYPE | VARCHAR2(200 BYTE) | Typ załącznika np. application/pdf | ||
4 | BODY_BLOB | BLOB | Załącznik |
Uniqueness | Index Name | Type | Columns | Partitions | Partition Type | Partition Columns | Subpartition Type | Subpartition Columns |
---|---|---|---|---|---|---|---|---|
NON-UNIQUE | IX_MAILMENTATT_MSGSENTID | NORMAL | MSG_SENT_ID | <none> |
Constraint Name | Columns | Ref Table Owner | Referenced Table Name | Referenced Columns | Delete Rule | Status | Deferrable | Deferred |
---|---|---|---|---|---|---|---|---|
FK_MAILSENDATTACH_HEADER | MSG_SENT_ID | F_54 | MAIL_MESSAGE_SENT_HEADER | MSG_SENT_ID | NO ACTION | ENABLED | No | No |
Partitions |
Primary Key, Unique, or Check Constraints |
Redaction Policies |