source: mauRepo/MolesManager/trunk/src/sqlTables.py @ 8014

from sqlalchemy import Table, Column, Integer, String, ForeignKey, Sequence, event, MetaData
from sqlalchemy.orm import relationship, backref, mapper, clear_mappers
from sqlalchemy.ext.declarative import declarative_base
from sqlalchemy.dialects.postgresql import ARRAY, TEXT, NUMERIC, BOOLEAN, DATE
from sqlalchemy.types import DateTime
from sqlalchemy.orm.util import class_mapper
from sqlalchemy.schema import ForeignKeyConstraint

from ascore.astext import ASText


        
from ea_model.iso_19111_referencing_by_coordinates.coordinate_reference_systems.sc_crs import  SC_CRS   
from ea_model.moles3_4.acquisition.mo_acquisition import  MO_Acquisition        
from ea_model.iso_19115_2006_metadata_corrigendum.metadata_entity_set_information.md_metadata import  MD_Metadata       
from ea_model.iso_19115_2006_metadata_corrigendum.metadata_extension_information.md_obligationcode import  MD_ObligationCode    
from ea_model.iso_19115_2006_metadata_corrigendum.identification_information.md_charactersetcode import  MD_CharacterSetCode    
from ea_model.iso_19115_2006_metadata_corrigendum.identification_information.ds_initiativetypecode import  DS_InitiativeTypeCode        
from ea_model.moles3_4.computation.mo_processing import  MO_Processing  
from ea_model.iso_19115_2006_metadata_corrigendum.citation_and_responsible_party_information.ci_date import  CI_Date    
from ea_model.moles3_4.acquisition.mo_operation import  MO_Operation    
from ea_model.iso_19108_2006_temporal_schema.temporal_reference_system.tm_position import  TM_Position  
from ea_model.iso_19115_2006_metadata_corrigendum.identification_information.md_progresscode import  MD_ProgressCode    
from ea_model.iso_19103_2005_schema_language.basic_types.derived.units_of_measure.scale import  Scale   
from ea_model.iso_19115_2006_metadata_corrigendum.distribution_information.md_distribution import  MD_Distribution      
from ea_model.iso_19111_referencing_by_coordinates.reference_systems.rs_referencesystem import  RS_ReferenceSystem      
from ea_model.iso_19115_2006_metadata_corrigendum.content_information.md_contentinformation import  MD_ContentInformation       
from ea_model.iso_19115_2006_metadata_corrigendum.reference_system_information.md_referencesystem import  MD_ReferenceSystem    
from ea_model.ceda_moles.ceda_acquisition.ceda_operation import  CEDA_Operation 
from ea_model.iso_19115_2006_metadata_corrigendum.citation_and_responsible_party_information.ci_address import  CI_Address      
from ea_model.iso_19115_2006_metadata_corrigendum.metadata_extension_information.md_datatypecode import  MD_DatatypeCode        
from ea_model.iso_19115_2006_metadata_corrigendum.portrayal_catalogue_information.md_portrayalcataloguereference import  MD_PortrayalCatalogueReference 
from ea_model.ceda_moles.ceda_acquisition.ceda_acquisition import  CEDA_Acquisition     
from ea_model.iso_19109_2005_application_schema.general_feature_model.gf_attributetype import  GF_AttributeType 
from ea_model.moles3_4.computation.mo_computation import  MO_Computation        
from ea_model.iso_19115_2006_metadata_corrigendum.citation_and_responsible_party_information.ci_telephone import  CI_Telephone  
from ea_model.iso_19108_2006_temporal_schema.temporal_reference_system.tm_indeterminatevalue import  TM_IndeterminateValue      
from ea_model.iso_19115_2006_metadata_corrigendum.citation_and_responsible_party_information.ci_onlineresource import  CI_OnlineResource        
from ea_model.iso_19103_2005_schema_language.basic_types.derived.units_of_measure.unitofmeasure import  UnitOfMeasure   
from ea_model.iso_19115_2006_metadata_corrigendum.extent_information.ex_extent import  EX_Extent        
from ea_model.iso_19115_2006_metadata_corrigendum.identification_information.md_aggregateinformation import  MD_AggregateInformation    
from ea_model.ceda_moles.ceda_observation.ceda_observation import  CEDA_Observation     
from ea_model.iso_19103_2005_schema_language.basic_types.implementation.names.genericname import  GenericName   
from ea_model.iso_19115_2006_metadata_corrigendum.identification_information.md_identification import  MD_Identification        
from ea_model.iso_19108_2006_temporal_schema.temporal_objects.tm_duration import  TM_Duration   
from ea_model.iso_19115_2006_metadata_corrigendum.citation_and_responsible_party_information.ci_responsibleparty import  CI_ResponsibleParty    
from ea_model.moles3_4.utilities.mo_rolevalue import  MO_RoleValue      
from ea_model.ceda_moles.ceda_utilities.ceda_reviewfrequencyvalue import  CEDA_ReviewFrequencyValue     
from ea_model.iso_19103_2005_schema_language.basic_types.primitive.date_and_time.datetime import  DateTime      
from ea_model.iso_19107_2003_spatial_schema.geometry.geometry_root.gm_object import  GM_Object  
from ea_model.iso_19115_2006_metadata_corrigendum.extent_information.ex_verticalextent import  EX_VerticalExtent        
from ea_model.moles3_4.observationcollection.mo_observationcollection import  MO_ObservationCollection  
from ea_model.iso_19115_2006_metadata_corrigendum.reference_system_information.rs_identifier import  RS_Identifier      
from ea_model.moles3_4.acquisition.mo_platform import  MO_Platform      
from ea_model.ceda_moles.ceda_computation.ceda_processing import  CEDA_Processing       
from ea_model.ceda_moles.ceda_acquisition.ceda_platform import  CEDA_Platform   
from ea_model.iso_19115_2006_metadata_corrigendum.extent_information.ex_geographicextent import  EX_GeographicExtent    
from ea_model.ceda_moles.ceda_result.ceda_result import  CEDA_Result    
from ea_model.ceda_moles.ceda_acquisition.ceda_instrument import  CEDA_Instrument       
from ea_model.moles3_4.acquisition.mo_platformtypevalue import  MO_PlatformTypeValue    
from ea_model.ceda_moles.ceda_result.ceda_curationvalue import  CEDA_CurationValue      
from ea_model.iso_19115_2006_metadata_corrigendum.maintenance_information.md_scopecode import  MD_ScopeCode     
from ea_model.iso_fdis_19156_2011_observations_and_measurements.observation_schema.observation.namedvalue import  NamedValue    
from ea_model.iso_19103_2005_schema_language.basic_types.implementation.records_and_class_metadata.any import  Any      
from ea_model.iso_19103_2005_schema_language.basic_types.derived.units_of_measure.time import  Time     
from ea_model.iso_19103_2005_schema_language.basic_types.primitive.date_and_time.clocktime import  ClockTime    
from ea_model.iso_fdis_19156_2011_observations_and_measurements.observation_schema.observation.om_process import  OM_Process    
from ea_model.iso_19115_2006_metadata_corrigendum.identification_information.md_keywordtypecode import  MD_KeywordTypeCode      
from ea_model.iso_19115_2006_metadata_corrigendum.data_quality_information.dq_scope import  DQ_Scope    
from ea_model.iso_19103_2005_schema_language.basic_types.implementation.names.localname import  LocalName       
from ea_model.iso_19115_2006_metadata_corrigendum.identification_information.md_keywords import  MD_Keywords    
from ea_model.moles3_4.computation.mo_inputoutput import  MO_InputOutput        
from ea_model.iso_19108_2006_temporal_schema.temporal_objects.tm_geometricprimitive import  TM_GeometricPrimitive       
from ea_model.iso_19103_2005_schema_language.basic_types.derived.units_of_measure.measuretype import  MeasureType       
from ea_model.iso_19108_2006_temporal_schema.temporal_objects.tm_primitive import  TM_Primitive 
from ea_model.moles3_4.observationprocess.mo_process import  MO_Process 
from ea_model.iso_19115_2006_metadata_corrigendum.maintenance_information.md_maintenancefrequencycode import  MD_MaintenanceFrequencyCode       
from ea_model.moles3_4.utilities.mo_publicationstatevalue import  MO_PublicationStateValue      
from ea_model.iso_19115_2006_metadata_corrigendum.citation_and_responsible_party_information.url import  URL    
from ea_model.iso_19115_2006_metadata_corrigendum.distribution_information.md_format import  MD_Format  
from ea_model.iso_19109_2005_application_schema.general_feature_model.gf_propertytype import  GF_PropertyType   
from ea_model.moles3_4.observation.mo_observation import  MO_Observation        
from ea_model.iso_19115_2006_metadata_corrigendum.identification_information.ds_associationtypecode import  DS_AssociationTypeCode      
from ea_model.iso_19115_2006_metadata_corrigendum.citation_and_responsible_party_information.ci_series import  CI_Series        
from ea_model.iso_19115_2006_metadata_corrigendum.citation_and_responsible_party_information.ci_datetypecode import  CI_DateTypeCode    
from ea_model.moles3_4.result.mo_onlineresource import  MO_OnlineResource       
from ea_model.iso_19103_2005_schema_language.basic_types.derived.units_of_measure.uomscale import  UomScale     
from ea_model.iso_19115_2006_metadata_corrigendum.data_quality_information.li_lineage import  LI_Lineage        
from ea_model.iso_19108_2006_temporal_schema.temporal_reference_system.tm_temporalposition import  TM_TemporalPosition  
from ea_model.iso_19103_2005_schema_language.basic_types.primitive.multiplicities.multiplicity import  Multiplicity     
from ea_model.iso_19108_2006_temporal_schema.temporal_objects.tm_period import  TM_Period       
from ea_model.ceda_moles.ceda_observationprocess.ceda_compositeprocess import  CEDA_CompositeProcess    
from ea_model.iso_19115_2006_metadata_corrigendum.spatial_representation_information.md_spatialrepresentation import  MD_SpatialRepresentation  
from ea_model.ceda_moles.ceda_project.ceda_project import  CEDA_Project 
from ea_model.iso_19115_2006_metadata_corrigendum.data_quality_information.dq_dataquality import  DQ_DataQuality        
from ea_model.iso_19115_2006_metadata_corrigendum.identification_information.md_browsegraphic import  MD_BrowseGraphic  
from ea_model.moles3_4.result.mo_result import  MO_Result       
from ea_model.iso_19115_2006_metadata_corrigendum.extent_information.ex_temporalextent import  EX_TemporalExtent        
from ea_model.iso_19103_2005_schema_language.basic_types.derived.units_of_measure.measure import  Measure       
from ea_model.iso_19103_2005_schema_language.basic_types.primitive.date_and_time.date import  Date      
from ea_model.iso_fdis_19156_2011_observations_and_measurements.observation_schema.observation.om_observation import  OM_Observation    
from ea_model.iso_19115_2006_metadata_corrigendum.data_quality_information.li_processstep import  LI_ProcessStep        
from ea_model.moles3_4.project.mo_project import  MO_Project    
from ea_model.iso_19115_2006_metadata_corrigendum.data_quality_information.dq_element import  DQ_Element        
from ea_model.iso_19115_2006_metadata_corrigendum.application_schema_information.md_applicationschemainformation import  MD_ApplicationSchemaInformation        
from ea_model.iso_19115_2006_metadata_corrigendum.reference_system_information.md_identifier import  MD_Identifier      
from ea_model.moles3_4.result.mo_onlinefunctionvalue import  MO_OnLineFunctionValue     
from ea_model.iso_19108_2006_temporal_schema.temporal_objects.tm_periodduration import  TM_PeriodDuration       
from ea_model.iso_19115_2006_metadata_corrigendum.citation_and_responsible_party_information.ci_onlinefunctioncode import  CI_OnLineFunctionCode        
from ea_model.ceda_moles.ceda_utilities.ceda_review import  CEDA_Review 
from ea_model.iso_19115_2006_metadata_corrigendum.data_quality_information.dq_result import  DQ_Result  
from ea_model.moles3_4.result.mo_applicationprofilevalue import  MO_ApplicationProfileValue     
from ea_model.iso_19115_2006_metadata_corrigendum.citation_and_responsible_party_information.ci_presentationformcode import  CI_PresentationFormCode    
from ea_model.iso_19115_2006_metadata_corrigendum.constraint_information.md_constraints import  MD_Constraints  
from ea_model.iso_19109_2005_application_schema.general_feature_model.gf_featuretype import  GF_FeatureType     
from ea_model.iso_19111_referencing_by_coordinates.identified_objects.io_identifiedobjectbase import  IO_IdentifiedObjectBase   
from ea_model.ceda_moles.ceda_utilities.ceda_reviewstatusvalue import  CEDA_ReviewStatusValue   
from ea_model.iso_19115_2006_metadata_corrigendum.maintenance_information.md_scopedescription import  MD_ScopeDescription       
from ea_model.ceda_moles.ceda_observationcollection.ceda_observationcollection import  CEDA_ObservationCollection       
from ea_model.ceda_moles.ceda_observation.ceda_citation import  CEDA_Citation   
from ea_model.iso_19115_2006_metadata_corrigendum.citation_and_responsible_party_information.ci_contact import  CI_Contact      
from ea_model.iso_19115_2006_metadata_corrigendum.identification_information.md_usage import  MD_Usage  
from ea_model.iso_19115_2006_metadata_corrigendum.metadata_extension_information.md_extendedelementinformation import  MD_ExtendedElementInformation    
from ea_model.iso_19103_2005_schema_language.basic_types.derived.units_of_measure.uomlength import  UomLength   
from ea_model.iso_19115_2006_metadata_corrigendum.metadata_extension_information.md_metadataextensioninformation import  MD_MetadataExtensionInformation        
from ea_model.moles3_4.acquisition.mo_instrument import  MO_Instrument  
from ea_model.iso_19115_2006_metadata_corrigendum.identification_information.md_representativefraction import  MD_RepresentativeFraction        
from ea_model.iso_19115_2006_metadata_corrigendum.citation_and_responsible_party_information.ci_rolecode import  CI_RoleCode    
from ea_model.iso_19108_2006_temporal_schema.temporal_objects.tm_instant import  TM_Instant     
from ea_model.moles3_4.acquisition.mo_location import  MO_Location      
from ea_model.iso_19115_2006_metadata_corrigendum.data_quality_information.dq_evaluationmethodtypecode import  DQ_EvaluationMethodTypeCode      
from ea_model.iso_19115_2006_metadata_corrigendum.citation_and_responsible_party_information.ci_citation import  CI_Citation    
from ea_model.moles3_4.observationprocess.mo_compositeprocess import  MO_CompositeProcess       
from ea_model.ceda_moles.ceda_observationprocess.ceda_process import  CEDA_Process      
from ea_model.iso_19103_2005_schema_language.basic_types.implementation.names.typename import  TypeName 
from ea_model.iso_19115_2006_metadata_corrigendum.data_quality_information.li_source import  LI_Source  
from ea_model.moles3_4.utilities.mo_responsiblepartyinfo import  MO_ResponsiblePartyInfo        
from ea_model.iso_19115_2006_metadata_corrigendum.extent_information.ex_geographicdescription import  EX_GeographicDescription  
from ea_model.iso_19115_2006_metadata_corrigendum.maintenance_information.md_maintenanceinformation import  MD_MaintenanceInformation   
from ea_model.iso_19109_2005_application_schema.general_feature_model.gf_constraint import  GF_Constraint       
from ea_model.moles3_4.acquisition.mo_instrumentplatformpair import  MO_InstrumentPlatformPair  
from ea_model.iso_19103_2005_schema_language.basic_types.primitive.date_and_time.dateprecision import  DatePrecision    
from ea_model.iso_19103_2005_schema_language.basic_types.implementation.names.scopedname import  ScopedName     
from ea_model.ceda_moles.ceda_utilities.ceda_notes import  CEDA_Notes   
from ea_model.iso_19108_2006_temporal_schema.temporal_objects.tm_object import  TM_Object

clear_mappers()
metadata = MetaData()
def next_id(connection, seq_name):
    seq = Sequence(seq_name)
    seq.create(bind=connection)
    return connection.execute(seq)












ci_series_table = Table('ci_series', metadata,
        Column('ci_series_id', Integer, Sequence('ci_series_id_seq'), primary_key=True),
        Column('ci_citation_series', Integer, ForeignKey('ci_citation.ci_citation_id')),
        Column('issueIdentification', TEXT , nullable=True),
        Column('name', TEXT , nullable=True),
        Column('page', TEXT , nullable=True),
Column('t_type', String(30), nullable=False, default='ci_series'),
        extend_existing=False,)
 
 










clocktime_table = Table('clocktime', metadata,
        Column('clocktime_id', Integer, Sequence('clocktime_id_seq'), primary_key=True),
        Column('minute', TEXT , nullable=True),
        Column('timeZone', TEXT , nullable=True),
        Column('second', TEXT , nullable=True),
        Column('hour', TEXT , nullable=False),
Column('t_type', String(30), nullable=False, default='clocktime'),
        extend_existing=False,)
 
 










md_distribution_table = Table('md_distribution', metadata,
        Column('md_distribution_id', Integer, Sequence('md_distribution_id_seq'), primary_key=True),
        Column('md_metadata_distributionInfo', Integer, ForeignKey('md_metadata.md_metadata_id')),
Column('t_type', String(30), nullable=False, default='md_distribution'),
        extend_existing=False,)
 
 










ci_telephone_table = Table('ci_telephone', metadata,
        Column('ci_telephone_id', Integer, Sequence('ci_telephone_id_seq'), primary_key=True),
        Column('ci_contact_phone', Integer, ForeignKey('ci_contact.ci_contact_id')),
        Column('voice', ARRAY(TEXT) , nullable=True),
        Column('facsimile', ARRAY(TEXT) , nullable=True),
Column('t_type', String(30), nullable=False, default='ci_telephone'),
        extend_existing=False,)
 
 










