콘팅
테이블 (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