USE NorthwindLog
਍䜀伀ഀഀ

਍䌀刀䔀䄀吀䔀 吀䄀䈀䰀䔀 嬀搀戀漀崀⸀嬀倀爀漀搀甀挀琀猀开䤀渀猀攀爀琀攀搀䐀攀氀攀琀攀搀䰀漀最崀 ⠀ഀഀ
	[PKey] [int] IDENTITY (1, 1) PRIMARY KEY CLUSTERED,
਍ऀ嬀倀爀漀搀甀挀琀䤀䐀崀 嬀椀渀琀崀 一伀吀 一唀䰀䰀Ⰰഀഀ
	[InsertUser] [nvarchar] (256) NOT NULL,
਍ऀ嬀䤀渀猀攀爀琀吀椀洀攀崀 嬀搀愀琀攀琀椀洀攀崀 一伀吀 一唀䰀䰀Ⰰഀഀ
	[DeleteUser] [nvarchar] (256) NULL,
਍ऀ嬀䐀攀氀攀琀攀吀椀洀攀崀 嬀搀愀琀攀琀椀洀攀崀 一唀䰀䰀Ⰰഀഀ
	[UniqueID] [uniqueidentifier] NOT NULL )
਍䜀伀ഀഀ

਍䌀刀䔀䄀吀䔀 吀䄀䈀䰀䔀 嬀搀戀漀崀⸀嬀倀爀漀搀甀挀琀猀开唀瀀搀愀琀攀搀䰀漀最崀 ⠀ഀഀ
	[PKey] [int] IDENTITY (1, 1) PRIMARY KEY CLUSTERED,
਍ऀ嬀䘀䬀攀礀崀 嬀椀渀琀崀 一伀吀 一唀䰀䰀Ⰰഀഀ
	[ProductID] [int] NOT NULL,
਍ऀ嬀倀爀漀搀甀挀琀一愀洀攀崀 嬀渀瘀愀爀挀栀愀爀崀 ⠀㐀　⤀Ⰰഀഀ
	[SupplierID] [int],
਍ऀ嬀䌀愀琀攀最漀爀礀䤀䐀崀 嬀椀渀琀崀Ⰰഀഀ
	[QuantityPerUnit] [nvarchar] (20),
਍ऀ嬀唀渀椀琀倀爀椀挀攀崀 嬀洀漀渀攀礀崀Ⰰഀഀ
	[UnitsInStock] [smallint],
਍ऀ嬀唀渀椀琀猀伀渀伀爀搀攀爀崀 嬀猀洀愀氀氀椀渀琀崀Ⰰഀഀ
	[ReorderLevel] [smallint],
਍ऀ嬀䐀椀猀挀漀渀琀椀渀甀攀搀崀 嬀戀椀琀崀Ⰰഀഀ
	[UpdateUser] [nvarchar] (256) NOT NULL,
਍ऀ嬀唀瀀搀愀琀攀吀椀洀攀崀 嬀搀愀琀攀琀椀洀攀崀 一伀吀 一唀䰀䰀 ⤀ഀഀ
GO
਍ഀഀ
CREATE  INDEX [IX_ProductID] 
਍ऀ伀一 嬀搀戀漀崀⸀嬀倀爀漀搀甀挀琀猀开䤀渀猀攀爀琀攀搀䐀攀氀攀琀攀搀䰀漀最崀⠀嬀倀爀漀搀甀挀琀䤀䐀崀⤀ഀഀ
GO
਍ഀഀ
CREATE  INDEX [FK_FKey] 
਍ऀ伀一 嬀搀戀漀崀⸀嬀倀爀漀搀甀挀琀猀开唀瀀搀愀琀攀搀䰀漀最崀⠀嬀䘀䬀攀礀崀⤀ഀഀ
GO
਍ഀഀ