chat

Tables (50)

chat_template_buttons (채팅템플릿버튼)

  • consultation_end_message_button_id (ID) — Primary key — NOT NULL
  • button_name (버튼명)
  • button_link (링크)
  • chat_template_id (채팅템플릿ID) — Foreign key → chat_templates.chat_template_id — NOT NULL

alimtalk_message_queue (알림톡 발송 큐 테이블)

  • id — BIGINT — Primary key — NOT NULL
  • priority (우선순위) — BIGINT — NOT NULL — 알림톡 발송 우선순위 (낮을수록 먼저 발송)
  • template_code (템플릿 코드) — VARCHAR(255) — NOT NULL — 알림톡 템플릿 코드
  • is_sent (발송 여부 (true: 발송됨, false: 미발송)) — TINYINT — NOT NULL — 발송 여부 (true: 발송됨, false: 미발송)
  • message (발송할 알림톡 메시지 내용) — TEXT — NOT NULL — 발송할 알림톡 메시지 내용
  • member_id (알림 대상 회원 ID) — BIGINT — NOT NULL — 알림 대상 회원 ID
  • is_last_recipient (마지막 발송 대상 여부 (true 시 반복 발송 방지)) — TINYINT — 마지막 발송 대상 여부 (true 시 반복 발송 방지)
  • created_at (생성일) — DATETIME(6) — NOT NULL — 레코드 생성 시각
  • updated_at (수정일) — DATETIME(6) — NOT NULL — 레코드 수정 시각
  • alimtalk_message_setting_id (alimtalk_message_setting 테이블의 ID) — BIGINT — Foreign key → alimtalk_message_setting.id — NOT NULL

alimtalk_message_setting (정기 발송 알림톡 스케줄 정보)

  • id — BIGINT — Primary key — NOT NULL
  • template_code (템플릿 코드) — VARCHAR(100) — NOT NULL — 알림톡 템플릿 코드
  • send_date (발송되어야할 일자) — DATETIME(6) — NOT NULL — 알림톡 발송 예정 날짜
  • is_completed (발송 완료 여부) — TINYINT — NOT NULL — 알림톡 발송 여부
  • created_at (생성일) — DATETIME(6) — NOT NULL
  • send_condition_id (조건 ID) — BIGINT — NOT NULL
  • completed_at (발송 완료 일자) — DATETIME(6) — 알림톡 발송 완료 날짜
  • next_recipient_id (다음 alimtalk_recipient 테이블의 id) — BIGINT

alimtalk_recipient (정기 발송 대상자 테이블)

  • id — BIGINT — Primary key — NOT NULL
  • member_id (알림 대상 회원 ID) — BIGINT — 알림톡 보낸 고객 아이디
  • created_at (생성일) — DATETIME(6) — NOT NULL
  • setting_id (alimtalk_message_setting 테이블의 ID) — BIGINT — Foreign key → alimtalk_message_setting.id — NOT NULL

auto_chat_busy_messages (자동채팅busy메시지)

  • auto_chat_message_id (자동채팅메시지ID) — Primary key — NOT NULL
  • message (메시지)
  • is_on (켜짐여부)
  • created_at (생성일)
  • by_planner_id (플래너 ID)

auto_chat_greeging_messages (자동채팅인사메시지)

  • auto_chat_message_id (자동채팅메시지ID) — Primary key — NOT NULL
  • message (메시지)
  • is_on (켜짐여부)
  • created_at (생성일)
  • by_planner_id (플래너 ID)

auto_chat_non_working_hour_messages (자동채팅근무시간외메시지)

  • auto_chat_message_id (자동채팅메시지ID) — Primary key — NOT NULL
  • message (메시지)
  • is_on (켜짐여부)
  • created_at (생성일)
  • by_planner_id (플래너 ID)

ban_words (금지어)

  • ban_word_id (금지어ID) — Primary key — NOT NULL
  • created_at (생성일)
  • ban_word (금지어)
  • by_planner_id (플래너 ID)

