Table "public.financial_periods"
       Column        |           Type           | Collation | Nullable |         Default         | Storage  | Compression | Stats target | Description 
---------------------+--------------------------+-----------+----------+-------------------------+----------+-------------+--------------+-------------
 id                  | character varying(36)    |           | not null |                         | extended |             |              | 
 security_id         | character varying(36)    |           | not null |                         | extended |             |              | 
 period_end          | date                     |           | not null |                         | plain    |             |              | 
 period_type         | character varying(8)     |           | not null |                         | extended |             |              | 
 filing_date         | date                     |           |          |                         | plain    |             |              | 
 published_at        | date                     |           |          |                         | plain    |             |              | 
 retrieved_at        | date                     |           |          |                         | plain    |             |              | 
 currency            | character varying(3)     |           | not null |                         | extended |             |              | 
 source_id           | character varying(36)    |           |          |                         | extended |             |              | 
 methodology_version | character varying(16)    |           | not null | 'v1'::character varying | extended |             |              | 
 created_at          | timestamp with time zone |           | not null | now()                   | plain    |             |              | 
 updated_at          | timestamp with time zone |           | not null | now()                   | plain    |             |              | 
Indexes:
    "financial_periods_pkey" PRIMARY KEY, btree (id)
    "ix_financial_periods_filing_date" btree (filing_date)
    "ix_financial_periods_period_end" btree (period_end)
    "ix_financial_periods_security_id" btree (security_id)
    "uq_financial_period" UNIQUE CONSTRAINT, btree (security_id, period_end, period_type, filing_date)
Foreign-key constraints:
    "financial_periods_security_id_fkey" FOREIGN KEY (security_id) REFERENCES securities(id)
    "financial_periods_source_id_fkey" FOREIGN KEY (source_id) REFERENCES sources(id)
Referenced by:
    TABLE "balance_sheets" CONSTRAINT "balance_sheets_financial_period_id_fkey" FOREIGN KEY (financial_period_id) REFERENCES financial_periods(id)
    TABLE "cash_flows" CONSTRAINT "cash_flows_financial_period_id_fkey" FOREIGN KEY (financial_period_id) REFERENCES financial_periods(id)
    TABLE "income_statements" CONSTRAINT "income_statements_financial_period_id_fkey" FOREIGN KEY (financial_period_id) REFERENCES financial_periods(id)
    TABLE "shares" CONSTRAINT "shares_financial_period_id_fkey" FOREIGN KEY (financial_period_id) REFERENCES financial_periods(id)
Access method: heap