/[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 625 by bourges.laurent, Fri Jun 20 09:58:32 2008 UTC revision 626 by bourges.laurent, Thu Jun 26 10:46:17 2008 UTC
# Line 2  Line 2 
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, xmlId VARCHAR(255), ivoId 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))  CREATE TABLE t_Snapshot (id  SERIAL NOT NULL, OPTLOCK INTEGER, publisherDID VARCHAR(255) NOT NULL, xmlId VARCHAR(255), ivoId 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))
 CREATE TABLE t_ChildObject (id  SERIAL NOT NULL, OPTLOCK INTEGER, name VARCHAR(32) NOT NULL, cardinality VARCHAR(255), xmlId VARCHAR(255), ivoId VARCHAR(255), containerId BIGINT NOT NULL, objectId BIGINT NOT NULL, PRIMARY KEY (id))  
 CREATE TABLE t_Protocol (id BIGINT NOT NULL, code VARCHAR(255), version VARCHAR(255), PRIMARY KEY (id))  
5  CREATE TABLE t_RepresentationObjectType (id BIGINT NOT NULL, type VARCHAR(255), label VARCHAR(255), containerId BIGINT NOT NULL, PRIMARY KEY (id))  CREATE TABLE t_RepresentationObjectType (id BIGINT NOT NULL, type VARCHAR(255), label VARCHAR(255), containerId BIGINT NOT NULL, PRIMARY KEY (id))
6    CREATE TABLE t_Protocol (id BIGINT NOT NULL, code VARCHAR(255), version VARCHAR(255), PRIMARY KEY (id))
7    CREATE TABLE t_ChildObject (id  SERIAL NOT NULL, OPTLOCK INTEGER, name VARCHAR(32) NOT NULL, cardinality VARCHAR(255), xmlId VARCHAR(255), ivoId VARCHAR(255), containerId BIGINT NOT NULL, objectId BIGINT NOT NULL, PRIMARY KEY (id))
8  CREATE TABLE t_ParameterGroup (id  SERIAL NOT NULL, OPTLOCK INTEGER, name VARCHAR(255), description TEXT, xmlId VARCHAR(255), ivoId VARCHAR(255), containerId BIGINT NOT NULL, PRIMARY KEY (id))  CREATE TABLE t_ParameterGroup (id  SERIAL NOT NULL, OPTLOCK INTEGER, name VARCHAR(255), description TEXT, xmlId VARCHAR(255), ivoId 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), ivoId 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), ivoId VARCHAR(255), containerId BIGINT NOT NULL, PRIMARY KEY (id))
 CREATE TABLE t_GenericParameterSetting (id BIGINT NOT NULL, value VARCHAR(255) 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))
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))
 CREATE TABLE t_InputDataset (id  SERIAL NOT NULL, OPTLOCK INTEGER, xmlId VARCHAR(255), ivoId VARCHAR(255), containerId BIGINT NOT NULL, snapshotId BIGINT NOT NULL, PRIMARY KEY (id))  
14  CREATE TABLE t_AppliedPhysics (id  SERIAL NOT NULL, OPTLOCK INTEGER, xmlId VARCHAR(255), ivoId VARCHAR(255), containerId BIGINT NOT NULL, physicsId BIGINT NOT NULL, PRIMARY KEY (id))  CREATE TABLE t_AppliedPhysics (id  SERIAL NOT NULL, OPTLOCK INTEGER, xmlId VARCHAR(255), ivoId VARCHAR(255), containerId BIGINT NOT NULL, physicsId BIGINT NOT NULL, PRIMARY KEY (id))
15  CREATE TABLE t_PropertyGroupMember (id  SERIAL NOT NULL, OPTLOCK INTEGER, xmlId VARCHAR(255), ivoId VARCHAR(255), containerId BIGINT NOT NULL, propertyId BIGINT NOT NULL, PRIMARY KEY (id))  CREATE TABLE t_PropertyGroupMember (id  SERIAL NOT NULL, OPTLOCK INTEGER, xmlId VARCHAR(255), ivoId VARCHAR(255), containerId BIGINT NOT NULL, propertyId BIGINT NOT NULL, PRIMARY KEY (id))
16  CREATE TABLE t_Party (id  SERIAL NOT NULL, OPTLOCK INTEGER, name VARCHAR(255) NOT NULL, address VARCHAR(255), email VARCHAR(255), telephone VARCHAR(255), xmlId VARCHAR(255), ivoId VARCHAR(255), PRIMARY KEY (id))  CREATE TABLE t_InputDataset (id  SERIAL NOT NULL, OPTLOCK INTEGER, xmlId VARCHAR(255), ivoId VARCHAR(255), containerId BIGINT NOT NULL, snapshotId BIGINT NOT NULL, PRIMARY KEY (id))
17  CREATE TABLE t_TargetObjectType (id BIGINT NOT NULL, multiplicity VARCHAR(255), identityName VARCHAR(255), label VARCHAR(255), containerId BIGINT NOT NULL, PRIMARY KEY (id))  CREATE TABLE t_TargetObjectType (id BIGINT NOT NULL, multiplicity VARCHAR(255), identityName VARCHAR(255), label VARCHAR(255), containerId BIGINT NOT NULL, PRIMARY KEY (id))
18    CREATE TABLE t_Party (id  SERIAL NOT NULL, OPTLOCK INTEGER, name VARCHAR(255) NOT NULL, address VARCHAR(255), email VARCHAR(255), telephone VARCHAR(255), xmlId VARCHAR(255), ivoId VARCHAR(255), PRIMARY KEY (id))
19  CREATE TABLE t_ParameterSetting (id  SERIAL NOT NULL, DTYPE VARCHAR(32), OPTLOCK INTEGER, xmlId VARCHAR(255), ivoId VARCHAR(255), 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), ivoId VARCHAR(255), containerId BIGINT NOT NULL, inputParameterId BIGINT, PRIMARY KEY (id))
20  CREATE TABLE t_InputParameter (id BIGINT NOT NULL, label VARCHAR(255), containerId BIGINT NOT NULL, PRIMARY KEY (id))  CREATE TABLE t_InputParameter (id BIGINT NOT NULL, label VARCHAR(255), containerId BIGINT NOT NULL, PRIMARY KEY (id))
21  CREATE TABLE t_ClusterDetection (id BIGINT NOT NULL, PRIMARY KEY (id))  CREATE TABLE t_ClusterDetection (id BIGINT NOT NULL, PRIMARY KEY (id))
# Line 31  Line 31 
31  CREATE TABLE t_Contact (id  SERIAL NOT NULL, OPTLOCK INTEGER, role VARCHAR(255) NOT NULL, xmlId VARCHAR(255), ivoId VARCHAR(255), containerId BIGINT NOT NULL, partyId BIGINT NOT NULL, PRIMARY KEY (id))  CREATE TABLE t_Contact (id  SERIAL NOT NULL, OPTLOCK INTEGER, role VARCHAR(255) NOT NULL, xmlId VARCHAR(255), ivoId VARCHAR(255), containerId BIGINT NOT NULL, partyId BIGINT NOT NULL, PRIMARY KEY (id))
32  CREATE TABLE t_ChildProtocol (id  SERIAL NOT NULL, OPTLOCK INTEGER, xmlId VARCHAR(255), ivoId VARCHAR(255), containerId BIGINT NOT NULL, protocolId BIGINT NOT NULL, PRIMARY KEY (id))  CREATE TABLE t_ChildProtocol (id  SERIAL NOT NULL, OPTLOCK INTEGER, xmlId VARCHAR(255), ivoId VARCHAR(255), containerId BIGINT NOT NULL, protocolId BIGINT NOT NULL, PRIMARY KEY (id))
33  CREATE TABLE t_Experiment (id BIGINT NOT NULL, protocolId BIGINT NOT NULL, PRIMARY KEY (id))  CREATE TABLE t_Experiment (id BIGINT NOT NULL, protocolId BIGINT NOT NULL, PRIMARY KEY (id))
34  CREATE TABLE t_ValidValue (id  SERIAL NOT NULL, OPTLOCK INTEGER, value VARCHAR(255) NOT NULL, description VARCHAR(255), xmlId VARCHAR(255), ivoId VARCHAR(255), containerId BIGINT NOT NULL, PRIMARY KEY (id))  CREATE TABLE t_ValidValue (id  SERIAL NOT NULL, OPTLOCK INTEGER, value VARCHAR(255) NOT NULL, description TEXT, label VARCHAR(255) NOT NULL, xmlId VARCHAR(255), ivoId VARCHAR(255), containerId BIGINT NOT NULL, PRIMARY KEY (id))
35  CREATE TABLE t_WebService (id  SERIAL NOT NULL, OPTLOCK INTEGER, baseURL VARCHAR(255) NOT NULL, description TEXT, type VARCHAR(255) NOT NULL, xmlId VARCHAR(255), ivoId VARCHAR(255), containerId BIGINT NOT NULL, PRIMARY KEY (id))  CREATE TABLE t_WebService (id  SERIAL NOT NULL, OPTLOCK INTEGER, baseURL VARCHAR(255) NOT NULL, description TEXT, type VARCHAR(255) NOT NULL, xmlId VARCHAR(255), ivoId VARCHAR(255), containerId BIGINT NOT NULL, PRIMARY KEY (id))
36  CREATE TABLE t_Field (id  SERIAL NOT NULL, DTYPE VARCHAR(32), OPTLOCK INTEGER, name VARCHAR(255), datatype VARCHAR(255), cardinality VARCHAR(255), description TEXT, isEnumerated BOOLEAN, xmlId VARCHAR(255), ivoId VARCHAR(255), PRIMARY KEY (id))  CREATE TABLE t_Field (id  SERIAL NOT NULL, DTYPE VARCHAR(32), OPTLOCK INTEGER, name VARCHAR(255), datatype VARCHAR(255), cardinality VARCHAR(255), description TEXT, isEnumerated BOOLEAN, xmlId VARCHAR(255), ivoId VARCHAR(255), PRIMARY KEY (id))
 CREATE TABLE t_ChildExperiment (id  SERIAL NOT NULL, OPTLOCK INTEGER, xmlId VARCHAR(255), ivoId VARCHAR(255), containerId BIGINT NOT NULL, experimentId BIGINT NOT NULL, PRIMARY KEY (id))  
37  CREATE TABLE t_Property (id BIGINT NOT NULL, ucd VARCHAR(255), containerId BIGINT NOT NULL, PRIMARY KEY (id))  CREATE TABLE t_Property (id BIGINT NOT NULL, ucd VARCHAR(255), containerId BIGINT NOT NULL, PRIMARY KEY (id))
38    CREATE TABLE t_ChildExperiment (id  SERIAL NOT NULL, OPTLOCK INTEGER, xmlId VARCHAR(255), ivoId VARCHAR(255), containerId BIGINT NOT NULL, experimentId BIGINT NOT NULL, PRIMARY KEY (id))
39  CREATE TABLE t_ExperimentProperty (id  SERIAL NOT NULL, OPTLOCK INTEGER, xmlId VARCHAR(255), ivoId VARCHAR(255), containerId BIGINT NOT NULL, propertyId BIGINT NOT NULL, PRIMARY KEY (id))  CREATE TABLE t_ExperimentProperty (id  SERIAL NOT NULL, OPTLOCK INTEGER, xmlId VARCHAR(255), ivoId VARCHAR(255), containerId BIGINT NOT NULL, propertyId BIGINT NOT NULL, PRIMARY KEY (id))
40  CREATE TABLE t_ObjectCollection (id  SERIAL NOT NULL, OPTLOCK INTEGER, numberOfObjects INTEGER, xmlId VARCHAR(255), ivoId VARCHAR(255), 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), ivoId VARCHAR(255), containerId BIGINT NOT NULL, objectTypeId BIGINT NOT NULL, PRIMARY KEY (id))
41  CREATE TABLE t_ObjectType (id  SERIAL NOT NULL, DTYPE VARCHAR(32), OPTLOCK INTEGER, name VARCHAR(32) NOT NULL, description TEXT, xmlId VARCHAR(255), ivoId VARCHAR(255), 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), ivoId VARCHAR(255), PRIMARY KEY (id))
# Line 48  Line 48 
48  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)
49  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)
50  ALTER TABLE t_Snapshot ADD CONSTRAINT FK_t_Snapshot_containerId FOREIGN KEY (containerId) REFERENCES t_Resource (id)  ALTER TABLE t_Snapshot ADD CONSTRAINT FK_t_Snapshot_containerId FOREIGN KEY (containerId) REFERENCES t_Resource (id)
 ALTER TABLE t_ChildObject ADD CONSTRAINT FK_t_ChildObject_containerId FOREIGN KEY (containerId) REFERENCES t_ObjectType (id)  
 ALTER TABLE t_ChildObject ADD CONSTRAINT FK_t_ChildObject_objectId FOREIGN KEY (objectId) REFERENCES t_ObjectType (id)  
 ALTER TABLE t_Protocol ADD CONSTRAINT FK_t_Protocol_id FOREIGN KEY (id) REFERENCES t_Resource (id)  
51  ALTER TABLE t_RepresentationObjectType ADD CONSTRAINT FK_t_RepresentationObjectType_id FOREIGN KEY (id) REFERENCES t_ObjectType (id)  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)  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_ChildObject ADD CONSTRAINT FK_t_ChildObject_containerId FOREIGN KEY (containerId) REFERENCES t_ObjectType (id)
55    ALTER TABLE t_ChildObject ADD CONSTRAINT FK_t_ChildObject_objectId FOREIGN KEY (objectId) REFERENCES t_ObjectType (id)
56  ALTER TABLE t_ParameterGroup ADD CONSTRAINT FK_t_ParameterGroup_containerId FOREIGN KEY (containerId) REFERENCES t_Resource (id)  ALTER TABLE t_ParameterGroup ADD CONSTRAINT FK_t_ParameterGroup_containerId FOREIGN KEY (containerId) REFERENCES t_Resource (id)
57  ALTER TABLE t_PropertyGroup ADD CONSTRAINT FK_t_PropertyGroup_containerId FOREIGN KEY (containerId) REFERENCES t_ObjectType (id)  ALTER TABLE t_PropertyGroup ADD CONSTRAINT FK_t_PropertyGroup_containerId FOREIGN KEY (containerId) REFERENCES t_ObjectType (id)
 ALTER TABLE t_GenericParameterSetting ADD CONSTRAINT FK_t_GenericParameterSetting_id FOREIGN KEY (id) REFERENCES t_ParameterSetting (id)  
