USE [DB_HRMS]
਍䜀伀ഀഀ
/****** Object:  Table [dbo].[TIMESHEET]    Script Date: 06/10/2014 15:22:37 ******/
਍匀䔀吀 䄀一匀䤀开一唀䰀䰀匀 伀一ഀഀ
GO
਍匀䔀吀 儀唀伀吀䔀䐀开䤀䐀䔀一吀䤀䘀䤀䔀刀 伀一ഀഀ
GO
਍䌀刀䔀䄀吀䔀 吀䄀䈀䰀䔀 嬀搀戀漀崀⸀嬀吀䤀䴀䔀匀䠀䔀䔀吀崀⠀ഀഀ
	[TS_ID] [int] IDENTITY(1,1) NOT NULL,
਍ऀ嬀吀匀开䐀䔀匀䌀崀 嬀渀瘀愀爀挀栀愀爀崀⠀㌀　⤀ 一伀吀 一唀䰀䰀Ⰰഀഀ
	[TS_REF] [nvarchar](20) NOT NULL,
਍ऀ嬀伀刀䜀开䤀䐀崀 嬀椀渀琀崀 一伀吀 一唀䰀䰀Ⰰഀഀ
	[COY_ID] [int] NOT NULL,
਍ऀ嬀圀伀刀䬀匀吀䄀吀䤀伀一开䤀䐀崀 嬀渀瘀愀爀挀栀愀爀崀⠀㌀　⤀ 一伀吀 一唀䰀䰀Ⰰഀഀ
	[CREATE_BY] [int] NOT NULL,
਍ऀ嬀䌀刀䔀䄀吀䔀开䐀䄀吀䔀崀 嬀搀愀琀攀琀椀洀攀崀 一伀吀 一唀䰀䰀Ⰰഀഀ
	[MODIFY_BY] [int] NOT NULL,
਍ऀ嬀䴀伀䐀䤀䘀夀开䐀䄀吀䔀崀 嬀搀愀琀攀琀椀洀攀崀 一伀吀 一唀䰀䰀Ⰰഀഀ
	[START_DATE] [datetime] NOT NULL,
਍ऀ嬀䔀堀倀䤀刀夀开䐀䄀吀䔀崀 嬀搀愀琀攀琀椀洀攀崀 一伀吀 一唀䰀䰀Ⰰഀഀ
	[BILLABLE] [bit] NOT NULL,
਍ऀ嬀倀刀伀䨀䔀䌀吀开䤀䐀崀 嬀椀渀琀崀 一伀吀 一唀䰀䰀Ⰰഀഀ
	[ACT_ID] [int] NOT NULL,
਍ऀ嬀䔀䴀倀开䤀䐀崀 嬀椀渀琀崀 一伀吀 一唀䰀䰀Ⰰഀഀ
 CONSTRAINT [PK_TIMESHEET] PRIMARY KEY CLUSTERED 
਍⠀ഀഀ
	[TS_ID] ASC
਍⤀圀䤀吀䠀 ⠀倀䄀䐀开䤀一䐀䔀堀  㴀 伀䘀䘀Ⰰ 匀吀䄀吀䤀匀吀䤀䌀匀开一伀刀䔀䌀伀䴀倀唀吀䔀  㴀 伀䘀䘀Ⰰ 䤀䜀一伀刀䔀开䐀唀倀开䬀䔀夀 㴀 伀䘀䘀Ⰰ 䄀䰀䰀伀圀开刀伀圀开䰀伀䌀䬀匀  㴀 伀一Ⰰ 䄀䰀䰀伀圀开倀䄀䜀䔀开䰀伀䌀䬀匀  㴀 伀一⤀ 伀一 嬀倀刀䤀䴀䄀刀夀崀ഀഀ
) ON [PRIMARY]
਍䜀伀ഀഀ
/****** Object:  Table [dbo].[PROJECT]    Script Date: 06/10/2014 15:22:37 ******/
਍匀䔀吀 䄀一匀䤀开一唀䰀䰀匀 伀一ഀഀ
GO
਍匀䔀吀 儀唀伀吀䔀䐀开䤀䐀䔀一吀䤀䘀䤀䔀刀 伀一ഀഀ
GO
਍䌀刀䔀䄀吀䔀 吀䄀䈀䰀䔀 嬀搀戀漀崀⸀嬀倀刀伀䨀䔀䌀吀崀⠀ഀഀ
	[PROJ_ID] [int] IDENTITY(1,1) NOT NULL,
