콘팅

테이블 (28)

tbl_ai_trait_analysis_job

  • seq — BIGINT — 기본 키 — NOT NULL
  • user_seq — BIGINT — 외래 키 → tbl_user_account.seq — NOT NULL
  • room_seq — BIGINT
  • consent_seq — BIGINT — 외래 키 → tbl_user_consent.seq
  • message_range_type — VARCHAR(20) — NOT NULL
  • message_from_seq — BIGINT
  • message_to_seq — BIGINT
  • analyzed_message_count — INT — NOT NULL
  • model_version — VARCHAR(50)
  • prompt_version — VARCHAR(50)
  • status — VARCHAR(20) — NOT NULL
  • requested_at — DATETIME(6) — NOT NULL
  • started_at — DATETIME(6)
  • completed_at — DATETIME(6)
  • error_code — VARCHAR(50)
  • error_message — VARCHAR(255)
  • created_at — DATETIME(6) — NOT NULL
  • updated_at — DATETIME(6) — NOT NULL

tbl_ai_trait_candidate

  • seq — BIGINT — 기본 키 — NOT NULL
  • job_seq — BIGINT — 외래 키 → tbl_ai_trait_analysis_job.seq — NOT NULL
  • user_seq — BIGINT — 외래 키 → tbl_user_account.seq — NOT NULL
  • trait_group — VARCHAR(30) — NOT NULL
  • trait_code — VARCHAR(50) — NOT NULL
  • confidence_score — DECIMAL(5,4) — NOT NULL
  • evidence_summary — VARCHAR(500)
  • activation_status — VARCHAR(20) — NOT NULL
  • activated_at — DATETIME(6)
  • rejected_reason — VARCHAR(255)
  • created_at — DATETIME(6) — NOT NULL
  • updated_at — DATETIME(6) — NOT NULL

tbl_audit_log

  • seq — BIGINT — 기본 키 — NOT NULL
  • actor_user_seq — BIGINT — 외래 키 → tbl_user_account.seq
  • action — VARCHAR(50) — NOT NULL
  • target_type — VARCHAR(50)
  • target_key — VARCHAR(100)
  • meta — JSON
  • ip_address — VARCHAR(45)
  • created_at — DATETIME(6) — NOT NULL

tbl_chat_request

  • seq — BIGINT — 기본 키 — NOT NULL
  • requester_seq — BIGINT — 외래 키 → tbl_user_account.seq — NOT NULL
  • target_seq — BIGINT — 외래 키 → tbl_user_account.seq — NOT NULL
  • status — VARCHAR(20) — NOT NULL
  • reject_days — INT
  • rejected_until — DATETIME(6)
  • coin_amount — INT — NOT NULL
  • responded_at — DATETIME(6)
  • created_at — DATETIME(6) — NOT NULL
  • updated_at — DATETIME(6) — NOT NULL

tbl_chat_room

  • seq — BIGINT — 기본 키 — NOT NULL
  • room_type — VARCHAR(10) — NOT NULL
  • room_name — VARCHAR(100)
  • status — VARCHAR(20) — NOT NULL
  • created_by_seq — BIGINT — NOT NULL
  • request_seq — BIGINT
  • user_a_seq — BIGINT
  • user_b_seq — BIGINT
  • closed_at — DATETIME(6)
  • created_at — DATETIME(6) — NOT NULL
  • updated_at — DATETIME(6) — NOT NULL

tbl_chat_room_member

  • seq — BIGINT — 기본 키 — NOT NULL
  • room_seq — BIGINT — 외래 키 → tbl_chat_room.seq — NOT NULL
  • member_seq — BIGINT — NOT NULL
  • member_role — VARCHAR(10) — NOT NULL
  • joined_at — DATETIME(6) — NOT NULL
  • left_at — DATETIME(6)
  • created_at — DATETIME(6) — NOT NULL
  • updated_at — DATETIME(6) — NOT NULL

tbl_coin_ledger

  • seq — BIGINT — 기본 키 — NOT NULL
  • user_seq — BIGINT — 외래 키 → tbl_user_account.seq — NOT NULL
  • txn_type — VARCHAR(20) — NOT NULL
  • amount — INT — NOT NULL
  • balance_after — INT — NOT NULL
  • reason_code — VARCHAR(30)
  • ref_table — VARCHAR(50)
  • ref_id — BIGINT
  • created_at — DATETIME(6) — NOT NULL

