; Проекты
;

create table tbProject (
  fId autoinc,
  fName char(32),

  primary key(fId));

commit;

create index ixName on tbProject (fName);

commit;

insert into tbProject (fName)
values ('Расчет 1');

commit;


; Исходные
;

create table tbSource (
  fId autoinc,
  fProjectID integer,
  fDataC char(32),
  fDataI integer,

  primary key(fId));

commit;

create index ixProjectID on tbSource (fProjectID);

commit;

insert into tbSource (fProjectID, fDataC, fDataI)
values (1, '2', 3);

commit;


; Результирующие
;

create table tbDest (
  fId autoinc,
  fSourceID integer,
  fResultC char(32),
  fResultI integer,

  primary key(fId));

commit;

create index ixSourceID on tbDest(fSourceID);

commit;

insert into tbDest (fSourceID, fResultC, fResultI)
values (1, '0', -1);

commit;