rem ///////////////////////////////////////////////////////////////////////////////////////////////
rem lddmm table
rem ///////////////////////////////////////////////////////////////////////////////////////////////

drop table lddmm;
create table lddmm(
  patientId                              varchar(64)
  structure                              varchar(64)  
  project                                varchar(64)  
  hemisphere                             varchar(32)  

  registrationSource                     varchar(1024)
  registrationType                       varchar(64)   
  registrationVersion                    varchar(8)   

  templateimagepath                      varchar(1024)
  templateheaderpath                     varchar(1024)
  targetimagepath                        varchar(1024)
  targetheaderpath                       varchar(1024)
  templatelandmarkpath                   varchar(1024)

  targetlandmarkpath                     varchar(1024)
  ouptutpath                             varchar(1024)

  dimensions                             number(1)
  numSimulations                         number(5,0)   
  normGradientToStopSimulations          number(5,0)   
  alpha                                  number(8,4)
  beta                                   number(5,2)

  gamma                                  number(5,2)
  delta                                  number(8,4)
  powerL                                 number(1)
  timesteps                              number(4)
  epsilonEnergy                          number(16,14) 

  stepsAfterWhichChangeImgMatchEpsilon   number(4) 
  useLandmarksForInitialVelocity         number(1)
  restart                                number(1)

  sigma                                  number(6,4)
  readExistingVelocity                   number(1)
  procsZ                                 number(3)     
  procsY                                 number(3)     
  procsX                                 number(3)  

  padI                                   number(4)   
  padH                                   number(4)  
  restart                                number(1)  
  fractionOriginalImageError             number(6,4)   

  numSimulationsLandmarks                number(5,0)
  epsilonLandmarks                       number(16,14)
  greensKernelSigmaLandmarks             number(2)
  useKernelFromLandmarks                 number(1)
  numLandmarks                           number(3)

  sigmaLandmarks                         number(6,4)
  methodLandmarks                        number(2)
  lambdaErrorLandmarks                   number(2)

  createMPG                              number(1)     
  createTAR                              number(1)     
  vtkInterval                            number(4)   

  imageScaledTo                          varchar(1024)
  metricDistance                         number(12,8)
  finishingErrorAtlasDeformedPatient     number(12,8)
  finishingErrorDeformedAtlasPatient     number(12,8)

  version                                varchar(32)
  startTime                              DATE
  endTime                                DATE

  userDefined1                           varchar(32)
  userDefined2                           varchar(32)
  userDefined3                           varchar(32)
);
