; ; Archive created at 2026-09-10 19:19:52 UTC ; dbname: stocklab ; TOC Entries: 262 ; Compression: gzip ; Dump Version: 1.15-0 ; Format: CUSTOM ; Integer: 4 bytes ; Offset: 8 bytes ; Dumped from database version: 16.15 ; Dumped by pg_dump version: 16.15 ; ; ; Selected TOC Entries: ; 215; 1259 16389 TABLE public alembic_version stocklab 249; 1259 16994 TABLE public alert_events stocklab 244; 1259 16910 TABLE public alerts stocklab 247; 1259 16967 TABLE public audit_log stocklab 226; 1259 16559 TABLE public balance_sheets stocklab 230; 1259 16624 TABLE public buybacks stocklab 227; 1259 16574 TABLE public cash_flows stocklab 222; 1259 16465 TABLE public companies stocklab 234; 1259 16706 TABLE public corporate_actions stocklab 216; 1259 16394 TABLE public countries stocklab 239; 1259 16813 TABLE public data_quality stocklab 229; 1259 16604 TABLE public dividends stocklab 250; 1259 17015 TABLE public emerging_classifications stocklab 231; 1259 16643 TABLE public estimates stocklab 217; 1259 16405 TABLE public exchanges stocklab 224; 1259 16521 TABLE public financial_periods stocklab 232; 1259 16665 TABLE public guidance stocklab 225; 1259 16544 TABLE public income_statements stocklab 219; 1259 16425 TABLE public industries stocklab 236; 1259 16754 TABLE public metric_history stocklab 235; 1259 16728 TABLE public metrics stocklab 246; 1259 16946 TABLE public portfolio_positions stocklab 245; 1259 16931 TABLE public portfolios stocklab 233; 1259 16685 TABLE public prices stocklab 248; 1259 16982 TABLE public revoked_tokens stocklab 238; 1259 16791 TABLE public scores stocklab 241; 1259 16856 TABLE public screen_results stocklab 240; 1259 16838 TABLE public screeners stocklab 218; 1259 16418 TABLE public sectors stocklab 223; 1259 16495 TABLE public securities stocklab 228; 1259 16589 TABLE public shares stocklab 221; 1259 16451 TABLE public sources stocklab 220; 1259 16438 TABLE public users stocklab 237; 1259 16772 TABLE public valuation stocklab 243; 1259 16887 TABLE public watchlist_items stocklab 242; 1259 16873 TABLE public watchlists stocklab 3909; 0 16389 TABLE DATA public alembic_version stocklab 3943; 0 16994 TABLE DATA public alert_events stocklab 3938; 0 16910 TABLE DATA public alerts stocklab 3941; 0 16967 TABLE DATA public audit_log stocklab 3920; 0 16559 TABLE DATA public balance_sheets stocklab 3924; 0 16624 TABLE DATA public buybacks stocklab 3921; 0 16574 TABLE DATA public cash_flows stocklab 3916; 0 16465 TABLE DATA public companies stocklab 3928; 0 16706 TABLE DATA public corporate_actions stocklab 3910; 0 16394 TABLE DATA public countries stocklab 3933; 0 16813 TABLE DATA public data_quality stocklab 3923; 0 16604 TABLE DATA public dividends stocklab 3944; 0 17015 TABLE DATA public emerging_classifications stocklab 3925; 0 16643 TABLE DATA public estimates stocklab 3911; 0 16405 TABLE DATA public exchanges stocklab 3918; 0 16521 TABLE DATA public financial_periods stocklab 3926; 0 16665 TABLE DATA public guidance stocklab 3919; 0 16544 TABLE DATA public income_statements stocklab 3913; 0 16425 TABLE DATA public industries stocklab 3930; 0 16754 TABLE DATA public metric_history stocklab 3929; 0 16728 TABLE DATA public metrics stocklab 3940; 0 16946 TABLE DATA public portfolio_positions stocklab 3939; 0 16931 TABLE DATA public portfolios stocklab 3927; 0 16685 TABLE DATA public prices stocklab 3942; 0 16982 TABLE DATA public revoked_tokens stocklab 3932; 0 16791 TABLE DATA public scores stocklab 3935; 0 16856 TABLE DATA public screen_results stocklab 3934; 0 16838 TABLE DATA public screeners stocklab 3912; 0 16418 TABLE DATA public sectors stocklab 3917; 0 16495 TABLE DATA public securities stocklab 3922; 0 16589 TABLE DATA public shares stocklab 3915; 0 16451 TABLE DATA public sources stocklab 3914; 0 16438 TABLE DATA public users stocklab 3931; 0 16772 TABLE DATA public valuation stocklab 3937; 0 16887 TABLE DATA public watchlist_items stocklab 3936; 0 16873 TABLE DATA public watchlists stocklab 3521; 2606 16393 CONSTRAINT public alembic_version alembic_version_pkc stocklab 3704; 2606 17002 CONSTRAINT public alert_events alert_events_pkey stocklab 3680; 2606 16918 CONSTRAINT public alerts alerts_pkey stocklab 3693; 2606 16974 CONSTRAINT public audit_log audit_log_pkey stocklab 3581; 2606 16567 CONSTRAINT public balance_sheets balance_sheets_financial_period_id_key stocklab 3583; 2606 16565 CONSTRAINT public balance_sheets balance_sheets_pkey stocklab 3600; 2606 16630 CONSTRAINT public buybacks buybacks_pkey stocklab 3586; 2606 16582 CONSTRAINT public cash_flows cash_flows_financial_period_id_key stocklab 3588; 2606 16580 CONSTRAINT public cash_flows cash_flows_pkey stocklab 3554; 2606 16474 CONSTRAINT public companies companies_pkey stocklab 3622; 2606 16714 CONSTRAINT public corporate_actions corporate_actions_pkey stocklab 3523; 2606 16400 CONSTRAINT public countries countries_iso2_key stocklab 3525; 2606 16402 CONSTRAINT public countries countries_iso3_key stocklab 3527; 2606 16398 CONSTRAINT public countries countries_pkey stocklab 3659; 2606 16821 CONSTRAINT public data_quality data_quality_pkey stocklab 3596; 2606 16611 CONSTRAINT public dividends dividends_pkey stocklab 3713; 2606 17023 CONSTRAINT public emerging_classifications emerging_classifications_pkey stocklab 3604; 2606 16649 CONSTRAINT public estimates estimates_pkey stocklab 3531; 2606 16411 CONSTRAINT public exchanges exchanges_mic_key stocklab 3533; 2606 16409 CONSTRAINT public exchanges exchanges_pkey stocklab 3569; 2606 16528 CONSTRAINT public financial_periods financial_periods_pkey stocklab 3611; 2606 16671 CONSTRAINT public guidance guidance_pkey stocklab 3576; 2606 16552 CONSTRAINT public income_statements income_statements_financial_period_id_key stocklab 3578; 2606 16550 CONSTRAINT public income_statements income_statements_pkey stocklab 3540; 2606 16431 CONSTRAINT public industries industries_code_key stocklab 3542; 2606 16429 CONSTRAINT public industries industries_pkey stocklab 3640; 2606 16760 CONSTRAINT public metric_history metric_history_pkey stocklab 3632; 2606 16736 CONSTRAINT public metrics metrics_pkey stocklab 3689; 2606 16952 CONSTRAINT public portfolio_positions portfolio_positions_pkey stocklab 3685; 2606 16939 CONSTRAINT public portfolios portfolios_pkey stocklab 3618; 2606 16691 CONSTRAINT public prices prices_pkey stocklab 3700; 2606 16990 CONSTRAINT public revoked_tokens revoked_tokens_jti_key stocklab 3702; 2606 16988 CONSTRAINT public revoked_tokens revoked_tokens_pkey stocklab 3655; 2606 16800 CONSTRAINT public scores scores_pkey stocklab 3669; 2606 16865 CONSTRAINT public screen_results screen_results_pkey stocklab 3663; 2606 16849 CONSTRAINT public screeners screeners_key_key stocklab 3665; 2606 16847 CONSTRAINT public screeners screeners_pkey stocklab 3536; 2606 16424 CONSTRAINT public sectors sectors_code_key stocklab 3538; 2606 16422 CONSTRAINT public sectors sectors_pkey stocklab 3565; 2606 16504 CONSTRAINT public securities securities_pkey stocklab 3592; 2606 16597 CONSTRAINT public shares shares_financial_period_id_key stocklab 3594; 2606 16595 CONSTRAINT public shares shares_pkey stocklab 3552; 2606 16461 CONSTRAINT public sources sources_pkey stocklab 3711; 2606 17004 CONSTRAINT public alert_events uq_alert_event_security_type_date stocklab 3719; 2606 17025 CONSTRAINT public emerging_classifications uq_emerging_security_date stocklab 3609; 2606 16651 CONSTRAINT public estimates uq_estimate stocklab 3574; 2606 16530 CONSTRAINT public financial_periods uq_financial_period stocklab 3642; 2606 16762 CONSTRAINT public metric_history uq_metric_history stocklab 3634; 2606 16738 CONSTRAINT public metrics uq_metric_security_key stocklab 3691; 2606 16954 CONSTRAINT public portfolio_positions uq_portfolio_position stocklab 3620; 2606 16693 CONSTRAINT public prices uq_price_security_date stocklab 3657; 2606 16802 CONSTRAINT public scores uq_score_security_date stocklab 3567; 2606 16506 CONSTRAINT public securities uq_security_ticker_exchange stocklab 3646; 2606 16783 CONSTRAINT public valuation uq_valuation_security_date stocklab 3676; 2606 16897 CONSTRAINT public watchlist_items uq_watchlist_item stocklab 3545; 2606 16450 CONSTRAINT public users users_email_key stocklab 3547; 2606 16448 CONSTRAINT public users users_pkey stocklab 3648; 2606 16781 CONSTRAINT public valuation valuation_pkey stocklab 3678; 2606 16895 CONSTRAINT public watchlist_items watchlist_items_pkey stocklab 3672; 2606 16880 CONSTRAINT public watchlists watchlists_pkey stocklab 3705; 1259 17011 INDEX public ix_alert_events_event_type stocklab 3706; 1259 17013 INDEX public ix_alert_events_occurred_on stocklab 3707; 1259 17014 INDEX public ix_alert_events_occurred_severity stocklab 3708; 1259 17010 INDEX public ix_alert_events_security_id stocklab 3709; 1259 17012 INDEX public ix_alert_events_severity stocklab 3681; 1259 16929 INDEX public ix_alerts_owner_user_id stocklab 3682; 1259 16930 INDEX public ix_alerts_security_id stocklab 3694; 1259 16981 INDEX public ix_audit_log_event_type stocklab 3695; 1259 16980 INDEX public ix_audit_log_occurred_at stocklab 3584; 1259 16573 INDEX public ix_balance_sheets_financial_period_id stocklab 3601; 1259 16642 INDEX public ix_buybacks_period_end stocklab 3602; 1259 16641 INDEX public ix_buybacks_security_id stocklab 3589; 1259 16588 INDEX public ix_cash_flows_financial_period_id stocklab 3555; 1259 16492 INDEX public ix_companies_country_id stocklab 3556; 1259 16491 INDEX public ix_companies_display_name stocklab 3557; 1259 16494 INDEX public ix_companies_industry_id stocklab 3558; 1259 16490 INDEX public ix_companies_legal_name stocklab 3559; 1259 16493 INDEX public ix_companies_sector_id stocklab 3623; 1259 16726 INDEX public ix_corporate_actions_action_type stocklab 3624; 1259 16727 INDEX public ix_corporate_actions_effective_date stocklab 3625; 1259 16725 INDEX public ix_corporate_actions_security_id stocklab 3528; 1259 16403 INDEX public ix_countries_iso2 stocklab 3529; 1259 16404 INDEX public ix_countries_region stocklab 3660; 1259 16837 INDEX public ix_data_quality_entity_id stocklab 3597; 1259 16623 INDEX public ix_dividends_ex_date stocklab 3598; 1259 16622 INDEX public ix_dividends_security_id stocklab 3714; 1259 17032 INDEX public ix_emerging_calculation_date stocklab 3715; 1259 17031 INDEX public ix_emerging_security_id stocklab 3716; 1259 17033 INDEX public ix_emerging_status stocklab 3717; 1259 17034 INDEX public ix_emerging_status_score stocklab 3605; 1259 16664 INDEX public ix_estimates_as_of_date stocklab 3606; 1259 16663 INDEX public ix_estimates_period_end stocklab 3607; 1259 16662 INDEX public ix_estimates_security_id stocklab 3534; 1259 16417 INDEX public ix_exchanges_country_id stocklab 3570; 1259 16543 INDEX public ix_financial_periods_filing_date stocklab 3571; 1259 16542 INDEX public ix_financial_periods_period_end stocklab 3572; 1259 16541 INDEX public ix_financial_periods_security_id stocklab 3612; 1259 16684 INDEX public ix_guidance_issued_date stocklab 3613; 1259 16683 INDEX public ix_guidance_period_end stocklab 3614; 1259 16682 INDEX public ix_guidance_security_id stocklab 3579; 1259 16558 INDEX public ix_income_statements_financial_period_id stocklab 3543; 1259 16437 INDEX public ix_industries_sector_id stocklab 3635; 1259 16770 INDEX public ix_metric_history_as_of stocklab 3636; 1259 16769 INDEX public ix_metric_history_metric_key stocklab 3637; 1259 16768 INDEX public ix_metric_history_security_id stocklab 3638; 1259 16771 INDEX public ix_metric_history_security_key_asof stocklab 3626; 1259 16750 INDEX public ix_metrics_industry_id stocklab 3627; 1259 16753 INDEX public ix_metrics_industry_key_value stocklab 3628; 1259 16751 INDEX public ix_metrics_metric_key stocklab 3629; 1259 16749 INDEX public ix_metrics_security_id stocklab 3630; 1259 16752 INDEX public ix_metrics_value stocklab 3686; 1259 16965 INDEX public ix_portfolio_positions_portfolio_id stocklab 3687; 1259 16966 INDEX public ix_portfolio_positions_security_id stocklab 3683; 1259 16945 INDEX public ix_portfolios_owner_user_id stocklab 3615; 1259 16705 INDEX public ix_prices_date stocklab 3616; 1259 16704 INDEX public ix_prices_security_id stocklab 3696; 1259 16993 INDEX public ix_revoked_tokens_expires_at stocklab 3697; 1259 16991 INDEX public ix_revoked_tokens_jti stocklab 3698; 1259 16992 INDEX public ix_revoked_tokens_user_id stocklab 3649; 1259 16809 INDEX public ix_scores_calculation_date stocklab 3650; 1259 16810 INDEX public ix_scores_overall_score stocklab 3651; 1259 16811 INDEX public ix_scores_quality_score stocklab 3652; 1259 16812 INDEX public ix_scores_recommendation stocklab 3653; 1259 16808 INDEX public ix_scores_security_id stocklab 3666; 1259 16872 INDEX public ix_screen_results_run_at stocklab 3667; 1259 16871 INDEX public ix_screen_results_screener_id stocklab 3661; 1259 16855 INDEX public ix_screeners_owner_user_id stocklab 3560; 1259 16517 INDEX public ix_securities_company_id stocklab 3561; 1259 16518 INDEX public ix_securities_exchange_id stocklab 3562; 1259 16520 INDEX public ix_securities_isin stocklab 3563; 1259 16519 INDEX public ix_securities_ticker stocklab 3590; 1259 16603 INDEX public ix_shares_financial_period_id stocklab 3548; 1259 16464 INDEX public ix_sources_content_hash stocklab 3549; 1259 16463 INDEX public ix_sources_is_demo stocklab 3550; 1259 16462 INDEX public ix_sources_provider stocklab 3643; 1259 16790 INDEX public ix_valuation_calculation_date stocklab 3644; 1259 16789 INDEX public ix_valuation_security_id stocklab 3673; 1259 16909 INDEX public ix_watchlist_items_security_id stocklab 3674; 1259 16908 INDEX public ix_watchlist_items_watchlist_id stocklab 3670; 1259 16886 INDEX public ix_watchlists_owner_user_id stocklab 3764; 2606 17005 FK CONSTRAINT public alert_events alert_events_security_id_fkey stocklab 3758; 2606 16919 FK CONSTRAINT public alerts alerts_owner_user_id_fkey stocklab 3759; 2606 16924 FK CONSTRAINT public alerts alerts_security_id_fkey stocklab 3763; 2606 16975 FK CONSTRAINT public audit_log audit_log_actor_user_id_fkey stocklab 3730; 2606 16568 FK CONSTRAINT public balance_sheets balance_sheets_financial_period_id_fkey stocklab 3735; 2606 16631 FK CONSTRAINT public buybacks buybacks_security_id_fkey stocklab 3736; 2606 16636 FK CONSTRAINT public buybacks buybacks_source_id_fkey stocklab 3731; 2606 16583 FK CONSTRAINT public cash_flows cash_flows_financial_period_id_fkey stocklab 3722; 2606 16475 FK CONSTRAINT public companies companies_country_id_fkey stocklab 3723; 2606 16485 FK CONSTRAINT public companies companies_industry_id_fkey stocklab 3724; 2606 16480 FK CONSTRAINT public companies companies_sector_id_fkey stocklab 3743; 2606 16715 FK CONSTRAINT public corporate_actions corporate_actions_security_id_fkey stocklab 3744; 2606 16720 FK CONSTRAINT public corporate_actions corporate_actions_source_id_fkey stocklab 3750; 2606 16832 FK CONSTRAINT public data_quality data_quality_selected_source_id_fkey stocklab 3751; 2606 16822 FK CONSTRAINT public data_quality data_quality_source_a_id_fkey stocklab 3752; 2606 16827 FK CONSTRAINT public data_quality data_quality_source_b_id_fkey stocklab 3733; 2606 16612 FK CONSTRAINT public dividends dividends_security_id_fkey stocklab 3734; 2606 16617 FK CONSTRAINT public dividends dividends_source_id_fkey stocklab 3765; 2606 17026 FK CONSTRAINT public emerging_classifications emerging_classifications_security_id_fkey stocklab 3737; 2606 16652 FK CONSTRAINT public estimates estimates_security_id_fkey stocklab 3738; 2606 16657 FK CONSTRAINT public estimates estimates_source_id_fkey stocklab 3720; 2606 16412 FK CONSTRAINT public exchanges exchanges_country_id_fkey stocklab 3727; 2606 16531 FK CONSTRAINT public financial_periods financial_periods_security_id_fkey stocklab 3728; 2606 16536 FK CONSTRAINT public financial_periods financial_periods_source_id_fkey stocklab 3739; 2606 16672 FK CONSTRAINT public guidance guidance_security_id_fkey stocklab 3740; 2606 16677 FK CONSTRAINT public guidance guidance_source_id_fkey stocklab 3729; 2606 16553 FK CONSTRAINT public income_statements income_statements_financial_period_id_fkey stocklab 3721; 2606 16432 FK CONSTRAINT public industries industries_sector_id_fkey stocklab 3747; 2606 16763 FK CONSTRAINT public metric_history metric_history_security_id_fkey stocklab 3745; 2606 16744 FK CONSTRAINT public metrics metrics_industry_id_fkey stocklab 3746; 2606 16739 FK CONSTRAINT public metrics metrics_security_id_fkey stocklab 3761; 2606 16955 FK CONSTRAINT public portfolio_positions portfolio_positions_portfolio_id_fkey stocklab 3762; 2606 16960 FK CONSTRAINT public portfolio_positions portfolio_positions_security_id_fkey stocklab 3760; 2606 16940 FK CONSTRAINT public portfolios portfolios_owner_user_id_fkey stocklab 3741; 2606 16694 FK CONSTRAINT public prices prices_security_id_fkey stocklab 3742; 2606 16699 FK CONSTRAINT public prices prices_source_id_fkey stocklab 3749; 2606 16803 FK CONSTRAINT public scores scores_security_id_fkey stocklab 3754; 2606 16866 FK CONSTRAINT public screen_results screen_results_screener_id_fkey stocklab 3753; 2606 16850 FK CONSTRAINT public screeners screeners_owner_user_id_fkey stocklab 3725; 2606 16507 FK CONSTRAINT public securities securities_company_id_fkey stocklab 3726; 2606 16512 FK CONSTRAINT public securities securities_exchange_id_fkey stocklab 3732; 2606 16598 FK CONSTRAINT public shares shares_financial_period_id_fkey stocklab 3748; 2606 16784 FK CONSTRAINT public valuation valuation_security_id_fkey stocklab 3756; 2606 16903 FK CONSTRAINT public watchlist_items watchlist_items_security_id_fkey stocklab 3757; 2606 16898 FK CONSTRAINT public watchlist_items watchlist_items_watchlist_id_fkey stocklab 3755; 2606 16881 FK CONSTRAINT public watchlists watchlists_owner_user_id_fkey stocklab