신 공용메일
테이블 (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