CREATE TABLE SecList_NotesHistory(
                              SNH_Sequence integer Identity(1,1) NOT NULL,
                              SNH_Symbol Varchar(15) NOT NULL,
                              SNH_Date datetime NOT NULL,
                              SNH_Note VarChar(500) Null,
                              SNH_ManuallyEntered bit null default 0,
			      SNH_Continuation bit null default 0,
                              SNH_NoteType tinyint null default 0,
                              SNH_TempRecord bit null default 0,
                              SNH_IsFrozen bit  Null
                              CONSTRAINT PK_SecList_NotesHistory PRIMARY KEY CLUSTERED
                              (SNH_Sequence)
                               );

ALTER TABLE [dbo].[SecList_NotesHistory] ADD
	CONSTRAINT [FK_SecList_NotesHistory_SecList_FixedData] FOREIGN KEY 
	(
		[SNH_Symbol]
	) REFERENCES [dbo].[SecList_FixedData] (
		[SLF_Symbol]
	) ON DELETE CASCADE  ON UPDATE CASCADE
