캡스톤디자인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