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