IF not EXISTS( SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'Tafsili' AND  COLUMN_NAME = 'Pro_ID_Vahed')
begin
	alter table Tafsili add	Pro_ID_Vahed	int references OtherProperties(ID)
end
IF not EXISTS( SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'Tafsili' AND  COLUMN_NAME = 'Pro_ID_Shahrestan')
begin
	alter table Tafsili add	Pro_ID_Shahrestan	int references OtherProperties(ID)
end
IF not EXISTS( SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'Kala' AND  COLUMN_NAME = 'Pro_ID_Grooh')
begin
	alter table Kala	Add	Pro_ID_Grooh	int references OtherProperties(ID) not null default -1
end
IF not EXISTS( SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'Kala' AND  COLUMN_NAME = 'Pro_ID_Vahed')
begin
	alter table Kala	Add	Pro_ID_Vahed	int references OtherProperties(ID) not null default -1
end
IF not EXISTS( SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'Kala' AND  COLUMN_NAME = 'Pro_ID_VahedBozorg')
begin
	alter table Kala	Add	Pro_ID_VahedBozorg	int references OtherProperties(ID) 
end
IF not EXISTS( SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'Kala' AND  COLUMN_NAME = 'Pro_ID_VahedMotevaset')
begin
	alter table Kala	Add	Pro_ID_VahedMotevaset	int references OtherProperties(ID) 
end
IF not EXISTS( SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'BargehDetail' AND  COLUMN_NAME = 'Pro_ID_Anbar')
begin
	alter table BargehDetail add	Pro_ID_Anbar	int references OtherProperties(ID)
end
IF not EXISTS( SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'BargehDetail' AND  COLUMN_NAME = 'Pro_ID_AnbarMaghsad')
begin
	alter table BargehDetail add	Pro_ID_AnbarMaghsad	int references OtherProperties(ID)
end
IF not EXISTS( SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'KalaDarAnbar' AND  COLUMN_NAME = 'Pro_ID_Anbar')
begin
	alter table KalaDarAnbar add	Pro_ID_Anbar	int references OtherProperties(ID) not null Default -1
end
IF not EXISTS( SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'Product' AND  COLUMN_NAME = 'Pro_ID_Anbar')
begin
	alter table Product add	Pro_ID_Anbar	int references OtherProperties(ID)
end
IF not EXISTS( SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'ProductDetail' AND  COLUMN_NAME = 'Pro_ID_Anbar')
begin
	alter table ProductDetail add	Pro_ID_Anbar	int references OtherProperties(ID)
end
IF not EXISTS( SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'ProductFormulDetail' AND  COLUMN_NAME = 'Pro_ID_Anbar')
begin
	alter table ProductFormulDetail add	Pro_ID_Anbar	int references OtherProperties(ID)
end