companies|id|NO|
companies|legal_name|NO|
companies|display_name|NO|
companies|country_id|NO|
companies|sector_id|NO|
companies|industry_id|NO|
companies|website|YES|
companies|description|YES|
companies|is_active|NO|true
companies|created_at|NO|now()
companies|updated_at|NO|now()
countries|id|NO|
countries|iso2|NO|
countries|iso3|NO|
countries|name|NO|
countries|region|NO|
countries|currency|NO|
countries|risk_free_rate_override|YES|
countries|equity_risk_premium_override|YES|
exchanges|id|NO|
exchanges|mic|NO|
exchanges|name|NO|
exchanges|country_id|NO|
exchanges|timezone|NO|
industries|id|NO|
industries|code|NO|
industries|name|NO|
industries|sector_id|NO|
sectors|id|NO|
sectors|code|NO|
sectors|name|NO|
securities|id|NO|
securities|company_id|NO|
securities|exchange_id|NO|
securities|ticker|NO|
securities|isin|YES|
securities|cusip|YES|
securities|security_type|NO|'COMMON'::character varying
securities|currency|NO|
securities|is_primary_listing|NO|true
securities|listing_date|YES|
securities|delisting_date|YES|
securities|status|NO|'ACTIVE'::character varying
securities|discovery_status|YES|
securities|created_at|NO|now()
securities|updated_at|NO|now()