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