12345
Tables (16)
asset
- asset_id — UUID
- ticker — VARCHAR(64)
- name — VARCHAR(255)
- sector — VARCHAR(128)
correlation_edge
- corr_id — UUID — Primary key — NOT NULL
- asset_i — UUID — Primary key — NOT NULL
- asset_j — UUID — Primary key — NOT NULL
- rho — DOUBLE
correlation_run
- corr_id — UUID
- run_id — UUID — NOT NULL
- window — VARCHAR(8)
- return_method — VARCHAR(16)
- corr_threshold — DOUBLE
- computed_at — TIMESTAMP
dataset
- dataset_id — UUID
- name — VARCHAR(255)
- source — VARCHAR(255)
- uploaded_at — TIMESTAMP
- note — TEXT
fundamental_snapshot
- asset_id — UUID — Primary key — NOT NULL
- as_of_date — DATE — Primary key — NOT NULL
- per — DOUBLE
- pbr — DOUBLE
- roe — DOUBLE
- debt_ratio — DOUBLE
optimization_run
- opt_id — UUID
- selection_id — UUID — NOT NULL
- pref_id — UUID
- risk_model — VARCHAR(16)
- rf — DOUBLE
- created_at — TIMESTAMP
portfolio_candidate
- candidate_id — UUID
- opt_id — UUID — NOT NULL
- kind — VARCHAR(32)
- expected_return — DOUBLE
- volatility — DOUBLE
- sharpe — DOUBLE
- rank — INT
portfolio_weight
- candidate_id — UUID — Primary key — NOT NULL
- asset_id — UUID — Primary key — NOT NULL
- weight — DOUBLE
price
- asset_id — UUID — Primary key — NOT NULL
- trade_date — DATE — Primary key — NOT NULL
- close — DOUBLE
report
- report_id — UUID
- opt_id — UUID — NOT NULL
- export_pdf_url — VARCHAR(512)
- export_csv_url — VARCHAR(512)
- summary_meta — TEXT
- created_at — TIMESTAMP
screening_config
- config_id — UUID
- per_weight — DOUBLE
- pbr_weight — DOUBLE
- roe_weight — DOUBLE
- debt_ratio_max — DOUBLE
- note — VARCHAR(255)
- created_at — TIMESTAMP
screening_run
- run_id — UUID
- dataset_id — UUID — NOT NULL
- config_id — UUID — NOT NULL
- status — VARCHAR(32)
- created_at — TIMESTAMP
screening_score
- run_id — UUID — Primary key — NOT NULL
- asset_id — UUID — Primary key — NOT NULL
- z_per — DOUBLE
- z_pbr — DOUBLE
- z_roe — DOUBLE
- score — DOUBLE
- passed — BOOLEAN
selection
- selection_id — UUID
- corr_id — UUID — NOT NULL
- method — VARCHAR(64)
- n_selected — INT
- created_at — TIMESTAMP
- note — VARCHAR(255)
selection_member
- selection_id — UUID — Primary key — NOT NULL
- asset_id — UUID — Primary key — NOT NULL
ui_preference
- pref_id — UUID
- top_n — INT
- weight_cap — DOUBLE
- no_short — BOOLEAN
- created_at — TIMESTAMP