chat_activities (채팅 활성화)

  • log_chat_activate_id (채팅활성화로그ID) — Primary key — NOT NULL
  • by_planner_id (요청한어드민플래너ID)
  • is_active (켰는지여부)
  • created_at (생성 날짜)

chat_auto_assignments (채팅 자동배정설정)

  • log_auto_assignment_id (채팅활성화로그ID) — Primary key — NOT NULL
  • by_planner_id (자동 배정한 어드민플래너ID)
  • created_at (생성 날짜)
  • is_auto_assigned (자동배정여부)

chat_bot_block (챗봇 블럭 ID)

  • chat_bot_block_id (챗봇 블럭 ID) — Primary key — NOT NULL
  • sub_chat_bot_block_id (서브 챗봇 블럭 ID) — Foreign key → chat_bot_block.chat_bot_block_id — NOT NULL
  • chat_bot_scenario_id (챗봇 시나리오 ID) — Foreign key → chat_bot_scenario.chat_bot_scenario_id — NOT NULL
  • block_title (블럭 이름)
  • message (블럭 내용)
  • by_planner_id (플래너ID)
  • created_at (생성일)
  • updated_at (수정일)
  • row (행 위치)
  • col (열 위치)
  • block_type (블럭타입)
  • is_start_block (시작 블록 여부)

chat_bot_block_button (챗봇 버튼)

  • chat_bot_button_id (챗봇 버튼 ID) — Primary key — NOT NULL
  • chat_bot_block_id (소유된 챗봇 블럭 ID) — Foreign key → chat_bot_block.chat_bot_block_id — NOT NULL
  • button_name (버튼 이름)
  • linked_chat_resource_id (연결된 챗봇 자원 ID)
  • button_type (버튼 타입)

chat_bot_block_image (챗봇 이미지)

  • chat_bot_image_id (챗봇 이미지 ID) — Primary key — NOT NULL
  • chat_bot_block_id (챗봇 메시지 ID) — Foreign key → chat_bot_block.chat_bot_block_id — NOT NULL
  • chat_bot_image_url (챗봇 이미지 url)

chat_bot_history (챗봇 히스토리)

  • chat_bot_history_id (챗봇 히스토리 ID) — Primary key — NOT NULL
  • chat_room_id (room ID) — Foreign key → chat_rooms.chat_room_id — NOT NULL
  • chat_bot_scenario_id (챗봇 시나리오 ID) — Foreign key → chat_bot_scenario.chat_bot_scenario_id — NOT NULL
  • created_at (챗봇 생성일)

chat_bot_scenario (챗봇 시나리오)

  • chat_bot_scenario_id (챗봇 시나리오 ID) — Primary key — NOT NULL
  • start_chat_bot_scenario_id (부모 챗봇 시나리오 ID) — Foreign key → chat_bot_scenario.chat_bot_scenario_id — NOT NULL
  • scenario_name (시나리오 이름)
  • description (설명)
  • by_planner_id (플래너ID)
  • created_at (생성일)
  • updated_at (수정일)
  • deleted_at (삭제일)
  • order (정렬 순서)

chat_bot_scenario_activation_setting (챗봇 시나리오 세팅)

  • chat_bot_scenario_setting_id (챗봇 세팅 ID) — Primary key — NOT NULL
  • chat_bot_scenario_id (챗봇 시나리오 ID) — Foreign key → chat_bot_scenario.chat_bot_scenario_id — NOT NULL
  • is_enabled (활성화 여부)
  • by_planner_id (플래너 ID)
  • created_at (생성일)

chat_bot_scenario_deployment_history (챗봇 시나리오 배포 히스토리)

  • chat_bot_scenario_deployment_history_id (챗봇 세팅 ID) — Primary key — NOT NULL
  • chat_bot_scenario_id (챗봇 시나리오 ID) — Foreign key → chat_bot_scenario.chat_bot_scenario_id — NOT NULL
  • by_planner_id (플래너 ID)
  • created_at (배포일자)
  • version (배포버전)

