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