DMSender
Tables (9)
a_banlist
- idx — int(11) — Primary key — NOT NULL
- insta_id — varchar(30) — NOT NULL
- created — datetime(3) — NOT NULL
- updated — datetime(3)
- type — tinyint(1)
- etc1 — tinyint(1)
- etc2 — tinyint(1)
a_map_recipient_list
- idx — int(11) — Primary key — NOT NULL
- rcp_idx — int(11) — Foreign key → a_recipient.idx — NOT NULL
- list_idx — int(11) — Foreign key → a_recipient_list.idx — NOT NULL
- is_invalid — tinyint(1) — NOT NULL
- created — timestamp(3) — NOT NULL
- etc1 — tinyint(1)
- etc2 — tinyint(1)
a_map_recipient_template
- idx — int(11) — Primary key — NOT NULL
- rcp_idx — int(11) — Foreign key → a_recipient.idx — NOT NULL
- tpl_idx — int(11) — Foreign key → a_template.idx — NOT NULL
- is_banned — tinyint(4) — NOT NULL
- sending_count — tinyint(4) — NOT NULL
- sending_time — datetime(3) — NOT NULL
- created — datetime(3)
- etc1 — tinyint(1)
- etc2 — tinyint(1)
a_map_template_banlist
- ban_idx — int(11) — Foreign key → a_banlist.idx — NOT NULL
- tpl_idx — int(11) — Foreign key → a_template.idx — NOT NULL
- is_invalid — tinyint(1) — NOT NULL
- created — datetime(3) — NOT NULL
- etc1 — tinyint(1) — NOT NULL
- etc2 — tinyint(1) — NOT NULL
a_receive_block
- idx — int(11) — Primary key — NOT NULL
- insta_id — varchar(30) — NOT NULL
- created — datetime(3) — NOT NULL
- updated — datetime(3)
a_recipient
- idx — int(11) — Primary key — NOT NULL
- insta_id — varchar(30) — NOT NULL
- created — datetime(3) — NOT NULL
- updated — datetime(3)
- etc1 — tinyint(1)
- etc2 — tinyint(1)
a_recipient_list
- idx — int(11) — Primary key — NOT NULL
- title — varchar(255)
- is_invalid — tinyint(1) — NOT NULL
- created — datetime(3)
- updated — datetime(3)
a_sender
- idx — int(11) — Primary key — NOT NULL
- insta_id — varchar(30) — NOT NULL
- passwd — varchar(100)
- ip — varchar(30)
- usr — varchar(30)
- type — tinyint(1) — NOT NULL — DM : 1, 댓글 : 2, 모두 : 3, 삭제 : 4
- recent_time_DM — datetime(3)
- recent_time_reply — datetime(3)
- created — datetime(3) — NOT NULL
- updated — datetime(3)
- etc1 — tinyint(1)
- etc2 — tinyint(1)
a_template
- idx — int(11) — Primary key — NOT NULL — Index
- title — varchar(255) — NOT NULL — Template Name
- kakao_url — text — NOT NULL — DM Kakao URL Template
- campaign_url — varchar(255) — NOT NULL — DM URL Template
- campaign_detail — text
- extra — text
- reply — text — NOT NULL — DM Content Template
- is_invalid — tinyint(4) — NOT NULL — Is Visiable
- recent_list — int(11) — NOT NULL
- created — datetime(3) — NOT NULL — Created Time
- updated — datetime(3) — Updated Time
- etc1 — tinyint(1)
- etc2 — tinyint(1)