﻿if not Exists(SELECT * FROM information_schema.tables where Table_name = 'Car')
begin
	Create table dbo.Car
	(
		ID	int Primary key,
		Mat_ID	bigint references dbo.matter(id) not null,
		Taf_ID	bigint references dbo.Tafsili(id) not null,
		Code	int not null,
		Plaque	nvarchar(50) not null,
		Pro_ID_Brand	int references OtherProperties(ID) null,
		Model	nvarchar(200) null,
		Pro_ID_Color	int references OtherProperties(ID) null,
		Pro_ID_Brake	int references OtherProperties(ID) null,-- ترمز
		Pro_ID_ManufactoryCountry	int references OtherProperties(ID) null, -- کشور سازنده
		ConstructionYear	nvarchar(200) null, -- سال ساخت
		CylinderCount	nvarchar(200) null,
		EnginVolume	nvarchar(200) null, -- حجم موتور
		Pro_ID_FuelType	int references OtherProperties(ID) null,
		[Power]	nvarchar(200) null,
		Pro_ID_Gearbox	int references OtherProperties(ID) null, -- نوع گیربکس
		Pro_ID_PowerTransmission	int references OtherProperties(ID) null, -- نوع انتقال قدرت
		Acceleration	nvarchar(200) null, --شتاب
		MaxSpeed	nvarchar(200) null,
		[Weight]	nvarchar(200) null,
		Size	nvarchar(200) null,
		FuelConsumptionInCity	nvarchar(200) null,
		FuelConsumptionOutCity	nvarchar(200) null,
		TankVolume	nvarchar(200) null,
		EmissionStandard	nvarchar(200) null,
		Airbag	nvarchar(200),
		SoundSystem nvarchar(200) null,
		[Description] nvarchar(1000) null,
		Dom_ID_Active	int references dbo.Domain(ID) not null
	)
end