﻿if not Exists(SELECT * FROM information_schema.tables where Table_name = 'CommercialStore')
begin
	create table CommercialStore
	(
		ID	int primary key,
		CS_ID	int references CommercialStore(id) null,
		Code	int not null,
		Mat_ID	bigint references matter(id) not null,
		FC_ID	int references Finance_Cycle(id) not null,
		Pro_ID_Anbar	int references otherProperties(id) not null,
		Dom_ID_Status	int references Domain(id) not null, -- قطعی | غیرقطعی
		ToDate	int not null,
		Description		nvarchar(1000)
	)
end
;
if not Exists(SELECT * FROM information_schema.tables where Table_name = 'CommercialStoreItem')
begin
	create table CommercialStoreItem
	(
		ID	int primary key identity(1,1),
		CS_ID	int references CommercialStore(id) not null,
		CSI_ID	int references CommercialStoreItem(id) null,
		Dom_ID_DocType	int references Domain(id) not null, -- نوع ردیف سند انبار => خرید | فروش | تولید ...
		Dom_ID_PriceType	int references Domain(id) not null, -- نحوه قيمتدار كردن اسناد انبار
		Kal_ID	int references Kala(id) not null, 
		Pro_ID_Unit	int references OtherProperties(id) not null, 
		Dom_ID_Restoration	int references domain(id) not null, 
		Quantity	float	not null,
		Price	decimal(19,4) not null,
		SystemTitle	nvarchar(max)
	)
end
;
if not Exists(SELECT * FROM information_schema.tables where Table_name = 'CommercialStoreItemRefrenceID')
begin
	create table CommercialStoreItemRefrenceID
	(
		ID	int primary key identity(1,1),
		CSI_ID	int references CommercialStoreItem(id) not null,
		KDA_ID	int references KalaDarAnbar(id) null,
		BD_ID	int references BargehDetail(id) null,
		ProductDetail_ID	int references ProductDetail(id) null,
		ConvertGoodDetail_ID	int references ConvertGoodDetail(id) null
	)
end