﻿if not Exists(SELECT * FROM information_schema.tables where Table_name = 'TariffPrice')
begin
	create table dbo.TariffPrice
	(
		ID	int primary key identity(1,1),
		Mat_ID	bigint references Matter(ID) not null,
		Kar_ID	int references Karbar(ID) not null,
		Tarikh		int not null,
		ToDate		int not null,
		Quantity		int not null,
		Price		decimal(19,4) not null,
		Guid	nvarchar(100),
		Description		nvarchar(1000)
	)
end
