캡스톤디자인2

테이블 (12)

campaign

  • campaign_id — BIGINT — 기본 키 — NOT NULL
  • campaign_name — VARCHAR(200) — NOT NULL
  • campaign_type — VARCHAR(50)
  • scheduled_at — DATETIME
  • send_mode — VARCHAR(30)
  • status — VARCHAR(30)
  • created_by — VARCHAR(100)
  • created_at — DATETIME — NOT NULL

campaign_target_rule

  • target_rule_id — BIGINT — 기본 키 — NOT NULL
  • campaign_id — BIGINT — 외래 키 → campaign.campaign_id — NOT NULL
  • rule_name — VARCHAR(100) — NOT NULL
  • rule_type — VARCHAR(50)
  • rule_expression — TEXT
  • created_at — DATETIME — NOT NULL

customer

  • customer_id — BIGINT — 기본 키 — NOT NULL
  • integrated_customer_key — VARCHAR(100) — NOT NULL
  • customer_type — VARCHAR(30) — NOT NULL
  • age_group — VARCHAR(30)
  • region — VARCHAR(100)
  • join_date — DATE
  • marketing_consent_yn — CHAR(1) — NOT NULL
  • customer_status — VARCHAR(30)
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

customer_activity

  • activity_id — BIGINT — 기본 키 — NOT NULL
  • customer_id — BIGINT — 외래 키 → customer.customer_id — NOT NULL
  • source_system_id — BIGINT — 외래 키 → external_source_system.source_system_id
  • activity_type_code — VARCHAR(50) — NOT NULL
  • activity_datetime — DATETIME — NOT NULL
  • activity_content — TEXT
  • created_at — DATETIME — NOT NULL

customer_analysis_result

  • analysis_result_id — BIGINT — 기본 키 — NOT NULL
  • customer_id — BIGINT — 외래 키 → customer.customer_id — NOT NULL
  • analysis_type — VARCHAR(50) — NOT NULL
  • segment_name — VARCHAR(100)
  • score_value — DECIMAL(8,2)
  • grade — VARCHAR(30)
  • result_summary — VARCHAR(255)
  • analyzed_at — DATETIME — NOT NULL
  • created_at — DATETIME — NOT NULL

customer_channel_consent

  • consent_id — BIGINT — 기본 키 — NOT NULL
  • customer_id — BIGINT — 외래 키 → customer.customer_id — NOT NULL
  • channel_code — VARCHAR(30) — NOT NULL
  • consent_yn — CHAR(1) — NOT NULL
  • consent_at — DATETIME
  • updated_at — DATETIME — NOT NULL

external_source_system

  • source_system_id — BIGINT — 기본 키 — NOT NULL
  • source_system_name — VARCHAR(100) — NOT NULL
  • source_system_type — VARCHAR(50) — NOT NULL
  • connection_type — VARCHAR(50)
  • use_yn — CHAR(1) — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

message_response

  • response_id — BIGINT — 기본 키 — NOT NULL
  • send_id — BIGINT — 외래 키 → message_send.send_id — NOT NULL
  • response_type_code — VARCHAR(30) — NOT NULL
  • response_datetime — DATETIME — NOT NULL
  • standardized_status — VARCHAR(30)
  • response_value — VARCHAR(255)
  • created_at — DATETIME — NOT NULL

message_send

  • send_id — BIGINT — 기본 키 — NOT NULL
  • campaign_id — BIGINT — 외래 키 → campaign.campaign_id — NOT NULL
  • customer_id — BIGINT — 외래 키 → customer.customer_id — NOT NULL
  • template_id — BIGINT — 외래 키 → message_template.template_id — NOT NULL
  • channel_code — VARCHAR(30) — NOT NULL
  • personalized_message — TEXT
  • send_requested_at — DATETIME
  • send_executed_at — DATETIME
  • send_status — VARCHAR(30)
  • external_message_key — VARCHAR(100)
  • created_at — DATETIME — NOT NULL

message_template

  • template_id — BIGINT — 기본 키 — NOT NULL
  • template_name — VARCHAR(200) — NOT NULL
  • template_purpose — VARCHAR(100)
  • template_version — INT — NOT NULL
  • kakao_approval_status — VARCHAR(30)
  • rejection_reason — VARCHAR(255)
  • content_body — TEXT — NOT NULL
  • is_active — CHAR(1) — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

purchase

  • purchase_id — BIGINT — 기본 키 — NOT NULL
  • customer_id — BIGINT — 외래 키 → customer.customer_id — NOT NULL
  • source_system_id — BIGINT — 외래 키 → external_source_system.source_system_id
  • product_or_service_name — VARCHAR(200) — NOT NULL
  • purchase_amount — DECIMAL(15,2) — NOT NULL
  • purchase_datetime — DATETIME — NOT NULL
  • order_status — VARCHAR(30)
  • created_at — DATETIME — NOT NULL

service_history

  • service_id — BIGINT — 기본 키 — NOT NULL
  • customer_id — BIGINT — 외래 키 → customer.customer_id — NOT NULL
  • source_system_id — BIGINT — 외래 키 → external_source_system.source_system_id
  • service_type_code — VARCHAR(50) — NOT NULL
  • service_datetime — DATETIME — NOT NULL
  • service_status — VARCHAR(30)
  • service_result — VARCHAR(255)
  • center_name — VARCHAR(100)
  • created_at — DATETIME — NOT NULL