/****** Object:  Table [dbo].[unified_pathway_relationReference]    Script Date: 08/08/2016 18:58:40 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[unified_pathway_relationReference](
	[pathwayId] [varchar](50) NOT NULL,
	[referenceId] [varchar](max) NULL,
	[referenceDbName] [varchar](max) NULL,
	[pathwayDbId] [varchar](max) NOT NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[unified_pathway_relationPair]    Script Date: 08/08/2016 18:58:40 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[unified_pathway_relationPair](
	[pathwayId] [varchar](max) NULL,
	[interactionId] [varchar](max) NULL,
	[interactionType] [varchar](max) NULL,
	[nodeA] [varchar](max) NULL,
	[nodeB] [varchar](max) NULL,
	[controlType] [varchar](max) NULL,
	[pathwaydbId] [int] NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[unified_pathway_nameList]    Script Date: 08/08/2016 18:58:40 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[unified_pathway_nameList](
	[pathwayId] [varchar](300) NULL,
	[pathwayName] [varchar](300) NULL,
	[pathwayDbId] [varchar](50) NULL,
	[pId] [int] NOT NULL
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[unified_pathway_abstractNode]    Script Date: 08/08/2016 18:58:40 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[unified_pathway_abstractNode](
	[pathwayId] [varchar](300) NULL,
	[superNodeId] [varchar](300) NULL,
	[pathwayDbId] [varchar](50) NULL
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[unified_abstract_node_information]    Script Date: 08/08/2016 18:58:40 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[unified_abstract_node_information](
	[abstractNodeId] [varchar](430) NULL,
	[nodeName] [varchar](430) NULL,
	[nodeType] [varchar](430) NULL,
	[publicId] [varchar](430) NULL,
	[publicIddbName] [varchar](430) NULL
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[RNAhybridCutOff_valueLess_20]    Script Date: 08/08/2016 18:58:40 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[RNAhybridCutOff_valueLess_20](
	[Target_mRNA_RefSeq] [varchar](50) NULL,
	[Gene_Name] [varchar](50) NULL,
	[Target_mRNA_Chr] [varchar](50) NULL,
	[Target_mRNA_Strand] [varchar](50) NULL,
	[Target_mRNA_Start] [int] NULL,
	[Target_mRNA_Stop] [int] NULL,
	[MicroRNA_ID] [varchar](50) NULL,
	[MirNA_Conservation_Family] [varchar](50) NULL,
	[CLIP_Start] [int] NULL,
	[CLIP_Stop] [int] NULL,
	[mRNA_Exon_Start] [int] NULL,
	[mRNA_Exon_Stop] [int] NULL,
	[Binding_Site_Seq] [varchar](50) NULL,
	[microRNA_Reversed_Seed] [varchar](50) NULL,
	[Match_Distance2CLIP_3p] [int] NULL,
	[Match_Distance2CLIP_5p] [int] NULL,
	[MicroRNA_Seq] [varchar](50) NULL,
	[Hybridization_Energy] [float] NULL,
	[Strength_Score] [float] NULL,
	[BC1] [varchar](50) NULL,
	[EF3D_AGO2] [varchar](50) NULL,
	[hESC] [varchar](50) NULL,
	[HeLa] [varchar](50) NULL,
	[_293s] [varchar](50) NULL,
	[Human_Lymphoblastic] [varchar](50) NULL,
	[CCR_Conservation_Score] [float] NULL
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[Result_Ranked]    Script Date: 08/08/2016 18:58:40 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[Result_Ranked](
	[Target_mRNA_RefSeq] [varchar](50) NULL,
	[Gene_Name] [varchar](50) NULL,
	[Target_mRNA_Chr] [varchar](50) NULL,
	[Target_mRNA_Strand] [varchar](50) NULL,
	[Target_mRNA_Start] [int] NULL,
	[Target_mRNA_Stop] [int] NULL,
	[MicroRNA_ID] [varchar](50) NULL,
	[MirNA_Conservation_Family] [varchar](50) NULL,
	[CLIP_Start] [int] NULL,
	[CLIP_Stop] [int] NULL,
	[mRNA_Exon_Start] [int] NULL,
	[mRNA_Exon_Stop] [int] NULL,
	[Binding_Site_Seq] [varchar](50) NULL,
	[microRNA_Reversed_Seed] [varchar](50) NULL,
	[Match_Distance2CLIP_3p] [int] NULL,
	[Match_Distance2CLIP_5p] [int] NULL,
	[MicroRNA_Seq] [varchar](50) NULL,
	[Hybridization_Energy] [float] NULL,
	[Strength_Score] [float] NULL,
	[BC1] [varchar](50) NULL,
	[EF3D_AGO2] [varchar](50) NULL,
	[hESC] [varchar](50) NULL,
	[HeLa] [varchar](50) NULL,
	[_293s] [varchar](50) NULL,
	[Human_Lymphoblastic] [varchar](50) NULL,
	[CCR_Conservation_Score] [float] NULL
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[Reactome]    Script Date: 08/08/2016 18:58:40 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[Reactome](
	[Ensembl] [varchar](255) NULL,
	[Id] [varchar](255) NULL,
	[Link] [varchar](255) NULL,
	[Descriptions] [varchar](255) NULL,
	[Tag] [varchar](255) NULL,
	[Species] [varchar](255) NULL
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[Optimistic_RNAhybridCut_off]    Script Date: 08/08/2016 18:58:40 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[Optimistic_RNAhybridCut_off](
	[Target_mRNA_RefSeq] [varchar](50) NULL,
	[Gene_Name] [varchar](50) NULL,
	[Target_mRNA_Chr] [varchar](50) NULL,
	[Target_mRNA_Strand] [varchar](50) NULL,
	[Target_mRNA_Start] [int] NULL,
	[Target_mRNA_Stop] [int] NULL,
	[MicroRNA_ID] [varchar](50) NULL,
	[MirNA_Conservation_Family] [varchar](50) NULL,
	[CLIP_Start] [int] NULL,
	[CLIP_Stop] [int] NULL,
	[mRNA_Exon_Start] [int] NULL,
	[mRNA_Exon_Stop] [int] NULL,
	[Binding_Site_Seq] [varchar](50) NULL,
	[microRNA_Reversed_Seed] [varchar](50) NULL,
	[Match_Distance2CLIP_3p] [int] NULL,
	[Match_Distance2CLIP_5p] [int] NULL,
	[MicroRNA_Seq] [varchar](50) NULL,
	[Hybridization_Energy] [float] NULL,
	[Strength_Score] [float] NULL,
	[BC1] [varchar](50) NULL,
	[EF3D_AGO2] [varchar](50) NULL,
	[hESC] [varchar](50) NULL,
	[HeLa] [varchar](50) NULL,
	[_293s] [varchar](50) NULL,
	[Human_Lymphoblastic] [varchar](50) NULL,
	[CCR_Conservation_Score] [float] NULL
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[Optimistic_Predictions]    Script Date: 08/08/2016 18:58:40 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[Optimistic_Predictions](
	[Target_mRNA_RefSeq] [varchar](50) NULL,
	[Gene_Name] [varchar](50) NULL,
	[Target_mRNA_Chr] [varchar](50) NULL,
	[Target_mRNA_Strand] [varchar](50) NULL,
	[Target_mRNA_Start] [int] NULL,
	[Target_mRNA_Stop] [int] NULL,
	[MicroRNA_ID] [varchar](50) NULL,
	[MirNA_Conservation_Family] [varchar](50) NULL,
	[CLIP_Start] [int] NULL,
	[CLIP_Stop] [int] NULL,
	[mRNA_Exon_Start] [int] NULL,
	[mRNA_Exon_Stop] [int] NULL,
	[Binding_Site_Seq] [varchar](50) NULL,
	[microRNA_Reversed_Seed] [varchar](50) NULL,
	[Match_Distance2CLIP_3p] [int] NULL,
	[Match_Distance2CLIP_5p] [int] NULL,
	[MicroRNA_Seq] [varchar](50) NULL,
	[Hybridization_Energy] [float] NULL,
	[Strength_Score] [float] NULL,
	[BC1] [varchar](50) NULL,
	[EF3D_AGO2] [varchar](50) NULL,
	[hESC] [varchar](50) NULL,
	[HeLa] [varchar](50) NULL,
	[_293s] [varchar](50) NULL,
	[Human_Lymphoblastic] [varchar](50) NULL,
	[CCR_Conservation_Score] [float] NULL
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[MicroRNA_Expression]    Script Date: 08/08/2016 18:58:40 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[MicroRNA_Expression](
	[MicroRNA_ID] [varchar](50) NULL,
	[_hE] [float] NULL,
	[BC_EF_Hu] [float] NULL,
	[HE] [float] NULL,
	[_29] [float] NULL
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[Gene_ID_Map_Ensembl]    Script Date: 08/08/2016 18:58:40 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[Gene_ID_Map_Ensembl](
	[Ensembl_Gene_ID] [varchar](50) NULL,
	[Ensembl_Transcript_ID] [varchar](50) NULL,
	[Gene_Name] [varchar](50) NULL
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[Gene_ID_Map]    Script Date: 08/08/2016 18:58:40 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[Gene_ID_Map](
	[Gene_Name] [varchar](100) NULL,
	[Entrez_ID] [varchar](100) NULL,
	[Target_mRNA_RefSeq] [varchar](100) NULL
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
/****** Object:  Default [DF__unified_p__refer__34C8D9D1]    Script Date: 08/08/2016 18:58:40 ******/
ALTER TABLE [dbo].[unified_pathway_relationReference] ADD  CONSTRAINT [DF__unified_p__refer__34C8D9D1]  DEFAULT (NULL) FOR [referenceId]
GO
/****** Object:  Default [DF__unified_p__refer__35BCFE0A]    Script Date: 08/08/2016 18:58:40 ******/
ALTER TABLE [dbo].[unified_pathway_relationReference] ADD  CONSTRAINT [DF__unified_p__refer__35BCFE0A]  DEFAULT (NULL) FOR [referenceDbName]
GO
/****** Object:  Default [DF__unified_p__nodeA__300424B4]    Script Date: 08/08/2016 18:58:40 ******/
ALTER TABLE [dbo].[unified_pathway_relationPair] ADD  DEFAULT (NULL) FOR [nodeA]
GO
/****** Object:  Default [DF__unified_p__nodeB__30F848ED]    Script Date: 08/08/2016 18:58:40 ******/
ALTER TABLE [dbo].[unified_pathway_relationPair] ADD  DEFAULT (NULL) FOR [nodeB]
GO
/****** Object:  Default [DF__unified_p__contr__31EC6D26]    Script Date: 08/08/2016 18:58:40 ******/
ALTER TABLE [dbo].[unified_pathway_relationPair] ADD  DEFAULT (NULL) FOR [controlType]
GO
/****** Object:  Default [DF__unified_p__pathw__32E0915F]    Script Date: 08/08/2016 18:58:40 ******/
ALTER TABLE [dbo].[unified_pathway_relationPair] ADD  DEFAULT (NULL) FOR [pathwaydbId]
GO
/****** Object:  Default [DF__unified_p__pathw__2B3F6F97]    Script Date: 08/08/2016 18:58:40 ******/
ALTER TABLE [dbo].[unified_pathway_nameList] ADD  CONSTRAINT [DF__unified_p__pathw__2B3F6F97]  DEFAULT (NULL) FOR [pathwayId]
GO
/****** Object:  Default [DF__unified_p__pathw__2C3393D0]    Script Date: 08/08/2016 18:58:40 ******/
ALTER TABLE [dbo].[unified_pathway_nameList] ADD  CONSTRAINT [DF__unified_p__pathw__2C3393D0]  DEFAULT (NULL) FOR [pathwayName]
GO
/****** Object:  Default [DF__unified_p__pathw__2D27B809]    Script Date: 08/08/2016 18:58:40 ******/
ALTER TABLE [dbo].[unified_pathway_nameList] ADD  CONSTRAINT [DF__unified_p__pathw__2D27B809]  DEFAULT (NULL) FOR [pathwayDbId]
GO
/****** Object:  Default [DF__unified_pat__pId__2E1BDC42]    Script Date: 08/08/2016 18:58:40 ******/
ALTER TABLE [dbo].[unified_pathway_nameList] ADD  CONSTRAINT [DF__unified_pat__pId__2E1BDC42]  DEFAULT ('0') FOR [pId]
GO
/****** Object:  Default [DF__unified_p__pathw__276EDEB3]    Script Date: 08/08/2016 18:58:40 ******/
ALTER TABLE [dbo].[unified_pathway_abstractNode] ADD  CONSTRAINT [DF__unified_p__pathw__276EDEB3]  DEFAULT (NULL) FOR [pathwayId]
GO
/****** Object:  Default [DF__unified_p__super__286302EC]    Script Date: 08/08/2016 18:58:40 ******/
ALTER TABLE [dbo].[unified_pathway_abstractNode] ADD  CONSTRAINT [DF__unified_p__super__286302EC]  DEFAULT (NULL) FOR [superNodeId]
GO
/****** Object:  Default [DF__unified_p__pathw__29572725]    Script Date: 08/08/2016 18:58:40 ******/
ALTER TABLE [dbo].[unified_pathway_abstractNode] ADD  CONSTRAINT [DF__unified_p__pathw__29572725]  DEFAULT (NULL) FOR [pathwayDbId]
GO
/****** Object:  Default [DF__unified_a__abstr__22AA2996]    Script Date: 08/08/2016 18:58:40 ******/
ALTER TABLE [dbo].[unified_abstract_node_information] ADD  CONSTRAINT [DF__unified_a__abstr__22AA2996]  DEFAULT (NULL) FOR [abstractNodeId]
GO
/****** Object:  Default [DF__unified_a__nodeT__239E4DCF]    Script Date: 08/08/2016 18:58:40 ******/
ALTER TABLE [dbo].[unified_abstract_node_information] ADD  CONSTRAINT [DF__unified_a__nodeT__239E4DCF]  DEFAULT (NULL) FOR [nodeType]
GO
/****** Object:  Default [DF__unified_a__publi__24927208]    Script Date: 08/08/2016 18:58:40 ******/
ALTER TABLE [dbo].[unified_abstract_node_information] ADD  CONSTRAINT [DF__unified_a__publi__24927208]  DEFAULT (NULL) FOR [publicId]
GO
/****** Object:  Default [DF__unified_a__publi__25869641]    Script Date: 08/08/2016 18:58:40 ******/
ALTER TABLE [dbo].[unified_abstract_node_information] ADD  CONSTRAINT [DF__unified_a__publi__25869641]  DEFAULT (NULL) FOR [publicIddbName]
GO
