-- finance migration 0006: company leadership (Phase 14).
--
-- A company's officers and board, parsed from SEC Form 3/4/5 ownership XML
-- (each filing carries a structured reportingOwnerRelationship), plus the
-- 8-K item-5.02 leadership-change events surfaced from the filing history.
-- Stocks only: ETFs and indexes have no officers or board to track.

-- When this stock's leadership roster was last refreshed from SEC. NULL = never.
ALTER TABLE symbols ADD COLUMN leadership_synced_at INTEGER;

-- The 8-K item codes a filing reported, comma-separated as EDGAR's submissions
-- feed lists them (e.g. '5.02,9.01'). Set for 8-K rows; NULL for other forms
-- and for filing rows stored before this migration (refilled on the next SEC
-- sync). Item 5.02 is the officer/director departure-and-appointment event,
-- which the symbol page reads as the leadership-changes feed.
ALTER TABLE filings ADD COLUMN items TEXT;


