alter table personnel add karmandiran_PostcODE TINYINT NULL DEFAULT(3)
alter table personnel add karmandiran_educate  tinyint   null default(3)
alter table personnel add karmandiran_empkind  tinyint null  default(4)
alter table personnel add karmandiran_jobgrade tinyint null default(2)
create table KARMANDIRAN1Item(
	ItemCode smallint NOT NULL,
	ItemName varchar(150) NOT NULL,
Primary Key (ItemCode)
)
create table KARMANDIRAN2Item(
	ItemCode smallint NOT NULL,
	ItemName varchar(150) NOT NULL,
Primary Key (ItemCode)
)

create table KARMANDIRANImpress(
	Serial int IDENTITY(1,1) NOT NULL,
	KARMANDIRANItem int NOT NULL,
	SalaryItemCode int NOT NULL,
	KInd int NOT NULL default(1),
primary Key (Serial)
)

create table  KARMANDIRANH(
SERIAL int IDENTITY(1,1) NOT NULL,
PARENT int NOT NULL,
f_PersonCode Bigint  NOT NULL,
NationalNo  varchar(10) null,
NAME varchar(15)null,
Family varchar(50)null,
FATHERNAME varchar(15)null,
CERTIFICATIONNO varchar(12)NULL,
JENSIAT  varchar(12)NULL,
BIRTHDATE varchar(10)NULL,
PRIMARY KEY (SERIAL)
)
KARMANDIRANR(
SERIAL int IDENTITY(1,1) NOT NULL,
PARENT int NOT NULL,
f_PersonCode Bigint  NOT NULL,
NationalNo  varchar(10) null,
POSTCODE int NULL,
EducateCODE int NULL,
EmployCODE int null,
GRADECODE int NULL,
SANAVATCODE int NULL,
Item1 decimal(18, 8) null default(0),
Item2 decimal(18, 8) null default(0),
Item3 decimal(18, 8) null default(0),
Item4 decimal(18, 8) null default(0),
Item5 decimal(18, 8) null default(0),
Item6 decimal(18, 8) null default(0),
Item7 decimal(18, 8) null default(0),
Item8 decimal(18, 8) null default(0),
Item9 decimal(18, 8) null default(0),
Item10 decimal(18, 8) null default(0),
Item11 decimal(18, 8) null default(0),
Item12 decimal(18, 8) null default(0),
Item13 decimal(18, 8) null default(0),
Item14 decimal(18, 8) null default(0),
Item15 decimal(18, 8) null default(0),
Item16 decimal(18, 8) null default(0),
Item17 decimal(18, 8) null default(0),
Item18 decimal(18, 8) null default(0),
Item19 decimal(18, 8) null default(0),
Item20 decimal(18, 8) null default(0),
Item21 decimal(18, 8) null default(0),
Item22 decimal(18, 8) null default(0),
Item23 decimal(18, 8) null default(0),
Item24 decimal(18, 8) null default(0),
Item25 decimal(18, 8) null default(0),
Item26 decimal(18, 8) null default(0),
Item27 decimal(18, 8) null default(0),
Item28 decimal(18, 8) null default(0),
Item29 decimal(18, 8) null default(0),
Item30 decimal(18, 8) null default(0),
Item31 decimal(18, 8) null default(0),
Item32 decimal(18, 8) null default(0),
Item33 decimal(18, 8) null default(0),
Item34 decimal(18, 8) null default(0),
Item35 decimal(18, 8) null default(0),
PRIMARY KEY (SERIAL)
)