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)