chat_button (채팅 버튼)

  • chat_button_id (채팅 버튼 ID) — Primary key — NOT NULL
  • chat_message_id (채팅메시지 ID) — Foreign key → chat_messages.chat_message_id — NOT NULL
  • button_name (채팅 버튼 이름)
  • button_link (채팅 버튼 url)

chat_files (채팅 파일)

  • chat_file_id (채팅파일ID) — Primary key — NOT NULL
  • file_url (파일 url)
  • file_name (파일 이름)
  • chat_message_id (채팅메시지 ID) — Foreign key → chat_messages.chat_message_id — NOT NULL

chat_images (채팅 이미지)

  • chat_image_id (채팅이미지ID) — Primary key — NOT NULL
  • file_url (파일 url)
  • chat_message_id (채팅메시지 ID) — Foreign key → chat_messages.chat_message_id — NOT NULL

chat_member_tags (채팅고객태그)

  • chat_planner_member_id (채팅고객태그ID) — Primary key — NOT NULL
  • tag_name (태그명)
  • planner_id (플래너ID) — Foreign key → planner.planner_id — NOT NULL
  • kakao_bomapp_member_id (카카오보맵매핑ID) — Foreign key → kakao_bomapp_members.kakao_bomapp_member_id — NOT NULL

chat_memo (채팅메모)

  • chat_memo_id (채팅메모ID) — Primary key — NOT NULL
  • type (메모 타입)
  • chat_room_id (room ID) — Foreign key → chat_rooms.chat_room_id — NOT NULL
  • created_at (생성일)
  • updated_at (수정일)

chat_message_result (Untitled)

  • chat_message_result_id (ID) — Primary key — NOT NULL
  • chat_message_id (채팅메시ID) — Foreign key → chat_messages.chat_message_id — NOT NULL
  • request_type (Field)
  • serial_number (Field2)
  • code (Field3)
  • error_message (Field4)
  • image (Field5)
  • file (Field6)
  • file_name (Field7)
  • file_size (Field8)

chat_messages (채팅메시지)

  • chat_message_id (채팅메시지 ID) — Primary key — NOT NULL
  • message (메시지)
  • read_or_not (읽음여부)
  • owner_type (해당 메시지 주인) — enum
  • chat_room_id (room ID) — Foreign key → chat_rooms.chat_room_id — NOT NULL
  • created_at (생성일)
  • message_type (메시지 타입)
  • send_result_type (메시지 전송 성공 여부)

chat_planner_auto_changes (플래너 변경 자동 설정)

  • chat_planner_auto_change_id (ID) — Primary key — NOT NULL
  • by_planner_id (요청한어드민플래너ID)
  • is_auto (자동변경여부)
  • created_at (생성 날짜)

chat_planner_change_submissions (플래너 변경 요청)

  • chat_planner_change_request_id (id) — Primary key — NOT NULL
  • from_planner_id (기존 플래너 ID)
  • to_planner_id (변경 플래너 ID)
  • created_at (생성날짜)
  • approve_at (승인날짜)
  • approve_planner_id (승인한 플래너 ID)
  • reason (사유)
  • chat_room_id (room ID) — Foreign key → chat_rooms.chat_room_id — NOT NULL

chat_room_tag_maps (채팅방태그메핑테이블)

  • chat_room_tag_mapping_id (채팅방태그매핑iD) — Primary key — NOT NULL
  • chat_room_id (room ID) — Foreign key → chat_rooms.chat_room_id — NOT NULL
  • chat_room_tag_id (채팅방태그ID) — Foreign key → chat_room_tags.chat_room_tag_id — NOT NULL
  • created_at (생성일)

chat_room_tags (채팅방태그)

  • chat_room_tag_id (채팅방태그ID) — Primary key — NOT NULL
  • name (태그이름)
  • created_at (생성일)

