25 lines
1.4 KiB
SQL
25 lines
1.4 KiB
SQL
-- Migration: Add detailed startup profile fields
|
|
ALTER TABLE startups
|
|
ADD COLUMN legal_name VARCHAR(255) AFTER name,
|
|
ADD COLUMN country VARCHAR(100) AFTER legal_name,
|
|
ADD COLUMN sub_industry VARCHAR(100) AFTER industry,
|
|
ADD COLUMN business_model TEXT AFTER sub_industry,
|
|
ADD COLUMN product_service TEXT AFTER business_model,
|
|
ADD COLUMN operational_stage VARCHAR(100) AFTER product_service,
|
|
ADD COLUMN total_shares BIGINT AFTER operational_stage,
|
|
ADD COLUMN share_classes TEXT AFTER total_shares,
|
|
ADD COLUMN founder_ownership TEXT AFTER share_classes,
|
|
ADD COLUMN investor_ownership TEXT AFTER founder_ownership,
|
|
ADD COLUMN esop_percentage DECIMAL(5,2) AFTER investor_ownership,
|
|
ADD COLUMN convertible_instruments TEXT AFTER esop_percentage,
|
|
ADD COLUMN current_cash_balance DECIMAL(15,2) AFTER convertible_instruments,
|
|
ADD COLUMN outstanding_debt TEXT AFTER current_cash_balance,
|
|
ADD COLUMN accounts_receivable_payable TEXT AFTER outstanding_debt,
|
|
ADD COLUMN burn_rate DECIMAL(15,2) AFTER accounts_receivable_payable,
|
|
ADD COLUMN doc_income_statements VARCHAR(255) AFTER financial_doc_path,
|
|
ADD COLUMN doc_balance_sheets VARCHAR(255) AFTER doc_income_statements,
|
|
ADD COLUMN doc_cash_flow_statements VARCHAR(255) AFTER doc_balance_sheets,
|
|
ADD COLUMN doc_revenue_breakdown VARCHAR(255) AFTER doc_cash_flow_statements,
|
|
ADD COLUMN doc_gross_margin VARCHAR(255) AFTER doc_revenue_breakdown,
|
|
ADD COLUMN doc_opex_breakdown VARCHAR(255) AFTER doc_gross_margin;
|