create table fy_con_res (
	ID int unsigned not null auto_increment,
	FID integer,
	dob date,
	doe date,
	dot date,
	sex character (1),
	race character (30),
	ssn character (11),
	status character (8),
	PRIMARY KEY (ID)
);

create table fy_con_res_diagcodes (
	ID int unsigned not null auto_increment,
	FID integer,
	code character (6),
	PRIMARY KEY (ID)
);

create table fy_con_res_mbpayors (
	ID int unsigned not null auto_increment,
	FID integer,
	payor_type character (10),
	service_type character (10),
	mc_ucid character (7),
	mc_medicaidnum character (12),
	status character (8),
	effectivedate date,
	PRIMARY KEY (ID)
);

create table fy_con_res_mbpayor_types (
	ID int unsigned not null auto_increment,
	payor_type character (10),
	PRIMARY KEY (ID)
);