md_contentinformation_table = Table('md_contentinformation', metadata,
        Column('md_contentinformation_id', Integer, Sequence('md_contentinformation_id_seq'), primary_key=True),
        Column('md_metadata_contentInfo', Integer, ForeignKey('md_metadata.md_metadata_id')),
Column('t_type', String(30), nullable=False, default='md_contentinformation'),
        extend_existing=False,)
 
 










mo_responsiblepartyinfo_table = Table('mo_responsiblepartyinfo', metadata,
        Column('mo_responsiblepartyinfo_id', Integer, Sequence('mo_responsiblepartyinfo_id_seq'), primary_key=True),
        Column('mo_observation_relatedParty', Integer, ForeignKey('mo_observation.mo_observation_id')),
        Column('mo_acquisition_realatedParty', Integer, ForeignKey('mo_acquisition.mo_acquisition_id')),
        Column('mo_instrument_realatedParty', Integer, ForeignKey('mo_instrument.mo_instrument_id')),
        Column('mo_platform_relatedParty', Integer, ForeignKey('mo_platform.mo_platform_id')),
        Column('mo_compositeprocess_relatedParty', Integer, ForeignKey('mo_compositeprocess.mo_compositeprocess_id')),
        Column('ceda_notes_commentator', Integer, ForeignKey('ceda_notes.ceda_notes_id')),
        Column('ceda_review_reviewer', Integer, ForeignKey('ceda_review.ceda_review_id')),
        Column('mo_project_relatedParty', Integer, ForeignKey('mo_project.mo_project_id')),
        Column('mo_operation_relatedPartyInfo', Integer, ForeignKey('mo_operation.mo_operation_id')),
        Column('mo_processing_relatedParty', Integer, ForeignKey('mo_processing.mo_processing_id')),
        Column('role', MO_RoleValue.db_type() , nullable=False),
Column('t_type', String(30), nullable=False, default='mo_responsiblepartyinfo'),
        extend_existing=False,)
 
 










multiplicity_table = Table('multiplicity', metadata,
        Column('multiplicity_id', Integer, Sequence('multiplicity_id_seq'), primary_key=True),
        Column('gf_attributetype_cardinality', Integer, ForeignKey('gf_attributetype.gf_attributetype_id')),
Column('t_type', String(30), nullable=False, default='multiplicity'),
        extend_existing=False,)
 
 










tm_temporalposition_table = Table('tm_temporalposition', metadata,
        Column('tm_temporalposition_id', Integer, Sequence('tm_temporalposition_id_seq'), primary_key=True),
        Column('tm_position_anyOther', Integer, ForeignKey('tm_position.tm_position_id')),
        Column('indeterminatePosition', TM_IndeterminateValue.db_type() , nullable=True),
Column('t_type', String(30), nullable=False, default='tm_temporalposition'),
        extend_existing=False,)
 
 










genericname_table = Table('genericname', metadata,
        Column('genericname_id', Integer, Sequence('genericname_id_seq'), primary_key=True),
        Column('namedvalue_name', Integer, ForeignKey('namedvalue.namedvalue_id')),
        Column('io_identifiedobjectbase_alias', Integer, ForeignKey('io_identifiedobjectbase.io_identifiedobjectbase_id')),
        Column('mo_inputoutput_name', Integer, ForeignKey('mo_inputoutput.mo_inputoutput_id')),
Column('t_type', String(30), nullable=False, default='genericname'),
        extend_existing=False,)
 
 










om_process_table = Table('om_process', metadata,
        Column('om_process_id', Integer, Sequence('om_process_id_seq'), primary_key=True),
Column('t_type', String(30), nullable=False, default='om_process'),
        extend_existing=False,)
 
 










gf_constraint_table = Table('gf_constraint', metadata,
        Column('gf_constraint_id', Integer, Sequence('gf_constraint_id_seq'), primary_key=True),
        Column('gf_featuretype_constrainedBy', Integer, ForeignKey('gf_featuretype.gf_featuretype_id')),
        Column('gf_propertytype_constrainedBy', Integer, ForeignKey('gf_propertytype.gf_propertytype_id')),
        Column('description', TEXT , nullable=False),
Column('t_type', String(30), nullable=False, default='gf_constraint'),
        extend_existing=False,)
 
 










any_table = Table('any', metadata,
        Column('any_id', Integer, Sequence('any_id_seq'), primary_key=True),
        Column('om_observation_result', Integer, ForeignKey('om_observation.om_observation_id')),
        Column('namedvalue_value', Integer, ForeignKey('namedvalue.namedvalue_id')),
Column('t_type', String(30), nullable=False, default='any'),
        extend_existing=False,)
 
 










gm_object_table = Table('gm_object', metadata,
        Column('gm_object_id', Integer, Sequence('gm_object_id_seq'), primary_key=True),
        Column('mo_location_geometryLocation', Integer, ForeignKey('mo_location.mo_location_id')),
Column('t_type', String(30), nullable=False, default='gm_object'),
        extend_existing=False,)
 
 










ceda_citation_table = Table('ceda_citation', metadata,
        Column('ceda_citation_id', Integer, Sequence('ceda_citation_id_seq'), primary_key=True),
        Column('ceda_observation_citation', Integer, ForeignKey('ceda_observation.ceda_observation_id')),
        Column('author', ARRAY(TEXT) , nullable=False),
        Column('title', TEXT , nullable=False),
Column('t_type', String(30), nullable=False, default='ceda_citation'),
        extend_existing=False,)
 
 










dateprecision_table = Table('dateprecision', metadata,
        Column('dateprecision_id', Integer, Sequence('dateprecision_id_seq'), primary_key=True),
        Column('date_precision', Integer, ForeignKey('date.date_id')),
        Column('determinationMethod', TEXT , nullable=False),
        Column('precision', TEXT , nullable=False),
Column('t_type', String(30), nullable=False, default='dateprecision'),
        extend_existing=False,)
 
 










md_spatialrepresentation_table = Table('md_spatialrepresentation', metadata,
        Column('md_spatialrepresentation_id', Integer, Sequence('md_spatialrepresentation_id_seq'), primary_key=True),
        Column('md_metadata_spatialRepresentationInfo', Integer, ForeignKey('md_metadata.md_metadata_id')),
Column('t_type', String(30), nullable=False, default='md_spatialrepresentation'),
        extend_existing=False,)
 
 










md_format_table = Table('md_format', metadata,
        Column('md_format_id', Integer, Sequence('md_format_id_seq'), primary_key=True),
        Column('md_identification_resourceFormat', Integer, ForeignKey('md_identification.md_identification_id')),
        Column('amendmentNumber', TEXT , nullable=True),
        Column('name', TEXT , nullable=False),
        Column('specification', TEXT , nullable=True),
        Column('version', TEXT , nullable=False),
        Column('fileDecompressionTechnique', TEXT , nullable=True),
Column('t_type', String(30), nullable=False, default='md_format'),
        extend_existing=False,)
 
 










unitofmeasure_table = Table('unitofmeasure', metadata,
        Column('unitofmeasure_id', Integer, Sequence('unitofmeasure_id_seq'), primary_key=True),
        Column('offsetToStandardUnit', NUMERIC , nullable=True),
        Column('scaleToStandardUnit', NUMERIC , nullable=True),
        Column('uomName', TEXT , nullable=False),
        Column('measureType', MeasureType.db_type() , nullable=False),
        Column('formula', TEXT , nullable=True),
        Column('nameStandardUnit', TEXT , nullable=True),
        Column('uomSymbol', TEXT , nullable=False),
Column('t_type', String(30), nullable=False, default='unitofmeasure'),
        extend_existing=False,)
 
 










tm_duration_table = Table('tm_duration', metadata,
        Column('tm_duration_id', Integer, Sequence('tm_duration_id_seq'), primary_key=True),
Column('t_type', String(30), nullable=False, default='tm_duration'),
        extend_existing=False,)
 
 










measure_table = Table('measure', metadata,
        Column('measure_id', Integer, Sequence('measure_id_seq'), primary_key=True),
        Column('value', NUMERIC , nullable=False),
Column('t_type', String(30), nullable=False, default='measure'),
        extend_existing=False,)
 
 










ci_address_table = Table('ci_address', metadata,
        Column('ci_address_id', Integer, Sequence('ci_address_id_seq'), primary_key=True),
        Column('ci_contact_address', Integer, ForeignKey('ci_contact.ci_contact_id')),
        Column('deliveryPoint', ARRAY(TEXT) , nullable=True),
        Column('city', TEXT , nullable=True),
        Column('electronicMailAddress', ARRAY(TEXT) , nullable=True),
        Column('country', TEXT , nullable=True),
        Column('administrativeArea', TEXT , nullable=True),
        Column('postalCode', TEXT , nullable=True),
Column('t_type', String(30), nullable=False, default='ci_address'),
        extend_existing=False,)
 
 










earootclass_table = Table('earootclass', metadata,
        Column('earootclass_id', Integer, Sequence('earootclass_id_seq'), primary_key=True),
Column('t_type', String(30), nullable=False, default='earootclass'),
        extend_existing=False,)
 
 










tm_object_table = Table('tm_object', metadata,
        Column('tm_object_id', Integer, Sequence('tm_object_id_seq'), primary_key=True),
        Column('om_observation_phenomenonTime', Integer, ForeignKey('om_observation.om_observation_id')),
        Column('mo_operation_operationTime', Integer, ForeignKey('mo_operation.mo_operation_id')),
        Column('mo_observationcollection_phenomenonTime', Integer, ForeignKey('mo_observationcollection.mo_observationcollection_id')),
Column('t_type', String(30), nullable=False, default='tm_object'),
        extend_existing=False,)
 
 










dq_result_table = Table('dq_result', metadata,
        Column('dq_result_id', Integer, Sequence('dq_result_id_seq'), primary_key=True),
        Column('dq_element_result', Integer, ForeignKey('dq_element.dq_element_id')),
Column('t_type', String(30), nullable=False, default='dq_result'),
        extend_existing=False,)
 
 










url_table = Table('url', metadata,
        Column('url_id', Integer, Sequence('url_id_seq'), primary_key=True),
        Column('ci_onlineresource_linkage', Integer, ForeignKey('ci_onlineresource.ci_onlineresource_id')),
Column('t_type', String(30), nullable=False, default='url'),
        extend_existing=False,)
 
 










ex_geographicextent_table = Table('ex_geographicextent', metadata,
        Column('ex_geographicextent_id', Integer, Sequence('ex_geographicextent_id_seq'), primary_key=True),
        Column('ex_extent_geographicElement', Integer, ForeignKey('ex_extent.ex_extent_id')),
        Column('mo_observationcollection_geographicExtent', Integer, ForeignKey('mo_observationcollection.mo_observationcollection_id')),
        Column('mo_observation_geographicExtent', Integer, ForeignKey('mo_observation.mo_observation_id')),
        Column('extentTypeCode', BOOLEAN , nullable=True),
Column('t_type', String(30), nullable=False, default='ex_geographicextent'),
        extend_existing=False,)
 
 










md_browsegraphic_table = Table('md_browsegraphic', metadata,
        Column('md_browsegraphic_id', Integer, Sequence('md_browsegraphic_id_seq'), primary_key=True),
        Column('md_identification_graphicOverview', Integer, ForeignKey('md_identification.md_identification_id')),
        Column('fileType', TEXT , nullable=True),
        Column('fileName', TEXT , nullable=False),
        Column('fileDescription', TEXT , nullable=True),
Column('t_type', String(30), nullable=False, default='md_browsegraphic'),
        extend_existing=False,)
 
 










md_constraints_table = Table('md_constraints', metadata,
        Column('md_constraints_id', Integer, Sequence('md_constraints_id_seq'), primary_key=True),
        Column('mo_observation_permission', Integer, ForeignKey('mo_observation.mo_observation_id')),
        Column('md_identification_resourceConstraints', Integer, ForeignKey('md_identification.md_identification_id')),
        Column('md_metadata_metadataConstraints', Integer, ForeignKey('md_metadata.md_metadata_id')),
        Column('useLimitation', ARRAY(TEXT) , nullable=True),
Column('t_type', String(30), nullable=False, default='md_constraints'),
        extend_existing=False,)
 
 










time_table = Table('time', metadata,
        Column('time_id', Integer, Sequence('time_id_seq'), primary_key=True),
                                Column('measure_id', Integer, ForeignKey('measure.measure_id')),        Column('tm_position_time8601', Integer, ForeignKey('tm_position.tm_position_id')),
Column('t_type', String(30), nullable=False, default='time'),
        extend_existing=False,)
 
 










scopedname_table = Table('scopedname', metadata,
        Column('scopedname_id', Integer, Sequence('scopedname_id_seq'), primary_key=True),
                                Column('genericname_id', Integer, ForeignKey('genericname.genericname_id')),    Column('mo_instrument_type', Integer, ForeignKey('mo_instrument.mo_instrument_id')),
Column('t_type', String(30), nullable=False, default='scopedname'),
        extend_existing=False,)
 
 










namedvalue_table = Table('namedvalue', metadata,
        Column('namedvalue_id', Integer, Sequence('namedvalue_id_seq'), primary_key=True),
        Column('om_observation_parameter', Integer, ForeignKey('om_observation.om_observation_id')),
Column('t_type', String(30), nullable=False, default='namedvalue'),
        extend_existing=False,)
 
 










tm_primitive_table = Table('tm_primitive', metadata,
        Column('tm_primitive_id', Integer, Sequence('tm_primitive_id_seq'), primary_key=True),
                                Column('tm_object_id', Integer, ForeignKey('tm_object.tm_object_id')),  Column('ex_temporalextent_extent', Integer, ForeignKey('ex_temporalextent.ex_temporalextent_id')),
Column('t_type', String(30), nullable=False, default='tm_primitive'),
        extend_existing=False,)
 
 










uomscale_table = Table('uomscale', metadata,
        Column('uomscale_id', Integer, Sequence('uomscale_id_seq'), primary_key=True),
                                Column('unitofmeasure_id', Integer, ForeignKey('unitofmeasure.unitofmeasure_id')),      Column('scale_uom', Integer, ForeignKey('scale.scale_id')),
Column('t_type', String(30), nullable=False, default='uomscale'),
        extend_existing=False,)
 
 










tm_periodduration_table = Table('tm_periodduration', metadata,
        Column('tm_periodduration_id', Integer, Sequence('tm_periodduration_id_seq'), primary_key=True),
                                Column('tm_duration_id', Integer, ForeignKey('tm_duration.tm_duration_id')),    Column('md_maintenanceinformation_userDefinedMaintenanceFrequency', Integer, ForeignKey('md_maintenanceinformation.md_maintenanceinformation_id')),
        Column('hours', TEXT , nullable=True),
        Column('designator', TEXT , nullable=False),
        Column('years', TEXT , nullable=True),
        Column('timeIndicator', TEXT , nullable=True),
        Column('minutes', TEXT , nullable=True),
        Column('months', TEXT , nullable=True),
        Column('days', TEXT , nullable=True),
        Column('seconds', TEXT , nullable=True),
Column('t_type', String(30), nullable=False, default='tm_periodduration'),
        extend_existing=False,)
 
 










date_table = Table('date', metadata,
        Column('date_id', Integer, Sequence('date_id_seq'), primary_key=True),
        Column('ci_citation_editionDate', Integer, ForeignKey('ci_citation.ci_citation_id')),
        Column('md_maintenanceinformation_dateOfNextUpdate', Integer, ForeignKey('md_maintenanceinformation.md_maintenanceinformation_id')),
        Column('tm_position_date8601', Integer, ForeignKey('tm_position.tm_position_id')),
        Column('ci_date_date', Integer, ForeignKey('ci_date.ci_date_id')),
        Column('md_metadata_dateStamp', Integer, ForeignKey('md_metadata.md_metadata_id')),
        Column('day', TEXT , nullable=True),
        Column('century', TEXT , nullable=False),
        Column('month', TEXT , nullable=True),
        Column('year', TEXT , nullable=True),
Column('t_type', String(30), nullable=False, default='date'),
        extend_existing=False,)
 
 










mo_process_table = Table('mo_process', metadata,
        Column('mo_process_id', Integer, Sequence('mo_process_id_seq'), primary_key=True),
                                Column('om_process_id', Integer, ForeignKey('om_process.om_process_id')),Column('t_type', String(30), nullable=False, default='mo_process'),
        extend_existing=False,)
 
 










mo_inputoutput_table = Table('mo_inputoutput', metadata,
        Column('mo_inputoutput_id', Integer, Sequence('mo_inputoutput_id_seq'), primary_key=True),
        Column('mo_processing_processingInput', Integer, ForeignKey('mo_processing.mo_processing_id')),
        Column('mo_processing_processingOutput', Integer, ForeignKey('mo_processing.mo_processing_id')),
        Column('mo_acquisition_outputDescription', Integer, ForeignKey('mo_acquisition.mo_acquisition_id')),
Column('t_type', String(30), nullable=False, default='mo_inputoutput'),
        extend_existing=False,)
 
 










mo_computation_table = Table('mo_computation', metadata,
        Column('mo_computation_id', Integer, Sequence('mo_computation_id_seq'), primary_key=True),
                                Column('mo_process_id', Integer, ForeignKey('mo_process.mo_process_id')),       Column('mo_compositeprocess_computationComponent', Integer, ForeignKey('mo_compositeprocess.mo_compositeprocess_id')),
Column('t_type', String(30), nullable=False, default='mo_computation'),
        extend_existing=False,)
 
 










