알림톡
테이블 (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