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