chat_rooms (채팅방)

  • chat_room_id (room ID) — Primary key — NOT NULL
  • kakao_session_id (세션 ID)
  • consultation_id (상담ID) — Foreign key → w_consultation.id — NOT NULL
  • finished_at (종료일)
  • created_at (생성일)
  • status (채팅상태)

chat_status (채팅 상태)

  • id — Primary key — NOT NULL
  • status (상태) — 접수, 상담사에 의한 종료, 플래너에 의한 종료, 플래너 변경 요청, 챗봇, 진행
  • created_at (생성일)
  • chat_room_id (room ID) — Foreign key → chat_rooms.chat_room_id — NOT NULL

chat_template_categories (템플릿 카테고리)

  • template_category_id (ID) — Primary key — NOT NULL
  • category_name (카테고리명)
  • created_at (생성날짜)
  • updated_at (수정날짜)
  • by_planner_id (플래너 ID)
  • deleted_at (삭제 날짜)

chat_template_image (채팅템플릿이미지)

  • chat_template_image_id (채팅템플릿이미지ID) — Primary key — NOT NULL
  • image_rul (이미지 url)
  • chat_template_id (ID2) — Foreign key → chat_templates.chat_template_id — NOT NULL
  • created_at (생성일)

chat_templates (채팅템플릿)

  • chat_template_id (ID) — Primary key — NOT NULL
  • created_at (생성날짜)
  • updated_at (수정날짜)
  • deleted_at (삭제날짜)
  • question (질문)
  • answer (답변)
  • is_favorite (즐겨찾기)
  • template_category_id (카테고리 ID) — Foreign key → chat_template_categories.template_category_id — NOT NULL
  • planner_id (플래너ID) — Foreign key → planner.planner_id — NOT NULL
  • planner_admin_id (플래너 어드민 ID) — Foreign key → planner.planner_id — NOT NULL

chat_work_hour (CopyOf근무시간)

  • chat_work_hour_id (ID) — Primary key — NOT NULL
  • by_planner_id (요청한어드민플래너ID)
  • created_at (업데이트 날짜)

chat_work_hour_settins (근무시간)

  • chat_work_hour_setting_id (ID) — Primary key — NOT NULL
  • chat_work_hour_id (ID2) — Foreign key → chat_work_hour.chat_work_hour_id — NOT NULL
  • work_week_type (근무일_타입) — enum
  • time_type (시간_타입) — enum
  • time (시간) — datatime
  • created_at (생성일자) — datetime

consultation_end_message_buttons (상담종료안내메시지버튼)

  • consultation_end_message_button_id (ID) — Primary key — NOT NULL
  • created_at (생성날짜)
  • button_name (버튼명)
  • button_link (링크)
  • consultation_end_message_id (ID2) — Foreign key → consultation_end_messages.consultation_end_message_id — NOT NULL

consultation_end_messages (상담종료안내메시지)

  • consultation_end_message_id (ID) — Primary key — NOT NULL
  • by_planner_id (요청한어드민플래너ID)
  • created_at (생성날짜)
  • is_active (켰는지여부)
  • message (메시지)

deployed_chat_bot_block (배포된 챗봇 블럭 ID)

  • deployed_chat_bot_block_id (챗봇 블럭 ID) — Primary key — NOT NULL
  • deployed_sub_chat_bot_block_id (챗봇 서브 블럭 ID) — Foreign key → deployed_chat_bot_block.deployed_chat_bot_block_id — NOT NULL
  • deployed_chat_bot_scenario_id (챗봇 시나리오 ID) — Foreign key → deployed_chat_bot_scenario.deployed_chat_bot_scenario_id — NOT NULL
  • block_name (블럭 이름)
  • message (블럭 내용)
  • by_planner_id (플래너ID)
  • created_at (생성일)
  • updated_at (수정일)
  • row (행 위치)
  • col (열 위치)
  • block_type (WIDE, TEXT)
  • is_start_block (시작 블럭 여부)

