알림톡

테이블 (8)

alim_action (Untitled3)

  • id — serial4 — 기본 키 — NOT NULL
  • kam_id — serial4 — 외래 키 → crm_baseXkam_history.id — NOT NULL

crm_baseXkam_history

  • id — serial4 — 기본 키 — NOT NULL
  • title — varchar(255)
  • type — varchar(255) — NOT NULL
  • message — varchar(1000) — NOT NULL
  • raw — json
  • sendType — varchar(255) — NOT NULL
  • intervalTime — int4
  • sendHourMinute — int4
  • countEstimate — int4
  • countSent — int4
  • sentAt — timestamptz
  • targetGroup — json
  • createdAt — timestamptz — NOT NULL
  • updatedAt — timestamptz — NOT NULL
  • sendUserId (id2) — int4 — 외래 키 → user.id
  • crmBaseXkfmReservationId — int4 — 외래 키 → crm_baseXkam_reservations.id

crm_baseXkam_reservations

  • id — serial4 — 기본 키 — NOT NULL
  • title — varchar(255)
  • type — varchar(255) — NOT NULL
  • message — varchar(1000) — NOT NULL
  • raw — json
  • sendType — varchar(255) — NOT NULL
  • intervalTime — int4
  • intervalStartDate — timestamptz
  • intervalFinishDate — timestamptz
  • sendHourMinute — int4
  • lastSentDate — timestamptz
  • sentStatus — varchar(255)
  • enabled — bool
  • targetGroup — json
  • createdAt — timestamptz — NOT NULL
  • updatedAt — timestamptz — NOT NULL
  • sendUserId — int4 — 외래 키 → user.id

crm_baseXmessage_template

  • id — serial4 — 기본 키 — NOT NULL
  • isAuto — bool — NOT NULL
  • key — varchar(255)
  • meta — json — 클릭업 참조
  • createdAt — timestamptz — NOT NULL
  • updatedAt — timestamptz — NOT NULL
  • status — string — NOT NULL — 심사요청(전), 심사중 , 반려 , 완료 , L2

crm_baseXmessage_template_resource (Untitled)

  • resource_id — integer — 기본 키 — NOT NULL
  • record_id — serial4 — 외래 키 → crm_baseXmessage_template.id — NOT NULL

crm_baseXreserved_message

  • id — serial4 — 기본 키 — NOT NULL
  • key — varchar(255) — NOT NULL
  • enabled — bool — NOT NULL
  • type — varchar(255) — NOT NULL
  • reservedAt — timestamptz — NOT NULL
  • condition — json — NOT NULL
  • contents — json — NOT NULL
  • target — json — NOT NULL
  • error — varchar(255)
  • createdAt — timestamptz — NOT NULL
  • updatedAt — timestamptz — NOT NULL
  • reservedUserId — int4

crm_si_tcXreservation_logs

  • id — serial4 — 기본 키 — NOT NULL
  • type — varchar(255) — NOT NULL
  • subType — varchar(255)
  • raw — json
  • createdAt — timestamptz — NOT NULL
  • updatedAt — timestamptz — NOT NULL
  • crmSiTcXreservationId — int4
  • loggedUserId — int4

user (Untitled2)

  • id — integer — 기본 키 — NOT NULL