create table fy_clinical_forms (
	ID int unsigned not null auto_increment,
	NID character (1),
	formname character (50),
	clinical_service character (5),
	billable character (1),
	PRIMARY KEY (ID)
);

create table fy_clinical_formdata (
	ID int unsigned not null auto_increment,
	FID integer,
	NID character (1),
	object_type character (10),
	imagename character (30),
	imagewidth integer,
	imageheight integer,
	object_text character (100),
	object_html character (100),
	fieldname character (20),
	formname character (40),
	type character (10),
	length character (5),
	spell character (1),
	groupsame character (1),
	ordernumber integer,
	PRIMARY KEY (ID)
);

create table fy_clinical_stdform (
	ID int unsigned not null auto_increment,
	std character (1),
	fieldname character (20),
	formname character (30),
	type character (10),
	length character (5),
	spell character (1),
	groupsame character (1),
	grouponly character (1),
	PRIMARY KEY (ID)
);

create table fy_clinical_groupcount (
	ID int unsigned not null auto_increment,
	nid character (1),
	PRIMARY KEY (ID)
);
