CREATE TABLE SecList_FinancialsHistory(
                                  SFH_Sequence integer Identity(1,1) NOT NULL,
                                  SFH_Symbol Varchar(15)  NOT NULL,
                                  SFH_Date datetime NOT NULL,
                                  SFH_PeriodSize SmallInt NOT NULL,
                                  SFH_EarningsPerShare real Null,
                                  SFH_SalesPerShare real Null,
                                  SFH_EBITDAPerShr real Null,
                                  SFH_BookValuePerShare real Null,
                                  SFH_CashPerShare real Null,
                                  SFH_FreeCFPerShare  real Null,
                                  SFH_CurrentRatio real Null,
                                  SFH_DebtEquity  real Null,
                                  SFH_SharesOutstanding real Null,
                                  SFH_InstitutionalPct real Null,
                                  SFH_InsiderPercent real Null,
                                  SFH_FCEarningsPerShr real Null,
                                  SFH_FCSalesPerShr real Null,
                                  SFH_PriceEarningsRatio real Null,
                                  SFH_PriceSalesRatio real Null,
				  SFH_DataSource varchar(4) Null,
                                  SFH_TempRecord bit null default 0,
                                  SFH_IsFrozen bit null default 0,
                                  CONSTRAINT PK_SecList_FinancialsHistory PRIMARY KEY CLUSTERED
                                  (SFH_Sequence)
                               );


ALTER TABLE [dbo].[SecList_FinancialsHistory] ADD
	CONSTRAINT [FK_SecList_FinancialsHistory_SecList_FixedData] FOREIGN KEY
	(
		[SFH_Symbol]
	) REFERENCES [dbo].[SecList_FixedData] (
		[SLF_Symbol]
	) ON DELETE CASCADE ON UPDATE CASCADE
