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