financial_report.sql

CREATE TABLE `financial_report` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `company_id` int(10) NOT NULL,
  `cik_id` int(10) NOT NULL,
  `segment_id` int(10) NOT NULL,
  `segment_name` varchar(50) NOT NULL,
  `year` varchar(10) NOT NULL,
  `quarter` enum('Q1','Q2', 'Q3', 'Q4', 'Y') NOT NULL,
  `total_revenue` decimal(15,2) DEFAULT NULL,
  `cost_of_revenue` decimal(15,2) DEFAULT NULL,
  `gross_profit` decimal(15,2) DEFAULT NULL,
  `operating_expense` decimal(15,2) DEFAULT NULL,
  `operating_income` decimal(15,2) DEFAULT NULL,
  `operating_margin` decimal(15,2) DEFAULT NULL,
  `net_income` decimal(15,2) DEFAULT NULL,
  `diluted_eps` decimal(15,2) DEFAULT NULL,
  `created_on` datetime NOT NULL,
  `modified_on` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`) USING BTREE,
  KEY `fk_symbol_idx` (`symbol_id`),
  KEY `fk_company_idx` (`company_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;