਍ऀ嬀倀刀伀䨀开䐀䔀匀䌀崀 嬀渀瘀愀爀挀栀愀爀崀⠀㌀　⤀ 一伀吀 一唀䰀䰀Ⰰഀഀ
	[PROJ_REF] [nvarchar](20) NOT NULL,
਍ऀ嬀伀刀䜀开䤀䐀崀 嬀椀渀琀崀 一伀吀 一唀䰀䰀Ⰰഀഀ
	[COY_ID] [int] NOT NULL,
਍ऀ嬀圀伀刀䬀匀吀䄀吀䤀伀一开䤀䐀崀 嬀渀瘀愀爀挀栀愀爀崀⠀㌀　⤀ 一伀吀 一唀䰀䰀Ⰰഀഀ
	[CREATE_BY] [int] NOT NULL,
਍ऀ嬀䌀刀䔀䄀吀䔀开䐀䄀吀䔀崀 嬀搀愀琀攀琀椀洀攀崀 一伀吀 一唀䰀䰀Ⰰഀഀ
	[MODIFY_BY] [int] NOT NULL,
਍ऀ嬀䴀伀䐀䤀䘀夀开䐀䄀吀䔀崀 嬀搀愀琀攀琀椀洀攀崀 一伀吀 一唀䰀䰀Ⰰഀഀ
 CONSTRAINT [PK_PROJECT] PRIMARY KEY CLUSTERED 
਍⠀ഀഀ
	[PROJ_ID] ASC
਍⤀圀䤀吀䠀 ⠀倀䄀䐀开䤀一䐀䔀堀  㴀 伀䘀䘀Ⰰ 匀吀䄀吀䤀匀吀䤀䌀匀开一伀刀䔀䌀伀䴀倀唀吀䔀  㴀 伀䘀䘀Ⰰ 䤀䜀一伀刀䔀开䐀唀倀开䬀䔀夀 㴀 伀䘀䘀Ⰰ 䄀䰀䰀伀圀开刀伀圀开䰀伀䌀䬀匀  㴀 伀一Ⰰ 䄀䰀䰀伀圀开倀䄀䜀䔀开䰀伀䌀䬀匀  㴀 伀一⤀ 伀一 嬀倀刀䤀䴀䄀刀夀崀ഀഀ
) ON [PRIMARY]
਍䜀伀ഀഀ
/****** Object:  Table [dbo].[ACTIVITY]    Script Date: 06/10/2014 15:22:37 ******/
਍匀䔀吀 䄀一匀䤀开一唀䰀䰀匀 伀一ഀഀ
GO
਍匀䔀吀 儀唀伀吀䔀䐀开䤀䐀䔀一吀䤀䘀䤀䔀刀 伀一ഀഀ
GO
਍䌀刀䔀䄀吀䔀 吀䄀䈀䰀䔀 嬀搀戀漀崀⸀嬀䄀䌀吀䤀嘀䤀吀夀崀⠀ഀഀ
	[ACT_ID] [int] IDENTITY(1,1) NOT NULL,
਍ऀ嬀䄀䌀吀开䐀䔀匀䌀崀 嬀渀瘀愀爀挀栀愀爀崀⠀㌀　⤀ 一伀吀 一唀䰀䰀Ⰰഀഀ
	[ACT_REF] [nvarchar](20) NOT NULL,
਍ऀ嬀伀刀䜀开䤀䐀崀 嬀椀渀琀崀 一伀吀 一唀䰀䰀Ⰰഀഀ
	[COY_ID] [int] NOT NULL,
਍ऀ嬀圀伀刀䬀匀吀䄀吀䤀伀一开䤀䐀崀 嬀渀瘀愀爀挀栀愀爀崀⠀㌀　⤀ 一伀吀 一唀䰀䰀Ⰰഀഀ
	[CREATE_BY] [int] NOT NULL,
਍ऀ嬀䌀刀䔀䄀吀䔀开䐀䄀吀䔀崀 嬀搀愀琀攀琀椀洀攀崀 一伀吀 一唀䰀䰀Ⰰഀഀ
	[MODIFY_BY] [int] NOT NULL,
਍ऀ嬀䴀伀䐀䤀䘀夀开䐀䄀吀䔀崀 嬀搀愀琀攀琀椀洀攀崀 一伀吀 一唀䰀䰀Ⰰഀഀ
 CONSTRAINT [PK_ACTIVITY] PRIMARY KEY CLUSTERED 
