Schema
CREATE TABLE BufferComponent ( id INTEGER PRIMARY KEY, name VARCHAR(40), componentRhoId INTEGER, componentViscId INTEGER, componentDensity DOUBLE, componentMr DOUBLE, active INTEGER NOT NULL DEFAULT (1), modified DATE ); CREATE TABLE amino ( "id" INTEGER PRIMARY KEY, "Namethree" VARCHAR(3), "name" VARCHAR(25), "nameone" VARCHAR(1), "Mr" DOUBLE, "covalent" INTEGER, "vbar" DOUBLE, "HipH7" DOUBLE, "HipH4" DOUBLE, "extinction" DOUBLE, "charge" DOUBLE, "pka" DOUBLE, "active" INTEGER NOT NULL DEFAULT (1), modified DATE); CREATE TABLE aminoComposition( id INTEGER PRIMARY KEY, sampleId INTEGER REFERENCES sample(id), aminoId INTEGER REFERENCES amino(id), count INTEGER, active INTEGER NOT NULL DEFAULT(1), modified DATE ); CREATE TABLE buffer ( id INTEGER PRIMARY KEY, name VARCHAR(64), densityDirectEntry DOUBLE,
name VARCHAR(64), densityDirectEntry DOUBLE, viscosityDirectEntry DOUBLE, densityStandard DOUBLE, viscosityStandard DOUBLE, densityStandardT DOUBLE, viscosityStandardT DOUBLE, computeDensity DOUBLE, computeViscosity DOUBLE, pH DOUBLE, isHeavyWater INTEGER, D2O DOUBLE, D2O18 DOUBLE, H2O18 DOUBLE, H2O DOUBLE, active INTEGER NOT NULL DEFAULT (1), modified DATE ); CREATE TABLE bufferComposition ( id INTEGER PRIMARY KEY, bufferId INTEGER, componentID INTEGER, concentration DOUBLE, units VARCHAR(10), active INTEGER NOT NULL DEFAULT (1), modified DATE ); CREATE TABLE conjugateComposition( id INTEGER PRIMARY KEY, sampleId INTEGER REFERENCES sample(id), conjugateId INTEGER REFERENCES conjugates(id), count INTEGER, active INTEGER NOT NULL DEFAULT(1), modified DATE ); CREATE TABLE conjugates (
"id" INTEGER PRIMARY KEY, "name" VARCHAR(30), "Mr" DOUBLE, "covalent" INTEGER, "vbar" DOUBLE, "hiph7" DOUBLE, "hiph4" DOUBLE, "extinction" DOUBLE, "charge" DOUBLE, "pka" DOUBLE, "Mcutoff" DOUBLE, "carbo" INTEGER, "active" INTEGER NOT NULL DEFAULT (1), modified DATE); CREATE TABLE defaults ( id INTEGER PRIMARY KEY, temperature DOUBLE, density DOUBLE, viscosity DOUBLE, vbar DOUBLE, pH DOUBLE, sk DOUBLE, modified DATE ); CREATE TABLE denature ( "id" INTEGER PRIMARY KEY, "Name" VARCHAR(25), "rhomin" DOUBLE, "v3" DOUBLE, "g3" DOUBLE, "Md" DOUBLE, "carbo" BOOLEAN, "active" INTEGER NOT NULL DEFAULT (1), modified DATE); CREATE TABLE experiment ( id INTEGER PRIMARY KEY,
name varchar(64), Tc DOUBLE, RPM DOUBLE, sigma DOUBLE, sstar DOUBLE, mgml DOUBLE, sstart DOUBLE, vbar DOUBLE, rho DOUBLE, vis DOUBLE, Mp DOUBLE, Mb DOUBLE, calculatedBy varchar(30), sample_id INTEGER, buffer_id INTEGER, results_id INTEGER, active INTEGER NOT NULL DEFAULT(1), modified DATE ); CREATE TABLE extinction ( "id" INTEGER PRIMARY KEY, "name" VARCHAR(25), "nm" DOUBLE, "ext" DOUBLE, "active" INTEGER NOT NULL DEFAULT (1), modified DATE); CREATE TABLE results ( id INTEGER PRIMARY KEY, name varchar(64), R DOUBLE, Ro DOUBLE, Rp DOUBLE, Fo DOUBLE, Fp DOUBLE, FFo DOUBLE,
FFp DOUBLE, So DOUBLE, Sp DOUBLE, Do DOUBLE, Dp DOUBLE, Delta1v DOUBLE, Delta1t DOUBLE, abv DOUBLE, abt DOUBLE, av DOUBLE, at DOUBLE, bv DOUBLE, bt DOUBLE, method varchar(20), options varchar(25), options_value DOUBLE, shape varchar(25), sample_id INTEGER, buffer_id INTEGER, experiment_id INTEGER, active INTEGER NOT NULL DEFAULT(1), modified DATE ); CREATE TABLE rhoseries ( id INTEGER PRIMARY KEY, name VARCHAR(40), a DOUBLE, b DOUBLE, c DOUBLE, d DOUBLE, e DOUBLE, f DOUBLE, Cmax DOUBLE, ErrorMax DOUBLE,
Source VARCHAR(80), modified DATE ); CREATE TABLE sample( id INTEGER PRIMARY KEY, name VARCHAR(64), VBarDirectEntry DOUBLE, VBarStandard DOUBLE, VbarStandardT DOUBLE, calcVBar DOUBLE, calcMr DOUBLE, calcHydration DOUBLE, useDenaturant INTEGER REFERENCES denaturant(id), sk DOUBLE, pkaamino DOUBLE, pkacarboxl DOUBLE, pH DOUBLE, nMer INTEGER, aminoSequence TEXT, active INTEGER NOT NULL DEFAULT(1), modified DATE , aminoSequenceCodeSize integer); CREATE TABLE version ("databaseVersion" varchar(9), applicationVersion varchar(9)); CREATE TABLE viscseries ( id INTEGER PRIMARY KEY, name VARCHAR(40), a DOUBLE, b DOUBLE, c DOUBLE, d DOUBLE, e DOUBLE, Cmax DOUBLE, ErrorMax DOUBLE, Source VARCHAR(80), modified DATE );
