﻿if not Exists(SELECT * FROM information_schema.tables where Table_name = 'TaxCustomer')
begin
	CREATE TABLE [dbo].[TaxCustomer]
	(
		[ID] [int] Primary key IDENTITY(1,1),
		[Mat_ID] [bigint] references dbo.Matter(ID) NOT NULL,
		[Code] [int] NOT NULL,
		[Title] [nvarchar](300) NULL,
		[Dom_ID_Noe] [int] references dbo.Domain(ID) NOT NULL,
		[NationalCode] [nvarchar](200) NULL,
		[EconomicCode] [nvarchar](200) NULL,
		[PostalCode] [nvarchar](200) NULL,
		[BranchCode] [nvarchar](200) NULL,
		[PassportCode] [nvarchar](200) NULL,
		[Description] [nvarchar](1000) NULL,
		[Guid] [nvarchar](200) NULL
	)
end