mail

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)