aa
Tables (23)
agent_logs
- log_id — BIGSERIAL
- agent_name — VARCHAR(100) — NOT NULL
- agent_version — VARCHAR(50)
- question — TEXT — NOT NULL
- answer — TEXT
- agent_response_time — INTEGER
- tokens_used — INTEGER
- model_name — VARCHAR(100)
- temperature — DECIMAL(3,2)
- success — BOOLEAN
- error_message — TEXT
- error_code — VARCHAR(50)
- context_data — JSONB
- conversation_id — VARCHAR(255)
- ip_address — INET
- user_agent — TEXT
- created_at — TIMESTAMP
blog_attachments
- id — SERIAL
- post_id — INTEGER — NOT NULL
- file_name — VARCHAR(500)
- file_size — VARCHAR(100)
- file_url — VARCHAR(1000)
- created_at — TIMESTAMP
blog_content_items
- id — SERIAL
- post_id — INTEGER — NOT NULL
- item_type — VARCHAR(50) — NOT NULL
- item_order — INTEGER
- text_value — TEXT
- image_src — VARCHAR(1000)
- table_data — JSONB
- created_at — TIMESTAMP
blog_posts
- id — SERIAL
- blog_id — VARCHAR(100) — NOT NULL
- post_url — VARCHAR(1000) — NOT NULL
- title — TEXT
- saved_at — VARCHAR(50)
- crawled_at — TIMESTAMP
- created_at — TIMESTAMP
content_sections
- id — SERIAL
- content_id — INTEGER — NOT NULL
- heading — VARCHAR(500)
- body — TEXT
- section_order — INTEGER
- created_at — TIMESTAMP
crawl_history
- id — SERIAL
- history_id — VARCHAR(100) — NOT NULL
- site_name — VARCHAR(200)
- url — VARCHAR(1000)
- status — VARCHAR(50) — NOT NULL
- changed — BOOLEAN
- changes — JSONB
- pages_crawled — INTEGER
- error — TEXT
- timestamp — TIMESTAMP
crawl_results
- result_id — BIGSERIAL
- session_id — BIGINT — NOT NULL
- target_id — BIGINT
- page_id — BIGINT
- crawl_url — VARCHAR(2000) — NOT NULL
- selector — VARCHAR(1000) — NOT NULL
- element_type — VARCHAR(50) — NOT NULL
- extracted_data — TEXT
- cleaned_data — TEXT
- data_format — VARCHAR(50)
- data_size — INTEGER
- content_hash — VARCHAR(64)
- language — VARCHAR(10)
- extraction_timestamp — TIMESTAMP
- processing_time_ms — INTEGER
- success — BOOLEAN
- error_code — VARCHAR(50)
- error_message — TEXT
- quality_score — DECIMAL(5,2)
- llm_processed — BOOLEAN
- rag_indexed — BOOLEAN
- document_stored — BOOLEAN
- access_count — INTEGER
- last_accessed — TIMESTAMP
crawl_sessions
- session_id — BIGSERIAL
- session_name — VARCHAR(255) — NOT NULL
- base_url — VARCHAR(2000) — NOT NULL
- session_type — VARCHAR(50)
- data_purpose — VARCHAR(50)
- start_time — TIMESTAMP
- end_time — TIMESTAMP
- duration_seconds — INTEGER
- total_targets — INTEGER
- successful_targets — INTEGER
- failed_targets — INTEGER
- status — VARCHAR(50)
- progress_percentage — DECIMAL(5,2)
- max_depth — INTEGER
- delay_seconds — DECIMAL(4,2)
- respect_robots — BOOLEAN
- timeout_seconds — INTEGER
- created_by — BIGINT
- data_classification — VARCHAR(50)
crawl_targets
- target_id — BIGSERIAL
- session_id — BIGINT — NOT NULL
- page_id — BIGINT
- target_url — VARCHAR(2000) — NOT NULL
- selector — VARCHAR(1000) — NOT NULL
- element_type — VARCHAR(50) — NOT NULL
- attribute_name — VARCHAR(100)
- description — TEXT
- priority — INTEGER
- is_selected — BOOLEAN
data_usage
- usage_id — BIGSERIAL
- user_id — BIGINT — NOT NULL
- usage_type — VARCHAR(50) — NOT NULL
- data_source — VARCHAR(50) — NOT NULL
- access_time — TIMESTAMP
- data_volume_mb — DECIMAL(10,2)
- processing_time_ms — INTEGER
- cost_credits — DECIMAL(10,2)
- metadata — JSONB
document_store
- doc_id — BIGSERIAL
- result_id — BIGINT — NOT NULL
- file_name — VARCHAR(255) — NOT NULL
- file_path — VARCHAR(1000) — NOT NULL
- file_type — VARCHAR(50) — NOT NULL
- file_size — BIGINT
- mime_type — VARCHAR(100)
- checksum — VARCHAR(64)
- storage_location — VARCHAR(20)
- s3_bucket — VARCHAR(100)
- s3_key — VARCHAR(500)
- compression_type — VARCHAR(20)
- encryption_status — BOOLEAN
- metadata — JSONB
- created_at — TIMESTAMP
- archived_at — TIMESTAMP
- download_count — INTEGER
- last_accessed — TIMESTAMP
icon_categories
- id — SERIAL
- name — VARCHAR(100) — NOT NULL
- description — TEXT
- is_active — BOOLEAN
- display_order — INT
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
knowledge_base
- kb_id — BIGSERIAL
- result_id — BIGINT — NOT NULL
- title — VARCHAR(500)
- content_summary — TEXT
- vector_data — JSONB
- embeddings_model — VARCHAR(100)
- chunk_size — INTEGER
- chunk_overlap — INTEGER
- keywords — JSONB
- categories — JSONB
- indexed_at — TIMESTAMP
- last_updated — TIMESTAMP
- rag_ready — BOOLEAN
- similarity_threshold — DECIMAL(3,2)
- access_count — INTEGER
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
schedule_crawl_data
- id — SERIAL
- data — JSONB — NOT NULL
- created_at — TIMESTAMP
service_pages
- page_id — BIGSERIAL
- url — VARCHAR(2000) — NOT NULL
- title — VARCHAR(500)
- meta_description — TEXT
- meta_keywords — TEXT
- depth — INTEGER
- parent_page_id — BIGINT
- domain — VARCHAR(255)
- path — VARCHAR(1000)
- content_type — VARCHAR(100)
- content_length — INTEGER
- response_status — INTEGER
- last_crawled — TIMESTAMP
- is_active — BOOLEAN
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
site_menus
- id — SERIAL
- site_id — INTEGER — NOT NULL
- title — VARCHAR(500) — NOT NULL
- href — VARCHAR(1000)
- parent_id — INTEGER
- depth — INTEGER
- order_index — INTEGER
- created_at — TIMESTAMP
site_selectors
- id — SERIAL
- site_id — INTEGER — NOT NULL
- side_selector — VARCHAR(200)
- tab_selector — VARCHAR(200)
- content_selector — VARCHAR(200)
- created_at — TIMESTAMP
user_activity_logs
- log_id — BIGSERIAL
- user_id — BIGINT
- activity_type — VARCHAR(50) — NOT NULL
- activity_description — TEXT
- ip_address — INET
- user_agent — TEXT
- session_id — VARCHAR(255)
- request_url — VARCHAR(1000)
- request_method — VARCHAR(10)
- response_status — INTEGER
- processing_time_ms — INTEGER
- data_accessed — JSONB
- changes_made — JSONB
- error_message — TEXT
- severity_level — VARCHAR(20)
- created_at — TIMESTAMP
user_sessions
- session_id — VARCHAR(255)
- user_id — BIGINT — NOT NULL
- login_time — TIMESTAMP
- logout_time — TIMESTAMP
- ip_address — INET
- user_agent — TEXT
- session_duration — INTEGER
- actions_count — INTEGER
- is_active — BOOLEAN
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 — VARCHAR(50) — NOT NULL
- permissions — JSONB
- api_key — VARCHAR(255)
- api_quota_daily — INTEGER
- api_quota_used — INTEGER
- organization_name — VARCHAR(255)
- organization_type — VARCHAR(50)
- 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 — VARCHAR(50)
- referrer_url — VARCHAR(500)
- utm_source — VARCHAR(100)
- utm_medium — VARCHAR(100)
- utm_campaign — VARCHAR(100)
- approval_status — VARCHAR(50)
- 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