ci_onlineresource_table = Table('ci_onlineresource', metadata,
        Column('ci_onlineresource_id', Integer, Sequence('ci_onlineresource_id_seq'), primary_key=True),
        Column('md_metadataextensioninformation_extensionOnLineResource', Integer, ForeignKey('md_metadataextensioninformation.md_metadataextensioninformation_id')),
        Column('ci_contact_onlineResource', Integer, ForeignKey('ci_contact.ci_contact_id')),
        Column('mo_observationcollection_additionalMetadata', Integer, ForeignKey('mo_observationcollection.mo_observationcollection_id')),
        Column('name', TEXT , nullable=True),
        Column('function', CI_OnLineFunctionCode.db_type() , nullable=True),
        Column('applicationProfile', TEXT , nullable=True),
        Column('description', TEXT , nullable=True),
        Column('protocol', TEXT , nullable=True),
Column('t_type', String(30), nullable=False, default='ci_onlineresource'),
        extend_existing=False,)
 
 










localname_table = Table('localname', metadata,
        Column('localname_id', Integer, Sequence('localname_id_seq'), primary_key=True),
                                Column('genericname_id', Integer, ForeignKey('genericname.genericname_id')),    Column('gf_featuretype_typeName', Integer, ForeignKey('gf_featuretype.gf_featuretype_id')),
        Column('gf_propertytype_memberName', Integer, ForeignKey('gf_propertytype.gf_propertytype_id')),
Column('t_type', String(30), nullable=False, default='localname'),
        extend_existing=False,)
 
 










uomlength_table = Table('uomlength', metadata,
        Column('uomlength_id', Integer, Sequence('uomlength_id_seq'), primary_key=True),
                                Column('unitofmeasure_id', Integer, ForeignKey('unitofmeasure.unitofmeasure_id')),      Column('scale_sourceUnits', Integer, ForeignKey('scale.scale_id')),
        Column('scale_targetUnits', Integer, ForeignKey('scale.scale_id')),
Column('t_type', String(30), nullable=False, default='uomlength'),
        extend_existing=False,)
 
 










ceda_process_table = Table('ceda_process', metadata,
        Column('ceda_process_id', Integer, Sequence('ceda_process_id_seq'), primary_key=True),
                                Column('mo_process_id', Integer, ForeignKey('mo_process.mo_process_id')),       Column('ceda_observation_procedure', Integer, ForeignKey('ceda_observation.ceda_observation_id')),
Column('t_type', String(30), nullable=False, default='ceda_process'),
        extend_existing=False,)
 
 










mo_onlineresource_table = Table('mo_onlineresource', metadata,
        Column('mo_onlineresource_id', Integer, Sequence('mo_onlineresource_id_seq'), primary_key=True),
                                Column('ci_onlineresource_id', Integer, ForeignKey('ci_onlineresource.ci_onlineresource_id')),  Column('mo_result_source', Integer, ForeignKey('mo_result.mo_result_id')),
        Column('mo_result_sample', Integer, ForeignKey('mo_result.mo_result_id')),
        Column('ceda_project_projectResource', Integer, ForeignKey('ceda_project.ceda_project_id')),
        Column('applicationProfile', MO_ApplicationProfileValue.db_type() , nullable=False),
        Column('function', MO_OnLineFunctionValue.db_type() , nullable=False),
Column('t_type', String(30), nullable=False, default='mo_onlineresource'),
        extend_existing=False,)
 
 










scale_table = Table('scale', metadata,
        Column('scale_id', Integer, Sequence('scale_id_seq'), primary_key=True),
                                Column('measure_id', Integer, ForeignKey('measure.measure_id')),        Column('md_representativefraction_equivalentScale', Integer, ForeignKey('md_representativefraction.md_representativefraction_id')),
Column('t_type', String(30), nullable=False, default='scale'),
        extend_existing=False,)
 
 










typename_table = Table('typename', metadata,
        Column('typename_id', Integer, Sequence('typename_id_seq'), primary_key=True),
                                Column('localname_id', Integer, ForeignKey('localname.localname_id')),  Column('gf_attributetype_valueType', Integer, ForeignKey('gf_attributetype.gf_attributetype_id')),
        Column('aName', TEXT , nullable=False),
Column('t_type', String(30), nullable=False, default='typename'),
        extend_existing=False,)
 
 










mo_result_table = Table('mo_result', metadata,
        Column('mo_result_id', Integer, Sequence('mo_result_id_seq'), primary_key=True),
        Column('mo_observation_result', Integer, ForeignKey('mo_observation.mo_observation_id')),
Column('t_type', String(30), nullable=False, default='mo_result'),
        extend_existing=False,)
 
 










datetime_table = Table('datetime', metadata,
        Column('datetime_id', Integer, Sequence('datetime_id_seq'), primary_key=True),
                                Column('date_id', Integer, ForeignKey('date.date_id')),                 Column('clocktime_id', Integer, ForeignKey('clocktime.clocktime_id')),  Column('li_processstep_dateTime', Integer, ForeignKey('li_processstep.li_processstep_id')),
        Column('md_usage_usageDateTime', Integer, ForeignKey('md_usage.md_usage_id')),
        Column('tm_position_dateTime8601', Integer, ForeignKey('tm_position.tm_position_id')),
        Column('dq_element_dateTime', Integer, ForeignKey('dq_element.dq_element_id')),
        Column('ceda_notes_date', Integer, ForeignKey('ceda_notes.ceda_notes_id')),
Column('t_type', String(30), nullable=False, default='datetime'),
        extend_existing=False,)
 
 










gf_featuretype_table = Table('gf_featuretype', metadata,
        Column('gf_featuretype_id', Integer, Sequence('gf_featuretype_id_seq'), primary_key=True),
        Column('md_scopedescription_features', Integer, ForeignKey('md_scopedescription.md_scopedescription_id')),
        Column('md_scopedescription_featureInstances', Integer, ForeignKey('md_scopedescription.md_scopedescription_id')),
        Column('definition', TEXT , nullable=False),
        Column('isAbstract', BOOLEAN , nullable=False),
Column('t_type', String(30), nullable=False, default='gf_featuretype'),
        extend_existing=False,)
 
 










ceda_result_table = Table('ceda_result', metadata,
        Column('ceda_result_id', Integer, Sequence('ceda_result_id_seq'), primary_key=True),
                                Column('mo_result_id', Integer, ForeignKey('mo_result.mo_result_id')),  Column('ceda_observation_result', Integer, ForeignKey('ceda_observation.ceda_observation_id')),
        Column('numberOfFiles', Integer , nullable=True),
        Column('internalPath', TEXT , nullable=False),
        Column('curationCategory', CEDA_CurationValue.db_type() , nullable=False),
        Column('volume', Integer , nullable=True),
Column('t_type', String(30), nullable=False, default='ceda_result'),
        extend_existing=False,)
 
 










gf_propertytype_table = Table('gf_propertytype', metadata,
        Column('gf_propertytype_id', Integer, Sequence('gf_propertytype_id_seq'), primary_key=True),
        Column('om_observation_observedProperty', Integer, ForeignKey('om_observation.om_observation_id')),
        Column('definition', TEXT , nullable=False),
Column('t_type', String(30), nullable=False, default='gf_propertytype'),
        extend_existing=False,)
 
 










ci_date_table = Table('ci_date', metadata,
        Column('ci_date_id', Integer, Sequence('ci_date_id_seq'), primary_key=True),
        Column('ci_citation_date', Integer, ForeignKey('ci_citation.ci_citation_id')),
        Column('dateType', CI_DateTypeCode.db_type() , nullable=False),
Column('t_type', String(30), nullable=False, default='ci_date'),
        extend_existing=False,)
 
 










tm_geometricprimitive_table = Table('tm_geometricprimitive', metadata,
        Column('tm_geometricprimitive_id', Integer, Sequence('tm_geometricprimitive_id_seq'), primary_key=True),
                                Column('tm_primitive_id', Integer, ForeignKey('tm_primitive.tm_primitive_id')),Column('t_type', String(30), nullable=False, default='tm_geometricprimitive'),
        extend_existing=False,)
 
 










ex_temporalextent_table = Table('ex_temporalextent', metadata,
        Column('ex_temporalextent_id', Integer, Sequence('ex_temporalextent_id_seq'), primary_key=True),
        Column('ex_extent_temporalElement', Integer, ForeignKey('ex_extent.ex_extent_id')),
Column('t_type', String(30), nullable=False, default='ex_temporalextent'),
        extend_existing=False,)
 
 










ceda_notes_table = Table('ceda_notes', metadata,
        Column('ceda_notes_id', Integer, Sequence('ceda_notes_id_seq'), primary_key=True),
        Column('ceda_review_notes', Integer, ForeignKey('ceda_review.ceda_review_id')),
        Column('comments', TEXT , nullable=False),
Column('t_type', String(30), nullable=False, default='ceda_notes'),
        extend_existing=False,)
 
 










ci_contact_table = Table('ci_contact', metadata,
        Column('ci_contact_id', Integer, Sequence('ci_contact_id_seq'), primary_key=True),
        Column('ci_responsibleparty_contactInfo', Integer, ForeignKey('ci_responsibleparty.ci_responsibleparty_id')),
        Column('hoursOfService', TEXT , nullable=True),
        Column('contactInstructions', TEXT , nullable=True),
Column('t_type', String(30), nullable=False, default='ci_contact'),
        extend_existing=False,)
 
 










tm_position_table = Table('tm_position', metadata,
        Column('tm_position_id', Integer, Sequence('tm_position_id_seq'), primary_key=True),
        Column('tm_instant_position', Integer, ForeignKey('tm_instant.tm_instant_id')),
Column('t_type', String(30), nullable=False, default='tm_position'),
        extend_existing=False,)
 
 










tm_period_table = Table('tm_period', metadata,
        Column('tm_period_id', Integer, Sequence('tm_period_id_seq'), primary_key=True),
                                Column('tm_geometricprimitive_id', Integer, ForeignKey('tm_geometricprimitive.tm_geometricprimitive_id')),      Column('om_observation_validTime', Integer, ForeignKey('om_observation.om_observation_id')),
Column('t_type', String(30), nullable=False, default='tm_period'),
        extend_existing=False,)
 
 










md_representativefraction_table = Table('md_representativefraction', metadata,
        Column('md_representativefraction_id', Integer, Sequence('md_representativefraction_id_seq'), primary_key=True),
        Column('li_source_scaleDenominator', Integer, ForeignKey('li_source.li_source_id')),
        Column('denominator', Integer , nullable=False),
Column('t_type', String(30), nullable=False, default='md_representativefraction'),
        extend_existing=False,)
 
 










ci_responsibleparty_table = Table('ci_responsibleparty', metadata,
        Column('ci_responsibleparty_id', Integer, Sequence('ci_responsibleparty_id_seq'), primary_key=True),
        Column('md_extendedelementinformation_source', Integer, ForeignKey('md_extendedelementinformation.md_extendedelementinformation_id')),
        Column('md_metadata_contact', Integer, ForeignKey('md_metadata.md_metadata_id')),
        Column('md_usage_userContactInfo', Integer, ForeignKey('md_usage.md_usage_id')),
        Column('li_processstep_processor', Integer, ForeignKey('li_processstep.li_processstep_id')),
        Column('md_identification_pointOfContact', Integer, ForeignKey('md_identification.md_identification_id')),
        Column('md_maintenanceinformation_contact', Integer, ForeignKey('md_maintenanceinformation.md_maintenanceinformation_id')),
        Column('ci_citation_citedResponsibleParty', Integer, ForeignKey('ci_citation.ci_citation_id')),
        Column('role', CI_RoleCode.db_type() , nullable=False),
        Column('individualName', TEXT , nullable=True),
        Column('organisationName', TEXT , nullable=True),
        Column('positionName', TEXT , nullable=True),
Column('t_type', String(30), nullable=False, default='ci_responsibleparty'),
        extend_existing=False,)
 
 










li_processstep_table = Table('li_processstep', metadata,
        Column('li_processstep_id', Integer, Sequence('li_processstep_id_seq'), primary_key=True),
        Column('li_lineage_processStep', Integer, ForeignKey('li_lineage.li_lineage_id')),
        Column('description', TEXT , nullable=False),
        Column('rationale', TEXT , nullable=True),
Column('t_type', String(30), nullable=False, default='li_processstep'),
        extend_existing=False,)
 
 










gf_attributetype_table = Table('gf_attributetype', metadata,
        Column('gf_attributetype_id', Integer, Sequence('gf_attributetype_id_seq'), primary_key=True),
                                Column('gf_propertytype_id', Integer, ForeignKey('gf_propertytype.gf_propertytype_id')),        Column('md_scopedescription_attributes', Integer, ForeignKey('md_scopedescription.md_scopedescription_id')),
        Column('md_scopedescription_attributeInstances', Integer, ForeignKey('md_scopedescription.md_scopedescription_id')),
        Column('valueDomain', TEXT , nullable=False),
Column('t_type', String(30), nullable=False, default='gf_attributetype'),
        extend_existing=False,)
 
 










md_usage_table = Table('md_usage', metadata,
        Column('md_usage_id', Integer, Sequence('md_usage_id_seq'), primary_key=True),
        Column('md_identification_resourceSpecificUsage', Integer, ForeignKey('md_identification.md_identification_id')),
        Column('userDeterminedLimitations', TEXT , nullable=True),
        Column('specificUsage', TEXT , nullable=False),
Column('t_type', String(30), nullable=False, default='md_usage'),
        extend_existing=False,)
 
 










tm_instant_table = Table('tm_instant', metadata,
        Column('tm_instant_id', Integer, Sequence('tm_instant_id_seq'), primary_key=True),
                                Column('tm_geometricprimitive_id', Integer, ForeignKey('tm_geometricprimitive.tm_geometricprimitive_id')),      Column('om_observation_resultTime', Integer, ForeignKey('om_observation.om_observation_id')),
Column('t_type', String(30), nullable=False, default='tm_instant'),
        extend_existing=False,)
 
 










ceda_review_table = Table('ceda_review', metadata,
        Column('ceda_review_id', Integer, Sequence('ceda_review_id_seq'), primary_key=True),
        Column('ceda_processing_review', Integer, ForeignKey('ceda_processing.ceda_processing_id')),
        Column('ceda_acquisition_review', Integer, ForeignKey('ceda_acquisition.ceda_acquisition_id')),
        Column('ceda_observationcollection_review', Integer, ForeignKey('ceda_observationcollection.ceda_observationcollection_id')),
        Column('ceda_project_review', Integer, ForeignKey('ceda_project.ceda_project_id')),
        Column('ceda_platform_review', Integer, ForeignKey('ceda_platform.ceda_platform_id')),
        Column('ceda_compositeprocess_review', Integer, ForeignKey('ceda_compositeprocess.ceda_compositeprocess_id')),
        Column('ceda_instrument_review', Integer, ForeignKey('ceda_instrument.ceda_instrument_id')),
        Column('ceda_observation_internalReview', Integer, ForeignKey('ceda_observation.ceda_observation_id')),
        Column('ceda_operation_review', Integer, ForeignKey('ceda_operation.ceda_operation_id')),
        Column('reviewFrequency', CEDA_ReviewFrequencyValue.db_type() , nullable=False),
        Column('reviewStatus', CEDA_ReviewStatusValue.db_type() , nullable=False),
Column('t_type', String(30), nullable=False, default='ceda_review'),
        extend_existing=False,)
 
 










md_scopedescription_table = Table('md_scopedescription', metadata,
        Column('md_scopedescription_id', Integer, Sequence('md_scopedescription_id_seq'), primary_key=True),
        Column('md_maintenanceinformation_updateScopeDescription', Integer, ForeignKey('md_maintenanceinformation.md_maintenanceinformation_id')),
        Column('dq_scope_levelDescription', Integer, ForeignKey('dq_scope.dq_scope_id')),
        Column('other', TEXT , nullable=False),
        Column('dataset', TEXT , nullable=False),
Column('t_type', String(30), nullable=False, default='md_scopedescription'),
        extend_existing=False,)
 
 










md_extendedelementinformation_table = Table('md_extendedelementinformation', metadata,
        Column('md_extendedelementinformation_id', Integer, Sequence('md_extendedelementinformation_id_seq'), primary_key=True),
        Column('md_metadataextensioninformation_extendedElementInformation', Integer, ForeignKey('md_metadataextensioninformation.md_metadataextensioninformation_id')),
        Column('domainValue', TEXT , nullable=True),
        Column('definition', TEXT , nullable=False),
        Column('name', TEXT , nullable=False),
        Column('dataType', MD_DatatypeCode.db_type() , nullable=False),
        Column('domainCode', Integer , nullable=True),
        Column('rationale', ARRAY(TEXT) , nullable=True),
        Column('parentEntity', ARRAY(TEXT) , nullable=False),
        Column('condition', TEXT , nullable=True),
        Column('obligation', MD_ObligationCode.db_type() , nullable=True),
        Column('maximumOccurrence', TEXT , nullable=True),
        Column('rule', TEXT , nullable=False),
        Column('shortName', TEXT , nullable=True),
Column('t_type', String(30), nullable=False, default='md_extendedelementinformation'),
        extend_existing=False,)
 
 










md_metadataextensioninformation_table = Table('md_metadataextensioninformation', metadata,
        Column('md_metadataextensioninformation_id', Integer, Sequence('md_metadataextensioninformation_id_seq'), primary_key=True),
        Column('md_metadata_metadataExtensionInfo', Integer, ForeignKey('md_metadata.md_metadata_id')),
Column('t_type', String(30), nullable=False, default='md_metadataextensioninformation'),
        extend_existing=False,)
 
 










md_maintenanceinformation_table = Table('md_maintenanceinformation', metadata,
        Column('md_maintenanceinformation_id', Integer, Sequence('md_maintenanceinformation_id_seq'), primary_key=True),
        Column('md_identification_resourceMaintenance', Integer, ForeignKey('md_identification.md_identification_id')),
        Column('md_metadata_metadataMaintenance', Integer, ForeignKey('md_metadata.md_metadata_id')),
        Column('maintenanceNote', ARRAY(TEXT) , nullable=True),
        Column('updateScope', MD_ScopeCode.db_type() , nullable=True),
        Column('maintenanceAndUpdateFrequency', MD_MaintenanceFrequencyCode.db_type() , nullable=False),
Column('t_type', String(30), nullable=False, default='md_maintenanceinformation'),
        extend_existing=False,)
 
 










