drop table fy_con_stf;
drop sequence fy_con_stf_id_seq;
create table fy_con_stf (
	ID serial,
	FID integer,
	doh date,
	dot date,
	dob date,
	sex character (1),
	race character (30),
	ssn character (11),
	jobtype character (10),
	status character (8),
	PRIMARY KEY (ID)
);

drop table fy_con_stf_jobtypes;
drop sequence fy_con_stf_jobtypes_id_seq;
create table fy_con_stf_jobtypes (
	ID serial,
	jobtype character (10),
	PRIMARY KEY (ID)
);

drop table fy_con_stf_acct;
drop sequence fy_con_stf_acct_id_seq;
create table fy_con_stf_acct (
	ID serial,
	FID integer,
	stafftype character (4),
	paytype character (6),
	payrate decimal (8 , 2),
	account integer,
	code integer,
	PRIMARY KEY (ID)
);

drop table fy_con_stf_acct_stftypes;
drop sequence fy_con_stf_acct_stftypes_id_seq;
create table fy_con_stf_acct_stftypes (
	ID serial,
	stftype character (4),
	PRIMARY KEY (ID)
);

drop table fy_con_stf_acct_paytypes;
drop sequence fy_con_stf_acct_paytypes_id_seq;
create table fy_con_stf_acct_paytypes (
	ID serial,
	paytype character (6),
	PRIMARY KEY (ID)
);

drop table fy_con_stf_acct_accounts;
drop sequence fy_con_stf_acct_accounts_id_seq;
create table fy_con_stf_acct_accounts (
	ID serial,
	account character (6),
	descr character (20),
	PRIMARY KEY (ID)
);

drop table fy_con_stf_timecard;
drop sequence fy_con_stf_timecard_id_seq;
create table fy_con_stf_timecard (
	ID serial,
	FID integer,
	onoff character (3),
	tc_date date,
	tc_time time,
	location character (2),
	comment character (20),
	PRIMARY KEY (ID)
);

drop table fy_con_stf_training;
drop sequence fy_con_stf_training_id_seq;
create table fy_con_stf_training (
	ID serial,
	FID integer,
	firstaid date,
	basic date,
	pci date,
	lsci date,
	cpr date,
	unipre date,
	PRIMARY KEY (ID)
);

drop table fy_con_stf_drvlic;
drop sequence fy_con_stf_drvlic_id_seq;
create table fy_con_stf_drvlic (
	ID serial,
	FID integer,
	state character (2),
	licenseno character (20),
	expdate date,
	PRIMARY KEY (ID)
);

drop table fy_con_stf_tottrain;
drop sequence fy_con_stf_tottrain_id_seq;
create table fy_con_stf_tottrain (
	ID serial,
	FID integer,
	yearending date,
	total decimal (8,2),
	PRIMARY KEY (ID)
);
