create table project(
	id integer primary key asc,
	name text
);

create table file_info(
	id integer primary key asc,
	project_id integer,
	root text,
	file_path text,
	file_type varchar(10),
	added_on varchar(20),
	foreign key (project_id) references project(id)
);

create table file_stats(
	id integer primary key asc,
	file_info_id integer,
	stats_gathered_on varchar(20),
	size_in_bytes integer,
	foreign key (file_info_id) references file_info(id)
);
