Schema F_54
Oracle Version 11.2.0.4.0
As Of 2022/09/19 13:58:07
Prior Table | Table MAIL_MESSAGE_BODY | Next Table |
Comment |
---|
Tabela z załącznikami oraz treścią otrzymanych maili |
Column ID | Column Name | Datatype | Not Null | Data Default | Comments |
---|---|---|---|---|---|
1 | MSG_ID | NUMBER | ID wiadomości odebranej | ||
2 | PARTINDEX | VARCHAR2(200 BYTE) | Index części wiadomosci | ||
3 | PARENT_INDEX | VARCHAR2(200 BYTE) | |||
4 | FILENAME | VARCHAR2(200 BYTE) | nazwa załącznika | ||
5 | CONTENT_TYPE | VARCHAR2(200 BYTE) | Typ załacznika np. text/plain; charset=iso-8859-2 | ||
6 | CONTENT_DISPOSITION | VARCHAR2(200 BYTE) | w jaki spaoósb został dołaczony plik attachment lub inline | ||
7 | PART_SIZE | NUMBER | wielkość załącznika | ||
8 | CHILD_COUNT | NUMBER | |||
9 | BODY_BLOB | BLOB | załącznik |
Uniqueness | Index Name | Type | Columns | Partitions | Partition Type | Partition Columns | Subpartition Type | Subpartition Columns |
---|---|---|---|---|---|---|---|---|
NON-UNIQUE | IX_MAILMESAGEB_MSGID | NORMAL | MSG_ID | <none> |
Constraint Name | Columns | Ref Table Owner | Referenced Table Name | Referenced Columns | Delete Rule | Status | Deferrable | Deferred |
---|---|---|---|---|---|---|---|---|
FK_MAILMESSAGEBODY_MSGID | MSG_ID | F_54 | MAIL_MESSAGE_HEADER | MSG_ID | NO ACTION | ENABLED | No | No |
Partitions |
Primary Key, Unique, or Check Constraints |
Redaction Policies |