ums-test

Tables (9)

notification_api_request

  • request_id — BIGINT — Primary key — NOT NULL
  • request_service — varchar(100) — 요청 서비스
  • request_uri — varchar(500) — 요청 API URI
  • channel — varchar(30) — NOT NULL — 발송 채널
  • request_status — varchar(30) — NOT NULL — API 요청 처리 상태
  • error_code — varchar(100) — API 요청 처리 오류 코드
  • error_message — varchar(1000) — API 요청 처리 오류 메시지
  • request_dtm — datetime — NOT NULL — API 요청 일시
  • response_dtm — datetime — API 응답 일시

notification_message

  • send_id — BIGINT — Foreign key → notification_send.send_id — NOT NULL
  • message_type — varchar(20) — NOT NULL — 문자 유형, SMS / LMS / MMS
  • sender_number — varchar(20) — 발신 번호
  • title — varchar(200) — 문자 제목, LMS/MMS 사용
  • message_content — text — 문자 내용

notification_provider

  • provider_id — BIGINT — Primary key — NOT NULL
  • channel — VARCHAR(30) — NOT NULL
  • provider_code — VARCHAR(50) — NOT NULL
  • provider_name — VARCHAR(100) — NOT NULL
  • priority_no — INT — NOT NULL
  • use_yn — CHAR(1) — NOT NULL
  • register_dtm — DATETIME — NOT NULL
  • update_dtm — DATETIME — NOT NULL

notification_push

  • send_id — BIGINT — Foreign key → notification_send.send_id — NOT NULL
  • category — varchar(50) — 푸시 카테고리
  • push_type — varchar(50) — 푸시 유형
  • page_move_url — varchar(1000) — 푸시 클릭 시 이동 URL
  • notification_icon_url — varchar(1000) — 푸시 알림 아이콘 URL
  • notification_banner_img_url — varchar(1000) — 푸시 알림 배너 이미지 URL

notification_send

  • send_id — BIGINT — Primary key — NOT NULL
  • channel — VARCHAR(30) — NOT NULL
  • variables_json — JSON
  • bulk_yn — CHAR(1) — NOT NULL
  • scheduled_dtm — DATETIME — NOT NULL
  • register_dtm — DATETIME — NOT NULL
  • template_version_id — BIGINT — Foreign key → notification_template_version.template_version_id — NOT NULL
  • request_id — BIGINT — Foreign key → notification_api_request.request_id — NOT NULL
  • provider_id — BIGINT — Foreign key → notification_provider.provider_id — NOT NULL

notification_send_recipient

  • recipient_id (recipient_id2) — BIGINT — Primary key — NOT NULL
  • member_id — bigint — 회원 아이디
  • contact_type — varchar(30) — NOT NULL — 수신 주소 유형
  • contact — varchar(500) — NOT NULL — 실제 수신 주소
  • template_parameters — json — 수신자별 템플릿 변수
  • register_dtm — datetime — NOT NULL — 등록 일시
  • send_id — BIGINT — Foreign key → notification_send.send_id — NOT NULL

notification_send_result

  • result_id — BIGINT — Primary key — NOT NULL
  • status — VARCHAR(30) — NOT NULL
  • total_count — INT — NOT NULL
  • success_count — INT — NOT NULL
  • fail_count — INT — NOT NULL
  • start_dtm — DATETIME
  • complete_dtm — DATETIME
  • update_dtm — DATETIME — NOT NULL
  • send_id — BIGINT — Foreign key → notification_send.send_id — NOT NULL

notification_template

  • template_id — BIGINT — Primary key — NOT NULL
  • channel — VARCHAR(30) — NOT NULL
  • template_code — VARCHAR(100) — NOT NULL
  • template_name — VARCHAR(200) — NOT NULL
  • use_yn — CHAR(1) — NOT NULL
  • register_dtm — DATETIME — NOT NULL
  • update_dtm — DATETIME — NOT NULL

notification_template_version

  • template_version_id — BIGINT — Primary key — NOT NULL
  • version_no — INT — NOT NULL
  • content_json — JSON — NOT NULL
  • register_dtm — DATETIME — NOT NULL
  • template_id — BIGINT — Foreign key → notification_template.template_id — NOT NULL