chatbot

Tables (4)

question_logs

  • id — BIGSERIAL
  • session_id — VARCHAR(255) — NOT NULL
  • user_id — BIGINT — 로그인한
  • ip_address — INET — 사용자
  • question — TEXT — NOT NULL — 사용자가
  • answer — TEXT — 챗봇이
  • response_time_ms — INTEGER — 답변
  • success — BOOLEAN — 답변
  • error_message — TEXT — 오류
  • user_agent — TEXT — 사용자
  • created_at — TIMESTAMP — 로그
  • updated_at — TIMESTAMP — 로그

recommended_keywords

  • id — SERIAL
  • keyword — VARCHAR(100) — NOT NULL
  • search_count — INT
  • display_order — INT
  • is_active — BOOLEAN
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP

recommended_questions

  • id — SERIAL
  • icon_category_id — INT
  • title — VARCHAR(200) — NOT NULL — 질문
  • description — TEXT — NOT NULL — 설명
  • question — TEXT — NOT NULL — 예시
  • search_count — INT — 실제
  • display_order — INT
  • is_active — BOOLEAN
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP

users

  • user_id — BIGSERIAL
  • username — VARCHAR(100) — NOT NULL
  • email — VARCHAR(255) — NOT NULL
  • password_hash — VARCHAR(255) — NOT NULL
  • password_salt — VARCHAR(255) — NOT NULL
  • password_reset_token — VARCHAR(255)
  • password_reset_expires — TIMESTAMP
  • user_type — user_type_enum — NOT NULL
  • permissions — JSONB
  • api_key — VARCHAR(255)
  • api_quota_daily — INTEGER
  • api_quota_used — INTEGER
  • organization_name — VARCHAR(255)
  • organization_type — organization_type_enum
  • business_number — VARCHAR(50)
  • organization_contact_email — VARCHAR(255)
  • organization_contact_phone — VARCHAR(50)
  • organization_address — TEXT
  • contract_start — DATE
  • contract_end — DATE
  • data_quota_gb — DECIMAL(10,2)
  • data_used_gb — DECIMAL(10,2)
  • registration_source — registration_source_enum
  • referrer_url — VARCHAR(500)
  • utm_source — VARCHAR(100)
  • utm_medium — VARCHAR(100)
  • utm_campaign — VARCHAR(100)
  • approval_status — approval_status_enum
  • approved_by — BIGINT
  • approved_at — TIMESTAMP
  • rejection_reason — TEXT
  • email_verified — BOOLEAN
  • email_verification_token — VARCHAR(255)
  • email_verified_at — TIMESTAMP
  • phone_number — VARCHAR(20)
  • phone_verified — BOOLEAN
  • two_factor_enabled — BOOLEAN
  • two_factor_secret — VARCHAR(255)
  • last_login — TIMESTAMP
  • login_attempts — INTEGER
  • locked_until — TIMESTAMP
  • is_active — BOOLEAN
  • deactivated_at — TIMESTAMP
  • deactivation_reason — TEXT
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP