CREATE TABLE t_SubvolumeExtraction (id BIGINT NOT NULL, PRIMARY KEY (id))
CREATE TABLE t_Visualisation (id BIGINT NOT NULL, PRIMARY KEY (id))
CREATE TABLE t_Simulator (id BIGINT NOT NULL, PRIMARY KEY (id))
CREATE TABLE t_Snapshot (id  SERIAL NOT NULL, OPTLOCK INTEGER, rank INTEGER NOT NULL, 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, rank INTEGER NOT NULL, 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_RepresentationObjectType (id BIGINT NOT NULL, rank INTEGER NOT NULL, type VARCHAR(255) NOT NULL, label VARCHAR(255), containerId BIGINT NOT NULL, PRIMARY KEY (id))
CREATE TABLE t_Protocol (id BIGINT NOT NULL, code VARCHAR(255) NOT NULL, version VARCHAR(255) NOT NULL, PRIMARY KEY (id))
CREATE TABLE t_ParameterGroup (id  SERIAL NOT NULL, OPTLOCK INTEGER, rank INTEGER NOT NULL, name VARCHAR(255) NOT NULL, description TEXT, xmlId VARCHAR(255), ivoId VARCHAR(255), containerId BIGINT NOT NULL, PRIMARY KEY (id))
CREATE TABLE t_PropertyGroup (id  SERIAL NOT NULL, OPTLOCK INTEGER, rank INTEGER NOT NULL, 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))
CREATE TABLE t_CompositeExperiment (id BIGINT NOT NULL, PRIMARY KEY (id))
CREATE TABLE t_PostProcessing (id BIGINT NOT NULL, primaryExperimentId BIGINT, PRIMARY KEY (id))
CREATE TABLE t_ClusterFinder (id BIGINT NOT NULL, PRIMARY KEY (id))
CREATE TABLE t_AppliedPhysics (id  SERIAL NOT NULL, OPTLOCK INTEGER, rank INTEGER NOT NULL, xmlId VARCHAR(255), ivoId VARCHAR(255), containerId BIGINT NOT NULL, physicsId BIGINT NOT NULL, PRIMARY KEY (id))
CREATE TABLE t_InputDataset (id  SERIAL NOT NULL, OPTLOCK INTEGER, rank INTEGER NOT NULL, xmlId VARCHAR(255), ivoId VARCHAR(255), containerId BIGINT NOT NULL, snapshotId BIGINT NOT NULL, PRIMARY KEY (id))
CREATE TABLE t_PropertyGroupMember (id  SERIAL NOT NULL, OPTLOCK INTEGER, rank INTEGER NOT NULL, xmlId VARCHAR(255), ivoId VARCHAR(255), containerId BIGINT NOT NULL, propertyId BIGINT NOT NULL, PRIMARY KEY (id))
CREATE TABLE t_TargetObjectType (id BIGINT NOT NULL, rank INTEGER NOT NULL, multiplicity VARCHAR(255), identityName VARCHAR(255), label VARCHAR(255), containerId BIGINT NOT NULL, PRIMARY KEY (id))
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_ParameterSetting (id  SERIAL NOT NULL, DTYPE VARCHAR(32), OPTLOCK INTEGER, rank INTEGER NOT NULL, xmlId VARCHAR(255), ivoId VARCHAR(255), containerId BIGINT NOT NULL, inputParameterId BIGINT NOT NULL, PRIMARY KEY (id))
CREATE TABLE t_InputParameter (id BIGINT NOT NULL, rank INTEGER NOT NULL, label VARCHAR(255), containerId BIGINT NOT NULL, PRIMARY KEY (id))
CREATE TABLE t_CompositeProtocol (id BIGINT NOT NULL, PRIMARY KEY (id))
CREATE TABLE t_ClusterDetection (id BIGINT NOT NULL, PRIMARY KEY (id))
CREATE TABLE t_ExperimentRepresentationObject (id  SERIAL NOT NULL, OPTLOCK INTEGER, rank INTEGER NOT NULL, xmlId VARCHAR(255), ivoId VARCHAR(255), containerId BIGINT NOT NULL, typeId BIGINT NOT NULL, PRIMARY KEY (id))
CREATE TABLE t_ProjectExperiment (id  SERIAL NOT NULL, OPTLOCK INTEGER, rank INTEGER NOT NULL, xmlId VARCHAR(255), ivoId VARCHAR(255), containerId BIGINT NOT NULL, experimentId BIGINT NOT NULL, PRIMARY KEY (id))
CREATE TABLE t_TargetProcess (id BIGINT NOT NULL, rank INTEGER NOT NULL, astroJournalSubject VARCHAR(255), containerId BIGINT NOT NULL, PRIMARY KEY (id))
CREATE TABLE t_Project (id BIGINT NOT NULL, PRIMARY KEY (id))
CREATE TABLE t_Characterisation (id  SERIAL NOT NULL, OPTLOCK INTEGER, rank INTEGER NOT NULL, type VARCHAR(255) NOT NULL, aPriori BOOLEAN, xmlId VARCHAR(255), ivoId VARCHAR(255), 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, rank INTEGER NOT NULL, name VARCHAR(255) NOT NULL, description VARCHAR(255), texForm VARCHAR(255), physicslabel VARCHAR(255), xmlId VARCHAR(255), ivoId VARCHAR(255), containerId BIGINT NOT NULL, PRIMARY KEY (id))
CREATE TABLE t_NumericParameterSetting (id BIGINT NOT NULL, value_value VARCHAR(255) NOT NULL, value_unit VARCHAR(32), PRIMARY KEY (id))
CREATE TABLE t_SubvolumeExtractor (id BIGINT NOT NULL, PRIMARY KEY (id))
CREATE TABLE t_Contact (id  SERIAL NOT NULL, OPTLOCK INTEGER, rank INTEGER NOT NULL, 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_ChildProtocol (id  SERIAL NOT NULL, OPTLOCK INTEGER, rank INTEGER NOT NULL, xmlId VARCHAR(255), ivoId VARCHAR(255), containerId 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))
CREATE TABLE t_ValidValue (id  SERIAL NOT NULL, OPTLOCK INTEGER, rank INTEGER NOT NULL, 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))
CREATE TABLE t_WebService (id  SERIAL NOT NULL, OPTLOCK INTEGER, rank INTEGER NOT NULL, 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_Field (id  SERIAL NOT NULL, DTYPE VARCHAR(32), OPTLOCK INTEGER, name VARCHAR(255) NOT NULL, datatype VARCHAR(255) NOT NULL, cardinality VARCHAR(255), description TEXT, isEnumerated BOOLEAN, xmlId VARCHAR(255), ivoId VARCHAR(255), PRIMARY KEY (id))
CREATE TABLE t_Property (id BIGINT NOT NULL, rank INTEGER NOT NULL, ucd VARCHAR(255), containerId BIGINT NOT NULL, PRIMARY KEY (id))
CREATE TABLE t_ChildExperiment (id  SERIAL NOT NULL, OPTLOCK INTEGER, rank INTEGER NOT NULL, xmlId VARCHAR(255), ivoId VARCHAR(255), containerId BIGINT NOT NULL, experimentId BIGINT NOT NULL, PRIMARY KEY (id))
CREATE TABLE t_ExperimentProperty (id  SERIAL NOT NULL, OPTLOCK INTEGER, rank INTEGER NOT NULL, xmlId VARCHAR(255), ivoId VARCHAR(255), containerId BIGINT NOT NULL, propertyId BIGINT NOT NULL, PRIMARY KEY (id))
CREATE TABLE t_ObjectCollection (id  SERIAL NOT NULL, OPTLOCK INTEGER, rank INTEGER NOT NULL, numberOfObjects INTEGER NOT NULL, xmlId VARCHAR(255), ivoId VARCHAR(255), containerId BIGINT NOT NULL, objectTypeId BIGINT NOT NULL, 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))
CREATE TABLE t_Algorithm (id  SERIAL NOT NULL, OPTLOCK INTEGER, rank INTEGER NOT NULL, name VARCHAR(255) NOT NULL, description TEXT, label VARCHAR(255), xmlId VARCHAR(255), ivoId VARCHAR(255), containerId BIGINT NOT NULL, PRIMARY KEY (id))
CREATE TABLE t_ParameterGroupMember (id  SERIAL NOT NULL, OPTLOCK INTEGER, rank INTEGER NOT NULL, xmlId VARCHAR(255), ivoId VARCHAR(255), containerId BIGINT NOT NULL, parameterId BIGINT NOT NULL, PRIMARY KEY (id))
CREATE TABLE t_Simulation (id BIGINT NOT NULL, executionTime TIMESTAMP, PRIMARY KEY (id))
CREATE TABLE t_Resource (id  SERIAL NOT NULL, DTYPE VARCHAR(32), OPTLOCK INTEGER, name VARCHAR(255) NOT NULL, description TEXT NOT NULL, referenceURL VARCHAR(255), publisherDID VARCHAR(255) NOT NULL, created TIMESTAMP NOT NULL, updated TIMESTAMP, status VARCHAR(255) NOT NULL, xmlId VARCHAR(255), ivoId VARCHAR(255), mainContactId BIGINT NOT NULL, PRIMARY KEY (id))
CREATE TABLE t_Visualiser (id BIGINT NOT NULL, PRIMARY KEY (id))
ALTER TABLE t_SubvolumeExtraction ADD CONSTRAINT FK_t_SubvolumeExtraction_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)
ALTER TABLE t_Simulator ADD CONSTRAINT FK_t_Simulator_id FOREIGN KEY (id) 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_RepresentationObjectType ADD CONSTRAINT FK_t_RepresentationObjectType_id FOREIGN KEY (id) REFERENCES t_ObjectType (id)
ALTER TABLE t_RepresentationObjectType ADD CONSTRAINT FK_t_RepresentationObjectType_containerId FOREIGN KEY (containerId) REFERENCES t_Resource (id)
ALTER TABLE t_Protocol ADD CONSTRAINT FK_t_Protocol_id FOREIGN KEY (id) REFERENCES t_Resource (id)
ALTER TABLE t_ParameterGroup ADD CONSTRAINT FK_t_ParameterGroup_containerId FOREIGN KEY (containerId) REFERENCES t_Resource (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)
ALTER TABLE t_CompositeExperiment ADD CONSTRAINT FK_t_CompositeExperiment_id FOREIGN KEY (id) REFERENCES t_Resource (id)
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_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)
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_containerId FOREIGN KEY (containerId) 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)
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_containerId FOREIGN KEY (containerId) REFERENCES t_PropertyGroup (id)
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_id FOREIGN KEY (id) REFERENCES t_ObjectType (id)
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_containerId FOREIGN KEY (containerId) REFERENCES t_Resource (id)
ALTER TABLE t_InputParameter ADD CONSTRAINT FK_t_InputParameter_id FOREIGN KEY (id) REFERENCES t_Field (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)
ALTER TABLE t_ClusterDetection ADD CONSTRAINT FK_t_ClusterDetection_id FOREIGN KEY (id) REFERENCES t_Resource (id)
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_containerId FOREIGN KEY (containerId) REFERENCES t_Resource (id)
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_containerId FOREIGN KEY (containerId) REFERENCES t_Resource (id)
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_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)
ALTER TABLE t_Characterisation ADD CONSTRAINT FK_t_Characterisation_axisId FOREIGN KEY (axisId) REFERENCES t_Field (id)
ALTER TABLE t_Characterisation ADD CONSTRAINT FK_t_Characterisation_containerId FOREIGN KEY (containerId) REFERENCES t_ObjectCollection (id)
ALTER TABLE t_Physics ADD CONSTRAINT FK_t_Physics_containerId FOREIGN KEY (containerId) REFERENCES t_Resource (id)
ALTER TABLE t_NumericParameterSetting ADD CONSTRAINT FK_t_NumericParameterSetting_id FOREIGN KEY (id) REFERENCES t_ParameterSetting (id)
ALTER TABLE t_SubvolumeExtractor ADD CONSTRAINT FK_t_SubvolumeExtractor_id FOREIGN KEY (id) REFERENCES t_Resource (id)
ALTER TABLE t_Contact ADD CONSTRAINT FK_t_Contact_containerId FOREIGN KEY (containerId) REFERENCES t_Resource (id)
ALTER TABLE t_Contact ADD CONSTRAINT FK_t_Contact_partyId FOREIGN KEY (partyId) REFERENCES t_Party (id)
ALTER TABLE t_ChildProtocol ADD CONSTRAINT FK_t_ChildProtocol_protocolId FOREIGN KEY (protocolId) REFERENCES t_Resource (id)
ALTER TABLE t_ChildProtocol ADD CONSTRAINT FK_t_ChildProtocol_containerId FOREIGN KEY (containerId) REFERENCES t_Resource (id)
ALTER TABLE t_Experiment ADD CONSTRAINT FK_t_Experiment_id FOREIGN KEY (id) REFERENCES t_Resource (id)
ALTER TABLE t_Experiment ADD CONSTRAINT FK_t_Experiment_protocolId FOREIGN KEY (protocolId) REFERENCES t_Resource (id)
ALTER TABLE t_ValidValue ADD CONSTRAINT FK_t_ValidValue_containerId FOREIGN KEY (containerId) REFERENCES t_Field (id)
ALTER TABLE t_WebService ADD CONSTRAINT FK_t_WebService_containerId FOREIGN KEY (containerId) REFERENCES t_Resource (id)
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_id FOREIGN KEY (id) REFERENCES t_Field (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)
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_containerId FOREIGN KEY (containerId) REFERENCES t_ExperimentRepresentationObject (id)
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_containerId FOREIGN KEY (containerId) REFERENCES t_Snapshot (id)
ALTER TABLE t_Algorithm ADD CONSTRAINT FK_t_Algorithm_containerId FOREIGN KEY (containerId) REFERENCES t_Resource (id)
ALTER TABLE t_ParameterGroupMember ADD CONSTRAINT FK_t_ParameterGroupMember_parameterId FOREIGN KEY (parameterId) REFERENCES t_Field (id)
ALTER TABLE t_ParameterGroupMember ADD CONSTRAINT FK_t_ParameterGroupMember_containerId FOREIGN KEY (containerId) REFERENCES t_ParameterGroup (id)
ALTER TABLE t_Simulation ADD CONSTRAINT FK_t_Simulation_id FOREIGN KEY (id) REFERENCES t_Resource (id)
ALTER TABLE t_Resource ADD CONSTRAINT FK_t_Resource_mainContactId FOREIGN KEY (mainContactId) REFERENCES t_Party (id)
ALTER TABLE t_Visualiser ADD CONSTRAINT FK_t_Visualiser_id FOREIGN KEY (id) REFERENCES t_Resource (id)