਍⠀ഀഀ
	[ACT_ID] ASC
਍⤀圀䤀吀䠀 ⠀倀䄀䐀开䤀一䐀䔀堀  㴀 伀䘀䘀Ⰰ 匀吀䄀吀䤀匀吀䤀䌀匀开一伀刀䔀䌀伀䴀倀唀吀䔀  㴀 伀䘀䘀Ⰰ 䤀䜀一伀刀䔀开䐀唀倀开䬀䔀夀 㴀 伀䘀䘀Ⰰ 䄀䰀䰀伀圀开刀伀圀开䰀伀䌀䬀匀  㴀 伀一Ⰰ 䄀䰀䰀伀圀开倀䄀䜀䔀开䰀伀䌀䬀匀  㴀 伀一⤀ 伀一 嬀倀刀䤀䴀䄀刀夀崀ഀഀ
) ON [PRIMARY]
਍䜀伀ഀഀ
/****** Object:  Default [DF_ACTIVITY_ACT_DESC]    Script Date: 06/10/2014 15:22:37 ******/
਍䄀䰀吀䔀刀 吀䄀䈀䰀䔀 嬀搀戀漀崀⸀嬀䄀䌀吀䤀嘀䤀吀夀崀 䄀䐀䐀  䌀伀一匀吀刀䄀䤀一吀 嬀䐀䘀开䄀䌀吀䤀嘀䤀吀夀开䄀䌀吀开䐀䔀匀䌀崀  䐀䔀䘀䄀唀䰀吀 ⠀✀✀⤀ 䘀伀刀 嬀䄀䌀吀开䐀䔀匀䌀崀ഀഀ
GO
਍⼀⨀⨀⨀⨀⨀⨀ 伀戀樀攀挀琀㨀  䐀攀昀愀甀氀琀 嬀䐀䘀开䄀䌀吀䤀嘀䤀吀夀开䄀䌀吀开刀䔀䘀崀    匀挀爀椀瀀琀 䐀愀琀攀㨀 　㘀⼀㄀　⼀㈀　㄀㐀 ㄀㔀㨀㈀㈀㨀㌀㜀 ⨀⨀⨀⨀⨀⨀⼀ഀഀ
ALTER TABLE [dbo].[ACTIVITY] ADD  CONSTRAINT [DF_ACTIVITY_ACT_REF]  DEFAULT ('') FOR [ACT_REF]
਍䜀伀ഀഀ
/****** Object:  Default [DF_ACTIVITY_ORG_ID]    Script Date: 06/10/2014 15:22:37 ******/
਍䄀䰀吀䔀刀 吀䄀䈀䰀䔀 嬀搀戀漀崀⸀嬀䄀䌀吀䤀嘀䤀吀夀崀 䄀䐀䐀  䌀伀一匀吀刀䄀䤀一吀 嬀䐀䘀开䄀䌀吀䤀嘀䤀吀夀开伀刀䜀开䤀䐀崀  䐀䔀䘀䄀唀䰀吀 ⠀⠀　⤀⤀ 䘀伀刀 嬀伀刀䜀开䤀䐀崀ഀഀ
GO
਍⼀⨀⨀⨀⨀⨀⨀ 伀戀樀攀挀琀㨀  䐀攀昀愀甀氀琀 嬀䐀䘀开䄀䌀吀䤀嘀䤀吀夀开䌀伀夀开䤀䐀崀    匀挀爀椀瀀琀 䐀愀琀攀㨀 　㘀⼀㄀　⼀㈀　㄀㐀 ㄀㔀㨀㈀㈀㨀㌀㜀 ⨀⨀⨀⨀⨀⨀⼀ഀഀ
ALTER TABLE [dbo].[ACTIVITY] ADD  CONSTRAINT [DF_ACTIVITY_COY_ID]  DEFAULT ((0)) FOR [COY_ID]
਍䜀伀ഀഀ
/****** Object:  Default [DF_ACTIVITY_WORKSTATION_ID]    Script Date: 06/10/2014 15:22:37 ******/
਍䄀䰀吀䔀刀 吀䄀䈀䰀䔀 嬀搀戀漀崀⸀嬀䄀䌀吀䤀嘀䤀吀夀崀 䄀䐀䐀  䌀伀一匀吀刀䄀䤀一吀 嬀䐀䘀开䄀䌀吀䤀嘀䤀吀夀开圀伀刀䬀匀吀䄀吀䤀伀一开䤀䐀崀  䐀䔀䘀䄀唀䰀吀 ⠀✀✀⤀ 䘀伀刀 嬀圀伀刀䬀匀吀䄀吀䤀伀一开䤀䐀崀ഀഀ
GO
਍⼀⨀⨀⨀⨀⨀⨀ 伀戀樀攀挀琀㨀  䐀攀昀愀甀氀琀 嬀䐀䘀开䄀䌀吀䤀嘀䤀吀夀开䌀刀䔀䄀吀䔀开䈀夀崀    匀挀爀椀瀀琀 䐀愀琀攀㨀 　㘀⼀㄀　⼀㈀　㄀㐀 ㄀㔀㨀㈀㈀㨀㌀㜀 ⨀⨀⨀⨀⨀⨀⼀ഀഀ
ALTER TABLE [dbo].[ACTIVITY] ADD  CONSTRAINT [DF_ACTIVITY_CREATE_BY]  DEFAULT ((0)) FOR [CREATE_BY]
਍䜀伀ഀഀ
/****** Object:  Default [DF_ACTIVITY_CREATE_DATE]    Script Date: 06/10/2014 15:22:37 ******/
਍䄀䰀吀䔀刀 吀䄀䈀䰀䔀 嬀搀戀漀崀⸀嬀䄀䌀吀䤀嘀䤀吀夀崀 䄀䐀䐀  䌀伀一匀吀刀䄀䤀一吀 嬀䐀䘀开䄀䌀吀䤀嘀䤀吀夀开䌀刀䔀䄀吀䔀开䐀䄀吀䔀崀  䐀䔀䘀䄀唀䰀吀 ⠀最攀琀搀愀琀攀⠀⤀⤀ 䘀伀刀 嬀䌀刀䔀䄀吀䔀开䐀䄀吀䔀崀ഀഀ
GO
਍⼀⨀⨀⨀⨀⨀⨀ 伀戀樀攀挀琀㨀  䐀攀昀愀甀氀琀 嬀䐀䘀开䄀䌀吀䤀嘀䤀吀夀开䴀伀䐀䤀䘀夀开䈀夀崀    匀挀爀椀瀀琀 䐀愀琀攀㨀 　㘀⼀㄀　⼀㈀　㄀㐀 ㄀㔀㨀㈀㈀㨀㌀㜀 ⨀⨀⨀⨀⨀⨀⼀ഀഀ
ALTER TABLE [dbo].[ACTIVITY] ADD  CONSTRAINT [DF_ACTIVITY_MODIFY_BY]  DEFAULT ((0)) FOR [MODIFY_BY]
਍䜀伀ഀഀ
/****** Object:  Default [DF_ACTIVITY_MODIFT_DATE]    Script Date: 06/10/2014 15:22:37 ******/
਍䄀䰀吀䔀刀 吀䄀䈀䰀䔀 嬀搀戀漀崀⸀嬀䄀䌀吀䤀嘀䤀吀夀崀 䄀䐀䐀  䌀伀一匀吀刀䄀䤀一吀 嬀䐀䘀开䄀䌀吀䤀嘀䤀吀夀开䴀伀䐀䤀䘀吀开䐀䄀吀䔀崀  䐀䔀䘀䄀唀䰀吀 ⠀最攀琀搀愀琀攀⠀⤀⤀ 䘀伀刀 嬀䴀伀䐀䤀䘀夀开䐀䄀吀䔀崀ഀഀ
GO
਍⼀⨀⨀⨀⨀⨀⨀ 伀戀樀攀挀琀㨀  䐀攀昀愀甀氀琀 嬀䐀䘀开倀刀伀䨀䔀䌀吀开倀刀伀䨀开䐀䔀匀䌀崀    匀挀爀椀瀀琀 䐀愀琀攀㨀 　㘀⼀㄀　⼀㈀　㄀㐀 ㄀㔀㨀㈀㈀㨀㌀㜀 ⨀⨀⨀⨀⨀⨀⼀ഀഀ
ALTER TABLE [dbo].[PROJECT] ADD  CONSTRAINT [DF_PROJECT_PROJ_DESC]  DEFAULT ('') FOR [PROJ_DESC]
਍䜀伀ഀഀ
/****** Object:  Default [DF_PROJECT_PROJ_REF]    Script Date: 06/10/2014 15:22:37 ******/
਍䄀䰀吀䔀刀 吀䄀䈀䰀䔀 嬀搀戀漀崀⸀嬀倀刀伀䨀䔀䌀吀崀 䄀䐀䐀  䌀伀一匀吀刀䄀䤀一吀 嬀䐀䘀开倀刀伀䨀䔀䌀吀开倀刀伀䨀开刀䔀䘀崀  䐀䔀䘀䄀唀䰀吀 ⠀✀✀⤀ 䘀伀刀 嬀倀刀伀䨀开刀䔀䘀崀ഀഀ
GO
਍⼀⨀⨀⨀⨀⨀⨀ 伀戀樀攀挀琀㨀  䐀攀昀愀甀氀琀 嬀䐀䘀开倀刀伀䨀䔀䌀吀开伀刀䜀开䤀䐀崀    匀挀爀椀瀀琀 䐀愀琀攀㨀 　㘀⼀㄀　⼀㈀　㄀㐀 ㄀㔀㨀㈀㈀㨀㌀㜀 ⨀⨀⨀⨀⨀⨀⼀ഀഀ
ALTER TABLE [dbo].[PROJECT] ADD  CONSTRAINT [DF_PROJECT_ORG_ID]  DEFAULT ((0)) FOR [ORG_ID]
਍䜀伀ഀഀ
/****** Object:  Default [DF_PROJECT_COY_ID]    Script Date: 06/10/2014 15:22:37 ******/
਍䄀䰀吀䔀刀 吀䄀䈀䰀䔀 嬀搀戀漀崀⸀嬀倀刀伀䨀䔀䌀吀崀 䄀䐀䐀  䌀伀一匀吀刀䄀䤀一吀 嬀䐀䘀开倀刀伀䨀䔀䌀吀开䌀伀夀开䤀䐀崀  䐀䔀䘀䄀唀䰀吀 ⠀⠀　⤀⤀ 䘀伀刀 嬀䌀伀夀开䤀䐀崀ഀഀ
GO
਍⼀⨀⨀⨀⨀⨀⨀ 伀戀樀攀挀琀㨀  䐀攀昀愀甀氀琀 嬀䐀䘀开倀刀伀䨀䔀䌀吀开圀伀刀䬀匀吀䄀吀䤀伀一开䤀䐀崀    匀挀爀椀瀀琀 䐀愀琀攀㨀 　㘀⼀㄀　⼀㈀　㄀㐀 ㄀㔀㨀㈀㈀㨀㌀㜀 ⨀⨀⨀⨀⨀⨀⼀ഀഀ
ALTER TABLE [dbo].[PROJECT] ADD  CONSTRAINT [DF_PROJECT_WORKSTATION_ID]  DEFAULT ('') FOR [WORKSTATION_ID]
਍䜀伀ഀഀ
/****** Object:  Default [DF_PROJECT_CREATE_BY]    Script Date: 06/10/2014 15:22:37 ******/
਍䄀䰀吀䔀刀 吀䄀䈀䰀䔀 嬀搀戀漀崀⸀嬀倀刀伀䨀䔀䌀吀崀 䄀䐀䐀  䌀伀一匀吀刀䄀䤀一吀 嬀䐀䘀开倀刀伀䨀䔀䌀吀开䌀刀䔀䄀吀䔀开䈀夀崀  䐀䔀䘀䄀唀䰀吀 ⠀⠀　⤀⤀ 䘀伀刀 嬀䌀刀䔀䄀吀䔀开䈀夀崀ഀഀ
GO
਍⼀⨀⨀⨀⨀⨀⨀ 伀戀樀攀挀琀㨀  䐀攀昀愀甀氀琀 嬀䐀䘀开倀刀伀䨀䔀䌀吀开䌀刀䔀䄀吀䔀开䐀䄀吀䔀崀    匀挀爀椀瀀琀 䐀愀琀攀㨀 　㘀⼀㄀　⼀㈀　㄀㐀 ㄀㔀㨀㈀㈀㨀㌀㜀 ⨀⨀⨀⨀⨀⨀⼀ഀഀ
ALTER TABLE [dbo].[PROJECT] ADD  CONSTRAINT [DF_PROJECT_CREATE_DATE]  DEFAULT (getdate()) FOR [CREATE_DATE]
਍䜀伀ഀഀ
/****** Object:  Default [DF_PROJECT_MODIFY_BY]    Script Date: 06/10/2014 15:22:37 ******/
਍䄀䰀吀䔀刀 吀䄀䈀䰀䔀 嬀搀戀漀崀⸀嬀倀刀伀䨀䔀䌀吀崀 䄀䐀䐀  䌀伀一匀吀刀䄀䤀一吀 嬀䐀䘀开倀刀伀䨀䔀䌀吀开䴀伀䐀䤀䘀夀开䈀夀崀  䐀䔀䘀䄀唀䰀吀 ⠀⠀　⤀⤀ 䘀伀刀 嬀䴀伀䐀䤀䘀夀开䈀夀崀ഀഀ
GO
਍⼀⨀⨀⨀⨀⨀⨀ 伀戀樀攀挀琀㨀  䐀攀昀愀甀氀琀 嬀䐀䘀开倀刀伀䨀䔀䌀吀开䴀伀䐀䤀䘀夀开䐀䄀吀䔀崀    匀挀爀椀瀀琀 䐀愀琀攀㨀 　㘀⼀㄀　⼀㈀　㄀㐀 ㄀㔀㨀㈀㈀㨀㌀㜀 ⨀⨀⨀⨀⨀⨀⼀ഀഀ
ALTER TABLE [dbo].[PROJECT] ADD  CONSTRAINT [DF_PROJECT_MODIFY_DATE]  DEFAULT (getdate()) FOR [MODIFY_DATE]
਍䜀伀ഀഀ
/****** Object:  Default [DF_TIMESHEET_TS_DESC]    Script Date: 06/10/2014 15:22:37 ******/
਍䄀䰀吀䔀刀 吀䄀䈀䰀䔀 嬀搀戀漀崀⸀嬀吀䤀䴀䔀匀䠀䔀䔀吀崀 䄀䐀䐀  䌀伀一匀吀刀䄀䤀一吀 嬀䐀䘀开吀䤀䴀䔀匀䠀䔀䔀吀开吀匀开䐀䔀匀䌀崀  䐀䔀䘀䄀唀䰀吀 ⠀✀✀⤀ 䘀伀刀 嬀吀匀开䐀䔀匀䌀崀ഀഀ
GO
਍⼀⨀⨀⨀⨀⨀⨀ 伀戀樀攀挀琀㨀  䐀攀昀愀甀氀琀 嬀䐀䘀开吀䤀䴀䔀匀䠀䔀䔀吀开吀匀开刀䔀䘀崀    匀挀爀椀瀀琀 䐀愀琀攀㨀 　㘀⼀㄀　⼀㈀　㄀㐀 ㄀㔀㨀㈀㈀㨀㌀㜀 ⨀⨀⨀⨀⨀⨀⼀ഀഀ
ALTER TABLE [dbo].[TIMESHEET] ADD  CONSTRAINT [DF_TIMESHEET_TS_REF]  DEFAULT ('') FOR [TS_REF]
਍䜀伀ഀഀ
/****** Object:  Default [DF_TIMESHEET_ORG_ID]    Script Date: 06/10/2014 15:22:37 ******/
਍䄀䰀吀䔀刀 吀䄀䈀䰀䔀 嬀搀戀漀崀⸀嬀吀䤀䴀䔀匀䠀䔀䔀吀崀 䄀䐀䐀  䌀伀一匀吀刀䄀䤀一吀 嬀䐀䘀开吀䤀䴀䔀匀䠀䔀䔀吀开伀刀䜀开䤀䐀崀  䐀䔀䘀䄀唀䰀吀 ⠀⠀　⤀⤀ 䘀伀刀 嬀伀刀䜀开䤀䐀崀ഀഀ
GO
਍⼀⨀⨀⨀⨀⨀⨀ 伀戀樀攀挀琀㨀  䐀攀昀愀甀氀琀 嬀䐀䘀开吀䤀䴀䔀匀䠀䔀䔀吀开䌀伀夀开䤀䐀崀    匀挀爀椀瀀琀 䐀愀琀攀㨀 　㘀⼀㄀　⼀㈀　㄀㐀 ㄀㔀㨀㈀㈀㨀㌀㜀 ⨀⨀⨀⨀⨀⨀⼀ഀഀ
ALTER TABLE [dbo].[TIMESHEET] ADD  CONSTRAINT [DF_TIMESHEET_COY_ID]  DEFAULT ((0)) FOR [COY_ID]
਍䜀伀ഀഀ
/****** Object:  Default [DF_TIMESHEET_WORKSTATION_ID]    Script Date: 06/10/2014 15:22:37 ******/
਍䄀䰀吀䔀刀 吀䄀䈀䰀䔀 嬀搀戀漀崀⸀嬀吀䤀䴀䔀匀䠀䔀䔀吀崀 䄀䐀䐀  䌀伀一匀吀刀䄀䤀一吀 嬀䐀䘀开吀䤀䴀䔀匀䠀䔀䔀吀开圀伀刀䬀匀吀䄀吀䤀伀一开䤀䐀崀  䐀䔀䘀䄀唀䰀吀 ⠀✀✀⤀ 䘀伀刀 嬀圀伀刀䬀匀吀䄀吀䤀伀一开䤀䐀崀ഀഀ
GO
਍⼀⨀⨀⨀⨀⨀⨀ 伀戀樀攀挀琀㨀  䐀攀昀愀甀氀琀 嬀䐀䘀开吀䤀䴀䔀匀䠀䔀䔀吀开䌀刀䔀䄀吀䔀开䈀夀崀    匀挀爀椀瀀琀 䐀愀琀攀㨀 　㘀⼀㄀　⼀㈀　㄀㐀 ㄀㔀㨀㈀㈀㨀㌀㜀 ⨀⨀⨀⨀⨀⨀⼀ഀഀ
ALTER TABLE [dbo].[TIMESHEET] ADD  CONSTRAINT [DF_TIMESHEET_CREATE_BY]  DEFAULT ((0)) FOR [CREATE_BY]
਍䜀伀ഀഀ
/****** Object:  Default [DF_TIMESHEET_CREATE_DATE]    Script Date: 06/10/2014 15:22:37 ******/
਍䄀䰀吀䔀刀 吀䄀䈀䰀䔀 嬀搀戀漀崀⸀嬀吀䤀䴀䔀匀䠀䔀䔀吀崀 䄀䐀䐀  䌀伀一匀吀刀䄀䤀一吀 嬀䐀䘀开吀䤀䴀䔀匀䠀䔀䔀吀开䌀刀䔀䄀吀䔀开䐀䄀吀䔀崀  䐀䔀䘀䄀唀䰀吀 ⠀最攀琀搀愀琀攀⠀⤀⤀ 䘀伀刀 嬀䌀刀䔀䄀吀䔀开䐀䄀吀䔀崀ഀഀ
GO
਍⼀⨀⨀⨀⨀⨀⨀ 伀戀樀攀挀琀㨀  䐀攀昀愀甀氀琀 嬀䐀䘀开吀䤀䴀䔀匀䠀䔀䔀吀开䴀伀䐀䤀䘀夀开䈀夀崀    匀挀爀椀瀀琀 䐀愀琀攀㨀 　㘀⼀㄀　⼀㈀　㄀㐀 ㄀㔀㨀㈀㈀㨀㌀㜀 ⨀⨀⨀⨀⨀⨀⼀ഀഀ
ALTER TABLE [dbo].[TIMESHEET] ADD  CONSTRAINT [DF_TIMESHEET_MODIFY_BY]  DEFAULT ((0)) FOR [MODIFY_BY]
਍䜀伀ഀഀ
/****** Object:  Default [DF_TIMESHEET_MODIFY_DATE]    Script Date: 06/10/2014 15:22:37 ******/
਍䄀䰀吀䔀刀 吀䄀䈀䰀䔀 嬀搀戀漀崀⸀嬀吀䤀䴀䔀匀䠀䔀䔀吀崀 䄀䐀䐀  䌀伀一匀吀刀䄀䤀一吀 嬀䐀䘀开吀䤀䴀䔀匀䠀䔀䔀吀开䴀伀䐀䤀䘀夀开䐀䄀吀䔀崀  䐀䔀䘀䄀唀䰀吀 ⠀最攀琀搀愀琀攀⠀⤀⤀ 䘀伀刀 嬀䴀伀䐀䤀䘀夀开䐀䄀吀䔀崀ഀഀ
GO
਍⼀⨀⨀⨀⨀⨀⨀ 伀戀樀攀挀琀㨀  䐀攀昀愀甀氀琀 嬀䐀䘀开吀䤀䴀䔀匀䠀䔀䔀吀开匀吀䄀刀吀开䐀䄀吀䔀崀    匀挀爀椀瀀琀 䐀愀琀攀㨀 　㘀⼀㄀　⼀㈀　㄀㐀 ㄀㔀㨀㈀㈀㨀㌀㜀 ⨀⨀⨀⨀⨀⨀⼀ഀഀ
ALTER TABLE [dbo].[TIMESHEET] ADD  CONSTRAINT [DF_TIMESHEET_START_DATE]  DEFAULT (getdate()) FOR [START_DATE]
਍䜀伀ഀഀ
/****** Object:  Default [DF_TIMESHEET_END_DATE]    Script Date: 06/10/2014 15:22:37 ******/
਍䄀䰀吀䔀刀 吀䄀䈀䰀䔀 嬀搀戀漀崀⸀嬀吀䤀䴀䔀匀䠀䔀䔀吀崀 䄀䐀䐀  䌀伀一匀吀刀䄀䤀一吀 嬀䐀䘀开吀䤀䴀䔀匀䠀䔀䔀吀开䔀一䐀开䐀䄀吀䔀崀  䐀䔀䘀䄀唀䰀吀 ⠀最攀琀搀愀琀攀⠀⤀⤀ 䘀伀刀 嬀䔀堀倀䤀刀夀开䐀䄀吀䔀崀ഀഀ
GO
਍⼀⨀⨀⨀⨀⨀⨀ 伀戀樀攀挀琀㨀  䐀攀昀愀甀氀琀 嬀䐀䘀开吀䤀䴀䔀匀䠀䔀䔀吀开䈀椀氀氀愀戀氀攀崀    匀挀爀椀瀀琀 䐀愀琀攀㨀 　㘀⼀㄀　⼀㈀　㄀㐀 ㄀㔀㨀㈀㈀㨀㌀㜀 ⨀⨀⨀⨀⨀⨀⼀ഀഀ
ALTER TABLE [dbo].[TIMESHEET] ADD  CONSTRAINT [DF_TIMESHEET_Billable]  DEFAULT ((0)) FOR [BILLABLE]
਍䜀伀ഀഀ
/****** Object:  Default [DF_TIMESHEET_PROJ_ID]    Script Date: 06/10/2014 15:22:37 ******/
਍䄀䰀吀䔀刀 吀䄀䈀䰀䔀 嬀搀戀漀崀⸀嬀吀䤀䴀䔀匀䠀䔀䔀吀崀 䄀䐀䐀  䌀伀一匀吀刀䄀䤀一吀 嬀䐀䘀开吀䤀䴀䔀匀䠀䔀䔀吀开倀刀伀䨀开䤀䐀崀  䐀䔀䘀䄀唀䰀吀 ⠀⠀　⤀⤀ 䘀伀刀 嬀倀刀伀䨀开䤀䐀崀ഀഀ
GO
਍⼀⨀⨀⨀⨀⨀⨀ 伀戀樀攀挀琀㨀  䐀攀昀愀甀氀琀 嬀䐀䘀开吀䤀䴀䔀匀䠀䔀䔀吀开䄀䌀吀开䤀䐀崀    匀挀爀椀瀀琀 䐀愀琀攀㨀 　㘀⼀㄀　⼀㈀　㄀㐀 ㄀㔀㨀㈀㈀㨀㌀㜀 ⨀⨀⨀⨀⨀⨀⼀ഀഀ
ALTER TABLE [dbo].[TIMESHEET] ADD  CONSTRAINT [DF_TIMESHEET_ACT_ID]  DEFAULT ((0)) FOR [ACT_ID]
਍䜀伀ഀഀ
/****** Object:  Default [DF_TIMESHEET_EMP_ID]    Script Date: 06/10/2014 15:22:37 ******/
਍䄀䰀吀䔀刀 吀䄀䈀䰀䔀 嬀搀戀漀崀⸀嬀吀䤀䴀䔀匀䠀䔀䔀吀崀 䄀䐀䐀  䌀伀一匀吀刀䄀䤀一吀 嬀䐀䘀开吀䤀䴀䔀匀䠀䔀䔀吀开䔀䴀倀开䤀䐀崀  䐀䔀䘀䄀唀䰀吀 ⠀⠀　⤀⤀ 䘀伀刀 嬀䔀䴀倀开䤀䐀崀ഀഀ
GO
਍