USE [CMS]
GO
/****** Object:  Table [dbo].[User]    Script Date: 6/30/2016 6:21:36 AM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[User](
	[User_ID] [int] IDENTITY(1,1) NOT NULL,
	[Account] [nvarchar](256) NULL,
	[Password] [nvarchar](256) NULL,
	[Name] [nvarchar](256) NULL,
	[role_ID] [int] NULL,
	[Online] [int] NULL,
	[ModifyUser] [nvarchar](256) NULL,
	[ModifyTime] [datetime] NOT NULL CONSTRAINT [DF_User_ModifyTime]  DEFAULT (getdate()),
 CONSTRAINT [PK_User] PRIMARY KEY CLUSTERED 
(
	[User_ID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]

GO
/****** Object:  Table [dbo].[基金]    Script Date: 6/30/2016 6:21:36 AM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[基金](
	[基金_ID] [int] NOT NULL,
	[IsReady] [binary](1) NOT NULL,
	[FundCode] [nchar](20) NOT NULL,
	[ClassInfo_ID] [int] NULL,
	[ClassInfo_Code] [nchar](10) NULL,
	[Info_ID] [int] NULL,
	[Info_Code] [nchar](10) NULL,
	[Area] [nchar](1) NULL,
	[ISIN_CODE] [nchar](12) NULL,
	[Name] [nvarchar](50) NULL,
	[NameEng] [nvarchar](50) NULL,
	[CP_ID] [int] NULL,
	[CP_Name] [nvarchar](50) NULL,
	[CP_NameEng] [nvarchar](100) NULL,
	[CT_ID] [int] NULL,
	[CT_Name] [nvarchar](50) NULL,
	[CT_NameEng] [nvarchar](50) NULL,
	[RCT_ID] [int] NULL,
	[RCT_Name] [nvarchar](50) NULL,
	[RCT_NameEng] [nvarchar](50) NULL,
	[InvestmentStrategy] [nvarchar](max) NULL,
	[InvestmentStrategyEng] [nvarchar](max) NULL,
	[Category_ID] [int] NULL,
	[Category_Name] [nvarchar](100) NULL,
	[Category_NameEng] [nvarchar](100) NULL,
	[BroadAssetClass_ID] [int] NULL,
	[BroadAssetClass_Name] [nvarchar](50) NULL,
	[BroadAssetClass_NameEng] [nvarchar](20) NULL,
	[PrimaryBenchMarkIndexName] [nvarchar](300) NULL,
	[PrimaryBenchMarkIndexNameEng] [nvarchar](300) NULL,
	[CatePrimaryIndex_ID] [int] NULL,
	[CatePrimaryIndex_Name] [nvarchar](100) NULL,
	[CatePrimaryIndex_NameEng] [nvarchar](100) NULL,
	[Custodian] [nvarchar](100) NULL,
	[TurnOverRatio] [decimal](19, 5) NULL,
	[InceptionYmdOn] [nchar](8) NULL,
	[Currency_Code] [nchar](10) NULL,
	[MSPrimaryIndex_ID] [int] NULL,
	[MSPrimaryIndex_Name] [nvarchar](100) NULL,
	[MSPrimaryIndex_NameEng] [nvarchar](100) NULL,
	[DistnbutionStatus] [nvarchar](50) NULL,
	[DividendDistributionFrequency] [nvarchar](20) NULL,
	[ManagementFee] [decimal](19, 5) NULL,
	[ManagementFeeUnit_ID] [int] NULL,
	[ManagementFeeUnit_Name] [nvarchar](50) NULL,
	[ManagementFeeUnit_NameEng] [nvarchar](50) NULL,
	[CustodianFee] [decimal](19, 5) NULL,
	[CustodianFeeUnit_ID] [int] NULL,
	[CustodianFeeUnit_Name] [nvarchar](50) NULL,
	[CustodianFeeUnit_NameEng] [nvarchar](50) NULL,
	[CustodianMaxFee] [decimal](19, 5) NULL,
	[FrontLoadFee] [decimal](19, 5) NULL,
	[FrontLoadFeeUnit_ID] [int] NULL,
	[FrontLoadFeeUnit_Name] [nvarchar](50) NULL,
	[FrontLoadFeeUnit_NameEng] [nvarchar](50) NULL,
	[MinInvestment] [decimal](19, 5) NULL,
	[MinInvestmentUnit] [nvarchar](20) NULL,
	[ExpenseRatioYmdOn] [nchar](8) NULL,
	[ExpenseRatio] [decimal](19, 5) NULL,
	[RiskLevel] [nchar](1) NULL,
	[Advisor_CP_ID] [int] NULL,
	[Agent_CP_ID] [int] NULL,
	[Subsequent_Inv] [decimal](19, 5) NULL,
	[SwitchingFee] [decimal](19, 5) NULL,
	[DeferLoadFee] [decimal](19, 5) NULL,
	[DelRmk] [binary](1) NOT NULL,
	[ModifyDate] [datetime] NOT NULL,
 CONSTRAINT [PK_基金] PRIMARY KEY CLUSTERED 
(
	[基金_ID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

GO
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[基金_基金組合]    Script Date: 6/30/2016 6:21:36 AM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[基金_基金組合](
	[基金_基金組合_ID] [int] IDENTITY(1,1) NOT NULL,
	[組別_ID] [int] NULL,
	[基金_ID] [int] NULL,
	[FUNDCODE] [nvarchar](50) NULL,
	[最後修改資料帳戶] [nvarchar](max) NULL,
	[最後修改資料時間] [datetime] NULL CONSTRAINT [DF_基金組合_最後修改資料時間]  DEFAULT (getdate()),
 CONSTRAINT [PK_基金組合] PRIMARY KEY CLUSTERED 
(
	[基金_基金組合_ID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

GO
/****** Object:  Table [dbo].[基金_關鍵字組合]    Script Date: 6/30/2016 6:21:36 AM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[基金_關鍵字組合](
	[基金_關鍵字組合_ID] [int] IDENTITY(1,1) NOT NULL,
	[組別_ID] [int] NULL,
	[關鍵字_ID] [int] NULL,
	[關鍵字詞] [nvarchar](max) NULL,
	[權重] [int] NULL,
	[有效碼] [int] NULL,
	[最後修改資料帳戶] [nvarchar](max) NULL,
	[最後修改資料時間] [datetime] NULL CONSTRAINT [DF_基金_關鍵字組合_最後修改資料時間]  DEFAULT (getdate()),
 CONSTRAINT [PK_基金_關鍵字組合] PRIMARY KEY CLUSTERED 
(
	[基金_關鍵字組合_ID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

GO
/****** Object:  Table [dbo].[帳號]    Script Date: 6/30/2016 6:21:36 AM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[帳號](
	[帳號_ID] [int] IDENTITY(1,1) NOT NULL,
	[帳號] [nvarchar](50) NOT NULL,
	[密碼] [nvarchar](50) NOT NULL,
	[姓名] [nvarchar](50) NULL,
	[角色權限_ID] [int] NOT NULL,
	[有效碼] [int] NULL,
	[最後修改資料帳戶] [nvarchar](50) NULL,
	[最後修改資料時間] [datetime] NULL,
 CONSTRAINT [PK_帳號] PRIMARY KEY CLUSTERED 
(
	[帳號_ID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]

GO
/****** Object:  Table [dbo].[版位]    Script Date: 6/30/2016 6:21:36 AM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[版位](
	[版位_ID] [int] IDENTITY(1,1) NOT NULL,
	[版位代碼] [nvarchar](max) NULL,
	[內容描述] [nvarchar](max) NULL,
	[版位尺寸] [nvarchar](max) NULL,
	[格式型態] [int] NULL,
	[輪撥方式] [int] NULL,
	[版位有效碼] [int] NOT NULL CONSTRAINT [DF_版位_版位有效碼]  DEFAULT ((0)),
	[最後修改資料帳戶] [nvarchar](max) NULL,
	[最後修改資料時間] [datetime] NULL CONSTRAINT [DF_版位_最後修改資料時間]  DEFAULT (getdate()),
 CONSTRAINT [PK_版位] PRIMARY KEY CLUSTERED 
(
	[版位_ID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

GO
/****** Object:  Table [dbo].[版位配置]    Script Date: 6/30/2016 6:21:36 AM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[版位配置](
	[版位配置_ID] [int] IDENTITY(1,1) NOT NULL,
	[版位_ID] [int] NULL,
	[素材_ID] [int] NULL,
 CONSTRAINT [PK_版素配置] PRIMARY KEY CLUSTERED 
(
	[版位配置_ID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]

GO
/****** Object:  Table [dbo].[研報]    Script Date: 6/30/2016 6:21:36 AM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[研報](
	[研報_ID] [int] IDENTITY(1,1) NOT NULL,
	[研報標題] [nvarchar](256) NULL,
	[研報摘要] [nvarchar](max) NULL,
	[提供單位] [nvarchar](256) NULL,
	[實體檔案] [nvarchar](max) NULL,
	[開始日期] [datetime] NULL,
	[結束日期] [datetime] NULL,
	[曝光點閱數] [int] NULL,
	[實際點閱數] [int] NULL,
	[有效碼] [int] NULL,
	[最後修改資料帳戶] [nvarchar](max) NULL,
	[最後修改資料時間] [datetime] NULL,
 CONSTRAINT [PK_研報] PRIMARY KEY CLUSTERED 
(
	[研報_ID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

GO
/****** Object:  Table [dbo].[研報_基金組合]    Script Date: 6/30/2016 6:21:36 AM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[研報_基金組合](
	[研報_基金組合_ID] [int] IDENTITY(1,1) NOT NULL,
	[組別_ID] [int] NULL,
	[FUNDCODE] [nvarchar](50) NULL,
	[最後修改資料帳戶] [nvarchar](max) NULL,
	[最後修改資料時間] [datetime] NULL,
 CONSTRAINT [PK_研報_基金組合] PRIMARY KEY CLUSTERED 
(
	[研報_基金組合_ID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

GO
/****** Object:  Table [dbo].[研報_關鍵字組合]    Script Date: 6/30/2016 6:21:36 AM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[研報_關鍵字組合](
	[研報_關鍵字組合_ID] [int] IDENTITY(1,1) NOT NULL,
	[組別_ID] [int] NULL,
	[關鍵字_ID] [int] NULL,
	[關鍵字詞] [nvarchar](max) NULL,
	[權重] [int] NULL,
	[有效碼] [int] NULL,
	[最後修改資料帳戶] [nvarchar](max) NULL,
	[最後修改資料時間] [datetime] NULL,
 CONSTRAINT [PK_研報_關鍵字組合] PRIMARY KEY CLUSTERED 
(
	[研報_關鍵字組合_ID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

GO
/****** Object:  Table [dbo].[素材]    Script Date: 6/30/2016 6:21:36 AM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[素材](
	[素材_ID] [int] IDENTITY(1,1) NOT NULL,
	[素材代碼] [nvarchar](50) NULL,
	[版位區塊] [nvarchar](max) NULL,
	[素材標題] [nvarchar](max) NULL,
	[素材摘要] [nvarchar](max) NULL,
	[素材尺寸_寬] [int] NULL,
	[素材尺寸_高] [int] NULL,
	[到達網址] [nvarchar](max) NULL,
	[替代文字] [nvarchar](max) NULL,
	[圖片path] [nvarchar](max) NULL,
	[HTML5碼] [nvarchar](max) NULL,
	[目標視窗] [int] NULL,
	[放送開始時間] [datetime] NULL,
	[放送結束時間] [datetime] NULL,
	[關鍵字組合] [nvarchar](max) NULL,
	[曝光率權重] [int] NULL,
	[素材有效碼] [int] NULL CONSTRAINT [DF_素材_素材有效碼]  DEFAULT ((0)),
	[最後修改資料帳戶] [datetime] NULL,
	[最後修改資料時間] [datetime] NULL CONSTRAINT [DF_素材_最後修改資料時間]  DEFAULT (getdate()),
 CONSTRAINT [PK_素材] PRIMARY KEY CLUSTERED 
(
	[素材_ID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

GO
/****** Object:  Table [dbo].[組別]    Script Date: 6/30/2016 6:21:36 AM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[組別](
	[組別_ID] [int] IDENTITY(1,1) NOT NULL,
	[組別類別_ID] [int] NULL,
	[組別名稱] [nvarchar](max) NULL,
	[組別內容描述] [nvarchar](max) NULL,
	[關鍵字_ID] [nvarchar](max) NULL,
	[基金_ID] [nvarchar](max) NULL,
	[組別有效碼] [bit] NULL,
	[最後修改資料帳戶] [nvarchar](max) NULL,
	[最後修改資料時間] [datetime] NULL CONSTRAINT [DF_組別_最後修改資料時間]  DEFAULT (getdate()),
 CONSTRAINT [PK_組別] PRIMARY KEY CLUSTERED 
(
	[組別_ID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

GO
/****** Object:  Table [dbo].[議題]    Script Date: 6/30/2016 6:21:36 AM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[議題](
	[議題_ID] [int] IDENTITY(1,1) NOT NULL,
	[大標] [nvarchar](256) NULL,
	[小標] [nvarchar](256) NULL,
	[摘要] [nvarchar](max) NULL,
	[圖檔] [nvarchar](256) NULL,
	[內文] [nvarchar](max) NULL,
	[開始日期] [datetime] NULL,
	[結束日期] [datetime] NULL,
	[曝光率權重] [int] NULL,
	[有效碼] [int] NULL,
	[最後修改資料帳戶] [nvarchar](50) NULL,
	[最後修改資料時間] [datetime] NULL,
 CONSTRAINT [PK_議題] PRIMARY KEY CLUSTERED 
(
	[議題_ID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

GO
/****** Object:  Table [dbo].[議題_基金組合]    Script Date: 6/30/2016 6:21:36 AM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[議題_基金組合](
	[議題_基金組合_ID] [int] IDENTITY(1,1) NOT NULL,
	[組別_ID] [int] NULL,
	[FUNDCODE] [nvarchar](50) NULL,
	[最後修改資料帳戶] [nvarchar](50) NULL,
	[最後修改資料時間] [datetime] NULL,
 CONSTRAINT [PK_議題_基金組合] PRIMARY KEY CLUSTERED 
(
	[議題_基金組合_ID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]

GO
/****** Object:  Table [dbo].[議題_關鍵字組合]    Script Date: 6/30/2016 6:21:36 AM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[議題_關鍵字組合](
	[議題_關鍵字組合_ID] [int] IDENTITY(1,1) NOT NULL,
	[組別_ID] [int] NULL,
	[關鍵字_ID] [int] NULL,
	[最後修改資料帳戶] [nvarchar](50) NULL,
	[最後修改資料時間] [datetime] NULL,
 CONSTRAINT [PK_議題_關鍵字組合] PRIMARY KEY CLUSTERED 
(
	[議題_關鍵字組合_ID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]

GO
/****** Object:  Table [dbo].[關鍵字]    Script Date: 6/30/2016 6:21:36 AM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[關鍵字](
	[關鍵字_ID] [int] IDENTITY(1,1) NOT NULL,
	[關鍵字群組_ID] [int] NULL,
	[關鍵字詞] [nvarchar](max) NULL,
	[內容描述] [nvarchar](256) NULL,
	[有效碼] [bit] NULL,
	[最後修改資料帳戶] [nvarchar](max) NULL,
	[最後修改資料時間] [datetime] NULL CONSTRAINT [DF_關鍵字_最後修改資料時間]  DEFAULT (getdate()),
 CONSTRAINT [PK_關鍵字] PRIMARY KEY CLUSTERED 
(
	[關鍵字_ID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

GO
/****** Object:  Table [dbo].[關鍵字群組]    Script Date: 6/30/2016 6:21:36 AM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[關鍵字群組](
	[關鍵字群組_ID] [int] IDENTITY(1,1) NOT NULL,
	[名稱] [nvarchar](max) NULL,
	[最後修改資料帳戶] [nvarchar](max) NULL,
	[最後修改資料時間] [datetime] NULL CONSTRAINT [DF_關鍵字群組_最後修改資料時間]  DEFAULT (getdate()),
 CONSTRAINT [PK_關鍵字群組] PRIMARY KEY CLUSTERED 
(
	[關鍵字群組_ID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

GO
ALTER TABLE [dbo].[帳號] ADD  CONSTRAINT [DF_帳號_有效碼]  DEFAULT ((0)) FOR [有效碼]
GO
ALTER TABLE [dbo].[帳號] ADD  CONSTRAINT [DF_帳號_最後修改資料時間]  DEFAULT (getdate()) FOR [最後修改資料時間]
GO
ALTER TABLE [dbo].[研報] ADD  CONSTRAINT [DF_研報_有效碼]  DEFAULT ((0)) FOR [有效碼]
GO
ALTER TABLE [dbo].[研報] ADD  CONSTRAINT [DF_研報_最後修改資料時間]  DEFAULT (getdate()) FOR [最後修改資料時間]
GO
ALTER TABLE [dbo].[研報_基金組合] ADD  CONSTRAINT [DF_研報_基金組合_最後修改資料時間]  DEFAULT (getdate()) FOR [最後修改資料時間]
GO
ALTER TABLE [dbo].[研報_關鍵字組合] ADD  CONSTRAINT [DF_研報_關鍵字組合_有效碼]  DEFAULT ((0)) FOR [有效碼]
GO
ALTER TABLE [dbo].[研報_關鍵字組合] ADD  CONSTRAINT [DF_研報_關鍵字組合_最後修改資料時間]  DEFAULT (getdate()) FOR [最後修改資料時間]
GO
ALTER TABLE [dbo].[議題_基金組合] ADD  CONSTRAINT [DF_議題_基金組合_最後修改資料時間]  DEFAULT (getdate()) FOR [最後修改資料時間]
GO
ALTER TABLE [dbo].[議題_關鍵字組合] ADD  CONSTRAINT [DF_議題_關鍵字組合_最後修改資料時間]  DEFAULT (getdate()) FOR [最後修改資料時間]
GO
ALTER TABLE [dbo].[版位配置]  WITH CHECK ADD  CONSTRAINT [FK_版位配置_版位] FOREIGN KEY([版位_ID])
REFERENCES [dbo].[版位] ([版位_ID])
GO
ALTER TABLE [dbo].[版位配置] CHECK CONSTRAINT [FK_版位配置_版位]
GO
ALTER TABLE [dbo].[版位配置]  WITH CHECK ADD  CONSTRAINT [FK_版位配置_素材] FOREIGN KEY([素材_ID])
REFERENCES [dbo].[素材] ([素材_ID])
GO
ALTER TABLE [dbo].[版位配置] CHECK CONSTRAINT [FK_版位配置_素材]
GO