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