Tables (18)
TB_MAIL_ACCOUNT_INFORMATION
- ACCOUNT_ID — VARCHAR(36) — Primary key — NOT NULL
- EMAIL_ADDRESS — VARCHAR(256)
- MAIL_USER_NAME — VARCHAR(501)
- WS_USE_CODE — VARCHAR(7)
- USER_ID — VARCHAR(36)
- WS_ID — VARCHAR(36)
- TDRIVE_CH_ID — VARCHAR(50)
- SEQ — VARCHAR(10)
- PANEL_TYPE — VARCHAR(10)
- MAIL_SEND_TYPE — VARCHAR(10)
- NEW_MAIL_SIGNATURE_ID — NUMBER
- REPLY_SIGNATURE_ID — NUMBER
- REG_TYPE — VARCHAR(5)
- PASSWORD — VARCHAR(256)
- HOST_NAME — VARCHAR(256)
- LAST_SYNC_TIME — TIMESTAMP(3)
- UIDL — VARCHAR(70)
- MODIFIED_DATE — TIMESTAMP(3)
- ACCESS_TOKEN — VARCHAR(255)
- REFRESH_TOKEN — VARCHAR(255)
- TOKEN_UPDATE_DATE — TIMESTAMP(3)
TB_MAIL_ADDRESSBOOK
- ADDRESSBOOK_ID — VARCHAR(36) — Primary key — NOT NULL
- LAST_NAME — VARCHAR(256)
- FIRST_NAME — VARCHAR(256)
- MIDDLE_NAME — VARCHAR(256)
- NICK_NAME — VARCHAR(256)
- COMPANY — VARCHAR(256)
- POSITION — VARCHAR(256)
- ADDRESS — VARCHAR(1024)
- BIRTHDAY — VARCHAR(256)
- MEMO — VARCHAR(1024)
- POST_NUM — VARCHAR(256)
- PROFILE_META — VARCHAR(1024)
- USER_ID — VARCHAR(36)
- ACCOUNT_ID — VARCHAR(36)
- NAME_INITIAL — VARCHAR(256)
- DATA — BLOB
- EXTENSION — VARCHAR(256)
TB_MAIL_ADDRESSBOOK_EMAIL
- ADDRESSBOOK_ID — VARCHAR(36)
- EMAIL_ADDRESS — VARCHAR(512)
TB_MAIL_ADDRESSBOOK_PHONE
- ADDRESSBOOK_ID — VARCHAR(36)
- PHONE_NUM — VARCHAR(512)
TB_MAIL_ATTACHMENT
- ATTACHMENT_ID — VARCHAR(36) — NOT NULL
- USER_ID — VARCHAR(36)
- WS_ID — VARCHAR(36)
- EXTENSION — VARCHAR(50)
- FILE_NAME — VARCHAR(256)
- TDRIVE_CH_ID — VARCHAR(50)
- FILE_META — VARCHAR(36)
- MAIL_ID — NUMBER
- FILE_SIZE — NUMBER
- ACCOUNT_ID — VARCHAR(36)
- DATA — BLOB
TB_MAIL_FOLDER
- FOLDER_ID — NUMBER — Primary key — NOT NULL
- ACCOUNT_ID — VARCHAR(36) — Primary key — NOT NULL
- DISPLAY_NAME — VARCHAR(600)
- FOLDER_TYPE — VARCHAR(7)
- SYNC_STATE — VARCHAR(7)
- USER_ID — VARCHAR(36)
- PARENT_FOLDER_TYPE — VARCHAR(36)
- PARENT_FOLDER_ID — NUMBER
- FULL_PATH — VARCHAR(256)
- IS_PARENT — VARCHAR(5)
TB_MAIL_HOST_LIST_IMAP
- HOST_NAME — VARCHAR(256)
- SMTP_SERVER_NAME — VARCHAR(256)
- SMTP_PORT — VARCHAR(256)
- IMAP_SERVER_NAME — VARCHAR(256)
- IMAP_PORT — VARCHAR(256)
- CONNECTION_TYPE — VARCHAR(256)
TB_MAIL_HOST_LIST_POP3
- HOST_NAME — VARCHAR(256) — Primary key — NOT NULL
- SMTP_SERVER_NAME — VARCHAR(256)
- SMTP_PORT — VARCHAR(256)
- POP_SERVER_NAME — VARCHAR(256)
- POP_PORT — VARCHAR(256)
- CONNECTION_TYPE — VARCHAR(256)
TB_MAIL_MST
- MAIL_ID — NUMBER — Primary key — NOT NULL
- SUBJECT — VARCHAR(2000)
- SENDER_NAME — VARCHAR(256)
- HAS_ATTACHMENT_YN_CODE — VARCHAR(8)
- SEEN_YN_CODE — VARCHAR(7)
- IMPORTANCE_YN_CODE — VARCHAR(7)
- DELETED — VARCHAR(5)
- FILE_SIZE — VARCHAR(255)
- USER_ID — VARCHAR(36)
- WS_ID — VARCHAR(36)
- SENDER_ADDR — VARCHAR(255)
- MAIL_GROUP_INDEX — VARCHAR(36)
- CONTENT — CLOB
- SEND_IMPORTANCE_CODE — VARCHAR(7)
- MAIL_FLAG — VARCHAR(20)
- OUTBOUND_STATUS — VARCHAR(7)
- SEEN — VARCHAR(20)
- RECEIVED_TIME — TIMESTAMP(3)
- FOLDER_ID — NUMBER
- FIRST_SAW_TIME — TIMESTAMP(3)
- ACCOUNT_ID — VARCHAR(36)
- MAIL_BYTES — BLOB
- PLAIN_TEXT — CLOB
- RECEIVED_ID — VARCHAR(256)
- DELETE_DATETIME — TIMESTAMP(3)
- ATTACHMENT_COUNT — NUMBER
- IMPORTANCE — VARCHAR(1)
- MAIL_UIDL — VARCHAR(70)
- RECOVERY — VARCHAR(1)
- MODIFIED_DATE — TIMESTAMP(3)
TB_MAIL_POP3_SYNC_STATE
- STATE — VARCHAR(7)
- REG_DATE — TIMESTAMP(3)
- ACCOUNT_ID — VARCHAR(36)
- REQUEST_TYPE — VARCHAR(7)
TB_MAIL_RULE
- RULE_ID — VARCHAR(36)
- VALUE — VARCHAR(36)
- PARENT_RULE_ID — VARCHAR(36)
- USER_ID — VARCHAR(36)
- ACCOUNT_ID — VARCHAR(36)
TB_MAIL_RULE_FOLDER
- RULE_ID — VARCHAR(36)
- FOLDER_ID — VARCHAR(36)
- FOLDER_NAME — VARCHAR(36)
TB_MAIL_SIGNATURE_MST
- USER_ID — VARCHAR(36) — Primary key — NOT NULL
- SIGNATURE_ID — NUMBER — Primary key — NOT NULL
- SIGNATURE_NAME — VARCHAR(200)
- SIGNATURE — CLOB
TB_MAIL_SPAM_EMAIL_ADDRESS
- USER_ID — VARCHAR(36) — NOT NULL
- EMAIL_ADDRESS — VARCHAR(36)
TB_MAIL_SPAM_FOLDER_SETTING
- USER_ID — VARCHAR(36) — NOT NULL
- FOLDER_HIDE_YN — VARCHAR(36)
- SPAM_MAIL_STORAGE_PERIOD — VARCHAR(36)
- SPAM_RESULT — VARCHAR(36)
- SPAM_CONTENT_IMAGE — VARCHAR(36)
TB_MAIL_SPAM_KEYWORD
- USER_ID — VARCHAR(36)
- KEYWORD — VARCHAR(255)
TB_MAIL_SPAM_MST
- USER_ID — VARCHAR(36)
- IMPOSTURE_YN — VARCHAR(36)
- TO_ADDR_YN — VARCHAR(36)
- SENDER_ADDR_YN — VARCHAR(36)
- LANGUAGE_SPAM_YN — VARCHAR(36)
- MOVE_YN — VARCHAR(36)
- REPORT_SPAM_RESULT — VARCHAR(36)
- REPORT_ADDR_BLOCK_YN — VARCHAR(36)
TB_MAIL_TO
- TO_ADDR — VARCHAR(255)
- TO_NAME — VARCHAR(255)
- GROUP_INDEX — VARCHAR(36)
- FIRST_SAW_TIME — VARCHAR(20)
- MAIL_ID — NUMBER
- ACCOUNT_ID — VARCHAR(36)
- TYPE — VARCHAR(3)