﻿if not Exists(SELECT * FROM information_schema.tables where Table_name = 'Billing')
begin
	create table dbo.Billing
	(
		ID	int primary key,
		FC_ID	int references dbo.Finance_Cycle(ID) not null,
		Pro_ID_VahedMali	int references dbo.OtherPRoperties(ID) not null,
		Mat_ID	bigint references dbo.Matter(ID) not null,
		Dom_ID_Type	int references dbo.Domain(ID) not null,
		Dom_ID_Status	int references dbo.Domain(ID) not null,
		Con_ID	int references dbo.Contract(ID) not null,
		Code	Int not null,
		Tarikh	Int not null,
		TarikhConfirm	Int not null,
		Serial	nvarchar(100) null,
		Description	nvarchar(1000) null,
		[Guid]	nvarchar(200) null
	)
end