/[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 465 - (show annotations)
Mon May 12 16:19:59 2008 UTC (12 years, 6 months ago) by bourges.laurent
File size: 15007 byte(s)
- updated build
- update jdbc jpa
- identity class in MetaDataObject
- javadoc moved to /dist/doc
1 CREATE TABLE t_SubvolumeExtraction (id BIGINT NOT NULL, PRIMARY KEY (id))
2 CREATE TABLE t_Visualisation (id BIGINT NOT NULL, PRIMARY KEY (id))
3 CREATE TABLE t_Simulator (id BIGINT NOT NULL, PRIMARY KEY (id))
4 CREATE TABLE t_Snapshot (id SERIAL NOT NULL, OPTLOCK INTEGER, publisherDID VARCHAR(255) NOT NULL, xmlId VARCHAR(255), simId VARCHAR(255), time_value VARCHAR(255) NOT NULL, time_unit VARCHAR(32), spatialSizePhysical_value VARCHAR(255) NOT NULL, spatialSizePhysical_unit VARCHAR(32), containerId BIGINT NOT NULL, PRIMARY KEY (id))
5 CREATE TABLE t_ChildObject (id SERIAL NOT NULL, OPTLOCK INTEGER, name VARCHAR(32) NOT NULL, cardinality VARCHAR(255), xmlId VARCHAR(255), simId VARCHAR(255), containerId BIGINT NOT NULL, objectId BIGINT NOT NULL, PRIMARY KEY (id))
6 CREATE TABLE t_RepresentationObjectType (id BIGINT NOT NULL, label VARCHAR(255), astroJournalSubject VARCHAR(255), containerId BIGINT NOT NULL, PRIMARY KEY (id))
7 CREATE TABLE t_Protocol (id BIGINT NOT NULL, code VARCHAR(255), version VARCHAR(255), PRIMARY KEY (id))
8 CREATE TABLE t_ParameterGroup (id SERIAL NOT NULL, OPTLOCK INTEGER, name VARCHAR(255), description VARCHAR(255), xmlId VARCHAR(255), simId VARCHAR(255), containerId BIGINT NOT NULL, PRIMARY KEY (id))
9 CREATE TABLE t_PropertyGroup (id SERIAL NOT NULL, OPTLOCK INTEGER, name VARCHAR(255) NOT NULL, description VARCHAR(255), xmlId VARCHAR(255), simId VARCHAR(255), containerId BIGINT NOT NULL, PRIMARY KEY (id))
10 CREATE TABLE t_CompositeExperiment (id BIGINT NOT NULL, PRIMARY KEY (id))
11 CREATE TABLE t_GenericParameterSetting (id BIGINT NOT NULL, value VARCHAR(255) NOT NULL, PRIMARY KEY (id))
12 CREATE TABLE t_ClusterFinder (id BIGINT NOT NULL, PRIMARY KEY (id))
13 CREATE TABLE t_PostProcessing (id BIGINT NOT NULL, primaryExperimentId BIGINT, PRIMARY KEY (id))
14 CREATE TABLE t_InputDataset (id SERIAL NOT NULL, OPTLOCK INTEGER, xmlId VARCHAR(255), simId VARCHAR(255), containerId BIGINT NOT NULL, snapshotId BIGINT NOT NULL, PRIMARY KEY (id))
15 CREATE TABLE t_AppliedPhysics (id SERIAL NOT NULL, OPTLOCK INTEGER, xmlId VARCHAR(255), simId VARCHAR(255), containerId BIGINT NOT NULL, physicsId BIGINT NOT NULL, PRIMARY KEY (id))
16 CREATE TABLE t_PropertyGroupMember (id SERIAL NOT NULL, OPTLOCK INTEGER, xmlId VARCHAR(255), simId VARCHAR(255), containerId BIGINT NOT NULL, propertyId BIGINT NOT NULL, PRIMARY KEY (id))
17 CREATE TABLE t_TargetObjectType (id BIGINT NOT NULL, multiplicity VARCHAR(255), identityName VARCHAR(255), astroJournalSubject VARCHAR(255), containerId BIGINT NOT NULL, PRIMARY KEY (id))
18 CREATE TABLE t_ParameterSetting (id SERIAL NOT NULL, DTYPE VARCHAR(32), OPTLOCK INTEGER, xmlId VARCHAR(255), simId VARCHAR(255), containerId BIGINT NOT NULL, inputParameterId BIGINT, PRIMARY KEY (id))
19 CREATE TABLE t_InputParameter (id SERIAL NOT NULL, OPTLOCK INTEGER, name VARCHAR(255), datatype VARCHAR(255), cardinality VARCHAR(255), label VARCHAR(255), description VARCHAR(255), xmlId VARCHAR(255), simId VARCHAR(255), containerId BIGINT NOT NULL, PRIMARY KEY (id))
20 CREATE TABLE t_ClusterDetection (id BIGINT NOT NULL, PRIMARY KEY (id))
21 CREATE TABLE t_CompositeProtocol (id BIGINT NOT NULL, PRIMARY KEY (id))
22 CREATE TABLE t_ExperimentRepresentationObject (id SERIAL NOT NULL, OPTLOCK INTEGER, xmlId VARCHAR(255), simId VARCHAR(255), containerId BIGINT NOT NULL, typeId BIGINT NOT NULL, PRIMARY KEY (id))
23 CREATE TABLE t_ProjectExperiment (id SERIAL NOT NULL, OPTLOCK INTEGER, xmlId VARCHAR(255), simId VARCHAR(255), containerId BIGINT NOT NULL, experimentId BIGINT NOT NULL, PRIMARY KEY (id))
24 CREATE TABLE t_TargetProcess (id BIGINT NOT NULL, astroJournalSubject VARCHAR(255), containerId BIGINT NOT NULL, PRIMARY KEY (id))
25 CREATE TABLE t_Characterisation (id SERIAL NOT NULL, OPTLOCK INTEGER, type VARCHAR(255), aPriori BOOLEAN, xmlId VARCHAR(255), simId VARCHAR(255), value_value VARCHAR(255) NOT NULL, value_unit VARCHAR(32), containerId BIGINT NOT NULL, axisId BIGINT NOT NULL, PRIMARY KEY (id))
26 CREATE TABLE t_Project (id BIGINT NOT NULL, PRIMARY KEY (id))
27 CREATE TABLE t_Physics (id SERIAL NOT NULL, OPTLOCK INTEGER, name VARCHAR(255), description VARCHAR(255), texForm VARCHAR(255), physicslabel VARCHAR(255), xmlId VARCHAR(255), simId VARCHAR(255), containerId BIGINT NOT NULL, PRIMARY KEY (id))
28 CREATE TABLE t_NumericParameterSetting (id BIGINT NOT NULL, value_value VARCHAR(255) NOT NULL, value_unit VARCHAR(32), PRIMARY KEY (id))
29 CREATE TABLE t_SubvolumeExtractor (id BIGINT NOT NULL, PRIMARY KEY (id))
30 CREATE TABLE t_Contact (id SERIAL NOT NULL, OPTLOCK INTEGER, name VARCHAR(255) NOT NULL, address VARCHAR(255), email VARCHAR(255), telephone VARCHAR(255), xmlId VARCHAR(255), simId VARCHAR(255), PRIMARY KEY (id))
31 CREATE TABLE t_ChildProtocol (id SERIAL NOT NULL, OPTLOCK INTEGER, xmlId VARCHAR(255), simId VARCHAR(255), containerId BIGINT NOT NULL, protocolId BIGINT NOT NULL, PRIMARY KEY (id))
32 CREATE TABLE t_Experiment (id BIGINT NOT NULL, publisherDID VARCHAR(255), protocolId BIGINT NOT NULL, PRIMARY KEY (id))
33 CREATE TABLE t_WebService (id SERIAL NOT NULL, OPTLOCK INTEGER, baseURL VARCHAR(255) NOT NULL, description VARCHAR(255), type VARCHAR(255) NOT NULL, xmlId VARCHAR(255), simId VARCHAR(255), containerId BIGINT NOT NULL, PRIMARY KEY (id))
34 CREATE TABLE t_Property (id SERIAL NOT NULL, OPTLOCK INTEGER, name VARCHAR(255) NOT NULL, datatype VARCHAR(255) NOT NULL, cardinality VARCHAR(255) NOT NULL, ucd VARCHAR(255), description VARCHAR(255), xmlId VARCHAR(255), simId VARCHAR(255), containerId BIGINT NOT NULL, PRIMARY KEY (id))
35 CREATE TABLE t_ChildExperiment (id SERIAL NOT NULL, OPTLOCK INTEGER, xmlId VARCHAR(255), simId VARCHAR(255), containerId BIGINT NOT NULL, experimentId BIGINT NOT NULL, PRIMARY KEY (id))
36 CREATE TABLE t_ExperimentProperty (id SERIAL NOT NULL, OPTLOCK INTEGER, xmlId VARCHAR(255), simId VARCHAR(255), containerId BIGINT NOT NULL, propertyId BIGINT NOT NULL, PRIMARY KEY (id))
37 CREATE TABLE t_ObjectCollection (id SERIAL NOT NULL, OPTLOCK INTEGER, numberOfObjects INTEGER, xmlId VARCHAR(255), simId VARCHAR(255), containerId BIGINT NOT NULL, objectTypeId BIGINT NOT NULL, PRIMARY KEY (id))
38 CREATE TABLE t_ObjectType (id SERIAL NOT NULL, DTYPE VARCHAR(32), OPTLOCK INTEGER, name VARCHAR(32) NOT NULL, description TEXT, xmlId VARCHAR(255), simId VARCHAR(255), PRIMARY KEY (id))
39 CREATE TABLE t_ParameterGroupMember (id SERIAL NOT NULL, OPTLOCK INTEGER, xmlId VARCHAR(255), simId VARCHAR(255), containerId BIGINT NOT NULL, parameterId BIGINT NOT NULL, PRIMARY KEY (id))
40 CREATE TABLE t_Algorithm (id SERIAL NOT NULL, OPTLOCK INTEGER, name VARCHAR(255) NOT NULL, description VARCHAR(255), label VARCHAR(255), xmlId VARCHAR(255), simId VARCHAR(255), containerId BIGINT NOT NULL, PRIMARY KEY (id))
41 CREATE TABLE t_Simulation (id BIGINT NOT NULL, executionTime TIMESTAMP, PRIMARY KEY (id))
42 CREATE TABLE t_Curation (id SERIAL NOT NULL, OPTLOCK INTEGER, publisher VARCHAR(255) NOT NULL, creator VARCHAR(255), contributor VARCHAR(255), date TIMESTAMP, version VARCHAR(255), xmlId VARCHAR(255), simId VARCHAR(255), containerId BIGINT NOT NULL, contactId BIGINT, PRIMARY KEY (id))
43 CREATE TABLE t_Visualiser (id BIGINT NOT NULL, PRIMARY KEY (id))
44 CREATE TABLE t_Resource (id SERIAL NOT NULL, DTYPE VARCHAR(32), OPTLOCK INTEGER, name VARCHAR(255), description VARCHAR(255), referenceURL VARCHAR(255), created TIMESTAMP, updated TIMESTAMP, status VARCHAR(255), xmlId VARCHAR(255), simId VARCHAR(255), PRIMARY KEY (id))
45 ALTER TABLE t_SubvolumeExtraction ADD CONSTRAINT FK_t_SubvolumeExtraction_id FOREIGN KEY (id) REFERENCES t_Resource (id)
46 ALTER TABLE t_Visualisation ADD CONSTRAINT FK_t_Visualisation_id FOREIGN KEY (id) REFERENCES t_Resource (id)
47 ALTER TABLE t_Simulator ADD CONSTRAINT FK_t_Simulator_id FOREIGN KEY (id) REFERENCES t_Resource (id)
48 ALTER TABLE t_Snapshot ADD CONSTRAINT FK_t_Snapshot_containerId FOREIGN KEY (containerId) REFERENCES t_Resource (id)
49 ALTER TABLE t_ChildObject ADD CONSTRAINT FK_t_ChildObject_containerId FOREIGN KEY (containerId) REFERENCES t_ObjectType (id)
50 ALTER TABLE t_ChildObject ADD CONSTRAINT FK_t_ChildObject_objectId FOREIGN KEY (objectId) REFERENCES t_ObjectType (id)
51 ALTER TABLE t_RepresentationObjectType ADD CONSTRAINT FK_t_RepresentationObjectType_id FOREIGN KEY (id) REFERENCES t_ObjectType (id)
52 ALTER TABLE t_RepresentationObjectType ADD CONSTRAINT FK_t_RepresentationObjectType_containerId FOREIGN KEY (containerId) REFERENCES t_Resource (id)
53 ALTER TABLE t_Protocol ADD CONSTRAINT FK_t_Protocol_id FOREIGN KEY (id) REFERENCES t_Resource (id)
54 ALTER TABLE t_ParameterGroup ADD CONSTRAINT FK_t_ParameterGroup_containerId FOREIGN KEY (containerId) REFERENCES t_Resource (id)
55 ALTER TABLE t_PropertyGroup ADD CONSTRAINT FK_t_PropertyGroup_containerId FOREIGN KEY (containerId) REFERENCES t_ObjectType (id)
56 ALTER TABLE t_CompositeExperiment ADD CONSTRAINT FK_t_CompositeExperiment_id FOREIGN KEY (id) REFERENCES t_Resource (id)
57 ALTER TABLE t_GenericParameterSetting ADD CONSTRAINT FK_t_GenericParameterSetting_id FOREIGN KEY (id) REFERENCES t_ParameterSetting (id)
58 ALTER TABLE t_ClusterFinder ADD CONSTRAINT FK_t_ClusterFinder_id FOREIGN KEY (id) REFERENCES t_Resource (id)
59 ALTER TABLE t_PostProcessing ADD CONSTRAINT FK_t_PostProcessing_primaryExperimentId FOREIGN KEY (primaryExperimentId) REFERENCES t_Resource (id)
60 ALTER TABLE t_PostProcessing ADD CONSTRAINT FK_t_PostProcessing_id FOREIGN KEY (id) REFERENCES t_Resource (id)
61 ALTER TABLE t_InputDataset ADD CONSTRAINT FK_t_InputDataset_containerId FOREIGN KEY (containerId) REFERENCES t_Resource (id)
62 ALTER TABLE t_InputDataset ADD CONSTRAINT FK_t_InputDataset_snapshotId FOREIGN KEY (snapshotId) REFERENCES t_Snapshot (id)
63 ALTER TABLE t_AppliedPhysics ADD CONSTRAINT FK_t_AppliedPhysics_physicsId FOREIGN KEY (physicsId) REFERENCES t_Physics (id)
64 ALTER TABLE t_AppliedPhysics ADD CONSTRAINT FK_t_AppliedPhysics_containerId FOREIGN KEY (containerId) REFERENCES t_Resource (id)
65 ALTER TABLE t_PropertyGroupMember ADD CONSTRAINT FK_t_PropertyGroupMember_propertyId FOREIGN KEY (propertyId) REFERENCES t_Property (id)
66 ALTER TABLE t_PropertyGroupMember ADD CONSTRAINT FK_t_PropertyGroupMember_containerId FOREIGN KEY (containerId) REFERENCES t_PropertyGroup (id)
67 ALTER TABLE t_TargetObjectType ADD CONSTRAINT FK_t_TargetObjectType_containerId FOREIGN KEY (containerId) REFERENCES t_Resource (id)
68 ALTER TABLE t_TargetObjectType ADD CONSTRAINT FK_t_TargetObjectType_id FOREIGN KEY (id) REFERENCES t_ObjectType (id)
69 ALTER TABLE t_ParameterSetting ADD CONSTRAINT FK_t_ParameterSetting_inputParameterId FOREIGN KEY (inputParameterId) REFERENCES t_InputParameter (id)
70 ALTER TABLE t_ParameterSetting ADD CONSTRAINT FK_t_ParameterSetting_containerId FOREIGN KEY (containerId) REFERENCES t_Resource (id)
71 ALTER TABLE t_InputParameter ADD CONSTRAINT FK_t_InputParameter_containerId FOREIGN KEY (containerId) REFERENCES t_Resource (id)
72 ALTER TABLE t_ClusterDetection ADD CONSTRAINT FK_t_ClusterDetection_id FOREIGN KEY (id) REFERENCES t_Resource (id)
73 ALTER TABLE t_CompositeProtocol ADD CONSTRAINT FK_t_CompositeProtocol_id FOREIGN KEY (id) REFERENCES t_Resource (id)
74 ALTER TABLE t_ExperimentRepresentationObject ADD CONSTRAINT FK_t_ExperimentRepresentationObject_typeId FOREIGN KEY (typeId) REFERENCES t_ObjectType (id)
75 ALTER TABLE t_ExperimentRepresentationObject ADD CONSTRAINT FK_t_ExperimentRepresentationObject_containerId FOREIGN KEY (containerId) REFERENCES t_Resource (id)
76 ALTER TABLE t_ProjectExperiment ADD CONSTRAINT FK_t_ProjectExperiment_experimentId FOREIGN KEY (experimentId) REFERENCES t_Resource (id)
77 ALTER TABLE t_ProjectExperiment ADD CONSTRAINT FK_t_ProjectExperiment_containerId FOREIGN KEY (containerId) REFERENCES t_Resource (id)
78 ALTER TABLE t_TargetProcess ADD CONSTRAINT FK_t_TargetProcess_id FOREIGN KEY (id) REFERENCES t_ObjectType (id)
79 ALTER TABLE t_TargetProcess ADD CONSTRAINT FK_t_TargetProcess_containerId FOREIGN KEY (containerId) REFERENCES t_Resource (id)
80 ALTER TABLE t_Characterisation ADD CONSTRAINT FK_t_Characterisation_axisId FOREIGN KEY (axisId) REFERENCES t_ExperimentProperty (id)
81 ALTER TABLE t_Characterisation ADD CONSTRAINT FK_t_Characterisation_containerId FOREIGN KEY (containerId) REFERENCES t_ObjectCollection (id)
82 ALTER TABLE t_Project ADD CONSTRAINT FK_t_Project_id FOREIGN KEY (id) REFERENCES t_Resource (id)
83 ALTER TABLE t_Physics ADD CONSTRAINT FK_t_Physics_containerId FOREIGN KEY (containerId) REFERENCES t_Resource (id)
84 ALTER TABLE t_NumericParameterSetting ADD CONSTRAINT FK_t_NumericParameterSetting_id FOREIGN KEY (id) REFERENCES t_ParameterSetting (id)
85 ALTER TABLE t_SubvolumeExtractor ADD CONSTRAINT FK_t_SubvolumeExtractor_id FOREIGN KEY (id) REFERENCES t_Resource (id)
86 ALTER TABLE t_ChildProtocol ADD CONSTRAINT FK_t_ChildProtocol_protocolId FOREIGN KEY (protocolId) REFERENCES t_Resource (id)
87 ALTER TABLE t_ChildProtocol ADD CONSTRAINT FK_t_ChildProtocol_containerId FOREIGN KEY (containerId) REFERENCES t_Resource (id)
88 ALTER TABLE t_Experiment ADD CONSTRAINT FK_t_Experiment_id FOREIGN KEY (id) REFERENCES t_Resource (id)
89 ALTER TABLE t_Experiment ADD CONSTRAINT FK_t_Experiment_protocolId FOREIGN KEY (protocolId) REFERENCES t_Resource (id)
90 ALTER TABLE t_WebService ADD CONSTRAINT FK_t_WebService_containerId FOREIGN KEY (containerId) REFERENCES t_Resource (id)
91 ALTER TABLE t_Property ADD CONSTRAINT FK_t_Property_containerId FOREIGN KEY (containerId) REFERENCES t_ObjectType (id)
92 ALTER TABLE t_ChildExperiment ADD CONSTRAINT FK_t_ChildExperiment_experimentId FOREIGN KEY (experimentId) REFERENCES t_Resource (id)
93 ALTER TABLE t_ChildExperiment ADD CONSTRAINT FK_t_ChildExperiment_containerId FOREIGN KEY (containerId) REFERENCES t_Resource (id)
94 ALTER TABLE t_ExperimentProperty ADD CONSTRAINT FK_t_ExperimentProperty_propertyId FOREIGN KEY (propertyId) REFERENCES t_Property (id)
95 ALTER TABLE t_ExperimentProperty ADD CONSTRAINT FK_t_ExperimentProperty_containerId FOREIGN KEY (containerId) REFERENCES t_ExperimentRepresentationObject (id)
96 ALTER TABLE t_ObjectCollection ADD CONSTRAINT FK_t_ObjectCollection_objectTypeId FOREIGN KEY (objectTypeId) REFERENCES t_ExperimentRepresentationObject (id)
97 ALTER TABLE t_ObjectCollection ADD CONSTRAINT FK_t_ObjectCollection_containerId FOREIGN KEY (containerId) REFERENCES t_Snapshot (id)
98 ALTER TABLE t_ParameterGroupMember ADD CONSTRAINT FK_t_ParameterGroupMember_parameterId FOREIGN KEY (parameterId) REFERENCES t_InputParameter (id)
99 ALTER TABLE t_ParameterGroupMember ADD CONSTRAINT FK_t_ParameterGroupMember_containerId FOREIGN KEY (containerId) REFERENCES t_ParameterGroup (id)
100 ALTER TABLE t_Algorithm ADD CONSTRAINT FK_t_Algorithm_containerId FOREIGN KEY (containerId) REFERENCES t_Resource (id)
101 ALTER TABLE t_Simulation ADD CONSTRAINT FK_t_Simulation_id FOREIGN KEY (id) REFERENCES t_Resource (id)
102 ALTER TABLE t_Curation ADD CONSTRAINT FK_t_Curation_contactId FOREIGN KEY (contactId) REFERENCES t_Contact (id)
103 ALTER TABLE t_Curation ADD CONSTRAINT FK_t_Curation_containerId FOREIGN KEY (containerId) REFERENCES t_Resource (id)
104 ALTER TABLE t_Visualiser ADD CONSTRAINT FK_t_Visualiser_id FOREIGN KEY (id) REFERENCES t_Resource (id)

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