rs_referencesystem_table = Table('rs_referencesystem', metadata,
        Column('rs_referencesystem_id', Integer, Sequence('rs_referencesystem_id_seq'), primary_key=True),
Column('t_type', String(30), nullable=False, default='rs_referencesystem'),
        extend_existing=False,)
 
 










md_identifier_table = Table('md_identifier', metadata,
        Column('md_identifier_id', Integer, Sequence('md_identifier_id_seq'), primary_key=True),
        Column('mo_project_identifier', Integer, ForeignKey('mo_project.mo_project_id')),
        Column('mo_processing_identifier', Integer, ForeignKey('mo_processing.mo_processing_id')),
        Column('mo_platform_identifier', Integer, ForeignKey('mo_platform.mo_platform_id')),
        Column('dq_element_measureIdentification', Integer, ForeignKey('dq_element.dq_element_id')),
        Column('mo_acquisition_identifier', Integer, ForeignKey('mo_acquisition.mo_acquisition_id')),
        Column('mo_observationcollection_identifier', Integer, ForeignKey('mo_observationcollection.mo_observationcollection_id')),
        Column('mo_observation_identifier', Integer, ForeignKey('mo_observation.mo_observation_id')),
        Column('ci_citation_identifier', Integer, ForeignKey('ci_citation.ci_citation_id', use_alter=True, name='fk_ci_citation')),
        Column('mo_instrument_identifier', Integer, ForeignKey('mo_instrument.mo_instrument_id')),
        Column('md_aggregateinformation_aggregateDataSetIdentifier', Integer, ForeignKey('md_aggregateinformation.md_aggregateinformation_id')),
        Column('mo_compositeprocess_identifier', Integer, ForeignKey('mo_compositeprocess.mo_compositeprocess_id')),
        Column('ex_geographicdescription_geographicIdentifier', Integer, ForeignKey('ex_geographicdescription.ex_geographicdescription_id')),
        Column('mo_operation_identifier', Integer, ForeignKey('mo_operation.mo_operation_id')),
        Column('code', TEXT , nullable=False),
Column('t_type', String(30), nullable=False, default='md_identifier'),
        extend_existing=False,)
 
 










ex_verticalextent_table = Table('ex_verticalextent', metadata,
        Column('ex_verticalextent_id', Integer, Sequence('ex_verticalextent_id_seq'), primary_key=True),
        Column('mo_observationcollection_verticalExtent', Integer, ForeignKey('mo_observationcollection.mo_observationcollection_id')),
        Column('mo_observation_verticalExtent', Integer, ForeignKey('mo_observation.mo_observation_id')),
        Column('ex_extent_verticalElement', Integer, ForeignKey('ex_extent.ex_extent_id', use_alter=True, name='fk_ex_extent')),
        Column('minimumValue', NUMERIC , nullable=False),
        Column('maximumValue', NUMERIC , nullable=False),
Column('t_type', String(30), nullable=False, default='ex_verticalextent'),
        extend_existing=False,)
 
 










ex_extent_table = Table('ex_extent', metadata,
        Column('ex_extent_id', Integer, Sequence('ex_extent_id_seq'), primary_key=True),
        Column('li_source_sourceExtent', Integer, ForeignKey('li_source.li_source_id')),
        Column('dq_scope_extent', Integer, ForeignKey('dq_scope.dq_scope_id')),
        Column('rs_referencesystem_domainOfValidity', Integer, ForeignKey('rs_referencesystem.rs_referencesystem_id', use_alter=True, name='fk_rs_referencesystem')),
        Column('description', TEXT , nullable=True),
Column('t_type', String(30), nullable=False, default='ex_extent'),
        extend_existing=False,)
 
 










ceda_observationcollection_table = Table('ceda_observationcollection', metadata,
        Column('ceda_observationcollection_id', Integer, Sequence('ceda_observationcollection_id_seq'), primary_key=True),
                                Column('mo_observationcollection_id', Integer, ForeignKey('mo_observationcollection.mo_observationcollection_id')),     Column('ceda_project_observationCollection', Integer, ForeignKey('ceda_project.ceda_project_id', use_alter=True, name='fk_ceda_project')),
Column('t_type', String(30), nullable=False, default='ceda_observationcollection'),
        extend_existing=False,)
 
 










io_identifiedobjectbase_table = Table('io_identifiedobjectbase', metadata,
        Column('io_identifiedobjectbase_id', Integer, Sequence('io_identifiedobjectbase_id_seq'), primary_key=True),
        Column('remarks', TEXT , nullable=True),
Column('t_type', String(30), nullable=False, default='io_identifiedobjectbase'),
        extend_existing=False,)
 
 










md_keywords_table = Table('md_keywords', metadata,
        Column('md_keywords_id', Integer, Sequence('md_keywords_id_seq'), primary_key=True),
        Column('md_identification_descriptiveKeywords', Integer, ForeignKey('md_identification.md_identification_id')),
        Column('mo_project_keywords', Integer, ForeignKey('mo_project.mo_project_id')),
        Column('ceda_observation_keywords', Integer, ForeignKey('ceda_observation.ceda_observation_id')),
        Column('type', MD_KeywordTypeCode.db_type() , nullable=True),
        Column('keyword', ARRAY(TEXT) , nullable=False),
Column('t_type', String(30), nullable=False, default='md_keywords'),
        extend_existing=False,)
 
 










ex_geographicdescription_table = Table('ex_geographicdescription', metadata,
        Column('ex_geographicdescription_id', Integer, Sequence('ex_geographicdescription_id_seq'), primary_key=True),
                                Column('ex_geographicextent_id', Integer, ForeignKey('ex_geographicextent.ex_geographicextent_id')),    Column('mo_location_nameLocation', Integer, ForeignKey('mo_location.mo_location_id')),
Column('t_type', String(30), nullable=False, default='ex_geographicdescription'),
        extend_existing=False,)
 
 










md_aggregateinformation_table = Table('md_aggregateinformation', metadata,
        Column('md_aggregateinformation_id', Integer, Sequence('md_aggregateinformation_id_seq'), primary_key=True),
        Column('md_identification_aggregationInfo', Integer, ForeignKey('md_identification.md_identification_id')),
        Column('associationType', DS_AssociationTypeCode.db_type() , nullable=False),
        Column('initiativeType', DS_InitiativeTypeCode.db_type() , nullable=True),
Column('t_type', String(30), nullable=False, default='md_aggregateinformation'),
        extend_existing=False,)
 
 










dq_dataquality_table = Table('dq_dataquality', metadata,
        Column('dq_dataquality_id', Integer, Sequence('dq_dataquality_id_seq'), primary_key=True),
        Column('md_metadata_dataQualityInfo', Integer, ForeignKey('md_metadata.md_metadata_id')),
Column('t_type', String(30), nullable=False, default='dq_dataquality'),
        extend_existing=False,)
 
 










mo_compositeprocess_table = Table('mo_compositeprocess', metadata,
        Column('mo_compositeprocess_id', Integer, Sequence('mo_compositeprocess_id_seq'), primary_key=True),
                                Column('mo_process_id', Integer, ForeignKey('mo_process.mo_process_id')),       Column('description', TEXT , nullable=True),
Column('t_type', String(30), nullable=False, default='mo_compositeprocess'),
        extend_existing=False,)
 
 










mo_observation_table = Table('mo_observation', metadata,
        Column('mo_observation_id', Integer, Sequence('mo_observation_id_seq'), primary_key=True),
                                Column('om_observation_id', Integer, ForeignKey('om_observation.om_observation_id')),   Column('mo_observationcollection_member', Integer, ForeignKey('mo_observationcollection.mo_observationcollection_id', use_alter=True, name='fk_mo_observationcollection')),
        Column('status', MD_ProgressCode.db_type() , nullable=True),
        Column('resolution', TEXT , nullable=True),
        Column('publicationState', MO_PublicationStateValue.db_type() , nullable=True),
        Column('description', TEXT , nullable=True),
        Column('resultAccumulation', MD_MaintenanceFrequencyCode.db_type() , nullable=True),
Column('t_type', String(30), nullable=False, default='mo_observation'),
        extend_existing=False,)
 
 










dq_scope_table = Table('dq_scope', metadata,
        Column('dq_scope_id', Integer, Sequence('dq_scope_id_seq'), primary_key=True),
        Column('dq_dataquality_scope', Integer, ForeignKey('dq_dataquality.dq_dataquality_id')),
        Column('level', MD_ScopeCode.db_type() , nullable=False),
Column('t_type', String(30), nullable=False, default='dq_scope'),
        extend_existing=False,)
 
 










ceda_compositeprocess_table = Table('ceda_compositeprocess', metadata,
        Column('ceda_compositeprocess_id', Integer, Sequence('ceda_compositeprocess_id_seq'), primary_key=True),
                                Column('mo_compositeprocess_id', Integer, ForeignKey('mo_compositeprocess.mo_compositeprocess_id')),                    Column('ceda_process_id', Integer, ForeignKey('ceda_process.ceda_process_id')),Column('t_type', String(30), nullable=False, default='ceda_compositeprocess'),
        extend_existing=False,)
 
 










md_metadata_table = Table('md_metadata', metadata,
        Column('md_metadata_id', Integer, Sequence('md_metadata_id_seq'), primary_key=True),
        Column('om_observation_metadata', Integer, ForeignKey('om_observation.om_observation_id')),
        Column('mo_observationcollection_isoMetadata', Integer, ForeignKey('mo_observationcollection.mo_observationcollection_id')),
        Column('metadataStandardName', TEXT , nullable=True),
        Column('language', TEXT , nullable=True),
        Column('fileIdentifier', TEXT , nullable=True),
        Column('hierarchyLevel', MD_ScopeCode.db_type() , nullable=True),
        Column('parentIdentifier', TEXT , nullable=True),
        Column('metadataStandardVersion', TEXT , nullable=True),
        Column('hierarchyLevelName', ARRAY(TEXT) , nullable=True),
        Column('characterSet', MD_CharacterSetCode.db_type() , nullable=True),
        Column('dataSet', TEXT , nullable=True),
Column('t_type', String(30), nullable=False, default='md_metadata'),
        extend_existing=False,)
 
 










li_source_table = Table('li_source', metadata,
        Column('li_source_id', Integer, Sequence('li_source_id_seq'), primary_key=True),
        Column('li_lineage_source', Integer, ForeignKey('li_lineage.li_lineage_id')),
        Column('description', TEXT , nullable=True),
Column('t_type', String(30), nullable=False, default='li_source'),
        extend_existing=False,)
 
 










md_referencesystem_table = Table('md_referencesystem', metadata,
        Column('md_referencesystem_id', Integer, Sequence('md_referencesystem_id_seq'), primary_key=True),
        Column('li_source_sourceReferenceSystem', Integer, ForeignKey('li_source.li_source_id')),
        Column('md_metadata_referenceSystemInfo', Integer, ForeignKey('md_metadata.md_metadata_id')),
Column('t_type', String(30), nullable=False, default='md_referencesystem'),
        extend_existing=False,)
 
 










om_observation_table = Table('om_observation', metadata,
        Column('om_observation_id', Integer, Sequence('om_observation_id_seq'), primary_key=True),
Column('t_type', String(30), nullable=False, default='om_observation'),
        extend_existing=False,)
 
 










sc_crs_table = Table('sc_crs', metadata,
        Column('sc_crs_id', Integer, Sequence('sc_crs_id_seq'), primary_key=True),
                                Column('io_identifiedobjectbase_id', Integer, ForeignKey('io_identifiedobjectbase.io_identifiedobjectbase_id')),                        Column('rs_referencesystem_id', Integer, ForeignKey('rs_referencesystem.rs_referencesystem_id')),       Column('ex_verticalextent_verticalCRS', Integer, ForeignKey('ex_verticalextent.ex_verticalextent_id', use_alter=True, name='fk_ex_verticalextent')),
        Column('scope', ARRAY(TEXT) , nullable=False),
Column('t_type', String(30), nullable=False, default='sc_crs'),
        extend_existing=False,)
 
 










mo_location_table = Table('mo_location', metadata,
        Column('mo_location_id', Integer, Sequence('mo_location_id_seq'), primary_key=True),
        Column('mo_platform_location', Integer, ForeignKey('mo_platform.mo_platform_id')),
        Column('mo_operation_location', Integer, ForeignKey('mo_operation.mo_operation_id')),
Column('t_type', String(30), nullable=False, default='mo_location'),
        extend_existing=False,)
 
 










mo_observationcollection_table = Table('mo_observationcollection', metadata,
        Column('mo_observationcollection_id', Integer, Sequence('mo_observationcollection_id_seq'), primary_key=True),
        Column('mo_project_observationCollection', Integer, ForeignKey('mo_project.mo_project_id', use_alter=True, name='fk_mo_project')),
        Column('publicationState', MO_PublicationStateValue.db_type() , nullable=True),
        Column('description', TEXT , nullable=True),
Column('t_type', String(30), nullable=False, default='mo_observationcollection'),
        extend_existing=False,)
 
 










ceda_operation_table = Table('ceda_operation', metadata,
        Column('ceda_operation_id', Integer, Sequence('ceda_operation_id_seq'), primary_key=True),
                                Column('mo_operation_id', Integer, ForeignKey('mo_operation.mo_operation_id')), Column('ceda_acquisition_operation', Integer, ForeignKey('ceda_acquisition.ceda_acquisition_id')),
Column('t_type', String(30), nullable=False, default='ceda_operation'),
        extend_existing=False,)
 
 










ceda_processing_table = Table('ceda_processing', metadata,
        Column('ceda_processing_id', Integer, Sequence('ceda_processing_id_seq'), primary_key=True),
                                Column('ceda_process_id', Integer, ForeignKey('ceda_process.ceda_process_id')),                 Column('mo_processing_id', Integer, ForeignKey('mo_processing.mo_processing_id')),      Column('ceda_compositeprocess_computationComponent', Integer, ForeignKey('ceda_compositeprocess.ceda_compositeprocess_id')),
Column('t_type', String(30), nullable=False, default='ceda_processing'),
        extend_existing=False,)
 
 










ceda_project_table = Table('ceda_project', metadata,
        Column('ceda_project_id', Integer, Sequence('ceda_project_id_seq'), primary_key=True),
                                Column('mo_project_id', Integer, ForeignKey('mo_project.mo_project_id')),       Column('ceda_observation_inSupportOf', Integer, ForeignKey('ceda_observation.ceda_observation_id', use_alter=True, name='fk_ceda_observation')),
Column('t_type', String(30), nullable=False, default='ceda_project'),
        extend_existing=False,)
 
 










md_identification_table = Table('md_identification', metadata,
        Column('md_identification_id', Integer, Sequence('md_identification_id_seq'), primary_key=True),
        Column('md_metadata_identificationInfo', Integer, ForeignKey('md_metadata.md_metadata_id')),
        Column('purpose', TEXT , nullable=True),
        Column('credit', ARRAY(TEXT) , nullable=True),
        Column('status', MD_ProgressCode.db_type() , nullable=True),
        Column('abstract', TEXT , nullable=False),
Column('t_type', String(30), nullable=False, default='md_identification'),
        extend_existing=False,)
 
 










mo_operation_table = Table('mo_operation', metadata,
        Column('mo_operation_id', Integer, Sequence('mo_operation_id_seq'), primary_key=True),
        Column('mo_acquisition_operation', Integer, ForeignKey('mo_acquisition.mo_acquisition_id')),
        Column('status', MD_ProgressCode.db_type() , nullable=True),
        Column('description', TEXT , nullable=True),
Column('t_type', String(30), nullable=False, default='mo_operation'),
        extend_existing=False,)
 
 










ceda_instrument_table = Table('ceda_instrument', metadata,
        Column('ceda_instrument_id', Integer, Sequence('ceda_instrument_id_seq'), primary_key=True),
                                Column('mo_instrument_id', Integer, ForeignKey('mo_instrument.mo_instrument_id')),      Column('ceda_acquisition_instrument', Integer, ForeignKey('ceda_acquisition.ceda_acquisition_id')),
Column('t_type', String(30), nullable=False, default='ceda_instrument'),
        extend_existing=False,)
 
 










ceda_observation_table = Table('ceda_observation', metadata,
        Column('ceda_observation_id', Integer, Sequence('ceda_observation_id_seq'), primary_key=True),
                                Column('mo_observation_id', Integer, ForeignKey('mo_observation.mo_observation_id')),   Column('ceda_observationcollection_member', Integer, ForeignKey('ceda_observationcollection.ceda_observationcollection_id', use_alter=True, name='fk_ceda_observationcollection')),
        Column('dataLineage', TEXT , nullable=False),
Column('t_type', String(30), nullable=False, default='ceda_observation'),
        extend_existing=False,)
 
 










mo_project_table = Table('mo_project', metadata,
        Column('mo_project_id', Integer, Sequence('mo_project_id_seq'), primary_key=True),
        Column('mo_observation_inSupportOf', Integer, ForeignKey('mo_observation.mo_observation_id', use_alter=True, name='fk_mo_observation')),
        Column('status', MD_ProgressCode.db_type() , nullable=True),
        Column('abstract', TEXT , nullable=True),
        Column('publicationState', MO_PublicationStateValue.db_type() , nullable=True),
        Column('description', TEXT , nullable=True),
Column('t_type', String(30), nullable=False, default='mo_project'),
        extend_existing=False,)
 
 










