if not Exists(SELECT * FROM information_schema.tables where Table_name = 'People')
begin
	create table People
	(
		ID int primary key,
		Code nvarchar(50) not null,
		Peo_ID	int references People (ID) null,
		Pro_ID	int references otherProperties (ID) not null,
		Name	nvarchar(300),
		FirstName	nvarchar(200),
		LastName	nvarchar(200),
		Tel1	varchar	(30),
		Tel2	varchar	(30),
		Fax	varchar	(30),
		Mobile	varchar	(30),
		AddressJob	nvarchar(400),
		AddressHome	nvarchar(400),
		Email	nvarchar(200),
		WebSite	nvarchar(200),
		FatherName	nvarchar(100),
		CertificateNo	varchar(30), -- شماره شناسنامه
		CertificateSerialNo	varchar(30), -- شماره سریال شناسنامه
		BirthDate	int null,
		BirthLocation	nvarchar(200), -- محل تولد
		CertificateLocation	nvarchar(200) null, -- محل صدور
		Dom_ID_Gender int references domain(ID) null, -- جنسیت
		NationalCode varchar (30),
		[Description] varchar (3000),
		Dom_ID_Active	int references domain(ID) not null,
		Dom_ID_MilitaryService	int references domain(ID) null, -- وضعیت سربازی
		Dom_ID_Marital	int references domain(ID) null, -- وضعیت تاهل
		Taf_ID	bigint references Tafsili (ID) null,
		TarikhSabt	int not null,
		SaatSabt	smallint not null
	)
end