nerd-board-crm

Tables (16)

TB_CRM_CAMPAIGN (CRM 캠페인)

  • campaign_id (Key) — Primary key — NOT NULL
  • tenant_id (고객사 ID) — big int — Foreign key → TB_TENANT.tenant_id — NOT NULL

TB_CRM_CAMPAIGN_IMAGE (CRM 캠페인 이미지)

  • campaign_image_id (Key) — int — Primary key — NOT NULL
  • image_id (이미지 ID) — int — Foreign key → TB_CRM_IMAGE.image_id — NOT NULL
  • campaign_id (캠페인 ID) — Foreign key → TB_CRM_CAMPAIGN.campaign_id — NOT NULL

TB_CRM_CAMPAIGN_TARGET_FILTER_CONTENT (CRM 캠페인 타켓 필터 내용)

  • campaign_filter_content_id (Key) — int — Primary key — NOT NULL
  • campaign_id (캠페인 ID) — Foreign key → TB_CRM_CAMPAIGN.campaign_id — NOT NULL
  • filter_value_id (필터 값 ID) — int — Foreign key → TB_CRM_TARGET_FILTER_VALUE.filter_value_id — NOT NULL
  • filter_content_id (타겟 필터 내용 ID) — int — Foreign key → TB_CRM_TARGET_FILTER_CONTENT.filter_content_id — NOT NULL

TB_CRM_IMAGE (CRM 이미지)

  • image_id (Key) — int — Primary key — NOT NULL
  • image_url (이미지URL) — varchar(255)

TB_CRM_TARGET_FILTER_CATEGORY (CRM 타켓 필터 카테고리)

  • filter_category_id (Key) — int — Primary key — NOT NULL
  • category (필터 카테고리) — varchar(255)

TB_CRM_TARGET_FILTER_CHECK_BOX_VALUE (CRM 타겟 필터 체크박스 값)

  • filter_value_id (PK/FK) — int — Foreign key → TB_CRM_TARGET_FILTER_VALUE.filter_value_id — NOT NULL
  • filter_content_id (필터 컨텐츠 ID) — int

TB_CRM_TARGET_FILTER_CONTENT (CRM 타겟 필터 내용)

  • filter_content_id (Key) — int — Primary key — NOT NULL
  • filter_name_id (필터이름 ID) — int — Foreign key → TB_CRM_TARGET_FILTER_NAME.filter_name_id — NOT NULL
  • tenant_id (고객사 ID) — big int — Foreign key → TB_TENANT.tenant_id — NOT NULL
  • content (필터내용) — varchar(255)

TB_CRM_TARGET_FILTER_CONTENT_PRESET (CRM 타겟 필터 내용 프리셋)

  • filter_content_preset_id (Key) — Primary key — NOT NULL
  • filter_preset_id (필터 프리셋 ID) — int — Foreign key → TB_CRM_TARGET_FILTER_PRESET.filter_preset_id — NOT NULL
  • filter_value_id (필터 값 ID) — int — Foreign key → TB_CRM_TARGET_FILTER_VALUE.filter_value_id — NOT NULL
  • filter_content_id (필터 내용 ID) — int — Foreign key → TB_CRM_TARGET_FILTER_CONTENT.filter_content_id — NOT NULL

TB_CRM_TARGET_FILTER_NAME (CRM 타겟 필터 이름)

  • filter_name_id (Key) — int — Primary key — NOT NULL
  • filter_category_id (필터 카테고리 ID) — int — Foreign key → TB_CRM_TARGET_FILTER_CATEGORY.filter_category_id — NOT NULL
  • name (필터 이름) — varchar(255)
  • input_type (입력타입) — varchar(20)
  • filter_type (필터 타입) — varchar(20)

TB_CRM_TARGET_FILTER_NUMBER_VALUE (CRM 타겟 필터 숫자 값)

  • filter_value_id (PK/FK) — int — Foreign key → TB_CRM_TARGET_FILTER_VALUE.filter_value_id — NOT NULL
  • number_value (숫자 값) — int

TB_CRM_TARGET_FILTER_PRESET (CRM 타겟 필터 프리셋)

  • filter_preset_id (Key) — int — Primary key — NOT NULL
  • tenant_id (고객사) — int — Foreign key → TB_TENANT.tenant_id — NOT NULL
  • title (필터 프리셋 제목) — varchar(255)

TB_CRM_TARGET_FILTER_VALUE (CRM 타겟 필터 공통 값)

  • filter_value_id (Key) — int — Primary key — NOT NULL
  • value_type (값 타입) — varchar(20)

TB_TENANT (고객사)

  • tenant_id (Key) — int — Primary key — NOT NULL
  • koreanName (고객사 이름(한글)) — varchar(100)
  • englishName (고객사 이름(영어)) — varchar(100)
  • password (비밀번호) — varchar(255)
  • marketing_phone_number (CRM 발신 전화번호) — varchar(20)
  • business_category (사업 카테고리(한글)) — varchar(30)
  • email (이메일) — varchar(50)
  • role (계정 권한 역할) — varchar(20)

cafe24_daily (카페24 데일리 집계)

  • dt (날짜) — varchar(10) — Primary key — NOT NULL
  • tenant_id (고객사 ID) — int — Foreign key → TB_TENANT.tenant_id — NOT NULL

cafe24_daily_product (카페24 데일리 상품 집계)

  • dt (날짜) — varchar(10) — Primary key — NOT NULL
  • product_name (상품 이름) — varchar(200) — Primary key — NOT NULL
  • tenant_id (고객사 ID) — int — Foreign key → TB_TENANT.tenant_id — NOT NULL

ga_users (GA 유저 집계)

  • dt (날짜) — varchar(10) — Primary key — NOT NULL
  • tenant_id (고객사 ID) — int — Foreign key → TB_TENANT.tenant_id — NOT NULL