mo_platform_table = Table('mo_platform', metadata,
        Column('mo_platform_id', Integer, Sequence('mo_platform_id_seq'), primary_key=True),
        Column('mo_instrumentplatformpair_platform', Integer, ForeignKey('mo_instrumentplatformpair.mo_instrumentplatformpair_id')),
        Column('mo_operation_platform', Integer, ForeignKey('mo_operation.mo_operation_id')),
        Column('mo_acquisition_platform', Integer, ForeignKey('mo_acquisition.mo_acquisition_id')),
        Column('description', TEXT , nullable=True),
        Column('type', MO_PlatformTypeValue.db_type() , nullable=True),
Column('t_type', String(30), nullable=False, default='mo_platform'),
        extend_existing=False,)
 
 










mo_acquisition_table = Table('mo_acquisition', metadata,
        Column('mo_acquisition_id', Integer, Sequence('mo_acquisition_id_seq'), primary_key=True),
                                Column('mo_process_id', Integer, ForeignKey('mo_process.mo_process_id')),       Column('mo_compositeprocess_acquisitionComponent', Integer, ForeignKey('mo_compositeprocess.mo_compositeprocess_id')),
        Column('description', TEXT , nullable=True),
Column('t_type', String(30), nullable=False, default='mo_acquisition'),
        extend_existing=False,)
 
 










mo_instrument_table = Table('mo_instrument', metadata,
        Column('mo_instrument_id', Integer, Sequence('mo_instrument_id_seq'), primary_key=True),
        Column('mo_acquisition_instrument', Integer, ForeignKey('mo_acquisition.mo_acquisition_id')),
        Column('mo_instrumentplatformpair_instrument', Integer, ForeignKey('mo_instrumentplatformpair.mo_instrumentplatformpair_id')),
        Column('description', TEXT , nullable=True),
Column('t_type', String(30), nullable=False, default='mo_instrument'),
        extend_existing=False,)
 
 










li_lineage_table = Table('li_lineage', metadata,
        Column('li_lineage_id', Integer, Sequence('li_lineage_id_seq'), primary_key=True),
        Column('dq_dataquality_lineage', Integer, ForeignKey('dq_dataquality.dq_dataquality_id')),
        Column('statement', TEXT , nullable=True),
Column('t_type', String(30), nullable=False, default='li_lineage'),
        extend_existing=False,)
 
 










mo_instrumentplatformpair_table = Table('mo_instrumentplatformpair', metadata,
        Column('mo_instrumentplatformpair_id', Integer, Sequence('mo_instrumentplatformpair_id_seq'), primary_key=True),
        Column('mo_acquisition_instrumentPlatformPair', Integer, ForeignKey('mo_acquisition.mo_acquisition_id')),
Column('t_type', String(30), nullable=False, default='mo_instrumentplatformpair'),
        extend_existing=False,)
 
 










md_applicationschemainformation_table = Table('md_applicationschemainformation', metadata,
        Column('md_applicationschemainformation_id', Integer, Sequence('md_applicationschemainformation_id_seq'), primary_key=True),
        Column('md_metadata_applicationSchemaInfo', Integer, ForeignKey('md_metadata.md_metadata_id')),
        Column('softwareDevelopmentFileFormat', TEXT , nullable=True),
        Column('schemaLanguage', TEXT , nullable=False),
        Column('constraintLanguage', TEXT , nullable=False),
        Column('schemaAscii', TEXT , nullable=True),
Column('t_type', String(30), nullable=False, default='md_applicationschemainformation'),
        extend_existing=False,)
 
 










dq_element_table = Table('dq_element', metadata,
        Column('dq_element_id', Integer, Sequence('dq_element_id_seq'), primary_key=True),
        Column('dq_dataquality_report', Integer, ForeignKey('dq_dataquality.dq_dataquality_id')),
        Column('om_observation_resultQuality', Integer, ForeignKey('om_observation.om_observation_id')),
        Column('nameOfMeasure', ARRAY(TEXT) , nullable=True),
        Column('evaluationMethodDescription', TEXT , nullable=True),
        Column('evaluationMethodType', DQ_EvaluationMethodTypeCode.db_type() , nullable=True),
        Column('measureDescription', TEXT , nullable=True),
Column('t_type', String(30), nullable=False, default='dq_element'),
        extend_existing=False,)
 
 










ceda_acquisition_table = Table('ceda_acquisition', metadata,
        Column('ceda_acquisition_id', Integer, Sequence('ceda_acquisition_id_seq'), primary_key=True),
                                Column('mo_acquisition_id', Integer, ForeignKey('mo_acquisition.mo_acquisition_id')),                   Column('ceda_process_id', Integer, ForeignKey('ceda_process.ceda_process_id')), Column('ceda_compositeprocess_aquisitionComponent', Integer, ForeignKey('ceda_compositeprocess.ceda_compositeprocess_id')),
Column('t_type', String(30), nullable=False, default='ceda_acquisition'),
        extend_existing=False,)
 
 










rs_identifier_table = Table('rs_identifier', metadata,
        Column('rs_identifier_id', Integer, Sequence('rs_identifier_id_seq'), primary_key=True),
                                Column('md_identifier_id', Integer, ForeignKey('md_identifier.md_identifier_id')),      Column('io_identifiedobjectbase_identifier', Integer, ForeignKey('io_identifiedobjectbase.io_identifiedobjectbase_id')),
        Column('md_referencesystem_referenceSystemIdentifier', Integer, ForeignKey('md_referencesystem.md_referencesystem_id')),
        Column('rs_referencesystem_name', Integer, ForeignKey('rs_referencesystem.rs_referencesystem_id')),
        Column('version', TEXT , nullable=True),
        Column('codeSpace', TEXT , nullable=True),
Column('t_type', String(30), nullable=False, default='rs_identifier'),
        extend_existing=False,)
 
 










ceda_platform_table = Table('ceda_platform', metadata,
        Column('ceda_platform_id', Integer, Sequence('ceda_platform_id_seq'), primary_key=True),
                                Column('mo_platform_id', Integer, ForeignKey('mo_platform.mo_platform_id')),    Column('ceda_acquisition_platform', Integer, ForeignKey('ceda_acquisition.ceda_acquisition_id')),
Column('t_type', String(30), nullable=False, default='ceda_platform'),
        extend_existing=False,)
 
 










ci_citation_table = Table('ci_citation', metadata,
        Column('ci_citation_id', Integer, Sequence('ci_citation_id_seq'), primary_key=True),
        Column('mo_platform_documentation', Integer, ForeignKey('mo_platform.mo_platform_id')),
        Column('md_portrayalcataloguereference_portrayalCatalogueCitation', Integer, ForeignKey('md_portrayalcataloguereference.md_portrayalcataloguereference_id')),
        Column('md_applicationschemainformation_name', Integer, ForeignKey('md_applicationschemainformation.md_applicationschemainformation_id')),
        Column('mo_observation_documentation', Integer, ForeignKey('mo_observation.mo_observation_id')),
        Column('mo_processing_softwareReference', Integer, ForeignKey('mo_processing.mo_processing_id')),
        Column('mo_compositeprocess_documentation', Integer, ForeignKey('mo_compositeprocess.mo_compositeprocess_id')),
        Column('mo_project_documentation', Integer, ForeignKey('mo_project.mo_project_id')),
        Column('mo_project_dmp', Integer, ForeignKey('mo_project.mo_project_id')),
        Column('mo_instrument_documentation', Integer, ForeignKey('mo_instrument.mo_instrument_id')),
        Column('md_aggregateinformation_aggregateDataSetName', Integer, ForeignKey('md_aggregateinformation.md_aggregateinformation_id')),
        Column('mo_acquisition_documentation', Integer, ForeignKey('mo_acquisition.mo_acquisition_id')),
        Column('mo_operation_documentation', Integer, ForeignKey('mo_operation.mo_operation_id')),
        Column('mo_processing_documentation', Integer, ForeignKey('mo_processing.mo_processing_id')),
        Column('dq_element_evaluationProcedure', Integer, ForeignKey('dq_element.dq_element_id')),
        Column('md_identifier_authority', Integer, ForeignKey('md_identifier.md_identifier_id', use_alter=True, name='fk_md_identifier')),
        Column('md_keywords_thesaurusName', Integer, ForeignKey('md_keywords.md_keywords_id')),
        Column('md_identification_citation', Integer, ForeignKey('md_identification.md_identification_id')),
        Column('li_source_sourceCitation', Integer, ForeignKey('li_source.li_source_id')),
        Column('ISSN', TEXT , nullable=True),
        Column('otherCitationDetails', TEXT , nullable=True),
        Column('edition', TEXT , nullable=True),
        Column('alternateTitle', ARRAY(TEXT) , nullable=True),
        Column('collectiveTitle', TEXT , nullable=True),
        Column('title', TEXT , nullable=False),
        Column('ISBN', TEXT , nullable=True),
        Column('presentationForm', CI_PresentationFormCode.db_type() , nullable=True),
Column('t_type', String(30), nullable=False, default='ci_citation'),
        extend_existing=False,)
 
 










md_portrayalcataloguereference_table = Table('md_portrayalcataloguereference', metadata,
        Column('md_portrayalcataloguereference_id', Integer, Sequence('md_portrayalcataloguereference_id_seq'), primary_key=True),
        Column('md_metadata_portrayalCatalogueInfo', Integer, ForeignKey('md_metadata.md_metadata_id')),
Column('t_type', String(30), nullable=False, default='md_portrayalcataloguereference'),
        extend_existing=False,)
 
 










mo_processing_table = Table('mo_processing', metadata,
        Column('mo_processing_id', Integer, Sequence('mo_processing_id_seq'), primary_key=True),
                                Column('mo_computation_id', Integer, ForeignKey('mo_computation.mo_computation_id')),   Column('description', TEXT , nullable=True),
Column('t_type', String(30), nullable=False, default='mo_processing'),
        extend_existing=False,)
 
 
mo_computation_mo_processing_table = Table('mo_computation_mo_processing', metadata,
        Column('left_node_id', Integer, ForeignKey(mo_computation_table.c.mo_computation_id)),
        Column('right_node_id', Integer, ForeignKey(mo_processing_table.c.mo_processing_id))
)
mo_project_ceda_project_table = Table('mo_project_ceda_project', metadata,
        Column('left_node_id', Integer, ForeignKey(mo_project_table.c.mo_project_id)),
        Column('right_node_id', Integer, ForeignKey(ceda_project_table.c.ceda_project_id))
)
mo_compositeprocess_ceda_compositeprocess_table = Table('mo_compositeprocess_ceda_compositeprocess', metadata,
        Column('left_node_id', Integer, ForeignKey(mo_compositeprocess_table.c.mo_compositeprocess_id)),
        Column('right_node_id', Integer, ForeignKey(ceda_compositeprocess_table.c.ceda_compositeprocess_id))
)
tm_geometricprimitive_tm_instant_table = Table('tm_geometricprimitive_tm_instant', metadata,
        Column('left_node_id', Integer, ForeignKey(tm_geometricprimitive_table.c.tm_geometricprimitive_id)),
        Column('right_node_id', Integer, ForeignKey(tm_instant_table.c.tm_instant_id))
)
ceda_process_ceda_processing_table = Table('ceda_process_ceda_processing', metadata,
        Column('left_node_id', Integer, ForeignKey(ceda_process_table.c.ceda_process_id)),
        Column('right_node_id', Integer, ForeignKey(ceda_processing_table.c.ceda_processing_id))
)
mo_result_ceda_result_table = Table('mo_result_ceda_result', metadata,
        Column('left_node_id', Integer, ForeignKey(mo_result_table.c.mo_result_id)),
        Column('right_node_id', Integer, ForeignKey(ceda_result_table.c.ceda_result_id))
)
mo_observation_ceda_observation_table = Table('mo_observation_ceda_observation', metadata,
        Column('left_node_id', Integer, ForeignKey(mo_observation_table.c.mo_observation_id)),
        Column('right_node_id', Integer, ForeignKey(ceda_observation_table.c.ceda_observation_id))
)
mo_platform_ceda_platform_table = Table('mo_platform_ceda_platform', metadata,
        Column('left_node_id', Integer, ForeignKey(mo_platform_table.c.mo_platform_id)),
        Column('right_node_id', Integer, ForeignKey(ceda_platform_table.c.ceda_platform_id))
)
genericname_scopedname_table = Table('genericname_scopedname', metadata,
        Column('left_node_id', Integer, ForeignKey(genericname_table.c.genericname_id)),
        Column('right_node_id', Integer, ForeignKey(scopedname_table.c.scopedname_id))
)
genericname_localname_table = Table('genericname_localname', metadata,
        Column('left_node_id', Integer, ForeignKey(genericname_table.c.genericname_id)),
        Column('right_node_id', Integer, ForeignKey(localname_table.c.localname_id))
)
tm_geometricprimitive_tm_period_table = Table('tm_geometricprimitive_tm_period', metadata,
        Column('left_node_id', Integer, ForeignKey(tm_geometricprimitive_table.c.tm_geometricprimitive_id)),
        Column('right_node_id', Integer, ForeignKey(tm_period_table.c.tm_period_id))
)
md_identifier_rs_identifier_table = Table('md_identifier_rs_identifier', metadata,
        Column('left_node_id', Integer, ForeignKey(md_identifier_table.c.md_identifier_id)),
        Column('right_node_id', Integer, ForeignKey(rs_identifier_table.c.rs_identifier_id))
)
mo_observationcollection_ceda_observationcollection_table = Table('mo_observationcollection_ceda_observationcollection', metadata,
        Column('left_node_id', Integer, ForeignKey(mo_observationcollection_table.c.mo_observationcollection_id)),
        Column('right_node_id', Integer, ForeignKey(ceda_observationcollection_table.c.ceda_observationcollection_id))
)
mo_acquisition_ceda_acquisition_table = Table('mo_acquisition_ceda_acquisition', metadata,
        Column('left_node_id', Integer, ForeignKey(mo_acquisition_table.c.mo_acquisition_id)),
        Column('right_node_id', Integer, ForeignKey(ceda_acquisition_table.c.ceda_acquisition_id))
)
rs_referencesystem_sc_crs_table = Table('rs_referencesystem_sc_crs', metadata,
        Column('left_node_id', Integer, ForeignKey(rs_referencesystem_table.c.rs_referencesystem_id)),
        Column('right_node_id', Integer, ForeignKey(sc_crs_table.c.sc_crs_id))
)
measure_time_table = Table('measure_time', metadata,
        Column('left_node_id', Integer, ForeignKey(measure_table.c.measure_id)),
        Column('right_node_id', Integer, ForeignKey(time_table.c.time_id))
)
ci_onlineresource_mo_onlineresource_table = Table('ci_onlineresource_mo_onlineresource', metadata,
        Column('left_node_id', Integer, ForeignKey(ci_onlineresource_table.c.ci_onlineresource_id)),
        Column('right_node_id', Integer, ForeignKey(mo_onlineresource_table.c.mo_onlineresource_id))
)
mo_operation_ceda_operation_table = Table('mo_operation_ceda_operation', metadata,
        Column('left_node_id', Integer, ForeignKey(mo_operation_table.c.mo_operation_id)),
        Column('right_node_id', Integer, ForeignKey(ceda_operation_table.c.ceda_operation_id))
)
gf_propertytype_gf_attributetype_table = Table('gf_propertytype_gf_attributetype', metadata,
        Column('left_node_id', Integer, ForeignKey(gf_propertytype_table.c.gf_propertytype_id)),
        Column('right_node_id', Integer, ForeignKey(gf_attributetype_table.c.gf_attributetype_id))
)
om_observation_mo_observation_table = Table('om_observation_mo_observation', metadata,
        Column('left_node_id', Integer, ForeignKey(om_observation_table.c.om_observation_id)),
        Column('right_node_id', Integer, ForeignKey(mo_observation_table.c.mo_observation_id))
)
ceda_process_ceda_acquisition_table = Table('ceda_process_ceda_acquisition', metadata,
        Column('left_node_id', Integer, ForeignKey(ceda_process_table.c.ceda_process_id)),
        Column('right_node_id', Integer, ForeignKey(ceda_acquisition_table.c.ceda_acquisition_id))
)
unitofmeasure_uomlength_table = Table('unitofmeasure_uomlength', metadata,
        Column('left_node_id', Integer, ForeignKey(unitofmeasure_table.c.unitofmeasure_id)),
        Column('right_node_id', Integer, ForeignKey(uomlength_table.c.uomlength_id))
)
mo_instrument_ceda_instrument_table = Table('mo_instrument_ceda_instrument', metadata,
        Column('left_node_id', Integer, ForeignKey(mo_instrument_table.c.mo_instrument_id)),
        Column('right_node_id', Integer, ForeignKey(ceda_instrument_table.c.ceda_instrument_id))
)
tm_object_tm_primitive_table = Table('tm_object_tm_primitive', metadata,
        Column('left_node_id', Integer, ForeignKey(tm_object_table.c.tm_object_id)),
        Column('right_node_id', Integer, ForeignKey(tm_primitive_table.c.tm_primitive_id))
)
mo_process_mo_computation_table = Table('mo_process_mo_computation', metadata,
        Column('left_node_id', Integer, ForeignKey(mo_process_table.c.mo_process_id)),
        Column('right_node_id', Integer, ForeignKey(mo_computation_table.c.mo_computation_id))
)
mo_process_mo_acquisition_table = Table('mo_process_mo_acquisition', metadata,
        Column('left_node_id', Integer, ForeignKey(mo_process_table.c.mo_process_id)),
        Column('right_node_id', Integer, ForeignKey(mo_acquisition_table.c.mo_acquisition_id))
)
mo_process_mo_compositeprocess_table = Table('mo_process_mo_compositeprocess', metadata,
        Column('left_node_id', Integer, ForeignKey(mo_process_table.c.mo_process_id)),
        Column('right_node_id', Integer, ForeignKey(mo_compositeprocess_table.c.mo_compositeprocess_id))
)
tm_primitive_tm_geometricprimitive_table = Table('tm_primitive_tm_geometricprimitive', metadata,
        Column('left_node_id', Integer, ForeignKey(tm_primitive_table.c.tm_primitive_id)),
        Column('right_node_id', Integer, ForeignKey(tm_geometricprimitive_table.c.tm_geometricprimitive_id))
)
date_datetime_table = Table('date_datetime', metadata,
        Column('left_node_id', Integer, ForeignKey(date_table.c.date_id)),
        Column('right_node_id', Integer, ForeignKey(datetime_table.c.datetime_id))
)
om_process_mo_process_table = Table('om_process_mo_process', metadata,
        Column('left_node_id', Integer, ForeignKey(om_process_table.c.om_process_id)),
        Column('right_node_id', Integer, ForeignKey(mo_process_table.c.mo_process_id))
)
localname_typename_table = Table('localname_typename', metadata,
        Column('left_node_id', Integer, ForeignKey(localname_table.c.localname_id)),
        Column('right_node_id', Integer, ForeignKey(typename_table.c.typename_id))
)
tm_duration_tm_periodduration_table = Table('tm_duration_tm_periodduration', metadata,
        Column('left_node_id', Integer, ForeignKey(tm_duration_table.c.tm_duration_id)),
        Column('right_node_id', Integer, ForeignKey(tm_periodduration_table.c.tm_periodduration_id))
)
ex_geographicextent_ex_geographicdescription_table = Table('ex_geographicextent_ex_geographicdescription', metadata,
        Column('left_node_id', Integer, ForeignKey(ex_geographicextent_table.c.ex_geographicextent_id)),
        Column('right_node_id', Integer, ForeignKey(ex_geographicdescription_table.c.ex_geographicdescription_id))
)
unitofmeasure_uomscale_table = Table('unitofmeasure_uomscale', metadata,
        Column('left_node_id', Integer, ForeignKey(unitofmeasure_table.c.unitofmeasure_id)),
        Column('right_node_id', Integer, ForeignKey(uomscale_table.c.uomscale_id))
)
mo_processing_ceda_processing_table = Table('mo_processing_ceda_processing', metadata,
        Column('left_node_id', Integer, ForeignKey(mo_processing_table.c.mo_processing_id)),
        Column('right_node_id', Integer, ForeignKey(ceda_processing_table.c.ceda_processing_id))
)
clocktime_datetime_table = Table('clocktime_datetime', metadata,
        Column('left_node_id', Integer, ForeignKey(clocktime_table.c.clocktime_id)),
        Column('right_node_id', Integer, ForeignKey(datetime_table.c.datetime_id))
)
measure_scale_table = Table('measure_scale', metadata,
        Column('left_node_id', Integer, ForeignKey(measure_table.c.measure_id)),
        Column('right_node_id', Integer, ForeignKey(scale_table.c.scale_id))
)
ceda_process_ceda_compositeprocess_table = Table('ceda_process_ceda_compositeprocess', metadata,
        Column('left_node_id', Integer, ForeignKey(ceda_process_table.c.ceda_process_id)),
        Column('right_node_id', Integer, ForeignKey(ceda_compositeprocess_table.c.ceda_compositeprocess_id))
)
mo_process_ceda_process_table = Table('mo_process_ceda_process', metadata,
        Column('left_node_id', Integer, ForeignKey(mo_process_table.c.mo_process_id)),
        Column('right_node_id', Integer, ForeignKey(ceda_process_table.c.ceda_process_id))
)
io_identifiedobjectbase_sc_crs_table = Table('io_identifiedobjectbase_sc_crs', metadata,
        Column('left_node_id', Integer, ForeignKey(io_identifiedobjectbase_table.c.io_identifiedobjectbase_id)),
        Column('right_node_id', Integer, ForeignKey(sc_crs_table.c.sc_crs_id))
)



