Census Code
Brought to you by:
kestrel_999,
lasse_l
SQLite format 3 @ ñ ûöñ
"Comment" TEXT,
"ObsRecs" INTEGER,
"Individuals" INTEGER,
"Model" TEXT,
"ModelMD5" TEXT,
"CtlFile" TEXT,
"CtlFileMD5" TEXT,
"DataFile" TEXT,
"DataFileMD5" TEXT,
"OutputFile" TEXT,
"OutputFileMD5" TEXT,
"MSF" TEXT,
"MSFMD5" TEXT,
"FitFile" TEXT,
"FitFileMD5" TEXT,
"patab" TEXT,
"patabMD5" TEXT,
"sdtab" TEXT,
"sdtabMD5" TEXT,
"catab" TEXT,
"catabMD5" TEXT,
"cotab" TEXT,
"cotabMD5" TEXT,
"mutab" TEXT,
"mutabMD5" TEXT,
"mytab" TEXT,
"mytabMD5" TEXT,
"txt" TEXT,
"txtMD5" TEXT,
"ext" TEXT,
"extMD5" TEXT,
"cov" TEXT,
"covMD5" TEXT,
"cor" TEXT,
"corMD5" TEXT,
"coi" TEXT,
"coiMD5" TEXT,
"phi" TEXT,
"phiMD5" TEXT,
"cwtab" TEXT,
"cwtabMD5" TEXT,
"cwtabEst" TEXT,
"cwtabEstMD5" TEXT,
"cwtabDeriv" TEXT,
"cwtabDerivMD5" TEXT,
"Comments" BLOB,
"ParentNo" TEXT,
"KeyRun" INTEGER,
"Timestamp" INTEGER,
"User" TEXT
)
! ! Çfªí tablerunsrunsCREATE TABLE 'runs' (
"ID" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL,
"RunNo" TEXT NOT NULL,
"iRunNo" INTEGER NOT NULL,
P++Ytablesqlite_sequencesqlite_sequenceCREATE TABLE sqlite_sequence(name,seq)KyindexrunnorunsCREATE INDEX "runno" on 'runs' (RunNo ASC, iRunNo ASC)BeindexirunnorunsCREATE INDEX "irunno" on 'runs' (iRunNo ASC)Acindexrunno2runsCREATE INDEX "runno2" on 'runs' (RunNo ASC){tablethetasthetasCREATE TABLE "thetas" (
"ID" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL,
"RunNo" TEXT NOT NULL,
"EstNo" TEXT NOT NULL,
"Theta" INTEGER NOT NULL,
"ThetaLabel" TEXT,
"ThetaValue" REAL,
"ThetaSE" REAL,
"Lower" REAL,
"Initial" REAL,
"Upper" REAL,
"ThetaRSE" REAL,
"Model" TEXT,
"ThetaMatrix" BLOB,
"ThetaSigDig" REAL,
"ThetaCIs" TEXT,
"ThetaCIUpper" REAL,
"ThetaCILower" REAL,
"Timestamp" INTEGER,
"User" TEXT
)
ä' B_indexthetaIDthetas
CREATE INDEX "thetaID" on thetas (ID ASC)AaindexthetathetasCREATE INDEX "theta" on thetas (Theta ASC)Y #indexrunno.thetathetas
CREATE INDEX "runno.theta" on thetas (RunNo ASC, EstNo ASC){
QtableomegasomegasCREATE TABLE "omegas" (
"ID" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL,
"RunNo" TEXT NOT NULL,
"EstNo" INTEGER NOT NULL,
"Omega" INTEGER NOT NULL,
"OmegaValue" REAL,
"EtaBar" REAL,
"EtaBarSE" REAL,
"EtaPVal" REAL,
"OmegaInit" REAL,
"OmegaSE" REAL,
"OmegaRSE" REAL,
"OmegaLabel" TEXT,
"OmegaModel" TEXT,
"OmegaMatrix" BLOB,
"OmegaSigDig" REAL,
"Blocks" INTEGER,
"OmegaCIs" TEXT,
"OmegaCIUpper" REAL,
"OmegaCILower" REAL,
"OmegaPerc" REAL,
"EtaShrinkage" REAL,
"Timestamp" INTEGER,
"User" TEXT
)
U°ô AaindexomegaomegasCREATE INDEX "omega" on omegas (Omega ASC)Y#indexrunno.omegaomegasCREATE INDEX "runno.omega" on omegas (RunNo ASC, EstNo ASC)B
_indexomegaIDomegasCREATE INDEX "omegaID" on omegas (ID ASC) mtablesigmassigmasCREATE TABLE sigmas (
"ID" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL,
"RunNo" TEXT,
"EstNo" INTEGER,
"Sigma" INTEGER,
"SigmaValue" REAL,
"SigmaInit" REAL,
"SigmaSE" REAL,
"SigmaRSE" REAL,
"SigmaLabel" TEXT,
"SigmaModel" TEXT,
"SigmaMatrix" BLOB,
"SigmaSigDig" REAL,
"Blocks" INTEGER,
"SigmaCIs" TEXT,
"SigmaCIUpper" REAL,
"SigmaCILower" REAL,
"EpsilonShrinkage" REAL,
"Timestamp" INTEGER,
"User" TEXT
)
! NãE¾ « q ! Nyindexrunno.estestCREATE INDEX "runno.est" on est (RunNo ASC, EstID ASC)8UindexestIDestCREATE INDEX "estID" on est (ID ASC)wtableestestCREATE TABLE est (
"ID" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL,
"RunNo" TEXT,
"EstID" INTEGER,
"Method" TEXT,
"MethLong" TEXT,
"GoalFunction" TEXT,
"OFV" REAL,
"dOFV" REAL,
"ParentNo" TEXT,
"KeyEst"