/[volute]/trunk/projects/theory/snapdm/build/createDDL.jdbc
ViewVC logotype

Contents of /trunk/projects/theory/snapdm/build/createDDL.jdbc

Parent Directory Parent Directory | Revision Log Revision Log


Revision 360 - (show annotations)
Mon May 5 18:18:10 2008 UTC (12 years, 6 months ago) by bourges.laurent
File size: 3057 byte(s)
runtime properties are given in properties/jpa-config.properties (jdbc.url, username, password, database)
persistence.xml is generated from an xml template in res/persistence.xml
1 CREATE TABLE Property (id BIGINT NOT NULL, name VARCHAR(255), ucd VARCHAR(255), description VARCHAR(255), PRIMARY KEY (id))
2 CREATE TABLE PropertyGroup (id BIGINT NOT NULL, name VARCHAR(255), description VARCHAR(255), PRIMARY KEY (id))
3 CREATE TABLE ExperimentProperty (id BIGINT NOT NULL, PRIMARY KEY (id))
4 CREATE TABLE ObjectCollection (id BIGINT NOT NULL, numberOfObjects INTEGER, PRIMARY KEY (id))
5 CREATE TABLE Pos3D (id BIGINT NOT NULL, PRIMARY KEY (id))
6 CREATE TABLE InputDataset (id BIGINT NOT NULL, PRIMARY KEY (id))
7 CREATE TABLE Characterisation (id BIGINT NOT NULL, aPriori BOOLEAN, PRIMARY KEY (id))
8 CREATE TABLE PropertyGroupMember (id BIGINT NOT NULL, PRIMARY KEY (id))
9 CREATE TABLE Curation (id BIGINT NOT NULL, publisher VARCHAR(255), creator VARCHAR(255), contributor VARCHAR(255), date TIMESTAMP, version VARCHAR(255), PRIMARY KEY (id))
10 CREATE TABLE ProjectExperiment (id BIGINT NOT NULL, PRIMARY KEY (id))
11 CREATE TABLE ChildExperiment (id BIGINT NOT NULL, PRIMARY KEY (id))
12 CREATE TABLE Quantity (id BIGINT NOT NULL, value VARCHAR(255), unit VARCHAR(255), PRIMARY KEY (id))
13 CREATE TABLE ParameterGroup (id BIGINT NOT NULL, name VARCHAR(255), description VARCHAR(255), PRIMARY KEY (id))
14 CREATE TABLE ObjectType (id BIGINT NOT NULL, DTYPE VARCHAR(31), name VARCHAR(255), description VARCHAR(255), astroJournalSubject VARCHAR(255), identityName VARCHAR(255), PRIMARY KEY (id))
15 CREATE TABLE Algorithm (id BIGINT NOT NULL, name VARCHAR(255), description VARCHAR(255), label VARCHAR(255), PRIMARY KEY (id))
16 CREATE TABLE InputParameter (id BIGINT NOT NULL, name VARCHAR(255), label VARCHAR(255), description VARCHAR(255), PRIMARY KEY (id))
17 CREATE TABLE WebService (id BIGINT NOT NULL, baseURL VARCHAR(255), description VARCHAR(255), PRIMARY KEY (id))
18 CREATE TABLE ParameterGroupMember (id BIGINT NOT NULL, PRIMARY KEY (id))
19 CREATE TABLE ParameterSetting (id BIGINT NOT NULL, PRIMARY KEY (id))
20 CREATE TABLE AppliedPhysics (id BIGINT NOT NULL, PRIMARY KEY (id))
21 CREATE TABLE ChildProtocol (id BIGINT NOT NULL, PRIMARY KEY (id))
22 CREATE TABLE Snapshot (id BIGINT NOT NULL, publisherDID VARCHAR(255), PRIMARY KEY (id))
23 CREATE TABLE Resource (id BIGINT NOT NULL, DTYPE VARCHAR(31), name VARCHAR(255), description VARCHAR(255), referenceURL VARCHAR(255), created TIMESTAMP, updated TIMESTAMP, status VARCHAR(255), code VARCHAR(255), version VARCHAR(255), publisherDID VARCHAR(255), executionTime TIMESTAMP, PRIMARY KEY (id))
24 CREATE TABLE Contact (id BIGINT NOT NULL, name VARCHAR(255), address VARCHAR(255), email VARCHAR(255), telephone VARCHAR(255), PRIMARY KEY (id))
25 CREATE TABLE Physics (id BIGINT NOT NULL, name VARCHAR(255), description VARCHAR(255), texForm VARCHAR(255), physicslabel VARCHAR(255), PRIMARY KEY (id))
26 CREATE TABLE ChildObject (id BIGINT NOT NULL, name VARCHAR(255), PRIMARY KEY (id))
27 CREATE TABLE ExperimentRepresentationObject (id BIGINT NOT NULL, PRIMARY KEY (id))
28 CREATE TABLE SEQUENCE (SEQ_NAME VARCHAR(50) NOT NULL, SEQ_COUNT DECIMAL(38), PRIMARY KEY (SEQ_NAME))
29 INSERT INTO SEQUENCE(SEQ_NAME, SEQ_COUNT) values ('SEQ_GEN', 0)

msdemlei@ari.uni-heidelberg.de
ViewVC Help
Powered by ViewVC 1.1.26