本文共 4272 字，大约阅读时间需要 14 分钟。

USE [OA.Film]GO/****** Object:  Table [dbo].[FM_Product]    Script Date: 03/03/2018 19:51:20 ******/SET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGOCREATE TABLE [dbo].[FM_Product](	[ID] [uniqueidentifier] NOT NULL,	[CategoryID] [uniqueidentifier] NULL,	[Name] [nvarchar](200) NULL,	[ImageID] [nvarchar](200) NULL,	[Score] [decimal](18, 1) NULL,	[Duration] [time](7) NULL,	[Country] [nvarchar](50) NULL,	[Year] [int] NULL,	[CanRead] [bit] NULL,	[IsDeleted] [bit] NULL,	[EmplID] [nvarchar](50) NULL,	[DeptID] [nvarchar](50) NULL,	[UpdateEmplID] [nvarchar](50) NULL,	[UpdateTime] [datetime] NULL,	[CreateTime] [datetime] NULL,	[Version] [int] NOT NULL, CONSTRAINT [PK_FM_Product] 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].[FM_Link]    Script Date: 03/03/2018 19:51:20 ******/SET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGOCREATE TABLE [dbo].[FM_Link](	[ID] [uniqueidentifier] NOT NULL,	[ProductID] [uniqueidentifier] NULL,	[LinkType] [int] NULL,	[Address] [nvarchar](1000) NULL,	[CommitIP] [nvarchar](50) NULL,	[AuditStatus] [int] NULL,	[EmplID] [nvarchar](50) NULL,	[DeptID] [nvarchar](50) NULL,	[UpdateEmplID] [nvarchar](50) NULL,	[UpdateTime] [datetime] NULL,	[CreateTime] [datetime] NULL,	[AuditTime] [datetime] NULL,	[Version] [int] NOT NULL, CONSTRAINT [PK_FM_Link] 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].[FM_ContentImage]    Script Date: 03/03/2018 19:51:20 ******/SET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGOCREATE TABLE [dbo].[FM_ContentImage](	[ID] [uniqueidentifier] NOT NULL,	[FileID] [nvarchar](50) NULL,	[EmplID] [nvarchar](50) NULL,	[DeptID] [nvarchar](50) NULL,	[UpdateEmplID] [nvarchar](50) NULL,	[UpdateTime] [datetime] NULL,	[CreateTime] [datetime] NULL,	[Version] [int] NOT NULL, CONSTRAINT [PK_FM_ContentImage] 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].[FM_Content]    Script Date: 03/03/2018 19:51:20 ******/SET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGOCREATE TABLE [dbo].[FM_Content](	[ID] [uniqueidentifier] NOT NULL,	[Introduction] [nvarchar](max) NULL,	[ReadCount] [int] NULL,	[DownLoadCount] [int] NULL,	[EmplID] [nvarchar](50) NULL,	[DeptID] [nvarchar](50) NULL,	[UpdateEmplID] [nvarchar](50) NULL,	[UpdateTime] [datetime] NULL,	[CreateTime] [datetime] NULL,	[Version] [int] NOT NULL, CONSTRAINT [PK_FM_Content] 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].[FM_Category]    Script Date: 03/03/2018 19:51:20 ******/SET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGOCREATE TABLE [dbo].[FM_Category](	[ID] [uniqueidentifier] NOT NULL,	[Name] [nvarchar](50) NULL,	[ParentID] [uniqueidentifier] NULL,	[EmplID] [nvarchar](50) NULL,	[DeptID] [nvarchar](50) NULL,	[UpdateEmplID] [nvarchar](50) NULL,	[UpdateTime] [datetime] NULL,	[CreateTime] [datetime] NULL,	[Version] [int] NOT NULL, CONSTRAINT [PK_FM_Category] 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].[FM_Author]    Script Date: 03/03/2018 19:51:20 ******/SET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGOCREATE TABLE [dbo].[FM_Author](	[ID] [uniqueidentifier] NOT NULL,	[ProductID] [uniqueidentifier] NULL,	[Name] [nvarchar](50) NULL,	[AuhorType] [int] NULL,	[EmplID] [nvarchar](50) NULL,	[DeptID] [nvarchar](50) NULL,	[UpdateEmplID] [nvarchar](50) NULL,	[UpdateTime] [datetime] NULL,	[CreateTime] [datetime] NULL,	[Version] [int] NOT NULL, CONSTRAINT [PK_FM_Author] 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