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)