deployed_chat_bot_block_button (배포된챗봇 버튼)

  • chat_bot_button_id (챗봇 버튼 ID) — Primary key — NOT NULL
  • deployed_chat_bot_block_id (챗봇 블럭 ID) — Foreign key → deployed_chat_bot_block.deployed_chat_bot_block_id — NOT NULL
  • button_name (버튼 이름)
  • linked_deployed_chat_bot_id (연결된 챗봇 자원 ID)
  • button_type (버튼 타입)

deployed_chat_bot_block_image (CopyOf챗봇 이미지)

  • chat_bot_image_id (챗봇 이미지 ID) — Primary key — NOT NULL
  • deployed_chat_bot_block_id (챗봇 블럭 ID) — Foreign key → deployed_chat_bot_block.deployed_chat_bot_block_id — NOT NULL
  • chat_bot_image_url (챗봇 이미지 url)

deployed_chat_bot_scenario (배포된 챗봇 시나리오)

  • deployed_chat_bot_scenario_id (배포 챗봇 시나리오 ID) — Primary key — NOT NULL
  • start_chat_bot_scenario_id (시작 챗봇 시나리오 ID) — Foreign key → deployed_chat_bot_scenario.deployed_chat_bot_scenario_id — NOT NULL
  • chat_bot_scenario_deployment_history_id (챗봇 세팅 ID) — Foreign key → chat_bot_scenario_deployment_history.chat_bot_scenario_deployment_history_id — NOT NULL
  • scenario_name (시나리오 이름)
  • description (설명)
  • by_planner_id (플래너ID)
  • created_at (생성일)
  • updated_at (수정일)
  • deleted_at (삭제일)

insurance_disclosure_data (알릴의무 정보)

  • id (아이디) — Primary key — NOT NULL
  • kakao_id (카카오 아이디)
  • planner_member_id (플래너멤버 아이디)
  • created_at (생성일)
  • type (타입) — 1차 일반보험 2차 일반보험, 치아보험 1차, 치아보험 2차, 펫보험, 운전자보험, 주택화재 보험, 카드정보, 계좌정보
  • insurance_disclosure_version_id (버전 아이디)

insurance_disclosure_data_history (알릴의무 히스토리)

  • id (아이디) — Primary key — NOT NULL
  • insurance_disclosure_data_id (알릴의무 추가정보 아이디)
  • planner_member_id (플래너멤버 아이디)
  • status (상태)
  • created_at (생성일)

insurance_disclosure_data_result (알릴 의무 결과)

  • id (아이디) — Primary key — NOT NULL
  • question number (항목)
  • answer (답변)
  • insurance_disclosure_data_id (알릴의무 ID)
  • created_at (생성일)
  • updated_at (수정일)

insurance_disclosure_data_token (알릴 의무 토큰)

  • id (아이디) — Primary key — NOT NULL
  • auth_token (토큰)
  • use_type (사용목적)
  • created_at (생성일)
  • insurance_disclosure_data_id (고객추가정보 아이디)

insurance_disclosure_data_version (알릴 의무 버전)

  • id (아이디) — Primary key — NOT NULL
  • type (타입)
  • version (버전)
  • created_at (생성일)

kakao_bomapp_members (카카오 유저 매핑 정보)

  • kakao_bomapp_member_id (카카오보맵매핑ID) — Primary key — NOT NULL
  • kakao_user_key (카카오 유저 ID)
  • member_id (고객 ID)
  • created_at (생성일)
  • deleted_at (탈퇴일)

planner (플래너)

  • planner_id (플래너ID) — Primary key — NOT NULL

w_consultation (상담)

  • id (상담ID) — Primary key — NOT NULL
  • planner_member_id (Key2) — Foreign key → w_planner_member.id — NOT NULL
  • chat_status (채팅상태)
  • status (상담상태)

w_planner_member (플래너멤버)

  • id (Key) — Primary key — NOT NULL