mapper(CI_Series, ci_series_table, properties  = {})




mapper(ClockTime, clocktime_table, properties  = {})




mapper(MD_Distribution, md_distribution_table, properties  = {})




mapper(CI_Telephone, ci_telephone_table, properties  = {})




mapper(MD_ContentInformation, md_contentinformation_table, properties  = {})




mapper(MO_ResponsiblePartyInfo, mo_responsiblepartyinfo_table, properties  = {})




mapper(Multiplicity, multiplicity_table, properties  = {})




mapper(TM_TemporalPosition, tm_temporalposition_table, properties  = {})




mapper(GenericName, genericname_table, properties  = {})




mapper(OM_Process, om_process_table, properties  = {})




mapper(GF_Constraint, gf_constraint_table, properties  = {})




mapper(Any, any_table, properties  = {})




mapper(GM_Object, gm_object_table, properties  = {})




mapper(CEDA_Citation, ceda_citation_table, properties  = {})




mapper(DatePrecision, dateprecision_table, properties  = {})




mapper(MD_SpatialRepresentation, md_spatialrepresentation_table, properties  = {})




mapper(MD_Format, md_format_table, properties  = {})




mapper(UnitOfMeasure, unitofmeasure_table, properties  = {})




mapper(TM_Duration, tm_duration_table, properties  = {})




mapper(Measure, measure_table, properties  = {})




mapper(CI_Address, ci_address_table, properties  = {})








mapper(TM_Object, tm_object_table, properties  = {})




mapper(DQ_Result, dq_result_table, properties  = {})




mapper(URL, url_table, properties  = {})




mapper(EX_GeographicExtent, ex_geographicextent_table, properties  = {})




mapper(MD_BrowseGraphic, md_browsegraphic_table, properties  = {})




mapper(MD_Constraints, md_constraints_table, properties  = {})




mapper(Time, time_table, properties  = {        '_measure': relationship(Measure, 
secondary=measure_time_table
, uselist=False
)})




mapper(ScopedName, scopedname_table, properties  = {    '_genericname': relationship(GenericName, 
secondary=genericname_scopedname_table
, uselist=False
)})




mapper(NamedValue, namedvalue_table, properties  = {    'name': relationship(GenericName, uselist=False
, primaryjoin=genericname_table.c.namedvalue_name==namedvalue_table.c.namedvalue_id
),      'value': relationship(Any, uselist=False
, primaryjoin=any_table.c.namedvalue_value==namedvalue_table.c.namedvalue_id
)})




mapper(TM_Primitive, tm_primitive_table, properties  = {        '_tm_object': relationship(TM_Object, 
secondary=tm_object_tm_primitive_table
, uselist=False
)})




mapper(UomScale, uomscale_table, properties  = {        '_unitofmeasure': relationship(UnitOfMeasure, 
secondary=unitofmeasure_uomscale_table
, uselist=False
)})




mapper(TM_PeriodDuration, tm_periodduration_table, properties  = {      '_tm_duration': relationship(TM_Duration, 
secondary=tm_duration_tm_periodduration_table
, uselist=False
)})




mapper(Date, date_table, properties  = {        'precision': relationship(DatePrecision, uselist=False
, primaryjoin=dateprecision_table.c.date_precision==date_table.c.date_id
)})




mapper(MO_Process, mo_process_table, properties  = {    '_om_process': relationship(OM_Process, 
secondary=om_process_mo_process_table
, uselist=False
)})




mapper(MO_InputOutput, mo_inputoutput_table, properties  = {    'name': relationship(GenericName, uselist=False
, primaryjoin=genericname_table.c.mo_inputoutput_name==mo_inputoutput_table.c.mo_inputoutput_id
)})




mapper(MO_Computation, mo_computation_table, properties  = {    '_mo_process': relationship(MO_Process, 
secondary=mo_process_mo_computation_table
, uselist=False
)})




mapper(CI_OnlineResource, ci_onlineresource_table, properties  = {      'linkage': relationship(URL, uselist=False
, primaryjoin=url_table.c.ci_onlineresource_linkage==ci_onlineresource_table.c.ci_onlineresource_id
)})




mapper(LocalName, localname_table, properties  = {      '_genericname': relationship(GenericName, 
secondary=genericname_localname_table
, uselist=False
)})




mapper(UomLength, uomlength_table, properties  = {      '_unitofmeasure': relationship(UnitOfMeasure, 
secondary=unitofmeasure_uomlength_table
, uselist=False
)})




mapper(CEDA_Process, ceda_process_table, properties  = {        '_mo_process': relationship(MO_Process, 
secondary=mo_process_ceda_process_table
, uselist=False
)})




mapper(MO_OnlineResource, mo_onlineresource_table, properties  = {      '_ci_onlineresource': relationship(CI_OnlineResource, 
secondary=ci_onlineresource_mo_onlineresource_table
, uselist=False
)})




mapper(Scale, scale_table, properties  = {      'targetUnits': relationship(UomLength, uselist=False
, primaryjoin=uomlength_table.c.scale_targetUnits==scale_table.c.scale_id
),      'uom': relationship(UomScale, uselist=False
, primaryjoin=uomscale_table.c.scale_uom==scale_table.c.scale_id
),      '_measure': relationship(Measure, 
secondary=measure_scale_table
, uselist=False
),      'sourceUnits': relationship(UomLength, uselist=False
, primaryjoin=uomlength_table.c.scale_sourceUnits==scale_table.c.scale_id
)})




mapper(TypeName, typename_table, properties  = {        '_localname': relationship(LocalName, 
secondary=localname_typename_table
, uselist=False
)})




mapper(MO_Result, mo_result_table, properties  = {      'source': relationship(MO_OnlineResource
, primaryjoin=mo_onlineresource_table.c.mo_result_source==mo_result_table.c.mo_result_id
),      'sample': relationship(MO_OnlineResource
, primaryjoin=mo_onlineresource_table.c.mo_result_sample==mo_result_table.c.mo_result_id
)})




mapper(DateTime, datetime_table, properties  = {        '_clocktime': relationship(ClockTime, 
secondary=clocktime_datetime_table
, uselist=False
),      '_date': relationship(Date, 
secondary=date_datetime_table
, uselist=False
)})




mapper(GF_FeatureType, gf_featuretype_table, properties  = {    'typeName': relationship(LocalName, uselist=False
, primaryjoin=localname_table.c.gf_featuretype_typeName==gf_featuretype_table.c.gf_featuretype_id
),      'constrainedBy': relationship(GF_Constraint, uselist=False
, primaryjoin=gf_constraint_table.c.gf_featuretype_constrainedBy==gf_featuretype_table.c.gf_featuretype_id
)})




mapper(CEDA_Result, ceda_result_table, properties  = {  '_mo_result': relationship(MO_Result, 
secondary=mo_result_ceda_result_table
, uselist=False
)})




mapper(GF_PropertyType, gf_propertytype_table, properties  = {  'constrainedBy': relationship(GF_Constraint, uselist=False
, primaryjoin=gf_constraint_table.c.gf_propertytype_constrainedBy==gf_propertytype_table.c.gf_propertytype_id
),      'memberName': relationship(LocalName, uselist=False
, primaryjoin=localname_table.c.gf_propertytype_memberName==gf_propertytype_table.c.gf_propertytype_id
)})




mapper(CI_Date, ci_date_table, properties  = {  'date': relationship(Date, uselist=False
, primaryjoin=date_table.c.ci_date_date==ci_date_table.c.ci_date_id
)})




mapper(TM_GeometricPrimitive, tm_geometricprimitive_table, properties  = {      '_tm_primitive': relationship(TM_Primitive, 
secondary=tm_primitive_tm_geometricprimitive_table
, uselist=False
)})




mapper(EX_TemporalExtent, ex_temporalextent_table, properties  = {      'extent': relationship(TM_Primitive, uselist=False
, primaryjoin=tm_primitive_table.c.ex_temporalextent_extent==ex_temporalextent_table.c.ex_temporalextent_id
)})




mapper(CEDA_Notes, ceda_notes_table, properties  = {    'date': relationship(DateTime, uselist=False
, primaryjoin=datetime_table.c.ceda_notes_date==ceda_notes_table.c.ceda_notes_id
),      'commentator': relationship(MO_ResponsiblePartyInfo, uselist=False
, primaryjoin=mo_responsiblepartyinfo_table.c.ceda_notes_commentator==ceda_notes_table.c.ceda_notes_id
)})




mapper(CI_Contact, ci_contact_table, properties  = {    'address': relationship(CI_Address, uselist=False
, primaryjoin=ci_address_table.c.ci_contact_address==ci_contact_table.c.ci_contact_id
),      'phone': relationship(CI_Telephone, uselist=False
, primaryjoin=ci_telephone_table.c.ci_contact_phone==ci_contact_table.c.ci_contact_id
),      'onlineResource': relationship(CI_OnlineResource, uselist=False
, primaryjoin=ci_onlineresource_table.c.ci_contact_onlineResource==ci_contact_table.c.ci_contact_id
)})




mapper(TM_Position, tm_position_table, properties  = {  'dateTime8601': relationship(DateTime, uselist=False
, primaryjoin=datetime_table.c.tm_position_dateTime8601==tm_position_table.c.tm_position_id
),      'anyOther': relationship(TM_TemporalPosition, uselist=False
, primaryjoin=tm_temporalposition_table.c.tm_position_anyOther==tm_position_table.c.tm_position_id
),      'time8601': relationship(Time, uselist=False
, primaryjoin=time_table.c.tm_position_time8601==tm_position_table.c.tm_position_id
),      'date8601': relationship(Date, uselist=False
, primaryjoin=date_table.c.tm_position_date8601==tm_position_table.c.tm_position_id
)})




mapper(TM_Period, tm_period_table, properties  = {      '_tm_geometricprimitive': relationship(TM_GeometricPrimitive, 
secondary=tm_geometricprimitive_tm_period_table
, uselist=False
)})




mapper(MD_RepresentativeFraction, md_representativefraction_table, properties  = {      'equivalentScale': relationship(Scale, uselist=False
, primaryjoin=scale_table.c.md_representativefraction_equivalentScale==md_representativefraction_table.c.md_representativefraction_id
)})




mapper(CI_ResponsibleParty, ci_responsibleparty_table, properties  = {  'contactInfo': relationship(CI_Contact, uselist=False
, primaryjoin=ci_contact_table.c.ci_responsibleparty_contactInfo==ci_responsibleparty_table.c.ci_responsibleparty_id
)})




mapper(LI_ProcessStep, li_processstep_table, properties  = {    'processor': relationship(CI_ResponsibleParty
, primaryjoin=ci_responsibleparty_table.c.li_processstep_processor==li_processstep_table.c.li_processstep_id
),      'dateTime': relationship(DateTime, uselist=False
, primaryjoin=datetime_table.c.li_processstep_dateTime==li_processstep_table.c.li_processstep_id
)})




mapper(GF_AttributeType, gf_attributetype_table, properties  = {        '_gf_propertytype': relationship(GF_PropertyType, 
secondary=gf_propertytype_gf_attributetype_table
, uselist=False
),      'cardinality': relationship(Multiplicity, uselist=False
, primaryjoin=multiplicity_table.c.gf_attributetype_cardinality==gf_attributetype_table.c.gf_attributetype_id
),      'valueType': relationship(TypeName, uselist=False
, primaryjoin=typename_table.c.gf_attributetype_valueType==gf_attributetype_table.c.gf_attributetype_id
)})




mapper(MD_Usage, md_usage_table, properties  = {        'userContactInfo': relationship(CI_ResponsibleParty
, primaryjoin=ci_responsibleparty_table.c.md_usage_userContactInfo==md_usage_table.c.md_usage_id
),      'usageDateTime': relationship(DateTime, uselist=False
, primaryjoin=datetime_table.c.md_usage_usageDateTime==md_usage_table.c.md_usage_id
)})




mapper(TM_Instant, tm_instant_table, properties  = {    'position': relationship(TM_Position, uselist=False
, primaryjoin=tm_position_table.c.tm_instant_position==tm_instant_table.c.tm_instant_id
),      '_tm_geometricprimitive': relationship(TM_GeometricPrimitive, 
secondary=tm_geometricprimitive_tm_instant_table
, uselist=False
)})




mapper(CEDA_Review, ceda_review_table, properties  = {  'notes': relationship(CEDA_Notes
, primaryjoin=ceda_notes_table.c.ceda_review_notes==ceda_review_table.c.ceda_review_id
),      'reviewer': relationship(MO_ResponsiblePartyInfo, uselist=False
, primaryjoin=mo_responsiblepartyinfo_table.c.ceda_review_reviewer==ceda_review_table.c.ceda_review_id
)})




mapper(MD_ScopeDescription, md_scopedescription_table, properties  = {  'attributeInstances': relationship(GF_AttributeType
, primaryjoin=gf_attributetype_table.c.md_scopedescription_attributeInstances==md_scopedescription_table.c.md_scopedescription_id
),      'attributes': relationship(GF_AttributeType
, primaryjoin=gf_attributetype_table.c.md_scopedescription_attributes==md_scopedescription_table.c.md_scopedescription_id
),      'features': relationship(GF_FeatureType
, primaryjoin=gf_featuretype_table.c.md_scopedescription_features==md_scopedescription_table.c.md_scopedescription_id
),      'featureInstances': relationship(GF_FeatureType
, primaryjoin=gf_featuretype_table.c.md_scopedescription_featureInstances==md_scopedescription_table.c.md_scopedescription_id
)})




mapper(MD_ExtendedElementInformation, md_extendedelementinformation_table, properties  = {      'source': relationship(CI_ResponsibleParty
, primaryjoin=ci_responsibleparty_table.c.md_extendedelementinformation_source==md_extendedelementinformation_table.c.md_extendedelementinformation_id
)})




mapper(MD_MetadataExtensionInformation, md_metadataextensioninformation_table, properties  = {  'extensionOnLineResource': relationship(CI_OnlineResource, uselist=False
, primaryjoin=ci_onlineresource_table.c.md_metadataextensioninformation_extensionOnLineResource==md_metadataextensioninformation_table.c.md_metadataextensioninformation_id
),      'extendedElementInformation': relationship(MD_ExtendedElementInformation, uselist=False
, primaryjoin=md_extendedelementinformation_table.c.md_metadataextensioninformation_extendedElementInformation==md_metadataextensioninformation_table.c.md_metadataextensioninformation_id
)})




