kcd-work

Tables (9)

outbox_event

  • id — BIGSERIAL
  • aggregate_type — VARCHAR(100) — NOT NULL — 집계
  • aggregate_id — BIGINT — NOT NULL — 집계
  • event_type — VARCHAR(100) — NOT NULL — 이벤트
  • partition_key — VARCHAR(100) — NOT NULL — Kafka
  • payload — TEXT — NOT NULL — 이벤트
  • status — VARCHAR(30) — NOT NULL — 이벤트
  • retry_count — INTEGER — NOT NULL — 재시도
  • next_retry_at — TIMESTAMP — 다음
  • last_error — VARCHAR(1000) — 마지막
  • created_at — TIMESTAMP — NOT NULL — 생성
  • published_at — TIMESTAMP — 발행
  • eventId — VARCHAR(100)
  • rootEventId — VARCHAR(100)

partner

  • id — BIGSERIAL
  • name — VARCHAR(100) — NOT NULL — 파트너명
  • api_key — VARCHAR(150) — NOT NULL — API
  • created_at — TIMESTAMP — NOT NULL — 생성
  • webhook_url — VACHAR(!00)

partner_metric_policy

  • id — BIGSERIAL
  • partner_id — BIGINT — Foreign key → partner.id — NOT NULL — 파트너
  • metric_code — VARCHAR(50) — NOT NULL — 허용
  • created_at — TIMESTAMP — NOT NULL — 생성

partner_notification

  • id — BIGSERIAL
  • report_id — BIGINT — Foreign key — NOT NULL — 리포트
  • partner_id — BIGINT — Foreign key — NOT NULL — 전달
  • webhook_url — VARCHAR(500) — NOT NULL — 전달
  • status — VARCHAR(20) — NOT NULL — 전달
  • last_error — VARCHAR(500) — 마지막
  • retry_count — INTEGER — NOT NULL — 재시도
  • last_attempt_at — TIMESTAMP — 마지막
  • delivered_at — TIMESTAMP — 전달
  • created_at — TIMESTAMP — NOT NULL — 생성
  • updated_at — TIMESTAMP — NOT NULL — 수정

processed_event

  • id — BIGSERIAL
  • consumer_name — VARCHAR(100) — NOT NULL — 컨슈머
  • event_id — VARCHAR(100) — NOT NULL — 원본
  • processed_at — TIMESTAMP — NOT NULL — 처리

report

  • id — BIGSERIAL
  • partner_id — BIGINT — Foreign key → partner.id — NOT NULL — 요청
  • registration_number — VARCHAR(20) — NOT NULL — 사업자등록번호
  • business_name — VARCHAR(200) — 상호명
  • industry — VARCHAR(200) — 업종
  • region — VARCHAR(200) — 지역
  • generated_at — TIMESTAMP — 리포트
  • status — VARCHAR(30) — NOT NULL — 리포트
  • failure_stage — VARCHAR(30) — 실패
  • failure_reason — VARCHAR(500) — 실패
  • total_notification_count — INTEGER — NOT NULL — 알림
  • success_notification_count — INTEGER — NOT NULL — 알림
  • requested_at — TIMESTAMP — NOT NULL — 리포트
  • created_at — TIMESTAMP — NOT NULL — 생성
  • updated_at — TIMESTAMP — NOT NULL — 수정

report_metric

  • id — BIGSERIAL
  • report_id — BIGINT — Foreign key → report.id — NOT NULL — 리포트
  • code — VARCHAR(50) — NOT NULL — 지표
  • label — VARCHAR(200) — NOT NULL — 지표
  • metric_value — VARCHAR(200) — NOT NULL — 지표
  • unit — VARCHAR(50) — 단위
  • base_date — VARCHAR(20) — NOT NULL — 기준월/기준일
  • created_at — TIMESTAMP — NOT NULL — 생성

report_metric_origin

  • id — BIGSERIAL
  • report_id — BIGINT — Foreign key → report.id — NOT NULL — 리포트
  • code — VARCHAR(50) — NOT NULL — 지표
  • label — VARCHAR(200) — NOT NULL — 지표
  • metric_value — VARCHAR(1000) — NOT NULL — 지표
  • unit — VARCHAR(50) — 단위
  • base_date — VARCHAR(20) — NOT NULL — 기준월/기준일
  • created_at — TIMESTAMP — NOT NULL — 생성

report_view_history

  • id — BIGSERIAL
  • partner_id — BIGINT — Foreign key → partner.id — NOT NULL — 조회한
  • registration_number — VARCHAR(20) — NOT NULL — 조회
  • report_id — BIGINT — Foreign key → report.id — 조회된
  • success — BOOLEAN — NOT NULL — 조회
  • failure_reason — VARCHAR(500) — 조회
  • viewed_at — TIMESTAMP — NOT NULL — 조회