﻿if not Exists(SELECT * FROM information_schema.tables where Table_name = 'BillingProperty')
begin
	create table dbo.BillingProperty
	(
		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,
		Dom_ID	int references dbo.Domain(ID) null,
		Pro_ID	int references dbo.OtherProperties(ID) null,
		Value	nvarchar(max) null,
		Quantity	float null,
		Price	decimal(19,4) null,
		Guid	nvarchar(100) null,
		Kar_ID_Creator		int references dbo.karbar(ID) not null,
		TarikhSabt	int not null,
		SaatSabt	int not null
	)
end