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