CREATE TABLE [tblCountryLookUp] (
	[chrCUI] [char] (12) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
	[chrPREF] [char] (1) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
	[vchSDUI] [char] (12) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
	[vchSOURCE] [varchar] (20) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
	[vchTerm] [varchar] (900) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL 
) ON [PRIMARY]
GO


CREATE TABLE [tblEntrezGene] (
	[intEntrezGeneID] [int] IDENTITY (1, 1) NOT NULL ,
	[intTaxID] [int] NULL ,
	[intGeneID] [int] NULL ,
	[vchgenesymbol] [varchar] (20) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
	[vchlocustag] [varchar] (20) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
	[vchgenealias] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
	[vchdbref] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
	[vchchromosome] [varchar] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
	[vchmaplocation] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
	[vchgenedescription] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
	[vchgenetype] [varchar] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
	[vchofficialgenename] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
	[vchfullgenename] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
	[chrgenesymbolstatus] [char] (1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
	CONSTRAINT [PK_tblEntrezGene] PRIMARY KEY  CLUSTERED 
	(
		[intEntrezGeneID]
	) WITH  FILLFACTOR = 90  ON [PRIMARY] 
) ON [PRIMARY]
GO

CREATE TABLE [tblHuGECat] (
	[intHuGECategoryID] [int] IDENTITY (1, 1) NOT NULL ,
	[vchHuGECategoryName] [varchar] (40) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
	[vchHuGECategoryDesc] [varchar] (500) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
	[chrInsertUserID] [audituserid] NOT NULL ,
	[dtmInsertDatetime] [auditdatetime] NOT NULL ,
	[chrUpdateUserID] [audituserid] NOT NULL ,
	[dtmUpdateDatetime] [auditdatetime] NOT NULL ,
	CONSTRAINT [PK__tblHuGECat__047AA831] PRIMARY KEY  NONCLUSTERED 
	(
		[intHuGECategoryID]
	) WITH  FILLFACTOR = 90  ON [PRIMARY] 
) ON [PRIMARY]
GO

CREATE TABLE [tblHuGEDocument] (
	[intHuGEDocumentID] [int] IDENTITY (1, 1) NOT NULL ,
	[chrDocIsMeshed] [char] (1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
	[vchDocTitle] [varchar] (500) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
	[vchAuthor] [varchar] (2000) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
	[vchDocOrganization] [varchar] (1000) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
	[vchDocJournal] [varchar] (1000) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
	[vchDocVolume] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
	[vchDocIssue] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
	[vchDocPages] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
	[intDocPublishedYear] [int] NULL ,
	[intDocPublishedMonth] [int] NULL ,
	[vchDocPublishedMonth] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
	[vchPubMedID] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
	[chrPubMedID] [int] NULL ,
	[txtDocAbstract] [text] COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
	[vchDocUrl] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
	[chrInsertUserID] [audituserid] NOT NULL ,
	[dtmInsertDatetime] [auditdatetime] NOT NULL ,
	[chrUpdateUserID] [audituserid] NOT NULL ,
	[dtmUpdateDatetime] [auditdatetime] NOT NULL ,
	CONSTRAINT [PK__tblHuGEDocument__0CDAE408] PRIMARY KEY  NONCLUSTERED 
	(
		[intHuGEDocumentID]
	) WITH  FILLFACTOR = 90  ON [PRIMARY] 
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO


CREATE TABLE [tblHuGEDocument_tblHuGECategory] (
	[intHuGEDocumentHuGECategoryID] [int] IDENTITY (1, 1) NOT NULL ,
	[intHuGEDocumentID] [int] NOT NULL ,
	[intHuGECategoryID] [int] NOT NULL ,
	[chrInsertUserID] [audituserid] NOT NULL ,
	[dtmInsertDatetime] [auditdatetime] NOT NULL ,
	[chrUpdateUserID] [audituserid] NOT NULL ,
	[dtmUpdateDatetime] [auditdatetime] NOT NULL ,
	CONSTRAINT [PK__tblHuGEDocument___71BCD978] PRIMARY KEY  NONCLUSTERED 
	(
		[intHuGEDocumentHuGECategoryID],
		[intHuGEDocumentID],
		[intHuGECategoryID]
	) WITH  FILLFACTOR = 90  ON [PRIMARY] 
) ON [PRIMARY]
GO


CREATE TABLE [tblHuGEDocument_tblHuGEParty] (
	[intHuGEDocumentPartyID] [int] IDENTITY (1, 1) NOT NULL ,
	[intHuGEDocumentID] [int] NOT NULL ,
	[intHuGEPartyID] [int] NOT NULL ,
	[tintDocLastParty] [tinyint] NULL ,
	[tintDocPartySeq] [tinyint] NOT NULL ,
	[vchAffiliation] [varchar] (1000) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
	[vchInstitute] [varchar] (1000) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
	[chrCountry] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
	[chrCui] [varchar] (20) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
	[vchEmail] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
	[chrInsertUserID] [audituserid] NOT NULL ,
	[dtmInsertDatetime] [auditdatetime] NOT NULL ,
	[chrUpdateUserID] [audituserid] NOT NULL ,
	[dtmUpdateDatetime] [auditdatetime] NOT NULL ,
	CONSTRAINT [PK_tblHuGEDocument_tblHuGEParty] PRIMARY KEY  NONCLUSTERED 
	(
		[intHuGEDocumentPartyID],
		[intHuGEPartyID],
		[intHuGEDocumentID]
	) WITH  FILLFACTOR = 90  ON [PRIMARY] 
) ON [PRIMARY]
GO


CREATE TABLE [tblHuGEDocument_tblHuGEStudyType] (
	[intHuGEDocumentHuGEStudyTypeID] [int] IDENTITY (1, 1) NOT NULL ,
	[intHuGEDocumentID] [int] NOT NULL ,
	[intHuGEStudyTypeID] [int] NOT NULL ,
	[chrInsertUserID] [audituserid] NOT NULL ,
	[dtmInsertDatetime] [auditdatetime] NOT NULL ,
	[chrUpdateUserID] [audituserid] NOT NULL ,
	[dtmUpdateDatetime] [auditdatetime] NOT NULL ,
	CONSTRAINT [PK_tblHuGEDocument_tblHuGEStudyType] PRIMARY KEY  NONCLUSTERED 
	(
		[intHuGEDocumentHuGEStudyTypeID],
		[intHuGEDocumentID],
		[intHuGEStudyTypeID]
	) WITH  FILLFACTOR = 90  ON [PRIMARY] 
) ON [PRIMARY]
GO


CREATE TABLE [tblHuGEDocument_tblUMLSMain] (
	[intHuGEDocumentUMLSID] [int] IDENTITY (1, 1) NOT NULL ,
	[intHuGEDocumentID] [int] NOT NULL ,
	[chrPubMedID] [int] NULL ,
	[chrCUI] [char] (12) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
	[vchDocTermName] [varchar] (250) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
	[chrGeneSymbolFlag] [char] (1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
	[chrInsertUserID] [audituserid] NOT NULL ,
	[dtmInsertDatetime] [auditdatetime] NOT NULL ,
	[chrUpdateUserID] [audituserid] NOT NULL ,
	[dtmUpdateDatetime] [auditdatetime] NOT NULL ,
	CONSTRAINT [PK_tblHuGEDocument_tblUMLSMain] PRIMARY KEY  NONCLUSTERED 
	(
		[intHuGEDocumentUMLSID],
		[intHuGEDocumentID],
		[chrCUI]
	) WITH  FILLFACTOR = 90  ON [PRIMARY] 
) ON [PRIMARY]
GO


CREATE TABLE [tblSelectedMeshTree] (
	[intMeshTreeID] [int] IDENTITY (1, 1) NOT NULL ,
	[chrCUI] [char] (12) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
	[vchMeshTerm] [varchar] (900) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
	[vchMeSHTreeID] [varchar] (200) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
	[chrInsertUserID] [audituserid] NULL ,
	[dtmInsertDatetime] [auditdatetime] NULL ,
	[chrUpdateUserID] [audituserid] NULL ,
	[dtmUpdateDatetime] [auditdatetime] NULL ,
	CONSTRAINT [PK_tblSelectedMeshTree] PRIMARY KEY  NONCLUSTERED 
	(
		[intMeshTreeID]
	) WITH  FILLFACTOR = 90  ON [PRIMARY] 
) ON [PRIMARY]
GO

CREATE TABLE [tblSelectedUMLSMain] (
	[intUMLSMainID] [int] IDENTITY (1, 1) NOT NULL ,
	[chrCUI] [char] (12) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
	[chrSDUI] [char] (12) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
	[chrPref] [char] (1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
	[vchSource] [varchar] (20) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
	[vchTerm] [varchar] (800) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
	[chrInsertUserID] [audituserid] NULL ,
	[dtmInsertDatetime] [auditdatetime] NULL ,
	[chrUpdateUserID] [audituserid] NULL ,
	[dtmUpdateDatetime] [auditdatetime] NULL ,
	CONSTRAINT [PK_tblSelectedUMLSMain] PRIMARY KEY  NONCLUSTERED 
	(
		[intUMLSMainID],
		[chrCUI],
		[vchTerm]
	) WITH  FILLFACTOR = 90  ON [PRIMARY] 
) ON [PRIMARY]
GO


CREATE TABLE [tblUMLSDefinition] (
	[intUMLSDefinitionID] [int] IDENTITY (1, 1) NOT NULL ,
	[chrCUI] [char] (8) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
	[vchSource] [varchar] (20) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
	[vchDescription] [varchar] (2000) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
	CONSTRAINT [PK_tblUMLSDefinition] PRIMARY KEY  CLUSTERED 
	(
		[intUMLSDefinitionID]
	) WITH  FILLFACTOR = 90  ON [PRIMARY] 
) ON [PRIMARY]
GO


CREATE TABLE [tblUMLSemantic] (
	[chrCUI] [char] (8) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
	[vchSTY] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL 
) ON [PRIMARY]
GO


CREATE TABLE [tblUMLSMain] (
	[chrCUI] [char] (12) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
	[chrPREF] [char] (1) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
	[vchSDUI] [char] (12) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
	[vchSOURCE] [varchar] (20) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
	[vchTerm] [varchar] (900) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL 
) ON [PRIMARY]
GO





