Comment for Table MAIL_MESSAGE_FOLDER
Comment
Słownik z katalogami w skrzynce pocztowej.

Columns of Table MAIL_MESSAGE_FOLDER
Column ID Column Name Datatype Not Null Data Default Comments
1 ID_FOLDER NUMBER Y   ID folderu
2 NAZWA VARCHAR2(128 BYTE)     Nazwa folderu
3 SYSTEMOWY VARCHAR2(1 BYTE)   'N' Informacja czy folder jest systemowy i nie może zostac skasowany.
4 ID_FOLDER_N NUMBER     ID folderu nadrzędnego

Indexes on Table MAIL_MESSAGE_FOLDER
Uniqueness Index Name Type Columns Partitions Partition Type Partition Columns Subpartition Type Subpartition Columns
NON-UNIQUE IX_MAILMEGEFOL_IDFOLDERN NORMAL ID_FOLDER_N <none>        
UNIQUE PK_MESSAGEFOLDER NORMAL ID_FOLDER <none>        

Foreign Key Constraints on Table MAIL_MESSAGE_FOLDER
Constraint Name Columns Ref Table Owner Referenced Table Name Referenced Columns Delete Rule Status Deferrable Deferred
FK_MAILSENT_FOLDERN ID_FOLDER_N F_54 MAIL_MESSAGE_FOLDER ID_FOLDER NO ACTION ENABLED No No

PK, UK, & Check Constraints on Table MAIL_MESSAGE_FOLDER
Constraint Name Type Condition Status Columns
PK_MESSAGEFOLDER Primary Key   ENABLED ID_FOLDER

Table MAIL_MESSAGE_FOLDER does not have...
Partitions
Redaction Policies