OnePlatformCenterAPI

테이블 (4)

발송템플릿 (template_info)

  • Key (id) — int — 기본 키 — NOT NULL
  • Field (sender_key) — varchar(100)
  • Field (sender_key_type) — varchar(1)
  • Field (template_code) — varchar(30)
  • Field (template_name) — varchar(200)
  • Field (template_message_type) — varchar(10)
  • Field (template_emphasize_type) — varchar(10)
  • Field (template_content) — varchar(4000)
  • Field (etc) — varchar(4000) or json
  • Field (inspection_status) — varchar(10)
  • Field (created_at) — varchar(19)
  • Field (modified_at) — varchar(19)
  • Field (status) — varchar(1)
  • Field (block) — boolean
  • Field (dormant) — boolean
  • Field (category_code) — varchar(20)
  • Field (securityFlag) — boolean
  • Field (created_by) — varchar(100)
  • Field (created_date) — varchar(19)
  • Field (last_modified_by) — varchar(100)
  • Field (last_modified_date) — varchar(19)

발신프로필 (send_profile)

  • Key (id) — int — 기본 키 — NOT NULL
  • Key (sender_key) — varchar(40) — 기본 키 — NOT NULL
  • Field (uuid) — varchar(20)
  • Field (name) — varchar(20)
  • Field (status) — varchar(20)
  • Field (block) — boolean
  • Field (dormant) — boolean
  • Field (profile_status) — varchar(20)
  • Field (created_at) — varchar(19)
  • Field (modified_at) — varchar(19)
  • Field (category_code) — varchar(11)
  • Field (alimtalk) — boolean
  • Field (bizchat) — boolean
  • Field (brandtalk) — boolean
  • Field (commital_company_name) — varchar(100)
  • Field (channel_key) — varchar(20)
  • Field (business_profile) — boolean
  • Field2 (business_type) — varchar(50)
  • Field (created_by) — varchar(100)
  • Field (created_date) — varchar(19)
  • Field (last_modified_by) — varchar(100)
  • Field (last_modified_date) — varchar(19)

발신프로필그룹 (send_profile_group)

  • Key (id) — int — 기본 키 — NOT NULL
  • Key (group_key) — varchar(100) — 기본 키 — NOT NULL
  • Field (name) — varchar(40)
  • Field (created_at) — varchar(19)
  • Field (created_by) — varchar(100)
  • Field (created_date) — varchar(19)
  • Field (last_modified_by) — varchar(100)
  • Field (last_modified_date) — varchar(19)

발신프로필그룹맵핑 (send_profile_group_mapping)

  • Key (id) — int — 기본 키 — NOT NULL
  • Key (group_key) — varchar(100) — 외래 키 → 발신프로필그룹.Key — NOT NULL
  • Key (sender_key) — varchar(40) — 외래 키 → 발신프로필.Key — NOT NULL
  • Field (created_by) — varchar(100)
  • Field (created_date) — varchar(19)
  • Field (last_modified_by) — varchar(100)
  • Field (last_modified_date) — varchar(19)