﻿if not Exists(SELECT * FROM information_schema.tables where Table_name = 'TaxGoods')
begin
	CREATE TABLE [dbo].[TaxGoods]
	(
		[ID] [int] primary key IDENTITY(1,1) ,
		[Mat_ID] [bigint] references dbo.Matter(ID) NOT NULL,
		[Code] [nvarchar](100) NOT NULL,
		[Title] [nvarchar](500) NULL,
		[Pro_ID_Unit] [int] references dbo.OtherProperties(ID) NOT NULL,
		[Price] [decimal](19, 4) NOT NULL,
		[VatPercent] [int] NOT NULL,
		[Description] [nvarchar](1000) NULL,
		[Guid] [nvarchar](200) NULL
	)
end