CREATE TABLE TaskGroupList (
group_id INTEGER NOT NULL,
group_name varchar2(30) NOT NULL,
description varchar2(100) NULL,
type INTEGER,
CONSTRAINT GroupList_PK PRIMARY KEY (group_id) 
);


alter table frequencies add group_id integer;

ALTER TABLE Frequencies
ADD CONSTRAINT Frequencies_TaskGroupList_FK
FOREIGN KEY (group_id)
REFERENCES TaskGroupList (group_id) ;


alter table energybands add group_id integer;

ALTER TABLE EnergyBands
ADD CONSTRAINT EnergyBands_TaskGroupList_FK
FOREIGN KEY (group_id)
REFERENCES TaskGroupList (group_id) ;


alter table rois add group_id integer;


ALTER TABLE Rois
ADD CONSTRAINT Rois_TaskGroupList_FK
FOREIGN KEY (group_id)
REFERENCES TaskGroupList (group_id) ;


alter table lightcurves add spectral_index_error  NUMBER;
