Create_Stock_Info_Table.sql

CREATE TABLE IF NOT EXISTS `security_info` (
`key_id` VARCHAR(25) NOT NULL,
`ticker` VARCHAR(8) NOT NULL,
`figi` VARCHAR(14) NOT NULL,
`company_name` VARCHAR(100) NOT NULL,
`company_id` VARCHAR(12) NOT NULL,
`security_id` VARCHAR(12) NULL,
`composite_ticker` VARCHAR(14) NULL,
`share_class_figi` VARCHAR(14) NULL,
`composite_figi` VARCHAR(14) NULL,
`currency` VARCHAR(4) NULL,
`instrument_type_name` VARCHAR(75) NULL,
`instrument_type_code` VARCHAR(4) NOT NULL,
`active_status` BOOLEAN NOT NULL,
`legal_entity_identifier` VARCHAR(25) NULL,
`country` VARCHAR(25) NULL,
`Intrinio_sector` VARCHAR(50) NULL,
`intrinio_industry_1` VARCHAR(50) NULL,
`intrinio_industry_2` VARCHAR(50) NOT NULL,
`sic_code` VARCHAR(10) NULL,
`primary_exchange` VARCHAR(12) NOT NULL,
`short_description` LONGTEXT NULL,
`long_description` LONGTEXT NULL,
`legal_name` VARCHAR(75) NULL,
`ceo` VARCHAR(75) NULL,
`company_url` VARCHAR(75) NULL,
`business_address` VARCHAR(150) NULL,
`employees` INT NULL,
`cik_number` VARCHAR(12) NULL,
`first_stock_price_date` DATETIME NULL,
`last_stock_price_date` DATETIME NULL,
`standardized_active` VARCHAR(6) NULL,
`first_fundamental_date` DATETIME NULL,
`last_fundamental_date` DATETIME NULL,
`latest_filing_date` DATETIME NULL,
`statement_template` VARCHAR(6) NULL,
`fv_sector` VARCHAR(25) NULL,
`fv_industry` VARCHAR(50) NULL,
`last_update_date` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
PRIMARY KEY (key_id(25))
) ENGINE=InnoDB DEFAULT CHARSET=latin1;