mapper(MD_MaintenanceInformation, md_maintenanceinformation_table, properties  = {      'contact': relationship(CI_ResponsibleParty
, primaryjoin=ci_responsibleparty_table.c.md_maintenanceinformation_contact==md_maintenanceinformation_table.c.md_maintenanceinformation_id
),      'dateOfNextUpdate': relationship(Date, uselist=False
, primaryjoin=date_table.c.md_maintenanceinformation_dateOfNextUpdate==md_maintenanceinformation_table.c.md_maintenanceinformation_id
),      'updateScopeDescription': relationship(MD_ScopeDescription
, primaryjoin=md_scopedescription_table.c.md_maintenanceinformation_updateScopeDescription==md_maintenanceinformation_table.c.md_maintenanceinformation_id
),      'userDefinedMaintenanceFrequency': relationship(TM_PeriodDuration, uselist=False
, primaryjoin=tm_periodduration_table.c.md_maintenanceinformation_userDefinedMaintenanceFrequency==md_maintenanceinformation_table.c.md_maintenanceinformation_id
)})


mapper(MD_AggregateInformation, md_aggregateinformation_table)


mapper(MO_Location, mo_location_table)


mapper(MO_ObservationCollection, mo_observationcollection_table)


mapper(RS_ReferenceSystem, rs_referencesystem_table)


mapper(MO_Platform, mo_platform_table)


mapper(MD_Identifier, md_identifier_table)


mapper(EX_VerticalExtent, ex_verticalextent_table)


mapper(EX_Extent, ex_extent_table)


mapper(DQ_DataQuality, dq_dataquality_table)


mapper(MO_Instrument, mo_instrument_table)


mapper(LI_Lineage, li_lineage_table)


mapper(MO_InstrumentPlatformPair, mo_instrumentplatformpair_table)


mapper(MD_ApplicationSchemaInformation, md_applicationschemainformation_table)


mapper(DQ_Scope, dq_scope_table)


mapper(DQ_Element, dq_element_table)


mapper(MD_Metadata, md_metadata_table)


mapper(MD_Identification, md_identification_table)


mapper(LI_Source, li_source_table)


mapper(CI_Citation, ci_citation_table)


mapper(MO_Operation, mo_operation_table)


mapper(IO_IdentifiedObjectBase, io_identifiedobjectbase_table)


mapper(MD_ReferenceSystem, md_referencesystem_table)


mapper(OM_Observation, om_observation_table)


mapper(MD_Keywords, md_keywords_table)


mapper(MO_Project, mo_project_table)


mapper(MD_PortrayalCatalogueReference, md_portrayalcataloguereference_table)


mapper(CEDA_ObservationCollection, ceda_observationcollection_table)


mapper(EX_GeographicDescription, ex_geographicdescription_table)


mapper(MO_CompositeProcess, mo_compositeprocess_table)


mapper(MO_Observation, mo_observation_table)


mapper(CEDA_CompositeProcess, ceda_compositeprocess_table)


mapper(SC_CRS, sc_crs_table)


mapper(CEDA_Operation, ceda_operation_table)


mapper(CEDA_Processing, ceda_processing_table)


mapper(CEDA_Project, ceda_project_table)


mapper(CEDA_Instrument, ceda_instrument_table)


mapper(CEDA_Observation, ceda_observation_table)


mapper(MO_Acquisition, mo_acquisition_table)


mapper(CEDA_Acquisition, ceda_acquisition_table)


mapper(RS_Identifier, rs_identifier_table)


mapper(CEDA_Platform, ceda_platform_table)


mapper(MO_Processing, mo_processing_table)


class_mapper(MD_AggregateInformation).add_properties({  'aggregateDataSetName': relationship(CI_Citation, uselist=False
, primaryjoin=ci_citation_table.c.md_aggregateinformation_aggregateDataSetName==md_aggregateinformation_table.c.md_aggregateinformation_id
),      'aggregateDataSetIdentifier': relationship(MD_Identifier, uselist=False
, primaryjoin=md_identifier_table.c.md_aggregateinformation_aggregateDataSetIdentifier==md_aggregateinformation_table.c.md_aggregateinformation_id
)})


class_mapper(MO_Location).add_properties({      'nameLocation': relationship(EX_GeographicDescription, uselist=False
, primaryjoin=ex_geographicdescription_table.c.mo_location_nameLocation==mo_location_table.c.mo_location_id
),      'geometryLocation': relationship(GM_Object, uselist=False
, primaryjoin=gm_object_table.c.mo_location_geometryLocation==mo_location_table.c.mo_location_id
)})


class_mapper(MO_ObservationCollection).add_properties({ 'geographicExtent': relationship(EX_GeographicExtent
, primaryjoin=ex_geographicextent_table.c.mo_observationcollection_geographicExtent==mo_observationcollection_table.c.mo_observationcollection_id
),      'member': relationship(MO_Observation, uselist=False
, primaryjoin=mo_observation_table.c.mo_observationcollection_member==mo_observationcollection_table.c.mo_observationcollection_id
),      'identifier': relationship(MD_Identifier
, primaryjoin=md_identifier_table.c.mo_observationcollection_identifier==mo_observationcollection_table.c.mo_observationcollection_id
),      'isoMetadata': relationship(MD_Metadata, uselist=False
, primaryjoin=md_metadata_table.c.mo_observationcollection_isoMetadata==mo_observationcollection_table.c.mo_observationcollection_id
),      'additionalMetadata': relationship(CI_OnlineResource
, primaryjoin=ci_onlineresource_table.c.mo_observationcollection_additionalMetadata==mo_observationcollection_table.c.mo_observationcollection_id
),      'verticalExtent': relationship(EX_VerticalExtent
, primaryjoin=ex_verticalextent_table.c.mo_observationcollection_verticalExtent==mo_observationcollection_table.c.mo_observationcollection_id
),      'phenomenonTime': relationship(TM_Object
, primaryjoin=tm_object_table.c.mo_observationcollection_phenomenonTime==mo_observationcollection_table.c.mo_observationcollection_id
)})


class_mapper(RS_ReferenceSystem).add_properties({       'domainOfValidity': relationship(EX_Extent, uselist=False
, primaryjoin=ex_extent_table.c.rs_referencesystem_domainOfValidity==rs_referencesystem_table.c.rs_referencesystem_id
),      'name': relationship(RS_Identifier, uselist=False
, primaryjoin=rs_identifier_table.c.rs_referencesystem_name==rs_referencesystem_table.c.rs_referencesystem_id
)})


class_mapper(MO_Platform).add_properties({      'identifier': relationship(MD_Identifier
, primaryjoin=md_identifier_table.c.mo_platform_identifier==mo_platform_table.c.mo_platform_id
),      'documentation': relationship(CI_Citation
, primaryjoin=ci_citation_table.c.mo_platform_documentation==mo_platform_table.c.mo_platform_id
),      'relatedParty': relationship(MO_ResponsiblePartyInfo
, primaryjoin=mo_responsiblepartyinfo_table.c.mo_platform_relatedParty==mo_platform_table.c.mo_platform_id
),      'location': relationship(MO_Location, uselist=False
, primaryjoin=mo_location_table.c.mo_platform_location==mo_platform_table.c.mo_platform_id
)})


class_mapper(MD_Identifier).add_properties({    'authority': relationship(CI_Citation, uselist=False
, primaryjoin=ci_citation_table.c.md_identifier_authority==md_identifier_table.c.md_identifier_id
)})


class_mapper(EX_VerticalExtent).add_properties({        'verticalCRS': relationship(SC_CRS, uselist=False
, primaryjoin=sc_crs_table.c.ex_verticalextent_verticalCRS==ex_verticalextent_table.c.ex_verticalextent_id
)})


class_mapper(EX_Extent).add_properties({        'verticalElement': relationship(EX_VerticalExtent, uselist=False
, primaryjoin=ex_verticalextent_table.c.ex_extent_verticalElement==ex_extent_table.c.ex_extent_id
),      'temporalElement': relationship(EX_TemporalExtent, uselist=False
, primaryjoin=ex_temporalextent_table.c.ex_extent_temporalElement==ex_extent_table.c.ex_extent_id
),      'geographicElement': relationship(EX_GeographicExtent, uselist=False
, primaryjoin=ex_geographicextent_table.c.ex_extent_geographicElement==ex_extent_table.c.ex_extent_id
)})


class_mapper(DQ_DataQuality).add_properties({   'report': relationship(DQ_Element, uselist=False
, primaryjoin=dq_element_table.c.dq_dataquality_report==dq_dataquality_table.c.dq_dataquality_id
),      'lineage': relationship(LI_Lineage, uselist=False
, primaryjoin=li_lineage_table.c.dq_dataquality_lineage==dq_dataquality_table.c.dq_dataquality_id
),      'scope': relationship(DQ_Scope, uselist=False
, primaryjoin=dq_scope_table.c.dq_dataquality_scope==dq_dataquality_table.c.dq_dataquality_id
)})


class_mapper(MO_Instrument).add_properties({    'realatedParty': relationship(MO_ResponsiblePartyInfo
, primaryjoin=mo_responsiblepartyinfo_table.c.mo_instrument_realatedParty==mo_instrument_table.c.mo_instrument_id
),      'documentation': relationship(CI_Citation
, primaryjoin=ci_citation_table.c.mo_instrument_documentation==mo_instrument_table.c.mo_instrument_id
),      'identifier': relationship(MD_Identifier
, primaryjoin=md_identifier_table.c.mo_instrument_identifier==mo_instrument_table.c.mo_instrument_id
),      'type': relationship(ScopedName, uselist=False
, primaryjoin=scopedname_table.c.mo_instrument_type==mo_instrument_table.c.mo_instrument_id
)})


class_mapper(LI_Lineage).add_properties({       'source': relationship(LI_Source, uselist=False
, primaryjoin=li_source_table.c.li_lineage_source==li_lineage_table.c.li_lineage_id
),      'processStep': relationship(LI_ProcessStep, uselist=False
, primaryjoin=li_processstep_table.c.li_lineage_processStep==li_lineage_table.c.li_lineage_id
)})


class_mapper(MO_InstrumentPlatformPair).add_properties({        'instrument': relationship(MO_Instrument, uselist=False
, primaryjoin=mo_instrument_table.c.mo_instrumentplatformpair_instrument==mo_instrumentplatformpair_table.c.mo_instrumentplatformpair_id
),      'platform': relationship(MO_Platform, uselist=False
, primaryjoin=mo_platform_table.c.mo_instrumentplatformpair_platform==mo_instrumentplatformpair_table.c.mo_instrumentplatformpair_id
)})


class_mapper(MD_ApplicationSchemaInformation).add_properties({  'name': relationship(CI_Citation, uselist=False
, primaryjoin=ci_citation_table.c.md_applicationschemainformation_name==md_applicationschemainformation_table.c.md_applicationschemainformation_id
)})


class_mapper(DQ_Scope).add_properties({ 'extent': relationship(EX_Extent, uselist=False
, primaryjoin=ex_extent_table.c.dq_scope_extent==dq_scope_table.c.dq_scope_id
),      'levelDescription': relationship(MD_ScopeDescription
, primaryjoin=md_scopedescription_table.c.dq_scope_levelDescription==dq_scope_table.c.dq_scope_id
)})


class_mapper(DQ_Element).add_properties({       'evaluationProcedure': relationship(CI_Citation, uselist=False
, primaryjoin=ci_citation_table.c.dq_element_evaluationProcedure==dq_element_table.c.dq_element_id
),      'result': relationship(DQ_Result
, primaryjoin=dq_result_table.c.dq_element_result==dq_element_table.c.dq_element_id
),      'dateTime': relationship(DateTime
, primaryjoin=datetime_table.c.dq_element_dateTime==dq_element_table.c.dq_element_id
),      'measureIdentification': relationship(MD_Identifier, uselist=False
, primaryjoin=md_identifier_table.c.dq_element_measureIdentification==dq_element_table.c.dq_element_id
)})


class_mapper(MD_Metadata).add_properties({      'portrayalCatalogueInfo': relationship(MD_PortrayalCatalogueReference, uselist=False
, primaryjoin=md_portrayalcataloguereference_table.c.md_metadata_portrayalCatalogueInfo==md_metadata_table.c.md_metadata_id
),      'applicationSchemaInfo': relationship(MD_ApplicationSchemaInformation, uselist=False
, primaryjoin=md_applicationschemainformation_table.c.md_metadata_applicationSchemaInfo==md_metadata_table.c.md_metadata_id
),      'identificationInfo': relationship(MD_Identification, uselist=False
, primaryjoin=md_identification_table.c.md_metadata_identificationInfo==md_metadata_table.c.md_metadata_id
),      'contentInfo': relationship(MD_ContentInformation, uselist=False
, primaryjoin=md_contentinformation_table.c.md_metadata_contentInfo==md_metadata_table.c.md_metadata_id
),      'distributionInfo': relationship(MD_Distribution, uselist=False
, primaryjoin=md_distribution_table.c.md_metadata_distributionInfo==md_metadata_table.c.md_metadata_id
),      'referenceSystemInfo': relationship(MD_ReferenceSystem, uselist=False
, primaryjoin=md_referencesystem_table.c.md_metadata_referenceSystemInfo==md_metadata_table.c.md_metadata_id
),      'spatialRepresentationInfo': relationship(MD_SpatialRepresentation, uselist=False
, primaryjoin=md_spatialrepresentation_table.c.md_metadata_spatialRepresentationInfo==md_metadata_table.c.md_metadata_id
),      'metadataConstraints': relationship(MD_Constraints, uselist=False
, primaryjoin=md_constraints_table.c.md_metadata_metadataConstraints==md_metadata_table.c.md_metadata_id
),      'metadataMaintenance': relationship(MD_MaintenanceInformation, uselist=False
, primaryjoin=md_maintenanceinformation_table.c.md_metadata_metadataMaintenance==md_metadata_table.c.md_metadata_id
),      'dataQualityInfo': relationship(DQ_DataQuality, uselist=False
, primaryjoin=dq_dataquality_table.c.md_metadata_dataQualityInfo==md_metadata_table.c.md_metadata_id
),      'metadataExtensionInfo': relationship(MD_MetadataExtensionInformation, uselist=False
, primaryjoin=md_metadataextensioninformation_table.c.md_metadata_metadataExtensionInfo==md_metadata_table.c.md_metadata_id
),      'dateStamp': relationship(Date, uselist=False
, primaryjoin=date_table.c.md_metadata_dateStamp==md_metadata_table.c.md_metadata_id
),      'contact': relationship(CI_ResponsibleParty
, primaryjoin=ci_responsibleparty_table.c.md_metadata_contact==md_metadata_table.c.md_metadata_id
)})


class_mapper(MD_Identification).add_properties({        'pointOfContact': relationship(CI_ResponsibleParty
, primaryjoin=ci_responsibleparty_table.c.md_identification_pointOfContact==md_identification_table.c.md_identification_id
),      'citation': relationship(CI_Citation, uselist=False
, primaryjoin=ci_citation_table.c.md_identification_citation==md_identification_table.c.md_identification_id
),      'aggregationInfo': relationship(MD_AggregateInformation, uselist=False
, primaryjoin=md_aggregateinformation_table.c.md_identification_aggregationInfo==md_identification_table.c.md_identification_id
),      'resourceFormat': relationship(MD_Format, uselist=False
, primaryjoin=md_format_table.c.md_identification_resourceFormat==md_identification_table.c.md_identification_id
),      'descriptiveKeywords': relationship(MD_Keywords, uselist=False
, primaryjoin=md_keywords_table.c.md_identification_descriptiveKeywords==md_identification_table.c.md_identification_id
),      'resourceMaintenance': relationship(MD_MaintenanceInformation, uselist=False
, primaryjoin=md_maintenanceinformation_table.c.md_identification_resourceMaintenance==md_identification_table.c.md_identification_id
),      'resourceConstraints': relationship(MD_Constraints, uselist=False
, primaryjoin=md_constraints_table.c.md_identification_resourceConstraints==md_identification_table.c.md_identification_id
),      'resourceSpecificUsage': relationship(MD_Usage, uselist=False
, primaryjoin=md_usage_table.c.md_identification_resourceSpecificUsage==md_identification_table.c.md_identification_id
),      'graphicOverview': relationship(MD_BrowseGraphic, uselist=False
, primaryjoin=md_browsegraphic_table.c.md_identification_graphicOverview==md_identification_table.c.md_identification_id
)})


class_mapper(LI_Source).add_properties({        'sourceExtent': relationship(EX_Extent
, primaryjoin=ex_extent_table.c.li_source_sourceExtent==li_source_table.c.li_source_id
),      'sourceCitation': relationship(CI_Citation, uselist=False
, primaryjoin=ci_citation_table.c.li_source_sourceCitation==li_source_table.c.li_source_id
),      'sourceReferenceSystem': relationship(MD_ReferenceSystem, uselist=False
, primaryjoin=md_referencesystem_table.c.li_source_sourceReferenceSystem==li_source_table.c.li_source_id
),      'scaleDenominator': relationship(MD_RepresentativeFraction, uselist=False
, primaryjoin=md_representativefraction_table.c.li_source_scaleDenominator==li_source_table.c.li_source_id
)})


class_mapper(CI_Citation).add_properties({      'editionDate': relationship(Date, uselist=False
, primaryjoin=date_table.c.ci_citation_editionDate==ci_citation_table.c.ci_citation_id
),      'citedResponsibleParty': relationship(CI_ResponsibleParty
, primaryjoin=ci_responsibleparty_table.c.ci_citation_citedResponsibleParty==ci_citation_table.c.ci_citation_id
),      'date': relationship(CI_Date
, primaryjoin=ci_date_table.c.ci_citation_date==ci_citation_table.c.ci_citation_id
),      'identifier': relationship(MD_Identifier
, primaryjoin=md_identifier_table.c.ci_citation_identifier==ci_citation_table.c.ci_citation_id
),      'series': relationship(CI_Series, uselist=False
, primaryjoin=ci_series_table.c.ci_citation_series==ci_citation_table.c.ci_citation_id
)})