tbl_device_session

  • seq — BIGINT — 기본 키 — NOT NULL
  • member_seq — BIGINT — 외래 키 → tbl_user_account.seq — NOT NULL
  • device_id — VARCHAR(128) — NOT NULL
  • platform — CHAR(1)
  • push_token — VARCHAR(512)
  • refresh_token — VARCHAR(512) — NOT NULL
  • is_active — TINYINT(1) — NOT NULL
  • last_seen_at — DATETIME(6)
  • created_at — DATETIME(6) — NOT NULL
  • updated_at — DATETIME(6) — NOT NULL

tbl_ideal_type_profile

  • user_seq — BIGINT — 외래 키 → tbl_user_account.seq — NOT NULL
  • preferred_age_min — INT
  • preferred_age_max — INT
  • preferred_height_min_cm — INT
  • preferred_height_max_cm — INT
  • preferred_religion_code — VARCHAR(30)
  • preferred_relationship_status — VARCHAR(30)
  • created_at — DATETIME(6) — NOT NULL
  • updated_at — DATETIME(6) — NOT NULL

tbl_ideal_type_trait

  • seq — BIGINT — 기본 키 — NOT NULL
  • user_seq — BIGINT — 외래 키 → tbl_user_account.seq — NOT NULL
  • trait_group — VARCHAR(30) — NOT NULL
  • trait_code — VARCHAR(50) — NOT NULL
  • preference_type — VARCHAR(20) — NOT NULL
  • source_type — VARCHAR(20) — NOT NULL
  • score — DECIMAL(5,2)
  • created_at — DATETIME(6) — NOT NULL
  • updated_at — DATETIME(6) — NOT NULL

tbl_match_card

  • seq — BIGINT — 기본 키 — NOT NULL
  • owner_user_seq — BIGINT — 외래 키 → tbl_user_account.seq — NOT NULL
  • target_user_seq — BIGINT — 외래 키 → tbl_user_account.seq — NOT NULL
  • card_type — VARCHAR(20) — NOT NULL
  • issued_date — DATE — NOT NULL
  • opened_at — DATETIME(6)
  • is_selected — TINYINT(1) — NOT NULL
  • selected_at — DATETIME(6)
  • created_at — DATETIME(6) — NOT NULL
  • updated_at — DATETIME(6) — NOT NULL

tbl_member_report

  • seq — BIGINT — 기본 키 — NOT NULL
  • reporter_seq — BIGINT — NOT NULL
  • reported_member_seq — BIGINT — NOT NULL
  • reason_code — VARCHAR(20) — NOT NULL
  • detail — TEXT
  • status — VARCHAR(20) — NOT NULL
  • handler_seq — BIGINT
  • handled_at — DATETIME(6)
  • created_at — DATETIME(6) — NOT NULL
  • updated_at — DATETIME(6) — NOT NULL

tbl_message

  • seq — BIGINT — 기본 키 — NOT NULL
  • room_seq — BIGINT — 외래 키 → tbl_chat_room.seq — NOT NULL
  • sender_seq — BIGINT — NOT NULL
  • message_type — VARCHAR(20) — NOT NULL
  • content — TEXT
  • is_deleted — TINYINT(1) — NOT NULL
  • is_edited — TINYINT(1) — NOT NULL
  • ai_flag — VARCHAR(20) — NOT NULL
  • gift_order_seq — BIGINT
  • deleted_at — DATETIME(6)
  • edited_at — DATETIME(6)
  • created_at — DATETIME(6) — NOT NULL
  • updated_at — DATETIME(6) — NOT NULL

tbl_message_hidden

  • seq — BIGINT — 기본 키 — NOT NULL
  • message_seq — BIGINT — 외래 키 → tbl_message.seq — NOT NULL
  • member_seq — BIGINT — NOT NULL
  • hidden_at — DATETIME(6) — NOT NULL

tbl_message_report

  • seq — BIGINT — 기본 키 — NOT NULL
  • reporter_seq — BIGINT — NOT NULL
  • message_seq — BIGINT — 외래 키 → tbl_message.seq — NOT NULL
  • room_seq — BIGINT — NOT NULL
  • sender_seq — BIGINT — NOT NULL
  • message_snapshot — TEXT — NOT NULL
  • reason_code — VARCHAR(20) — NOT NULL
  • detail — TEXT
  • status — VARCHAR(20) — NOT NULL
  • handler_seq — BIGINT
  • handled_at — DATETIME(6)
  • created_at — DATETIME(6) — NOT NULL
  • updated_at — DATETIME(6) — NOT NULL

