soso-insuarance

테이블 (20)

GA

  • id (Key) — Long — 기본 키 — NOT NULL
  • status (Field13) — String
  • name (Field) — String
  • ceo_name (Field2) — String
  • biz_number (Field3) — String
  • biz_address (Field4) — String
  • biz_type (Field5) — String
  • biz_type_detail (Field6) — String
  • phone (Field7) — String
  • fax (Field8) — String
  • created_admin_id (Field11) — Long
  • last_updated_admin_id (Field12) — Long
  • createdAt (Field9) — LocalDateTime
  • updatedAt (Field10) — LocalDateTime

Log (로그)

    admin (관리자)

    • id (Key) — Long — 기본 키 — NOT NULL
    • role_id (Field7) — Long
    • company_id (Field8) — Long
    • username (Field) — String
    • password (Field2) — String
    • name (Field3) — String
    • phone (Field4) — String
    • email (Field5) — String
    • status (r) — String
    • last_login_at (Field6) — LocasDateTime
    • creat_admin_id (Field14) — Long
    • last_update_admin_id (Field13) — Long
    • createdAt (Field9) — LocalDateTime
    • updatedAt (Field12) — LocalDateTime

    admin_sms (문자연동정보)

    • id (Key) — Long — 기본 키 — NOT NULL
    • admin_id (Field) — Long
    • api_key (Field3) — String
    • identifier (Field2) — String

    admin_sms_sender (발신번호)

    • id (Key) — Long — 기본 키 — NOT NULL
    • admin_sms_id (Field) — Long
    • is_basic (Field3) — Boolean
    • number (Field2) — String
    • name (Field4) — String

    category (보험 카테고리)

    • id (Key) — Long — 기본 키 — NOT NULL
    • Field

    company (보험사)

    • id (Key) — Long — 기본 키 — NOT NULL
    • ga_id (Field15) — Long
    • status (Field) — String
    • type (Field2) — String
    • name (Field3) — String
    • ceo_name (Field4) — String
    • biz_number (Field5) — String
    • biz_address (Field6) — String
    • phone (Field7) — String
    • fax (Field8) — String
    • manager_name (Field9) — String
    • manager_phone (Field16) — String
    • manager_email (Field17) — String
    • created_admin_id (Field12) — Long
    • last_updated_admin_id (Field13) — Long
    • createdAt (Field10) — LocalDateTime
    • updatedAt (Field11) — LocalDateTime

    consult (상담)

    • id (Key) — Long — 기본 키 — NOT NULL
    • customer_id (Field) — Long
    • content (Field2) — String
    • writer_admin_id (Field3) — Long
    • createdAt (Field4) — LocalDateTime
    • updatedAt (Field5) — LocalDateTime

    consultant (Untitled2)

    • id (Key) — Long — 기본 키 — NOT NULL
    • admin_id (Field) — Long
    • ga_id (Field2) — Long
    • number (Field3) — String
    • contractedAt (Field4) — LocalDateTime
    • role_id (Field5) — Long

    consultant_detail (CopyOf관리자 메모)

    • id (Key) — Long — 기본 키 — NOT NULL
    • admin_id (Field) — Long
    • content (Field2) — String
    • writer_admin_id (Field3) — Long
    • createdAt (Field4) — LocalDateTime
    • updatedAt (Field5) — LocalDateTime

    consultant_log (CopyOf로그)

      customer (고객)

      • id (Key) — Long — 기본 키 — NOT NULL
      • name (고객명) — String
      • username (Field) — String
      • phone (Field2) — String
      • birth (Field3) — String
      • gender (Field4) — String
      • insuarance_age (Field5) — String
      • insuarance_age_increase_date (Field6) — LocalDate
      • status (Field7) — String
      • ga_id (Field15) — Long
      • consultant_id (Field8) — Long
      • createdAt (Field9) — LocalDateTime
      • updatedAt (Field10) — LocalDateTime
      • assignedAt (Field12) — LocalDateTime
      • is_agree (Field11) — String
      • is_agreed_at (Field13) — LocalDateTime
      • note (Field14) — String

      memo (관리자 메모)

      • id (Key) — Long — 기본 키 — NOT NULL
      • target_id (Field) — Long
      • create_admin_id (Field3) — Long
      • type (Field6) — String
      • content (Field2) — String
      • createdAt (Field4) — LocalDateTime
      • updatedAt (Field5) — LocalDateTime

      policy (보험 약관)

      • id (Key) — Long — 기본 키 — NOT NULL
      • name (Field) — String
      • 개정시행일 (Field3) — LocalDate
      • 표시화면 (Field2) — String
      • is_use (Field9) — Boolean
      • 동의구분 (Field4) — String
      • content (Field5) — String
      • isImportant (Field6) — Boolean
      • createdAt (Field7) — LocalDateTime
      • updatedAt (Field8) — LocalDateTime

      policy_log (약관 개정 이력)

      • id (Key) — Long — 기본 키 — NOT NULL
      • policy_id (Field) — Long
      • writer_admin_id (Field2) — Long
      • updatedAt (Field3) — LocalDateTime
      • note (Field4) — String

      product (보험 상품)

      • id (Key) — Long — 기본 키 — NOT NULL
      • category_id (Field) — Long
      • level (Field2) — Integer
      • company_id (Field3) — Long
      • name (Field4) — String
      • 상품특징 (Field5) — String
      • type (Field6) — String
      • 고객정보입력폼? (Field8)
      • 준법감시필 (Field7) — String
      • 보장내용 (Field9) — String
      • 가입예시 (Field10) — String
      • 알아두실 사항 (Field11) — String
      • createdAt (Field12) — LocalDateTime
      • updatedAt (Field13) — LocalDateTime

      role (권한)

      • id (Key) — Long — 기본 키 — NOT NULL
      • name (Field) — String
      • note (Field2) — String
      • isUse (Field3) — Boolean
      • createdAt (Field4) — LocalDateTime
      • updatedAt (Field5) — LocalDateTime
      • created_admin_id (Field6) — Long
      • last_update_admin_id (Field7) — Long

      sms (Untitled3)

      • id (Key) — Long — 기본 키 — NOT NULL
      • sms_template_id (Field) — Long
      • 발송요청일시 (Field2) — LocalDateTime
      • 예약일시 (Field7) — LocalDateTime
      • type (Field3) — String
      • phone (Field4) — String
      • status (Field5) — String
      • 발송현황 (Field6) — String
      • Field8

      sms_template (문자 템플릿)

      • id (Key) — Long — 기본 키 — NOT NULL
      • name (Field) — String
      • status (Field2) — Boolean
      • type (Field5) — String
      • tilte (Field3) — String
      • content (Field4) — String
      • createdAt (Field6) — LocalDateTime
      • updatedAt (Field7) — LocalDateTime
      • created_admin_id (Field8) — Long
      • last_updated_admin_id (Field9) — Long

      변수명? (Untitled)

      • id (Key) — Long — 기본 키 — NOT NULL
      • sms_template_id (Field) — Long
      • name (Field2) — String