
IF NOT EXISTS(SELECT Name FROM Sysobjects WHERE Name = 'Tbl_ClubChargePolicy')
BEGIN
CREATE TABLE [dbo].[Tbl_ClubChargePolicy](
	[id] [numeric](18, 0) IDENTITY(1,1) NOT NULL,
	[K_code] [varchar](15) NOT NULL,
	[charge] [real] NOT NULL,
	[Gid_Fk] [int] NULL,
	[K_Qty] [money] NOT NULL,
	[name2] [nvarchar](80) NULL,
	[FactorType] [tinyint] NULL,
 CONSTRAINT [PK_Tbl_ClubChargePolicy] 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]
End