tbl_profile_trait_response

  • seq — BIGINT — 기본 키 — NOT NULL
  • user_seq — BIGINT — 외래 키 → tbl_user_account.seq — NOT NULL
  • trait_group — VARCHAR(30) — NOT NULL
  • trait_code — VARCHAR(50) — NOT NULL
  • source_type — VARCHAR(20) — NOT NULL
  • score — DECIMAL(5,2)
  • created_at — DATETIME(6) — NOT NULL
  • updated_at — DATETIME(6) — NOT NULL

tbl_report_case

  • seq — BIGINT — 기본 키 — NOT NULL
  • reporter_seq — BIGINT — NOT NULL
  • target_user_seq — BIGINT — NOT NULL
  • report_type — VARCHAR(20) — NOT NULL
  • detail — VARCHAR(1000)
  • status — VARCHAR(20) — NOT NULL
  • source_table — VARCHAR(50)
  • source_seq — BIGINT
  • handler_seq — BIGINT
  • action_type — VARCHAR(30)
  • action_reason — VARCHAR(1000)
  • actioned_at — DATETIME(6)
  • created_at — DATETIME(6) — NOT NULL
  • updated_at — DATETIME(6) — NOT NULL

tbl_store_item

  • seq — BIGINT — 기본 키 — NOT NULL
  • item_type — VARCHAR(20) — NOT NULL
  • category — VARCHAR(30)
  • name — VARCHAR(100) — NOT NULL
  • brand — VARCHAR(100)
  • price_coin — INT — NOT NULL
  • list_price — INT
  • stock_qty — INT — NOT NULL
  • icon_type — VARCHAR(30)
  • description — VARCHAR(500)
  • is_active — TINYINT(1) — NOT NULL
  • created_at — DATETIME(6) — NOT NULL
  • updated_at — DATETIME(6) — NOT NULL

tbl_store_order

  • seq — BIGINT — 기본 키 — NOT NULL
  • user_seq — BIGINT — 외래 키 → tbl_user_account.seq — NOT NULL
  • store_item_seq — BIGINT — 외래 키 → tbl_store_item.seq — NOT NULL
  • order_status — VARCHAR(20) — NOT NULL
  • deducted_coin — INT — NOT NULL
  • coupon_code — VARCHAR(100)
  • shipping_name — VARCHAR(50)
  • shipping_phone — VARCHAR(30)
  • shipping_address — VARCHAR(255)
  • gift_receiver_seq — BIGINT — 외래 키 → tbl_user_account.seq
  • gift_message — VARCHAR(500)
  • created_at — DATETIME(6) — NOT NULL
  • updated_at — DATETIME(6) — NOT NULL

tbl_trait_definition

  • seq — BIGINT — 기본 키 — NOT NULL
  • trait_group — VARCHAR(30) — NOT NULL
  • trait_code — VARCHAR(50) — NOT NULL
  • display_name — VARCHAR(100) — NOT NULL
  • description — VARCHAR(500)
  • version — VARCHAR(20) — NOT NULL
  • sort_order — INT — NOT NULL
  • is_active — TINYINT(1) — NOT NULL
  • kr_name — VARCHAR(100)
  • en_name — VARCHAR(100)
  • jp_name — VARCHAR(100)
  • zh_name — VARCHAR(100)
  • kr_description — VARCHAR(500)
  • en_description — VARCHAR(500)
  • jp_description — VARCHAR(500)
  • zh_description — VARCHAR(500)
  • created_at — DATETIME(6) — NOT NULL
  • updated_at — DATETIME(6) — NOT NULL

tbl_trait_group_label

  • seq — BIGINT — 기본 키 — NOT NULL
  • trait_group — VARCHAR(30) — NOT NULL
  • locale — VARCHAR(10) — NOT NULL
  • display_name — VARCHAR(100) — NOT NULL
  • short_label — VARCHAR(50)
  • onboarding_label — VARCHAR(100)
  • description — VARCHAR(500)
  • admin_memo — VARCHAR(500)
  • created_at — DATETIME(6) — NOT NULL
  • updated_at — DATETIME(6) — NOT NULL

tbl_user_account

  • seq — BIGINT — 기본 키 — NOT NULL
  • phone_hash — VARCHAR(128) — NOT NULL
  • phone_enc — VARCHAR(512) — NOT NULL
  • nickname — VARCHAR(30)
  • gender — CHAR(1)
  • birth_date — DATE
  • region_code — VARCHAR(10)
  • profile_image_url — VARCHAR(512)
  • login_type — VARCHAR(20)
  • email — VARCHAR(255)
  • password_hash — VARCHAR(255)
  • grade_code — VARCHAR(10)
  • member_status — VARCHAR(20) — NOT NULL
  • member_role — VARCHAR(20) — NOT NULL
  • withdrawn_at — DATETIME(6)
  • last_active_at — DATETIME(6)
  • created_at — DATETIME(6) — NOT NULL
  • updated_at — DATETIME(6) — NOT NULL

