AI challengers

Tables (16)

ai_analysis_results

  • id — SERIAL
  • startup_id — INTEGER
  • document_id — INTEGER
  • analysis_type — VARCHAR(50) — NOT NULL
  • analysis_date — TIMESTAMP
  • market_score — DECIMAL(3,2)
  • technology_score — DECIMAL(3,2)
  • team_score — DECIMAL(3,2)
  • business_model_score — DECIMAL(3,2)
  • financial_score — DECIMAL(3,2)
  • overall_score — DECIMAL(3,2)
  • risk_factors — JSONB
  • opportunities — JSONB
  • key_insights — TEXT
  • analysis_summary — TEXT
  • confidence_level — DECIMAL(3,2)

audit_logs

  • id — SERIAL
  • user_id — INTEGER
  • action — VARCHAR(100) — NOT NULL
  • resource_type — VARCHAR(50)
  • resource_id — INTEGER
  • details — JSONB
  • ip_address — INET
  • user_agent — TEXT
  • created_at — TIMESTAMP

chat_conversations

  • id — SERIAL
  • user_id — INTEGER
  • session_id — VARCHAR(100) — NOT NULL
  • conversation_title — VARCHAR(200)
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP
  • is_active — BOOLEAN

chat_messages

  • id — SERIAL
  • conversation_id — INTEGER
  • message_type — VARCHAR(20) — NOT NULL
  • content — TEXT — NOT NULL
  • metadata — JSONB
  • tokens_used — INTEGER
  • response_time_ms — INTEGER
  • created_at — TIMESTAMP

custom_metrics

  • id — SERIAL
  • metric_name — VARCHAR(100) — NOT NULL
  • industry_category — VARCHAR(100)
  • funding_stage — VARCHAR(50)
  • metric_formula — TEXT
  • weight — DECIMAL(3,2)
  • description — TEXT
  • created_by — INTEGER
  • created_at — TIMESTAMP
  • is_active — BOOLEAN

dart_disclosures

  • id — SERIAL
  • corp_code — VARCHAR(20)
  • corp_name — VARCHAR(200)
  • stock_code — VARCHAR(20)
  • corp_cls — VARCHAR(10)
  • report_nm — VARCHAR(300)
  • rcept_no — VARCHAR(20)
  • flr_nm — VARCHAR(200)
  • rcept_dt — VARCHAR(8)
  • rm — TEXT
  • created_at — TIMESTAMP

document_embeddings

  • id — SERIAL
  • document_id — INTEGER
  • chunk_index — INTEGER — NOT NULL
  • chunk_text — TEXT — NOT NULL
  • embedding_vector — VECTOR(1536)
  • metadata — JSONB
  • created_at — TIMESTAMP

due_diligence_checklist

  • id — SERIAL
  • startup_id — INTEGER
  • report_id — INTEGER
  • checklist_category — VARCHAR(100)
  • checklist_item — VARCHAR(300)
  • status — VARCHAR(50)
  • assigned_to — INTEGER
  • notes — TEXT
  • priority — INTEGER
  • due_date — DATE
  • completed_date — TIMESTAMP
  • created_at — TIMESTAMP

investment_reports

  • id — SERIAL
  • startup_id — INTEGER
  • created_by — INTEGER
  • report_title — VARCHAR(200) — NOT NULL
  • investment_recommendation — VARCHAR(50)
  • target_investment_amount — BIGINT
  • expected_return_rate — DECIMAL(5,2)
  • investment_horizon — INTEGER
  • executive_summary — TEXT
  • detailed_analysis — TEXT
  • risk_assessment — TEXT
  • financial_projections — JSONB
  • report_status — VARCHAR(50)
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP

ir_documents

  • id — SERIAL
  • startup_id — INTEGER
  • uploader_id — INTEGER
  • document_type — VARCHAR(50) — NOT NULL
  • file_name — VARCHAR(255) — NOT NULL
  • file_path — VARCHAR(500) — NOT NULL
  • file_size — BIGINT
  • mime_type — VARCHAR(100)
  • upload_date — TIMESTAMP
  • processing_status — VARCHAR(50)
  • extracted_text — TEXT
  • summary — TEXT
  • is_active — BOOLEAN

market_news

  • id — SERIAL
  • title — VARCHAR(500) — NOT NULL
  • content — TEXT
  • source — VARCHAR(100)
  • published_date — TIMESTAMP
  • url — VARCHAR(500)
  • category — VARCHAR(100)
  • keywords — JSONB
  • sentiment_score — DECIMAL(3,2)
  • relevance_score — DECIMAL(3,2)
  • created_at — TIMESTAMP

notifications

  • id — SERIAL
  • user_id — INTEGER
  • notification_type — VARCHAR(50)
  • title — VARCHAR(200) — NOT NULL
  • message — TEXT
  • reference_id — INTEGER
  • reference_type — VARCHAR(50)
  • is_read — BOOLEAN
  • priority — VARCHAR(20)
  • created_at — TIMESTAMP
  • read_at — TIMESTAMP

startup_metric_values

  • id — SERIAL
  • startup_id — INTEGER
  • metric_id — INTEGER
  • metric_value — DECIMAL(10,4)
  • calculated_date — TIMESTAMP
  • data_source — VARCHAR(100)
  • confidence_score — DECIMAL(3,2)

startups

  • id — SERIAL
  • company_name — VARCHAR(200) — NOT NULL
  • business_registration_number — VARCHAR(50)
  • industry_category — VARCHAR(100)
  • founding_date — DATE
  • employee_count — INTEGER
  • headquarter_location — VARCHAR(200)
  • website_url — VARCHAR(255)
  • description — TEXT
  • current_funding_stage — VARCHAR(50)
  • total_funding_amount — BIGINT
  • last_funding_date — DATE
  • valuation — BIGINT
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP

user_bookmarks

  • id — SERIAL
  • user_id — INTEGER
  • startup_id — INTEGER
  • bookmark_date — TIMESTAMP
  • notes — TEXT
  • priority_level — INTEGER
  • UNIQUE(user_id, — startup_id)

users

  • id — SERIAL
  • email — VARCHAR(255) — NOT NULL
  • password_hash — VARCHAR(255) — NOT NULL
  • name — VARCHAR(100) — NOT NULL
  • role — VARCHAR(50) — NOT NULL
  • vc_company — VARCHAR(100)
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP
  • is_active — BOOLEAN