﻿if not Exists(SELECT * FROM information_schema.tables where Table_name = 'BillingItem')
begin
	create table dbo.BillingItem
	(
		ID	int primary key identity(1,1),
		Bil_ID	int references dbo.Billing(ID) not null,
		Dom_ID_RowType	int references dbo.Domain(ID) not null,
		CI_ID	int references dbo.ContractItem(ID) null,
		
		Kal_ID	int references dbo.Kala(ID) null,
		Taf_ID	bigint references dbo.Tafsili(ID) null,
		Title	nvarchar(500) null,
		
		Quantity	float not null,
		QuantityConfirm	float not null,
		Price	decimal(19,4) not null,
		PriceConfirm	decimal(19,4) not null,
		[Description]	nvarchar(1000) null,
		[Guid]	nvarchar(200) null
	)
end