create table fy_ir (
	ID int unsigned not null auto_increment,
	incident_time time,
	incident_time_end time,
	incident_date date,
	date_reported date,
	time_reported time,
	resident character (30),
	resident_id integer,
	staff character (30),
	staff_id integer,
	group_home character (2),
	at_group_home character (1),
	incident_address character (30),
	written_by character (30),
	written_by_id integer,
	critical character (1),
	merged character (1),
	PRIMARY KEY (ID)
);

create table fy_ir_sum (
	ID int unsigned not null auto_increment,
	FID integer,
	remarks_summary varchar (255),
	action_taken varchar (255),
	other_remarks varchar (255),
	PRIMARY KEY (ID)
);

create table fy_ir_cat (
	ID int unsigned not null auto_increment,
	FID integer,
	needed_pci character (1),
	temper_tantrum character (1),
	stealing character (1),
	property_damage character (1),
	injury_self character (1),
	injury_other character (1),
	fighting character (1),
	drug character (1),
	alcohol character (1),
	awol character (1),
	car_wo_permission character (1),
	verbal_abuse character (1),
	other character (1),
	cir character (1),
	PRIMARY KEY (ID)
);

create table fy_ir_tt (
	ID int unsigned not null auto_increment,
	FID integer,
	pre_tantrum_anxiety character (1),
	inter_personal_conflict character (1),
	either_or_stage character (1),
	defiant_stage character (1),
	aggression_to_depression character (1),
	post_tantrum_stage character (1),
	staff_supportive character (1),
	staff_directive character (1),
	staff_maintains character (1),
	helped_resident character (1),
	staff_intervention character (1),
	staff_taught_stages character (1),
	tt_other varchar (255),
	PRIMARY KEY (ID)
);

create table fy_ir_pci (
	ID int unsigned not null auto_increment,
	FID integer,
	anxiety_stage character (1),
	youth_defensive character (1),
	aop character (1),
	tension_reduction character (1),
	length_of_restraint integer,
	pci_other varchar (255),
	defensive_level integer,
	PRIMARY KEY (ID)
);

create table fy_ir_othinv (
	ID int unsigned not null auto_increment,
	FID integer,
	othinv1 character (30),
	othinv1_id integer,
	othinv2 character (30),
	othinv2_id integer,
	othinv3 character (30),
	othinv3_id integer,
	PRIMARY KEY (ID)
);

create table fy_ir_track (
	ID int unsigned not null auto_increment,
	FID integer,
	at_date date,
	at_time time,
	action character (10),
	staff character (30),
	staff_id integer,
	PRIMARY KEY (ID)
);