tbl_user_consent

  • seq — BIGINT — 기본 키 — NOT NULL
  • user_seq — BIGINT — 외래 키 → tbl_user_account.seq — NOT NULL
  • consent_type — VARCHAR(30) — NOT NULL
  • consent_version — VARCHAR(20) — NOT NULL
  • agreed — TINYINT(1) — NOT NULL
  • agreed_at — DATETIME(6) — NOT NULL
  • revoked_at — DATETIME(6)
  • created_at — DATETIME(6) — NOT NULL
  • updated_at — DATETIME(6) — NOT NULL

tbl_user_profile

  • user_seq — BIGINT — 외래 키 → tbl_user_account.seq — NOT NULL
  • region_sido — VARCHAR(50)
  • region_sigungu — VARCHAR(50)
  • region_dong — VARCHAR(50)
  • profile_intro — VARCHAR(500)
  • meeting_speed_code — VARCHAR(20)
  • visibility_level — VARCHAR(20)
  • job — VARCHAR(100)
  • education — VARCHAR(100)
  • height_cm — INT
  • relationship_status — VARCHAR(30)
  • purpose_code — VARCHAR(30)
  • religion_code — VARCHAR(30)
  • created_at — DATETIME(6) — NOT NULL
  • updated_at — DATETIME(6) — NOT NULL

tbl_user_profile_photo

  • seq — BIGINT — 기본 키 — NOT NULL
  • user_seq — BIGINT — 외래 키 → tbl_user_account.seq — NOT NULL
  • image_url — VARCHAR(500) — NOT NULL
  • sort_order — INT — NOT NULL
  • is_main — TINYINT(1) — NOT NULL
  • review_status — VARCHAR(20) — NOT NULL
  • created_at — DATETIME(6) — NOT NULL
  • updated_at — DATETIME(6) — NOT NULL

tbl_video_call_active_participant

  • user_seq — BIGINT — 기본 키 — NOT NULL
  • request_seq — BIGINT — 외래 키 → tbl_video_call_request.seq — NOT NULL
  • session_seq — BIGINT — 외래 키 → tbl_video_call_session.seq
  • joined_at — DATETIME(6) — NOT NULL

tbl_video_call_request

  • seq — BIGINT — 기본 키 — NOT NULL
  • room_seq — BIGINT — 외래 키 → tbl_chat_room.seq — NOT NULL
  • caller_seq — BIGINT — NOT NULL
  • receiver_seq — BIGINT — NOT NULL
  • client_request_id — VARCHAR(36) — NOT NULL
  • status — VARCHAR(20) — NOT NULL
  • settlement_status — VARCHAR(20) — NOT NULL
  • coin_hold_amount — INT — NOT NULL
  • hold_ledger_seq — BIGINT
  • capture_ledger_seq — BIGINT
  • release_ledger_seq — BIGINT
  • requested_at — DATETIME(6) — NOT NULL
  • responded_at — DATETIME(6)
  • timeout_at — DATETIME(6) — NOT NULL
  • created_at — DATETIME(6) — NOT NULL
  • updated_at — DATETIME(6) — NOT NULL

tbl_video_call_session

  • seq — BIGINT — 기본 키 — NOT NULL
  • call_request_seq — BIGINT — 외래 키 → tbl_video_call_request.seq — NOT NULL
  • status — VARCHAR(20) — NOT NULL
  • started_at — DATETIME(6)
  • ended_at — DATETIME(6)
  • duration_sec — INT — NOT NULL
  • current_connected_started_at — DATETIME(6)
  • interrupted_at — DATETIME(6)
  • reconnect_deadline_at — DATETIME(6)
  • caller_connected — TINYINT(1) — NOT NULL
  • receiver_connected — TINYINT(1) — NOT NULL
  • caller_last_heartbeat_at — DATETIME(6)
  • receiver_last_heartbeat_at — DATETIME(6)
  • end_reason — VARCHAR(30)
  • settlement_status — VARCHAR(20) — NOT NULL
  • refund_coin — INT — NOT NULL
  • final_charge — INT — NOT NULL
  • capture_ledger_seq — BIGINT
  • release_ledger_seq — BIGINT
  • last_disconnected_side — VARCHAR(10)
  • quality_score — DECIMAL(5,2)
  • call_session_token — VARCHAR(255)
  • created_at — DATETIME(6) — NOT NULL
  • updated_at — DATETIME(6) — NOT NULL