58  ALTER TABLE t_CompositeExperiment ADD CONSTRAINT FK_t_CompositeExperiment_id FOREIGN KEY (id) REFERENCES t_Resource (id)  ALTER TABLE t_CompositeExperiment ADD CONSTRAINT FK_t_CompositeExperiment_id FOREIGN KEY (id) REFERENCES t_Resource (id)
59    ALTER TABLE t_GenericParameterSetting ADD CONSTRAINT FK_t_GenericParameterSetting_id FOREIGN KEY (id) REFERENCES t_ParameterSetting (id)
60  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)
61  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)
62  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)
 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)  
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_Field (id)  ALTER TABLE t_PropertyGroupMember ADD CONSTRAINT FK_t_PropertyGroupMember_propertyId FOREIGN KEY (propertyId) REFERENCES t_Field (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)
67    ALTER TABLE t_InputDataset ADD CONSTRAINT FK_t_InputDataset_containerId FOREIGN KEY (containerId) REFERENCES t_Resource (id)
68    ALTER TABLE t_InputDataset ADD CONSTRAINT FK_t_InputDataset_snapshotId FOREIGN KEY (snapshotId) REFERENCES t_Snapshot (id)
69  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)
70  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)
71  ALTER TABLE t_ParameterSetting ADD CONSTRAINT FK_t_ParameterSetting_inputParameterId FOREIGN KEY (inputParameterId) REFERENCES t_Field (id)  ALTER TABLE t_ParameterSetting ADD CONSTRAINT FK_t_ParameterSetting_inputParameterId FOREIGN KEY (inputParameterId) REFERENCES t_Field (id)
# Line 94  Line 94 
94  ALTER TABLE t_Experiment ADD CONSTRAINT FK_t_Experiment_protocolId FOREIGN KEY (protocolId) REFERENCES t_Resource (id)  ALTER TABLE t_Experiment ADD CONSTRAINT FK_t_Experiment_protocolId FOREIGN KEY (protocolId) REFERENCES t_Resource (id)
95  ALTER TABLE t_ValidValue ADD CONSTRAINT FK_t_ValidValue_containerId FOREIGN KEY (containerId) REFERENCES t_Field (id)  ALTER TABLE t_ValidValue ADD CONSTRAINT FK_t_ValidValue_containerId FOREIGN KEY (containerId) REFERENCES t_Field (id)
96  ALTER TABLE t_WebService ADD CONSTRAINT FK_t_WebService_containerId FOREIGN KEY (containerId) REFERENCES t_Resource (id)  ALTER TABLE t_WebService ADD CONSTRAINT FK_t_WebService_containerId FOREIGN KEY (containerId) REFERENCES t_Resource (id)
 ALTER TABLE t_ChildExperiment ADD CONSTRAINT FK_t_ChildExperiment_experimentId FOREIGN KEY (experimentId) REFERENCES t_Resource (id)  
 ALTER TABLE t_ChildExperiment ADD CONSTRAINT FK_t_ChildExperiment_containerId FOREIGN KEY (containerId) REFERENCES t_Resource (id)  
97  ALTER TABLE t_Property ADD CONSTRAINT FK_t_Property_containerId FOREIGN KEY (containerId) REFERENCES t_ObjectType (id)  ALTER TABLE t_Property ADD CONSTRAINT FK_t_Property_containerId FOREIGN KEY (containerId) REFERENCES t_ObjectType (id)
98  ALTER TABLE t_Property ADD CONSTRAINT FK_t_Property_id FOREIGN KEY (id) REFERENCES t_Field (id)  ALTER TABLE t_Property ADD CONSTRAINT FK_t_Property_id FOREIGN KEY (id) REFERENCES t_Field (id)
99    ALTER TABLE t_ChildExperiment ADD CONSTRAINT FK_t_ChildExperiment_experimentId FOREIGN KEY (experimentId) REFERENCES t_Resource (id)
100    ALTER TABLE t_ChildExperiment ADD CONSTRAINT FK_t_ChildExperiment_containerId FOREIGN KEY (containerId) REFERENCES t_Resource (id)
101  ALTER TABLE t_ExperimentProperty ADD CONSTRAINT FK_t_ExperimentProperty_propertyId FOREIGN KEY (propertyId) REFERENCES t_Field (id)  ALTER TABLE t_ExperimentProperty ADD CONSTRAINT FK_t_ExperimentProperty_propertyId FOREIGN KEY (propertyId) REFERENCES t_Field (id)
102  ALTER TABLE t_ExperimentProperty ADD CONSTRAINT FK_t_ExperimentProperty_containerId FOREIGN KEY (containerId) REFERENCES t_ExperimentRepresentationObject (id)  ALTER TABLE t_ExperimentProperty ADD CONSTRAINT FK_t_ExperimentProperty_containerId FOREIGN KEY (containerId) REFERENCES t_ExperimentRepresentationObject (id)
103  ALTER TABLE t_ObjectCollection ADD CONSTRAINT FK_t_ObjectCollection_objectTypeId FOREIGN KEY (objectTypeId) REFERENCES t_ObjectType (id)  ALTER TABLE t_ObjectCollection ADD CONSTRAINT FK_t_ObjectCollection_objectTypeId FOREIGN KEY (objectTypeId) REFERENCES t_ObjectType (id)

Legend:
Removed from v.625  
changed lines
  Added in v.626

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