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