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

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

Parent Directory Parent Directory | Revision Log Revision Log | View Patch Patch

revision 464 by bourges.laurent, Sun May 11 19:29:40 2008 UTC revision 465 by bourges.laurent, Mon May 12 16:19:59 2008 UTC
# Line 1  Line 1 
1  CREATE TABLE t_SubvolumeExtraction (id BIGINT NOT NULL, PRIMARY KEY (id))  CREATE TABLE t_SubvolumeExtraction (id BIGINT NOT NULL, PRIMARY KEY (id))
2  CREATE TABLE t_Visualisation (id BIGINT NOT NULL, PRIMARY KEY (id))  CREATE TABLE t_Visualisation (id BIGINT NOT NULL, PRIMARY KEY (id))
3  CREATE TABLE t_Simulator (id BIGINT NOT NULL, PRIMARY KEY (id))  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, 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))  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), containerId BIGINT NOT NULL, objectId BIGINT NOT NULL, PRIMARY KEY (id))  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))  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))  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), containerId BIGINT NOT NULL, PRIMARY KEY (id))  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), containerId BIGINT NOT NULL, PRIMARY KEY (id))  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))  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))  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))  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))  CREATE TABLE t_PostProcessing (id BIGINT NOT NULL, primaryExperimentId BIGINT, PRIMARY KEY (id))
14  CREATE TABLE t_AppliedPhysics (id  SERIAL NOT NULL, OPTLOCK INTEGER, containerId BIGINT NOT NULL, physicsId BIGINT NOT NULL, PRIMARY KEY (id))  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_PropertyGroupMember (id  SERIAL NOT NULL, OPTLOCK INTEGER, containerId BIGINT NOT NULL, propertyId BIGINT NOT NULL, PRIMARY KEY (id))  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_InputDataset (id  SERIAL NOT NULL, OPTLOCK INTEGER, containerId BIGINT NOT NULL, snapshotId BIGINT NOT NULL, PRIMARY KEY (id))  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))  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, containerId BIGINT NOT NULL, inputParameterId BIGINT, PRIMARY KEY (id))  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), containerId BIGINT NOT NULL, PRIMARY KEY (id))  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))
 CREATE TABLE t_CompositeProtocol (id BIGINT NOT NULL, PRIMARY KEY (id))  
20  CREATE TABLE t_ClusterDetection (id BIGINT NOT NULL, PRIMARY KEY (id))  CREATE TABLE t_ClusterDetection (id BIGINT NOT NULL, PRIMARY KEY (id))
21  CREATE TABLE t_ExperimentRepresentationObject (id  SERIAL NOT NULL, OPTLOCK INTEGER, containerId BIGINT NOT NULL, typeId BIGINT NOT NULL, PRIMARY KEY (id))  CREATE TABLE t_CompositeProtocol (id BIGINT NOT NULL, PRIMARY KEY (id))
22  CREATE TABLE t_ProjectExperiment (id  SERIAL NOT NULL, OPTLOCK INTEGER, containerId BIGINT NOT NULL, experimentId BIGINT NOT NULL, PRIMARY KEY (id))  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))  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))  CREATE TABLE t_Project (id BIGINT NOT NULL, PRIMARY KEY (id))
27  CREATE TABLE t_Characterisation (id  SERIAL NOT NULL, OPTLOCK INTEGER, type VARCHAR(255), aPriori BOOLEAN, value_value VARCHAR(255) NOT NULL, value_unit VARCHAR(32), containerId BIGINT NOT NULL, axisId BIGINT NOT NULL, PRIMARY KEY (id))  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))
 CREATE TABLE t_Physics (id  SERIAL NOT NULL, OPTLOCK INTEGER, name VARCHAR(255), description VARCHAR(255), texForm VARCHAR(255), physicslabel 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))  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))  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), PRIMARY KEY (id))  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, containerId BIGINT NOT NULL, protocolId BIGINT NOT NULL, PRIMARY KEY (id))  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))  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, containerId BIGINT NOT NULL, PRIMARY KEY (id))  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), containerId BIGINT NOT NULL, PRIMARY KEY (id))  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, containerId BIGINT NOT NULL, experimentId BIGINT NOT NULL, PRIMARY KEY (id))  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, containerId BIGINT NOT NULL, propertyId BIGINT NOT NULL, PRIMARY KEY (id))  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, containerId BIGINT NOT NULL, objectTypeId BIGINT NOT NULL, PRIMARY KEY (id))  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, PRIMARY KEY (id))  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, containerId BIGINT NOT NULL, parameterId BIGINT NOT NULL, PRIMARY KEY (id))  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), containerId BIGINT NOT NULL, PRIMARY KEY (id))  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))  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), containerId BIGINT NOT NULL, contactId BIGINT, PRIMARY KEY (id))  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))  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), PRIMARY KEY (id))  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)  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)  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)  ALTER TABLE t_Simulator ADD CONSTRAINT FK_t_Simulator_id FOREIGN KEY (id) REFERENCES t_Resource (id)
# Line 58  Line 58 
58  ALTER TABLE t_ClusterFinder ADD CONSTRAINT FK_t_ClusterFinder_id FOREIGN KEY (id) REFERENCES t_Resource (id)  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)  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)  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)  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)  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)  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)  ALTER TABLE t_PropertyGroupMember ADD CONSTRAINT FK_t_PropertyGroupMember_containerId FOREIGN KEY (containerId) REFERENCES t_PropertyGroup (id)
 ALTER TABLE t_InputDataset ADD CONSTRAINT FK_t_InputDataset_containerId FOREIGN KEY (containerId) REFERENCES t_Resource (id)  
 ALTER TABLE t_InputDataset ADD CONSTRAINT FK_t_InputDataset_snapshotId FOREIGN KEY (snapshotId) REFERENCES t_Snapshot (id)  
67  ALTER TABLE t_TargetObjectType ADD CONSTRAINT FK_t_TargetObjectType_containerId FOREIGN KEY (containerId) REFERENCES t_Resource (id)  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)  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)  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)  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)  ALTER TABLE t_InputParameter ADD CONSTRAINT FK_t_InputParameter_containerId FOREIGN KEY (containerId) REFERENCES t_Resource (id)
 ALTER TABLE t_CompositeProtocol ADD CONSTRAINT FK_t_CompositeProtocol_id FOREIGN KEY (id) REFERENCES t_Resource (id)  
72  ALTER TABLE t_ClusterDetection ADD CONSTRAINT FK_t_ClusterDetection_id FOREIGN KEY (id) REFERENCES t_Resource (id)  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)  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)  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)  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)  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)  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)  ALTER TABLE t_TargetProcess ADD CONSTRAINT FK_t_TargetProcess_containerId FOREIGN KEY (containerId) REFERENCES t_Resource (id)
 ALTER TABLE t_Project ADD CONSTRAINT FK_t_Project_id FOREIGN KEY (id) REFERENCES t_Resource (id)  
80  ALTER TABLE t_Characterisation ADD CONSTRAINT FK_t_Characterisation_axisId FOREIGN KEY (axisId) REFERENCES t_ExperimentProperty (id)  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)  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)  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)  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)  ALTER TABLE t_SubvolumeExtractor ADD CONSTRAINT FK_t_SubvolumeExtractor_id FOREIGN KEY (id) REFERENCES t_Resource (id)

Legend:
Removed from v.464  
changed lines
  Added in v.465

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