Create table for storing query result

create table testreportbst
(
id char(4),
parentId char(4),
value int,
status varchar,
primary key(id), foreign key(id) references testbst);