create table tbPosition(
-- Autoincrement Primary key
posid int primary key not null identity(1,1),
postitle varchar(200),
posdcs varchar(max)
);
--now we create tbstaff
create table tbStaff(
-- increment start from 100 and add 1
staffid int primary key not null identity(100,1),
staffname varchar(200),
gender char(1),
dob date,
merital varchar(200),
address1 varchar(max),
address2 varchar(max),
city varchar(200),
[state] varchar(200),
zipcode int,
email varchar(200),
posid int, -- now we create relationship on this
phone varchar(200),
photo varbinary(max),
active bit,
constraint fk_posid foreign key(posid)
references tbPosition(posid)
on delete cascade
on update cascade
);