class_mapper(MO_Operation).add_properties({     'relatedPartyInfo': relationship(MO_ResponsiblePartyInfo
, primaryjoin=mo_responsiblepartyinfo_table.c.mo_operation_relatedPartyInfo==mo_operation_table.c.mo_operation_id
),      'operationTime': relationship(TM_Object, uselist=False
, primaryjoin=tm_object_table.c.mo_operation_operationTime==mo_operation_table.c.mo_operation_id
),      'location': relationship(MO_Location, uselist=False
, primaryjoin=mo_location_table.c.mo_operation_location==mo_operation_table.c.mo_operation_id
),      'identifier': relationship(MD_Identifier
, primaryjoin=md_identifier_table.c.mo_operation_identifier==mo_operation_table.c.mo_operation_id
),      'documentation': relationship(CI_Citation
, primaryjoin=ci_citation_table.c.mo_operation_documentation==mo_operation_table.c.mo_operation_id
),      'platform': relationship(MO_Platform, uselist=False
, primaryjoin=mo_platform_table.c.mo_operation_platform==mo_operation_table.c.mo_operation_id
)})


class_mapper(IO_IdentifiedObjectBase).add_properties({  'alias': relationship(GenericName
, primaryjoin=genericname_table.c.io_identifiedobjectbase_alias==io_identifiedobjectbase_table.c.io_identifiedobjectbase_id
),      'identifier': relationship(RS_Identifier
, primaryjoin=rs_identifier_table.c.io_identifiedobjectbase_identifier==io_identifiedobjectbase_table.c.io_identifiedobjectbase_id
)})


class_mapper(MD_ReferenceSystem).add_properties({       'referenceSystemIdentifier': relationship(RS_Identifier, uselist=False
, primaryjoin=rs_identifier_table.c.md_referencesystem_referenceSystemIdentifier==md_referencesystem_table.c.md_referencesystem_id
)})


class_mapper(OM_Observation).add_properties({   'validTime': relationship(TM_Period, uselist=False
, primaryjoin=tm_period_table.c.om_observation_validTime==om_observation_table.c.om_observation_id
),      'resultTime': relationship(TM_Instant, uselist=False
, primaryjoin=tm_instant_table.c.om_observation_resultTime==om_observation_table.c.om_observation_id
),      'parameter': relationship(NamedValue
, primaryjoin=namedvalue_table.c.om_observation_parameter==om_observation_table.c.om_observation_id
),      'metadata': relationship(MD_Metadata, uselist=False
, primaryjoin=md_metadata_table.c.om_observation_metadata==om_observation_table.c.om_observation_id
),      'observedProperty': relationship(GF_PropertyType, uselist=False
, primaryjoin=gf_propertytype_table.c.om_observation_observedProperty==om_observation_table.c.om_observation_id
),      'phenomenonTime': relationship(TM_Object, uselist=False
, primaryjoin=tm_object_table.c.om_observation_phenomenonTime==om_observation_table.c.om_observation_id
),      'result': relationship(Any, uselist=False
, primaryjoin=any_table.c.om_observation_result==om_observation_table.c.om_observation_id
),      'resultQuality': relationship(DQ_Element
, primaryjoin=dq_element_table.c.om_observation_resultQuality==om_observation_table.c.om_observation_id
)})


class_mapper(MD_Keywords).add_properties({      'thesaurusName': relationship(CI_Citation, uselist=False
, primaryjoin=ci_citation_table.c.md_keywords_thesaurusName==md_keywords_table.c.md_keywords_id
)})


class_mapper(MO_Project).add_properties({       'dmp': relationship(CI_Citation, uselist=False
, primaryjoin=ci_citation_table.c.mo_project_dmp==mo_project_table.c.mo_project_id
),      'observationCollection': relationship(MO_ObservationCollection, uselist=False
, primaryjoin=mo_observationcollection_table.c.mo_project_observationCollection==mo_project_table.c.mo_project_id
),      'relatedParty': relationship(MO_ResponsiblePartyInfo
, primaryjoin=mo_responsiblepartyinfo_table.c.mo_project_relatedParty==mo_project_table.c.mo_project_id
),      'documentation': relationship(CI_Citation
, primaryjoin=ci_citation_table.c.mo_project_documentation==mo_project_table.c.mo_project_id
),      'identifier': relationship(MD_Identifier
, primaryjoin=md_identifier_table.c.mo_project_identifier==mo_project_table.c.mo_project_id
),      'keywords': relationship(MD_Keywords
, primaryjoin=md_keywords_table.c.mo_project_keywords==mo_project_table.c.mo_project_id
)})


class_mapper(MD_PortrayalCatalogueReference).add_properties({   'portrayalCatalogueCitation': relationship(CI_Citation
, primaryjoin=ci_citation_table.c.md_portrayalcataloguereference_portrayalCatalogueCitation==md_portrayalcataloguereference_table.c.md_portrayalcataloguereference_id
)})


class_mapper(CEDA_ObservationCollection).add_properties({       'review': relationship(CEDA_Review
, primaryjoin=ceda_review_table.c.ceda_observationcollection_review==ceda_observationcollection_table.c.ceda_observationcollection_id
),      '_mo_observationcollection': relationship(MO_ObservationCollection, 
secondary=mo_observationcollection_ceda_observationcollection_table
, uselist=False
),      'member': relationship(CEDA_Observation, uselist=False
, primaryjoin=ceda_observation_table.c.ceda_observationcollection_member==ceda_observationcollection_table.c.ceda_observationcollection_id
)})


class_mapper(EX_GeographicDescription).add_properties({ 'geographicIdentifier': relationship(MD_Identifier, uselist=False
, primaryjoin=md_identifier_table.c.ex_geographicdescription_geographicIdentifier==ex_geographicdescription_table.c.ex_geographicdescription_id
),      '_ex_geographicextent': relationship(EX_GeographicExtent, 
secondary=ex_geographicextent_ex_geographicdescription_table
, uselist=False
)})


class_mapper(MO_CompositeProcess).add_properties({      'relatedParty': relationship(MO_ResponsiblePartyInfo
, primaryjoin=mo_responsiblepartyinfo_table.c.mo_compositeprocess_relatedParty==mo_compositeprocess_table.c.mo_compositeprocess_id
),      'acquisitionComponent': relationship(MO_Acquisition, uselist=False
, primaryjoin=mo_acquisition_table.c.mo_compositeprocess_acquisitionComponent==mo_compositeprocess_table.c.mo_compositeprocess_id
),      'identifier': relationship(MD_Identifier
, primaryjoin=md_identifier_table.c.mo_compositeprocess_identifier==mo_compositeprocess_table.c.mo_compositeprocess_id
),      'computationComponent': relationship(MO_Computation, uselist=False
, primaryjoin=mo_computation_table.c.mo_compositeprocess_computationComponent==mo_compositeprocess_table.c.mo_compositeprocess_id
),      '_mo_process': relationship(MO_Process, 
secondary=mo_process_mo_compositeprocess_table
, uselist=False
),      'documentation': relationship(CI_Citation
, primaryjoin=ci_citation_table.c.mo_compositeprocess_documentation==mo_compositeprocess_table.c.mo_compositeprocess_id
)})


class_mapper(MO_Observation).add_properties({   'verticalExtent': relationship(EX_VerticalExtent
, primaryjoin=ex_verticalextent_table.c.mo_observation_verticalExtent==mo_observation_table.c.mo_observation_id
),      'relatedParty': relationship(MO_ResponsiblePartyInfo
, primaryjoin=mo_responsiblepartyinfo_table.c.mo_observation_relatedParty==mo_observation_table.c.mo_observation_id
),      'result': relationship(MO_Result, uselist=False
, primaryjoin=mo_result_table.c.mo_observation_result==mo_observation_table.c.mo_observation_id
),      'permission': relationship(MD_Constraints, uselist=False
, primaryjoin=md_constraints_table.c.mo_observation_permission==mo_observation_table.c.mo_observation_id
),      'inSupportOf': relationship(MO_Project, uselist=False
, primaryjoin=mo_project_table.c.mo_observation_inSupportOf==mo_observation_table.c.mo_observation_id
),      '_om_observation': relationship(OM_Observation, 
secondary=om_observation_mo_observation_table
, uselist=False
),      'identifier': relationship(MD_Identifier
, primaryjoin=md_identifier_table.c.mo_observation_identifier==mo_observation_table.c.mo_observation_id
),      'geographicExtent': relationship(EX_GeographicExtent
, primaryjoin=ex_geographicextent_table.c.mo_observation_geographicExtent==mo_observation_table.c.mo_observation_id
),      'documentation': relationship(CI_Citation
, primaryjoin=ci_citation_table.c.mo_observation_documentation==mo_observation_table.c.mo_observation_id
)})


class_mapper(CEDA_CompositeProcess).add_properties({    '_ceda_process': relationship(CEDA_Process, 
secondary=ceda_process_ceda_compositeprocess_table
, uselist=False
),      '_mo_compositeprocess': relationship(MO_CompositeProcess, 
secondary=mo_compositeprocess_ceda_compositeprocess_table
, uselist=False
),      'computationComponent': relationship(CEDA_Processing, uselist=False
, primaryjoin=ceda_processing_table.c.ceda_compositeprocess_computationComponent==ceda_compositeprocess_table.c.ceda_compositeprocess_id
),      'aquisitionComponent': relationship(CEDA_Acquisition, uselist=False
, primaryjoin=ceda_acquisition_table.c.ceda_compositeprocess_aquisitionComponent==ceda_compositeprocess_table.c.ceda_compositeprocess_id
),      'review': relationship(CEDA_Review
, primaryjoin=ceda_review_table.c.ceda_compositeprocess_review==ceda_compositeprocess_table.c.ceda_compositeprocess_id
)})


class_mapper(SC_CRS).add_properties({   '_rs_referencesystem': relationship(RS_ReferenceSystem, 
secondary=rs_referencesystem_sc_crs_table
, uselist=False
),      '_io_identifiedobjectbase': relationship(IO_IdentifiedObjectBase, 
secondary=io_identifiedobjectbase_sc_crs_table
, uselist=False
)})


class_mapper(CEDA_Operation).add_properties({   'review': relationship(CEDA_Review
, primaryjoin=ceda_review_table.c.ceda_operation_review==ceda_operation_table.c.ceda_operation_id
),      '_mo_operation': relationship(MO_Operation, 
secondary=mo_operation_ceda_operation_table
, uselist=False
)})


class_mapper(CEDA_Processing).add_properties({  '_ceda_process': relationship(CEDA_Process, 
secondary=ceda_process_ceda_processing_table
, uselist=False
),      'review': relationship(CEDA_Review
, primaryjoin=ceda_review_table.c.ceda_processing_review==ceda_processing_table.c.ceda_processing_id
),      '_mo_processing': relationship(MO_Processing, 
secondary=mo_processing_ceda_processing_table
, uselist=False
)})


class_mapper(CEDA_Project).add_properties({     'observationCollection': relationship(CEDA_ObservationCollection, uselist=False
, primaryjoin=ceda_observationcollection_table.c.ceda_project_observationCollection==ceda_project_table.c.ceda_project_id
),      'projectResource': relationship(MO_OnlineResource
, primaryjoin=mo_onlineresource_table.c.ceda_project_projectResource==ceda_project_table.c.ceda_project_id
),      'review': relationship(CEDA_Review
, primaryjoin=ceda_review_table.c.ceda_project_review==ceda_project_table.c.ceda_project_id
),      '_mo_project': relationship(MO_Project, 
secondary=mo_project_ceda_project_table
, uselist=False
)})


class_mapper(CEDA_Instrument).add_properties({  'review': relationship(CEDA_Review
, primaryjoin=ceda_review_table.c.ceda_instrument_review==ceda_instrument_table.c.ceda_instrument_id
),      '_mo_instrument': relationship(MO_Instrument, 
secondary=mo_instrument_ceda_instrument_table
, uselist=False
)})


class_mapper(CEDA_Observation).add_properties({ '_mo_observation': relationship(MO_Observation, 
secondary=mo_observation_ceda_observation_table
, uselist=False
),      'inSupportOf': relationship(CEDA_Project, uselist=False
, primaryjoin=ceda_project_table.c.ceda_observation_inSupportOf==ceda_observation_table.c.ceda_observation_id
),      'internalReview': relationship(CEDA_Review
, primaryjoin=ceda_review_table.c.ceda_observation_internalReview==ceda_observation_table.c.ceda_observation_id
),      'keywords': relationship(MD_Keywords
, primaryjoin=md_keywords_table.c.ceda_observation_keywords==ceda_observation_table.c.ceda_observation_id
),      'procedure': relationship(CEDA_Process, uselist=False
, primaryjoin=ceda_process_table.c.ceda_observation_procedure==ceda_observation_table.c.ceda_observation_id
),      'result': relationship(CEDA_Result, uselist=False
, primaryjoin=ceda_result_table.c.ceda_observation_result==ceda_observation_table.c.ceda_observation_id
),      'citation': relationship(CEDA_Citation
, primaryjoin=ceda_citation_table.c.ceda_observation_citation==ceda_observation_table.c.ceda_observation_id
)})


class_mapper(MO_Acquisition).add_properties({   'platform': relationship(MO_Platform, uselist=False
, primaryjoin=mo_platform_table.c.mo_acquisition_platform==mo_acquisition_table.c.mo_acquisition_id
),      'realatedParty': relationship(MO_ResponsiblePartyInfo
, primaryjoin=mo_responsiblepartyinfo_table.c.mo_acquisition_realatedParty==mo_acquisition_table.c.mo_acquisition_id
),      'instrument': relationship(MO_Instrument, uselist=False
, primaryjoin=mo_instrument_table.c.mo_acquisition_instrument==mo_acquisition_table.c.mo_acquisition_id
),      'operation': relationship(MO_Operation, uselist=False
, primaryjoin=mo_operation_table.c.mo_acquisition_operation==mo_acquisition_table.c.mo_acquisition_id
),      '_mo_process': relationship(MO_Process, 
secondary=mo_process_mo_acquisition_table
, uselist=False
),      'documentation': relationship(CI_Citation
, primaryjoin=ci_citation_table.c.mo_acquisition_documentation==mo_acquisition_table.c.mo_acquisition_id
),      'outputDescription': relationship(MO_InputOutput, uselist=False
, primaryjoin=mo_inputoutput_table.c.mo_acquisition_outputDescription==mo_acquisition_table.c.mo_acquisition_id
),      'instrumentPlatformPair': relationship(MO_InstrumentPlatformPair
, primaryjoin=mo_instrumentplatformpair_table.c.mo_acquisition_instrumentPlatformPair==mo_acquisition_table.c.mo_acquisition_id
),      'identifier': relationship(MD_Identifier
, primaryjoin=md_identifier_table.c.mo_acquisition_identifier==mo_acquisition_table.c.mo_acquisition_id
)})


class_mapper(CEDA_Acquisition).add_properties({ 'operation': relationship(CEDA_Operation, uselist=False
, primaryjoin=ceda_operation_table.c.ceda_acquisition_operation==ceda_acquisition_table.c.ceda_acquisition_id
),      '_ceda_process': relationship(CEDA_Process, 
secondary=ceda_process_ceda_acquisition_table
, uselist=False
),      'review': relationship(CEDA_Review
, primaryjoin=ceda_review_table.c.ceda_acquisition_review==ceda_acquisition_table.c.ceda_acquisition_id
),      'instrument': relationship(CEDA_Instrument, uselist=False
, primaryjoin=ceda_instrument_table.c.ceda_acquisition_instrument==ceda_acquisition_table.c.ceda_acquisition_id
),      'platform': relationship(CEDA_Platform, uselist=False
, primaryjoin=ceda_platform_table.c.ceda_acquisition_platform==ceda_acquisition_table.c.ceda_acquisition_id
),      '_mo_acquisition': relationship(MO_Acquisition, 
secondary=mo_acquisition_ceda_acquisition_table
, uselist=False
)})


class_mapper(RS_Identifier).add_properties({    '_md_identifier': relationship(MD_Identifier, 
secondary=md_identifier_rs_identifier_table
, uselist=False
)})


class_mapper(CEDA_Platform).add_properties({    'review': relationship(CEDA_Review
, primaryjoin=ceda_review_table.c.ceda_platform_review==ceda_platform_table.c.ceda_platform_id
),      '_mo_platform': relationship(MO_Platform, 
secondary=mo_platform_ceda_platform_table
, uselist=False
)})


class_mapper(MO_Processing).add_properties({    '_mo_computation': relationship(MO_Computation, 
secondary=mo_computation_mo_processing_table
, uselist=False
),      'identifier': relationship(MD_Identifier
, primaryjoin=md_identifier_table.c.mo_processing_identifier==mo_processing_table.c.mo_processing_id
),      'documentation': relationship(CI_Citation
, primaryjoin=ci_citation_table.c.mo_processing_documentation==mo_processing_table.c.mo_processing_id
),      'processingInput': relationship(MO_InputOutput
, primaryjoin=mo_inputoutput_table.c.mo_processing_processingInput==mo_processing_table.c.mo_processing_id
),      'relatedParty': relationship(MO_ResponsiblePartyInfo
, primaryjoin=mo_responsiblepartyinfo_table.c.mo_processing_relatedParty==mo_processing_table.c.mo_processing_id
),      'softwareReference': relationship(CI_Citation, uselist=False
, primaryjoin=ci_citation_table.c.mo_processing_softwareReference==mo_processing_table.c.mo_processing_id
),      'processingOutput': relationship(MO_InputOutput, uselist=False
, primaryjoin=mo_inputoutput_table.c.mo_processing_processingOutput==mo_processing_table.c.mo_processing_id
)})

metadata.create_all(engine)