Mail ERD
Tables (7)
mail_admin_users (메일 관리자)
- mail_admin_user_id (Key) — Primary key — NOT NULL
- Field
mail_messages (개별 메일)
- mail_message_id (Key) — Primary key — NOT NULL
- Field
- mail_request_id (Key2) — Foreign key → mail_requests.mail_request_id — NOT NULL
mail_requests (메일 전송 요청)
- mail_request_id (Key) — Primary key — NOT NULL
- mail_body (Field)
- template_edition_id (Key2) — Foreign key → template_editions.template_edition_id
- Field2
project_authority (프로젝트 권한)
- project_id (Key) — Foreign key → projects.project_id — NOT NULL
- mail_admin_user_id (Key2) — Foreign key → mail_admin_users.mail_admin_user_id — NOT NULL
projects (프로젝트)
- project_id (Key) — Primary key — NOT NULL
- Field
template_editions (템플릿 에디션)
- template_edition_id (Key) — Primary key — NOT NULL
- Field
- template_id (Key2) — Foreign key → templates.template_id — NOT NULL
- mail_admin_user_id (Key3) — Foreign key → mail_admin_users.mail_admin_user_id — NOT NULL
templates (템플릿)
- template_id (Key) — Primary key — NOT NULL
- Field
- mail_admin_user_id (Key2) — Foreign key → mail_admin_users.mail_admin_user_id — NOT NULL
- project_id (Key3) — Foreign key → projects.project_id — NOT NULL