USE [SEST] GO /****** Object: Table [dbo].[BaseData_TEC_TI_OrderType] Script Date: 09/26/2012 02:14:50 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO SET ANSI_PADDING ON GO CREATE TABLE [dbo].[BaseData_TEC_TI_OrderType]( [ID] [int] NOT NULL, [Name] [varchar](50) NOT NULL, [Description] [varchar](100) NOT NULL, [Writer] [varchar](20) NOT NULL, [ITime] [datetime] NOT NULL CONSTRAINT [DF_BaseData_TEC_TI_OrderType_ITime] DEFAULT (getdate()), CONSTRAINT [PK_BaseData_TEC_TI_OrderType] PRIMARY KEY CLUSTERED ( [ID] ASC ) ON [PRIMARY] ) ON [PRIMARY] GO SET ANSI_PADDING OFF GO 1 已受注 已受注 SYS 2012/9/9 下午 04:33:23 2 客戶另向其他廠商採購 客戶另向其他廠商採購 SYS 2012/9/9 下午 04:33:49 3 客戶無預算 客戶無預算 SYS 2012/9/9 下午 04:33:49 4 Pending 待追蹤 SYS 2012/9/9 下午 04:33:49 5 客戶持續觀察中 客戶持續觀察中 SYS 2012/9/9 下午 04:33:49 6 客戶不願更換 客戶不願更換 SYS 2012/9/9 下午 04:33:49 NULL NULL NULL NULL NULL