신 공용메일

테이블 (16)

actions

  • no — bigint(11) — 기본 키 — NOT NULL
  • filter_no — bigint(11) — NOT NULL
  • action_type — enum('MOVE','READ','IMPORTANT','DELETE') — NOT NULL
  • created_at — datetime — NOT NULL

approvals

  • no — bigint(11) — 기본 키 — NOT NULL
  • mail_no — bigint(11) — NOT NULL
  • status — enum('REJECT', 'APPROVAL', 'CANCEL') — NOT NULL
  • created_at — datetime
  • updated_at — datetime

approvers

  • no — bigint(11) — 기본 키 — NOT NULL
  • apprvoal_no — bigint(11) — NOT NULL
  • user_no — bigint(11) — NOT NULL
  • is_approval — boolean — NOT NULL
  • memo — varchar(100)
  • created_at — datetime
  • updated_at — datetime

attachments

  • no — bigint(11) — 기본 키 — NOT NULL
  • message_no — bigint(11) — NOT NULL
  • part_id — varchar(10) — NOT NULL
  • name — varchar(100) — NOT NULL
  • size — int(20) — NOT NULL
  • content_type — varchar(50) — NOT NULL

autoreplies

  • no — bigint(11) — 기본 키 — NOT NULL
  • mail_config_no — bigint(11) — NOT NULL
  • start_date — date — NOT NULL
  • end_date — date — NOT NULL
  • content — text — NOT NULL
  • subject — varchar(100)
  • is_use — boolean — NOT NULL
  • created_at — datetime — NOT NULL
  • updated_at — datetime

filters

  • no — bigint(11) — 기본 키 — NOT NULL
  • mail_config_no — bigint(11) — NOT NULL
  • from — varchar(100)
  • to — varchar(300)
  • cc — varchar(300)
  • subject — varchar(300)
  • has_attach — boolean
  • created_at — datetime
  • updated_at — datetime

group_members

  • no — bigint(11) — 기본 키 — NOT NULL
  • address_no — bigint(11) — NOT NULL
  • member_address_no — bigint(11)
  • created_at — datetime

mailboxes

  • no — bigint(11) — 기본 키 — NOT NULL
  • user_no — bigint(11) — NOT NULL
  • name — varchar(100) — NOT NULL
  • box_no — bigint(11)
  • box_type — ENUM("SYSTEM","PERSONAL")
  • parent_id — bigint(11)
  • order — int — NOT NULL
  • password — varchar(255)
  • password_hint — varchar(50)
  • created_at — datetime — NOT NULL
  • updated_at — datetime

mails

  • no — bigint(11) — 기본 키 — NOT NULL
  • message_no — bigint(11) — NOT NULL
  • user_no — bigint(11) — NOT NULL
  • address_no — bigint(11)
  • mailbox_no — bigint(11) — NOT NULL
  • memo — varchar(100)
  • is_read — boolean
  • is_important — boolean
  • is_deleted — boolean
  • created_at — datetime
  • updated_at — datetime

messages

  • no — bigint(11) — 기본 키 — NOT NULL
  • office_no — bigint(11) — NOT NULL
  • from — varchar(100)
  • to — mediumtext
  • cc — mediumtext
  • bcc — mediumtext
  • reply_to — varchar(100)
  • subject — varchar(200)
  • mail_path — varchar(200) — NOT NULL
  • message_id — varchar(100) — NOT NULL
  • mail_size — int(10) — NOT NULL
  • priority — int(1)
  • date — datetime
  • content_type — varchar(100)
  • security_type — enum('PASS','FAIL','NONE') — NOT NULL
  • has_attach — boolean — NOT NULL
  • thread_id — varchar(100)
  • created_at — datetime — NOT NULL

schedules

  • no — bigint(11) — 기본 키 — NOT NULL
  • mail_no — bigint(11) — NOT NULL
  • is_sent — boolean — NOT NULL
  • scheduled_at — datetime — NOT NULL
  • created_at — datetime
  • updated_at — datetime

senders

  • no — bigint(11) — 기본 키 — NOT NULL
  • mail_config_no — bigint(11) — NOT NULL
  • address_no — bigint(11) — NOT NULL
  • signature_no — bigint(11) — NOT NULL
  • name — varchar(50) — NOT NULL
  • is_default — boolean — NOT NULL
  • created_at — datetime — NOT NULL
  • updated_at — datetime

signatures

  • no — bigint(11) — 기본 키 — NOT NULL
  • mail_config_no — bigint(11) — NOT NULL
  • subject — varchar(50) — NOT NULL
  • content — text — NOT NULL
  • created_at — datetime — NOT NULL
  • updated_at — datetime

도메인 (domains)

  • no — bigint(11) — 기본 키 — NOT NULL
  • office_no — bigint(11) — NOT NULL
  • domain — varchar(100) — NOT NULL
  • is_main — boolean — NOT NULL
  • created_at — datetime — NOT NULL
  • updated_at — datetime

메일 계정 (mail_accounts)

  • no — bigint(11) — 기본 키 — NOT NULL
  • office_no — bigint(11)
  • mail_size — bigint(11)
  • name — varchar(100)
  • account_key (bigint(11)) — bigint(11)
  • account_type (enum('ORG', 'USER', 'TEAM")) — enum('ORG', 'USER', 'TEAM")
  • is_active (활성 상태)
  • use_smtp — boolean
  • use_pop3 — boolean
  • use_imap — boolean
  • created_at (생성일) — datetime
  • updated_at (수정일) — datetime

메일 주소 (addresses)

  • no — bigint(11) — 기본 키 — NOT NULL
  • 메일 계정 no (mail_account_no) — bigint(11) — 외래 키 → 메일 계정.no — NOT NULL
  • 도메인 no (domain_no) — bigint(11) — 외래 키 → 도메인.no — NOT NULL
  • 이름 (name) — varchar(50)
  • 메일주소 (address_id)
  • 주소타입 (address_type) — ENUM('GROUP','USER')
  • 활성상태 (is_active) — boolean
  • 생성날짜 (created_at) — datetime
  • 수정날짜 (updated_at) — datetime