USE [SEST]
GO
/****** Object:  Table [dbo].[TEC_FM_EQDiagramClass]    Script Date: 05/29/2012 23:48:30 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[TEC_FM_EQDiagramClass](
	[DiagramClass] [varchar](20) NOT NULL,
	[Writer] [varchar](20) NULL,
	[ITime] [datetime] NULL CONSTRAINT [DF_TEC_FM_DiagramClass_ITime]  DEFAULT (getdate()),
 CONSTRAINT [PK_TEC_FM_EQDiagramClass] PRIMARY KEY CLUSTERED 
(
	[DiagramClass] ASC
) ON [PRIMARY]
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[TEC_WaferSize]    Script Date: 05/29/2012 23:48:33 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[TEC_WaferSize](
	[WaferSize] [real] NOT NULL,
	[ITime] [datetime] NOT NULL CONSTRAINT [DF_TEC_WaferSize_ITime]  DEFAULT (getdate()),
 CONSTRAINT [PK_TEC_WaferSize] PRIMARY KEY CLUSTERED 
(
	[WaferSize] ASC
) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[TEC_ToolClass]    Script Date: 05/29/2012 23:47:52 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[TEC_ToolClass](
	[ToolClass] [varchar](30) NOT NULL,
	[ITime] [datetime] NOT NULL CONSTRAINT [DF_Table_1_ITime1]  DEFAULT (getdate()),
 CONSTRAINT [PK_TEC_ToolClass] PRIMARY KEY CLUSTERED 
(
	[ToolClass] ASC
) ON [PRIMARY]
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[TEC_FM_Data]    Script Date: 05/29/2012 23:48:26 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[TEC_FM_Data](
	[FMID] [int] NOT NULL,
	[FileType] [varchar](30) NOT NULL,
	[PN] [varchar](20) NULL,
	[CompanyID] [nvarchar](50) NULL,
	[FabID] [varchar](50) NULL,
	[ToolType] [varchar](50) NULL,
	[ToolZone] [varchar](50) NULL,
	[WaferSize] [real] NULL,
	[ToolClass] [varchar](20) NULL,
	[DiagramClass] [varchar](20) NULL,
	[PartsName] [varchar](50) NULL,
	[PartsNo] [varchar](50) NULL,
	[PartsType] [varchar](50) NULL,
	[PartsMaterial] [varchar](50) NULL,
	[TECDataClass] [varchar](50) NULL,
	[TECDataName] [varchar](50) NULL,
	[TECDataSource] [varchar](50) NULL,
	[SOPName] [varchar](50) NULL,
	[KeyWord] [varchar](50) NULL,
	[ManualName] [varchar](50) NULL,
	[Manufacturer] [varchar](50) NULL,
	[PartsMainClass] [varchar](50) NULL,
	[PartsSubClass] [varchar](50) NULL,
	[DocClass] [varchar](50) NULL,
	[OpinionProvenance] [varchar](50) NULL,
	[OpinionName] [varchar](50) NULL,
	[TroubleNo] [varchar](50) NULL,
	[OpinionNo] [varchar](50) NULL,
	[OccurTime] [datetime] NULL,
	[ProductSpecName] [varchar](50) NULL,
	[BriefingName] [varchar](50) NULL,
	[Comment] [varchar](512) NULL,
	[UploadUser] [varchar](20) NULL,
	[DownloadCount] [int] NOT NULL CONSTRAINT [DF_TEC_FM_DownloadCount]  DEFAULT ((0)),
	[IsDeleted] [bit] NOT NULL CONSTRAINT [DF_TEC_FM_Data_IsDeleted]  DEFAULT ((0)),
	[DeleteUser] [varchar](20) NULL,
	[ITime] [datetime] NOT NULL CONSTRAINT [DF_TEC_FM_ITime]  DEFAULT (getdate()),
 CONSTRAINT [PK_TEC_FM_Data] PRIMARY KEY CLUSTERED 
(
	[FMID] ASC
) ON [PRIMARY]
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO




外觀圖	SYS	2012/4/8 上午 11:47:17
電氣配線圖	SYS	2012/4/8 上午 11:47:57
管路圖	SYS	2012/4/8 上午 11:47:42


Batch Type	2012/4/10 下午 08:08:16
檢測機台	2012/4/10 下午 08:08:35
Single Wafer	2012/4/10 下午 08:08:42