CRM
Tables (15)
Counsel (상담기록)
- id (PK) — INT — Primary key — NOT NULL — Auto Increment
- customer_id (FK) — INT — Foreign key → Customer.id — NOT NULL
- summary (요약) — text
- details (내용) — text — NOT NULL
- due_day (처리기간) — date
- emergency (긴급처리) — boolean — NOT NULL
- status (상태) — enum — NOT NULL
- created_at (생성일) — date — NOT NULL — auto_now_add
- updated_at (수정일) — date — auto_now
CounselDocument (상담자료)
- id (PK) — INT — Primary key — NOT NULL — Auto Increment
- counsel_id (FK) — INT — Foreign key → Counsel.id — NOT NULL — Auto Increment
- document_name — VARCHAR(255) — NOT NULL
- document_path — TEXT — NOT NULL
- created_at — DATETIME
- updated_at — DATETIME
Customer (고객)
- id (PK) — int — Primary key — NOT NULL — Auto Increment
- user_id (FK) — int — Foreign key → Users.id — NOT NULL
- phone_number (전화번호) — varchar — NOT NULL — 010-1111-1111
- name (이름) — varchar — NOT NULL
- gender (성별) — varchar — NOT NULL — Female,Male
- birth (Field2)
- address (주소) — varchar
- created_at (생성일) — date — NOT NULL — auto_now_add
- updated_at (수정일) — date — auto_now
CustomerFeedback (고객 피드백)
- id (PK) — INT — Primary key — NOT NULL — Auto Increment
- customer_id (FK) — INT — Foreign key → Customer.id — NOT NULL
- id (FK2) — INT — Foreign key → Counsel.id — Auto Increment
- feedback_text — TEXT
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME
EducationResource (교육자료)
- id — INT
- title — VARCHAR(255)
- type — VARCHAR(255)
- content — TEXT
- created_at — DATETIME
- updated_at — DATETIME
InsuranceProduct (기본상품들)
- id (PK) — INT — Primary key — NOT NULL — Auto Increment
- name — VARCHAR(255)
- description — TEXT
- premium — FLOAT
- coverage — VARCHAR(255)
- created_at — DATETIME
- updated_at — DATETIME
Lead (잠재고객)
- id — INT
- name — VARCHAR(255)
- contact — VARCHAR(255)
- interested_in — VARCHAR(255)
- created_at — DATETIME
- updated_at — DATETIME
MarketingCampaign (마케팅 캠페인)
- id — INT
- name — VARCHAR(255)
- description — TEXT
- start_date — DATE
- end_date — DATE
- created_at — DATETIME
- updated_at — DATETIME
MobileAccess (모바일 접근기록)
- id (PK) — INT — Primary key
- user_id (FK) — INT — Foreign key → Users.id — Auto Increment
- device_type — VARCHAR(255)
- last_login — DATETIME
- created_at — DATETIME
- updated_at — DATETIME
PerformanceReport (성과보고서)
- id — INT
- sales — FLOAT
- retention_rate — FLOAT
- date — DATE
- created_at — DATETIME
- updated_at — DATETIME
Policy (가입계약정보)
- id (PK) — INT — Primary key — NOT NULL — Auto Increment
- customer_id (FK) — INT — Foreign key → Customer.id — NOT NULL
- product_id (FK2) — INT — Foreign key → InsuranceProduct.id — NOT NULL
- policy_number — VARCHAR(255)
- start_date — DATE
- end_date — DATE
- premium_amount — FLOAT
- created_at — DATETIME
- updated_at — DATETIME
Reminder (알림)
- id (PK) — INT — Primary key — NOT NULL — Auto Increment
- user_id (FK) — INT — Foreign key → Users.id — NOT NULL
- counsel_id (FK2) — INT — Foreign key → Counsel.id — NOT NULL
- reminder_date — DATETIME
- type — VARCHAR(255)
- created_at — DATETIME
- updated_at — DATETIME
Schedule (일정)
- id (PK) — INT — Primary key — NOT NULL — Auto Increment
- date — DATETIME
- type — VARCHAR(255)
- created_at — DATETIME
- updated_at — DATETIME
Security (보안설정)
- id (PK) — INT — Primary key — Auto Increment
- customer_id (FK) — INT — Foreign key → Customer.id — NOT NULL
- is_korean (내국인여부) — BOOLEAN — NOT NULL
- key (중요키) — VARCHAR(6) — NOT NULL
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME
Users (사용자)
- id (PK) — int — Primary key — Auto Increment
- phone_number (전화번호) — varchar — NOT NULL — 010-xxxx-xxxx
- password (비밀번호) — varchar — NOT NULL — 해쉬
- name (이름) — varchar — NOT NULL — 송미미
- gender (성별) — varchar — NOT NULL — Female
- birth (생일) — date — 2000-01-01
- address (주소) — varchar — NOT NULL
- is_active (활성화) — boolean — NOT NULL
- key (키) — varchar — 해쉬
- is_staff (스탭여부) — boolean — NOT NULL
- created_at (생성일) — date — NOT NULL — auto_now_add
- updated_at (수정일) — date — auto_now