source: mauRepo/MolesManager/trunk/src/MolesManager/static/admin/joinInheritedSqlTables.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 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_2_2009_metadata___imagery.data_quality_information___imagery.le_source import  LE_Source        
from ea_model.iso_19115_2006_metadata_corrigendum.metadata_entity_set_information.md_metadata import  MD_Metadata       
from ea_model.upcomingiso.ci_individual import  CI_Individual   
from ea_model.iso_19115_2006_metadata_corrigendum.metadata_extension_information.md_obligationcode import  MD_ObligationCode    
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.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.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_19103_2005_schema_language.basic_types.derived.units_of_measure.distance import  Distance     
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.ceda_moles.ceda_acquisition.ceda_acquisition import  CEDA_Acquisition     
from ea_model.iso_19115_2006_metadata_corrigendum.portrayal_catalogue_information.md_portrayalcataloguereference import  MD_PortrayalCatalogueReference 
from ea_model.iso_19115_2006_metadata_corrigendum.metadata_extension_information.md_datatypecode import  MD_DatatypeCode        
from ea_model.upcomingiso.ci_responsiblepartyinfo import  CI_ResponsiblePartyInfo       
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.distribution_information.md_medium import  MD_Medium  
from ea_model.iso_19108_2006_temporal_schema.temporal_objects.tm_duration import  TM_Duration   
from ea_model.iso_19115_2006_metadata_corrigendum.identification_information.md_identification import  MD_Identification        
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.upcomingiso.ci_responsibility import  CI_Responsibility   
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_2_2009_metadata___imagery.data_quality_information___imagery.le_algorithm import  LE_Algorithm  
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_acquisition.ceda_platform import  CEDA_Platform   
from ea_model.ceda_moles.ceda_computation.ceda_processing import  CEDA_Processing       
from ea_model.iso_19115_2006_metadata_corrigendum.extent_information.ex_geographicextent import  EX_GeographicExtent    
from ea_model.ceda_moles.ceda_acquisition.ceda_instrument import  CEDA_Instrument       
from ea_model.ceda_moles.ceda_result.ceda_result import  CEDA_Result    
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_fdis_19156_2011_observations_and_measurements.observation_schema.observation.namedvalue import  NamedValue    
from ea_model.iso_19115_2006_metadata_corrigendum.maintenance_information.md_scopecode import  MD_ScopeCode     
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.distribution_information.md_distributor import  MD_Distributor        
from ea_model.iso_19115_2006_metadata_corrigendum.identification_information.md_keywordtypecode import  MD_KeywordTypeCode      
from ea_model.iso_19103_2005_schema_language.basic_types.derived.units_of_measure.length import  Length 
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_19108_2006_temporal_schema.temporal_objects.tm_primitive import  TM_Primitive 
from ea_model.iso_19103_2005_schema_language.basic_types.derived.units_of_measure.measuretype import  MeasureType       
from ea_model.moles3_4.observationprocess.mo_process import  MO_Process 
from ea_model.moles3_4.utilities.mo_publicationstatevalue import  MO_PublicationStateValue      
from ea_model.iso_19115_2006_metadata_corrigendum.maintenance_information.md_maintenancefrequencycode import  MD_MaintenanceFrequencyCode       
from ea_model.iso_19109_2005_application_schema.general_feature_model.gf_propertytype import  GF_PropertyType   
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.moles3_4.observation.mo_observation import  MO_Observation        
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.identification_information.ds_associationtypecode import  DS_AssociationTypeCode      
from ea_model.moles3_4.result.mo_onlineresource import  MO_OnlineResource       
from ea_model.iso_19115_2006_metadata_corrigendum.citation_and_responsible_party_information.ci_datetypecode import  CI_DateTypeCode    
from ea_model.iso_19115_2006_metadata_corrigendum.distribution_information.md_standardorderprocess import  MD_StandardOrderProcess      
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_19115_2006_metadata_corrigendum.distribution_information.md_digitaltransferoptions import  MD_DigitalTransferOptions  
from ea_model.upcomingiso.ci_party import  CI_Party     
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.moles3_4.utilities.mo_organization import  MO_Organization        
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.distribution_information.md_mediumnamecode import  MD_MediumNameCode  
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.primitive.date_and_time.date import  Date      
from ea_model.iso_19103_2005_schema_language.basic_types.derived.units_of_measure.measure import  Measure       
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.upcomingiso.ci_organisation import  CI_Organisation       
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.distribution_information.md_mediumformatcode import  MD_MediumFormatCode      
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_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_2_2009_metadata___imagery.data_quality_information___imagery.le_nominalresolution import  LE_NominalResolution  
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.citation_and_responsible_party_information.ci_citation import  CI_Citation    
from ea_model.iso_19115_2006_metadata_corrigendum.data_quality_information.dq_evaluationmethodtypecode import  DQ_EvaluationMethodTypeCode      
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.moles3_4.utilities.mo_responsiblepartyinfo import  MO_ResponsiblePartyInfo        
from ea_model.iso_19115_2006_metadata_corrigendum.data_quality_information.li_source import  LI_Source  
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.moles3_4.acquisition.mo_instrumentplatformpair import  MO_InstrumentPlatformPair  
from ea_model.iso_19109_2005_application_schema.general_feature_model.gf_constraint import  GF_Constraint       
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)













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('fileName', TEXT() , nullable=False),
        Column('fileDescription', TEXT() , nullable=True),
        Column('fileType', TEXT() , nullable=True),
Column('t_type', String(30), nullable=False, default='md_browsegraphic'),
        extend_existing=False,)
 
 











ex_geographicextent_table = Table('ex_geographicextent', metadata,
        Column('ex_geographicextent_id', Integer, Sequence('ex_geographicextent_id_seq'), primary_key=True),
        Column('mo_observationcollection_geographicExtent', Integer, ForeignKey('mo_observationcollection.mo_observationcollection_id')),
        Column('ex_extent_geographicElement', Integer, ForeignKey('ex_extent.ex_extent_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,)
 
 











genericname_table = Table('genericname', metadata,
        Column('genericname_id', Integer, Sequence('genericname_id_seq'), primary_key=True),
        Column('mo_inputoutput_name', Integer, ForeignKey('mo_inputoutput.mo_inputoutput_id')),
        Column('io_identifiedobjectbase_alias', Integer, ForeignKey('io_identifiedobjectbase.io_identifiedobjectbase_id')),
        Column('namedvalue_name', Integer, ForeignKey('namedvalue.namedvalue_id')),
Column('t_type', String(30), nullable=False, default='genericname'),
        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,)
 
 











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,)
 
 











md_format_table = Table('md_format', metadata,
        Column('md_format_id', Integer, Sequence('md_format_id_seq'), primary_key=True),
        Column('md_distribution_distributionFormat', Integer, ForeignKey('md_distribution.md_distribution_id')),
        Column('md_identification_resourceFormat', Integer, ForeignKey('md_identification.md_identification_id')),
        Column('name', TEXT() , nullable=False),
        Column('amendmentNumber', TEXT() , nullable=True),
        Column('specification', TEXT() , nullable=True),
        Column('fileDecompressionTechnique', TEXT() , nullable=True),
        Column('version', TEXT() , nullable=False),
Column('t_type', String(30), nullable=False, default='md_format'),
        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,)
 
 











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











unitofmeasure_table = Table('unitofmeasure', metadata,
        Column('unitofmeasure_id', Integer, Sequence('unitofmeasure_id_seq'), primary_key=True),
        Column('scaleToStandardUnit', NUMERIC() , nullable=True),
        Column('nameStandardUnit', TEXT() , nullable=True),
        Column('uomName', TEXT() , nullable=False),
        Column('formula', TEXT() , nullable=True),
        Column('uomSymbol', TEXT() , nullable=False),
        Column('measureType', MeasureType.db_type() , nullable=False),
        Column('offsetToStandardUnit', NUMERIC() , nullable=True),
Column('t_type', String(30), nullable=False, default='unitofmeasure'),
        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,)
 
 











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('name', TEXT() , nullable=True),
        Column('page', TEXT() , nullable=True),
        Column('issueIdentification', TEXT() , nullable=True),
Column('t_type', String(30), nullable=False, default='ci_series'),
        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,)
 
 











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











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,)
 
 











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,)
 
 











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,)
 
 











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











md_medium_table = Table('md_medium', metadata,
        Column('md_medium_id', Integer, Sequence('md_medium_id_seq'), primary_key=True),
        Column('md_digitaltransferoptions_offLine', Integer, ForeignKey('md_digitaltransferoptions.md_digitaltransferoptions_id')),
        Column('densityUnits', TEXT() , nullable=True),
        Column('volumes', Integer() , nullable=True),
        Column('name', MD_MediumNameCode.db_type() , nullable=True),
        Column('mediumNote', TEXT() , nullable=True),
        Column('mediumFormat', MD_MediumFormatCode.db_type() , nullable=True),
        Column('density', ARRAY(NUMERIC) , nullable=True),
Column('t_type', String(30), nullable=False, default='md_medium'),
        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,)
 
 











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,)
 
 











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('country', TEXT() , nullable=True),
        Column('electronicMailAddress', ARRAY(TEXT) , nullable=True),
        Column('administrativeArea', TEXT() , nullable=True),
        Column('city', TEXT() , nullable=True),
        Column('postalCode', TEXT() , nullable=True),
        Column('deliveryPoint', ARRAY(TEXT) , nullable=True),
Column('t_type', String(30), nullable=False, default='ci_address'),
        extend_existing=False,)
 
 











md_scopedescription_table = Table('md_scopedescription', metadata,
        Column('md_scopedescription_id', Integer, Sequence('md_scopedescription_id_seq'), primary_key=True),
        Column('dq_scope_levelDescription', Integer, ForeignKey('dq_scope.dq_scope_id')),
        Column('md_maintenanceinformation_updateScopeDescription', Integer, ForeignKey('md_maintenanceinformation.md_maintenanceinformation_id')),
        Column('other', TEXT() , nullable=False),
        Column('dataset', TEXT() , nullable=False),
Column('t_type', String(30), nullable=False, default='md_scopedescription'),
        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,)
 
 











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,)
 
 











gf_constraint_table = Table('gf_constraint', metadata,
        Column('gf_constraint_id', Integer, Sequence('gf_constraint_id_seq'), primary_key=True),
        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,)
 
 











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,)
 
 











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('minutes', TEXT() , nullable=True),
        Column('timeIndicator', TEXT() , nullable=True),
        Column('seconds', TEXT() , nullable=True),
        Column('days', TEXT() , nullable=True),
        Column('years', TEXT() , nullable=True),
        Column('designator', TEXT() , nullable=False),
        Column('hours', TEXT() , nullable=True),
        Column('months', TEXT() , nullable=True),
Column('t_type', String(30), nullable=False, default='tm_periodduration'),
        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,)
 
 











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,)
 
 











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,)
 
 











ci_onlineresource_table = Table('ci_onlineresource', metadata,
        Column('ci_onlineresource_id', Integer, Sequence('ci_onlineresource_id_seq'), primary_key=True),
        Column('md_digitaltransferoptions_onLine', Integer, ForeignKey('md_digitaltransferoptions.md_digitaltransferoptions_id')),
        Column('ci_contact_onlineResource', Integer, ForeignKey('ci_contact.ci_contact_id')),
        Column('md_metadataextensioninformation_extensionOnLineResource', Integer, ForeignKey('md_metadataextensioninformation.md_metadataextensioninformation_id')),
        Column('mo_observationcollection_additionalMetadata', Integer, ForeignKey('mo_observationcollection.mo_observationcollection_id')),
        Column('name', TEXT() , nullable=True),
        Column('description', TEXT() , nullable=True),
        Column('function', CI_OnLineFunctionCode.db_type() , nullable=True),
        Column('protocol', TEXT() , nullable=True),
        Column('applicationProfile', TEXT() , nullable=True),
Column('t_type', String(30), nullable=False, default='ci_onlineresource'),
        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,)
 
 











date_table = Table('date', metadata,
        Column('date_id', Integer, Sequence('date_id_seq'), primary_key=True),
        Column('md_metadata_dateStamp', Integer, ForeignKey('md_metadata.md_metadata_id')),
        Column('ci_date_date', Integer, ForeignKey('ci_date.ci_date_id')),
        Column('tm_position_date8601', Integer, ForeignKey('tm_position.tm_position_id')),
        Column('md_maintenanceinformation_dateOfNextUpdate', Integer, ForeignKey('md_maintenanceinformation.md_maintenanceinformation_id')),
        Column('ci_citation_editionDate', Integer, ForeignKey('ci_citation.ci_citation_id')),
        Column('year', TEXT() , nullable=True),
        Column('century', TEXT() , nullable=False),
        Column('day', TEXT() , nullable=True),
        Column('month', TEXT() , nullable=True),
Column('t_type', String(30), nullable=False, default='date'),
        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_propertytype_memberName', Integer, ForeignKey('gf_propertytype.gf_propertytype_id')),
Column('t_type', String(30), nullable=False, default='localname'),
        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,)
 
 











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,)
 
 











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_targetUnits', Integer, ForeignKey('scale.scale_id')),
        Column('length_uom', Integer, ForeignKey('length.length_id')),
        Column('scale_sourceUnits', Integer, ForeignKey('scale.scale_id')),
Column('t_type', String(30), nullable=False, default='uomlength'),
        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,)
 
 











ci_contact_table = Table('ci_contact', metadata,
        Column('ci_contact_id', Integer, Sequence('ci_contact_id_seq'), primary_key=True),
        Column('ci_party_contactInfo', Integer, ForeignKey('ci_party.ci_party_id')),
        Column('ci_responsibleparty_contactInfo', Integer, ForeignKey('ci_responsibleparty.ci_responsibleparty_id')),
        Column('contactInstructions', TEXT() , nullable=True),
        Column('hoursOfService', TEXT() , nullable=True),
Column('t_type', String(30), nullable=False, default='ci_contact'),
        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,)
 
 











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,)
 
 











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_sample', Integer, ForeignKey('mo_result.mo_result_id')),
        Column('mo_result_source', 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,)
 
 











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,)
 
 











md_digitaltransferoptions_table = Table('md_digitaltransferoptions', metadata,
        Column('md_digitaltransferoptions_id', Integer, Sequence('md_digitaltransferoptions_id_seq'), primary_key=True),
        Column('md_distribution_transferOptions', Integer, ForeignKey('md_distribution.md_distribution_id')),
        Column('md_distributor_distributorTransferOptions', Integer, ForeignKey('md_distributor.md_distributor_id')),
        Column('transferSize', NUMERIC() , nullable=True),
        Column('unitsOfDistribution', TEXT() , nullable=True),
Column('t_type', String(30), nullable=False, default='md_digitaltransferoptions'),
        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,)
 
 











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,)
 
 











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,)
 
 











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











length_table = Table('length', metadata,
        Column('length_id', Integer, Sequence('length_id_seq'), primary_key=True),
                                Column('measure_id', Integer, ForeignKey('measure.measure_id')),Column('t_type', String(30), nullable=False, default='length'),
        extend_existing=False,)
 
 











distance_table = Table('distance', metadata,
        Column('distance_id', Integer, Sequence('distance_id_seq'), primary_key=True),
                                Column('length_id', Integer, ForeignKey('length.length_id')),   Column('le_nominalresolution_scanningResolution', Integer, ForeignKey('le_nominalresolution.le_nominalresolution_id')),
        Column('le_nominalresolution_groundResolution', Integer, ForeignKey('le_nominalresolution.le_nominalresolution_id')),
Column('t_type', String(30), nullable=False, default='distance'),
        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,)
 
 











ci_responsibleparty_table = Table('ci_responsibleparty', metadata,
        Column('ci_responsibleparty_id', Integer, Sequence('ci_responsibleparty_id_seq'), primary_key=True),
        Column('md_identification_pointOfContact', Integer, ForeignKey('md_identification.md_identification_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_maintenanceinformation_contact', Integer, ForeignKey('md_maintenanceinformation.md_maintenanceinformation_id')),
        Column('md_distributor_distributorContact', Integer, ForeignKey('md_distributor.md_distributor_id')),
        Column('ci_citation_citedResponsibleParty', Integer, ForeignKey('ci_citation.ci_citation_id')),
        Column('md_metadata_contact', Integer, ForeignKey('md_metadata.md_metadata_id')),
        Column('md_extendedelementinformation_source', Integer, ForeignKey('md_extendedelementinformation.md_extendedelementinformation_id')),
        Column('organisationName', TEXT() , nullable=True),
        Column('role', CI_RoleCode.db_type() , nullable=False),
        Column('individualName', TEXT() , nullable=True),
        Column('positionName', TEXT() , nullable=True),
Column('t_type', String(30), nullable=False, default='ci_responsibleparty'),
        extend_existing=False,)
 
 











ci_party_table = Table('ci_party', metadata,
        Column('ci_party_id', Integer, Sequence('ci_party_id_seq'), primary_key=True),
        Column('ci_responsibility_party', Integer, ForeignKey('ci_responsibility.ci_responsibility_id')),
        Column('name', TEXT() , nullable=True),
Column('t_type', String(30), nullable=False, default='ci_party'),
        extend_existing=False,)
 
 











ci_individual_table = Table('ci_individual', metadata,
        Column('ci_individual_id', Integer, Sequence('ci_individual_id_seq'), primary_key=True),
                                Column('ci_party_id', Integer, ForeignKey('ci_party.ci_party_id')),     Column('ci_organisation_individual', Integer, ForeignKey('ci_organisation.ci_organisation_id')),
        Column('positionName', TEXT() , nullable=True),
Column('t_type', String(30), nullable=False, default='ci_individual'),
        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,)
 
 











le_nominalresolution_table = Table('le_nominalresolution', metadata,
        Column('le_nominalresolution_id', Integer, Sequence('le_nominalresolution_id_seq'), primary_key=True),
        Column('le_source_resolution', Integer, ForeignKey('le_source.le_source_id')),
Column('t_type', String(30), nullable=False, default='le_nominalresolution'),
        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,)
 
 











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('specificUsage', TEXT() , nullable=False),
        Column('userDeterminedLimitations', TEXT() , nullable=True),
Column('t_type', String(30), nullable=False, default='md_usage'),
        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('rationale', TEXT() , nullable=True),
        Column('description', TEXT() , nullable=False),
Column('t_type', String(30), nullable=False, default='li_processstep'),
        extend_existing=False,)
 
 











ci_organisation_table = Table('ci_organisation', metadata,
        Column('ci_organisation_id', Integer, Sequence('ci_organisation_id_seq'), primary_key=True),
                                Column('ci_party_id', Integer, ForeignKey('ci_party.ci_party_id')),Column('t_type', String(30), nullable=False, default='ci_organisation'),
        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,)
 
 











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('name', TEXT() , nullable=False),
        Column('domainValue', TEXT() , nullable=True),
        Column('maximumOccurrence', TEXT() , nullable=True),
        Column('rule', TEXT() , nullable=False),
        Column('definition', TEXT() , nullable=False),
        Column('domainCode', Integer() , nullable=True),
        Column('parentEntity', ARRAY(TEXT) , nullable=False),
        Column('condition', TEXT() , nullable=True),
        Column('rationale', ARRAY(TEXT) , nullable=True),
        Column('shortName', TEXT() , nullable=True),
        Column('obligation', MD_ObligationCode.db_type() , nullable=True),
        Column('dataType', MD_DatatypeCode.db_type() , nullable=False),
Column('t_type', String(30), nullable=False, default='md_extendedelementinformation'),
        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_metadata_metadataMaintenance', Integer, ForeignKey('md_metadata.md_metadata_id')),
        Column('md_identification_resourceMaintenance', Integer, ForeignKey('md_identification.md_identification_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,)
 
 











md_standardorderprocess_table = Table('md_standardorderprocess', metadata,
        Column('md_standardorderprocess_id', Integer, Sequence('md_standardorderprocess_id_seq'), primary_key=True),
        Column('md_distributor_distributionOrderProcess', Integer, ForeignKey('md_distributor.md_distributor_id')),
        Column('fees', TEXT() , nullable=True),
        Column('orderingInstructions', TEXT() , nullable=True),
        Column('turnaround', TEXT() , nullable=True),
Column('t_type', String(30), nullable=False, default='md_standardorderprocess'),
        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_distributor_table = Table('md_distributor', metadata,
        Column('md_distributor_id', Integer, Sequence('md_distributor_id_seq'), primary_key=True),
        Column('md_distribution_distributor', Integer, ForeignKey('md_distribution.md_distribution_id')),
Column('t_type', String(30), nullable=False, default='md_distributor'),
        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,)
 
 











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('curationCategory', CEDA_CurationValue.db_type() , nullable=False),
        Column('internalPath', TEXT() , nullable=False),
        Column('volume', Integer() , nullable=True),
Column('t_type', String(30), nullable=False, default='ceda_result'),
        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,)
 
 











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,)
 
 











le_algorithm_table = Table('le_algorithm', metadata,
        Column('le_algorithm_id', Integer, Sequence('le_algorithm_id_seq'), primary_key=True),
        Column('mo_processing_algorithm', Integer, ForeignKey('mo_processing.mo_processing_id')),
        Column('description', TEXT() , nullable=False),
Column('t_type', String(30), nullable=False, default='le_algorithm'),
        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('constraintLanguage', TEXT() , nullable=False),
        Column('softwareDevelopmentFileFormat', TEXT() , nullable=True),
        Column('schemaLanguage', TEXT() , nullable=False),
        Column('schemaAscii', TEXT() , nullable=True),
Column('t_type', String(30), nullable=False, default='md_applicationschemainformation'),
        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,)
 
 











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,)
 
 











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('codeSpace', TEXT() , nullable=True),
        Column('version', TEXT() , nullable=True),
Column('t_type', String(30), nullable=False, default='rs_identifier'),
        extend_existing=False,)
 
 











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











ci_responsiblepartyinfo_table = Table('ci_responsiblepartyinfo', metadata,
        Column('ci_responsiblepartyinfo_id', Integer, Sequence('ci_responsiblepartyinfo_id_seq'), primary_key=True),
        Column('role', CI_RoleCode.db_type() , nullable=False),
Column('t_type', String(30), nullable=False, default='ci_responsiblepartyinfo'),
        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,)
 
 











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,)
 
 











md_identifier_table = Table('md_identifier', metadata,
        Column('md_identifier_id', Integer, Sequence('md_identifier_id_seq'), primary_key=True),
        Column('md_aggregateinformation_aggregateDataSetIdentifier', Integer, ForeignKey('md_aggregateinformation.md_aggregateinformation_id')),
        Column('mo_observationcollection_identifier', Integer, ForeignKey('mo_observationcollection.mo_observationcollection_id')),
        Column('dq_element_measureIdentification', Integer, ForeignKey('dq_element.dq_element_id')),
        Column('ex_geographicdescription_geographicIdentifier', Integer, ForeignKey('ex_geographicdescription.ex_geographicdescription_id')),
        Column('ci_citation_identifier', Integer, ForeignKey('ci_citation.ci_citation_id', use_alter=True, name='fk_ci_citation')),
        Column('mo_platform_identifier', Integer, ForeignKey('mo_platform.mo_platform_id')),
        Column('mo_organization_identifier', Integer, ForeignKey('mo_organization.mo_organization_id')),
        Column('mo_processing_identifier', Integer, ForeignKey('mo_processing.mo_processing_id')),
        Column('mo_instrument_identifier', Integer, ForeignKey('mo_instrument.mo_instrument_id')),
        Column('le_source_processedLevel', Integer, ForeignKey('le_source.le_source_id')),
        Column('mo_project_identifier', Integer, ForeignKey('mo_project.mo_project_id')),
        Column('mo_observation_identifier', Integer, ForeignKey('mo_observation.mo_observation_id')),
        Column('mo_compositeprocess_identifier', Integer, ForeignKey('mo_compositeprocess.mo_compositeprocess_id')),
        Column('mo_acquisition_identifier', Integer, ForeignKey('mo_acquisition.mo_acquisition_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,)
 
 











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,)
 
 











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('initiativeType', DS_InitiativeTypeCode.db_type() , nullable=True),
        Column('associationType', DS_AssociationTypeCode.db_type() , nullable=False),
Column('t_type', String(30), nullable=False, default='md_aggregateinformation'),
        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_instrument_review', Integer, ForeignKey('ceda_instrument.ceda_instrument_id')),
        Column('ceda_project_review', Integer, ForeignKey('ceda_project.ceda_project_id')),
        Column('ceda_compositeprocess_review', Integer, ForeignKey('ceda_compositeprocess.ceda_compositeprocess_id')),
        Column('ceda_operation_review', Integer, ForeignKey('ceda_operation.ceda_operation_id')),
        Column('ceda_platform_review', Integer, ForeignKey('ceda_platform.ceda_platform_id')),
        Column('ceda_observationcollection_review', Integer, ForeignKey('ceda_observationcollection.ceda_observationcollection_id')),
        Column('ceda_acquisition_review', Integer, ForeignKey('ceda_acquisition.ceda_acquisition_id')),
        Column('ceda_processing_review', Integer, ForeignKey('ceda_processing.ceda_processing_id')),
        Column('ceda_observation_internalReview', Integer, ForeignKey('ceda_observation.ceda_observation_id')),
        Column('reviewStatus', CEDA_ReviewStatusValue.db_type() , nullable=False),
        Column('reviewFrequency', CEDA_ReviewFrequencyValue.db_type() , nullable=False),
Column('t_type', String(30), nullable=False, default='ceda_review'),
        extend_existing=False,)
 
 











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











ci_responsibility_table = Table('ci_responsibility', metadata,
        Column('ci_responsibility_id', Integer, Sequence('ci_responsibility_id_seq'), primary_key=True),
                                Column('ci_responsiblepartyinfo_id', Integer, ForeignKey('ci_responsiblepartyinfo.ci_responsiblepartyinfo_id')),Column('t_type', String(30), nullable=False, default='ci_responsibility'),
        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,)
 
 











mo_organization_table = Table('mo_organization', metadata,
        Column('mo_organization_id', Integer, Sequence('mo_organization_id_seq'), primary_key=True),
                                Column('ci_organisation_id', Integer, ForeignKey('ci_organisation.ci_organisation_id')),        Column('description', TEXT() , nullable=True),
Column('t_type', String(30), nullable=False, default='mo_organization'),
        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('description', TEXT() , nullable=True),
        Column('status', MD_ProgressCode.db_type() , nullable=True),
Column('t_type', String(30), nullable=False, default='mo_operation'),
        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_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,)
 
 











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,)
 
 











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('description', TEXT() , nullable=True),
        Column('publicationState', MO_PublicationStateValue.db_type() , nullable=True),
Column('t_type', String(30), nullable=False, default='mo_observationcollection'),
        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,)
 
 











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,)
 
 











ex_extent_table = Table('ex_extent', metadata,
        Column('ex_extent_id', Integer, Sequence('ex_extent_id_seq'), primary_key=True),
        Column('rs_referencesystem_domainOfValidity', Integer, ForeignKey('rs_referencesystem.rs_referencesystem_id')),
        Column('ci_responsiblepartyinfo_extent', Integer, ForeignKey('ci_responsiblepartyinfo.ci_responsiblepartyinfo_id')),
        Column('dq_scope_extent', Integer, ForeignKey('dq_scope.dq_scope_id')),
        Column('li_source_sourceExtent', Integer, ForeignKey('li_source.li_source_id')),
        Column('description', TEXT() , nullable=True),
Column('t_type', String(30), nullable=False, default='ex_extent'),
        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,)
 
 











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('credit', ARRAY(TEXT) , nullable=True),
        Column('purpose', TEXT() , nullable=True),
        Column('abstract', TEXT() , nullable=False),
        Column('status', MD_ProgressCode.db_type() , nullable=True),
Column('t_type', String(30), nullable=False, default='md_identification'),
        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,)
 
 











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,)
 
 











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,)
 
 











md_keywords_table = Table('md_keywords', metadata,
        Column('md_keywords_id', Integer, Sequence('md_keywords_id_seq'), primary_key=True),
        Column('mo_project_keywords', Integer, ForeignKey('mo_project.mo_project_id')),
        Column('md_identification_descriptiveKeywords', Integer, ForeignKey('md_identification.md_identification_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,)
 
 











md_metadata_table = Table('md_metadata', metadata,
        Column('md_metadata_id', Integer, Sequence('md_metadata_id_seq'), primary_key=True),
        Column('mo_observationcollection_isoMetadata', Integer, ForeignKey('mo_observationcollection.mo_observationcollection_id')),
        Column('om_observation_metadata', Integer, ForeignKey('om_observation.om_observation_id')),
        Column('characterSet', MD_CharacterSetCode.db_type() , nullable=True),
        Column('metadataStandardName', TEXT() , nullable=True),
        Column('dataSet', TEXT() , nullable=True),
        Column('fileIdentifier', TEXT() , nullable=True),
        Column('hierarchyLevel', MD_ScopeCode.db_type() , nullable=True),
        Column('language', TEXT() , nullable=True),
        Column('metadataStandardVersion', TEXT() , nullable=True),
        Column('parentIdentifier', TEXT() , nullable=True),
        Column('hierarchyLevelName', ARRAY(TEXT) , nullable=True),
Column('t_type', String(30), nullable=False, default='md_metadata'),
        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_acquisition_platform', Integer, ForeignKey('mo_acquisition.mo_acquisition_id')),
        Column('mo_operation_platform', Integer, ForeignKey('mo_operation.mo_operation_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,)
 
 











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,)
 
 











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,)
 
 











le_source_table = Table('le_source', metadata,
        Column('le_source_id', Integer, Sequence('le_source_id_seq'), primary_key=True),
                                Column('li_source_id', Integer, ForeignKey('li_source.li_source_id')),  Column('mo_inputoutput_description', Integer, ForeignKey('mo_inputoutput.mo_inputoutput_id')),
Column('t_type', String(30), nullable=False, default='le_source'),
        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,)
 
 











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,)
 
 











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,)
 
 











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_compositeprocess_table = Table('ceda_compositeprocess', metadata,
        Column('ceda_compositeprocess_id', Integer, Sequence('ceda_compositeprocess_id_seq'), primary_key=True),
                                Column('ceda_process_id', Integer, ForeignKey('ceda_process.ceda_process_id')),                 Column('mo_compositeprocess_id', Integer, ForeignKey('mo_compositeprocess.mo_compositeprocess_id')),Column('t_type', String(30), nullable=False, default='ceda_compositeprocess'),
        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('ex_extent_verticalElement', Integer, ForeignKey('ex_extent.ex_extent_id')),
        Column('mo_observation_verticalExtent', Integer, ForeignKey('mo_observation.mo_observation_id')),
        Column('minimumValue', NUMERIC() , nullable=False),
        Column('maximumValue', NUMERIC() , nullable=False),
Column('t_type', String(30), nullable=False, default='ex_verticalextent'),
        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,)
 
 











ceda_acquisition_table = Table('ceda_acquisition', metadata,
        Column('ceda_acquisition_id', Integer, Sequence('ceda_acquisition_id_seq'), primary_key=True),
                                Column('ceda_process_id', Integer, ForeignKey('ceda_process.ceda_process_id')),                 Column('mo_acquisition_id', Integer, ForeignKey('mo_acquisition.mo_acquisition_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,)
 
 











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











sc_crs_table = Table('sc_crs', metadata,
        Column('sc_crs_id', Integer, Sequence('sc_crs_id_seq'), primary_key=True),
                                Column('rs_referencesystem_id', Integer, ForeignKey('rs_referencesystem.rs_referencesystem_id')),                       Column('io_identifiedobjectbase_id', Integer, ForeignKey('io_identifiedobjectbase.io_identifiedobjectbase_id')),        Column('ex_verticalextent_verticalCRS', Integer, ForeignKey('ex_verticalextent.ex_verticalextent_id')),
        Column('scope', ARRAY(TEXT) , nullable=False),
Column('t_type', String(30), nullable=False, default='sc_crs'),
        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('description', TEXT() , nullable=True),
        Column('abstract', TEXT() , nullable=True),
        Column('publicationState', MO_PublicationStateValue.db_type() , nullable=True),
        Column('status', MD_ProgressCode.db_type() , nullable=True),
Column('t_type', String(30), nullable=False, default='mo_project'),
        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('description', TEXT() , nullable=True),
        Column('resultAccumulation', MD_MaintenanceFrequencyCode.db_type() , nullable=True),
        Column('resolution', TEXT() , nullable=True),
        Column('status', MD_ProgressCode.db_type() , nullable=True),
        Column('publicationState', MO_PublicationStateValue.db_type() , nullable=True),
Column('t_type', String(30), nullable=False, default='mo_observation'),
        extend_existing=False,)
 
 
mo_platform_mo_platform_table = Table('mo_platform_mo_platform', metadata,
        Column('left_node_id', Integer, ForeignKey(mo_platform_table.c.mo_platform_id)),
        Column('right_node_id', Integer, ForeignKey(mo_platform_table.c.mo_platform_id))
)
mo_result_mo_result_table = Table('mo_result_mo_result', metadata,
        Column('left_node_id', Integer, ForeignKey(mo_result_table.c.mo_result_id)),
        Column('right_node_id', Integer, ForeignKey(mo_result_table.c.mo_result_id))
)
mo_observationcollection_mo_observationcollection_table = Table('mo_observationcollection_mo_observationcollection', metadata,
        Column('left_node_id', Integer, ForeignKey(mo_observationcollection_table.c.mo_observationcollection_id)),
        Column('right_node_id', Integer, ForeignKey(mo_observationcollection_table.c.mo_observationcollection_id))
)
mo_operation_mo_operation_table = Table('mo_operation_mo_operation', metadata,
        Column('left_node_id', Integer, ForeignKey(mo_operation_table.c.mo_operation_id)),
        Column('right_node_id', Integer, ForeignKey(mo_operation_table.c.mo_operation_id))
)
mo_project_mo_project_table = Table('mo_project_mo_project', metadata,
        Column('left_node_id', Integer, ForeignKey(mo_project_table.c.mo_project_id)),
        Column('right_node_id', Integer, ForeignKey(mo_project_table.c.mo_project_id))
)
mo_instrument_mo_instrument_table = Table('mo_instrument_mo_instrument', metadata,
        Column('left_node_id', Integer, ForeignKey(mo_instrument_table.c.mo_instrument_id)),
        Column('right_node_id', Integer, ForeignKey(mo_instrument_table.c.mo_instrument_id))
)
om_observation_om_observation_table = Table('om_observation_om_observation', metadata,
        Column('left_node_id', Integer, ForeignKey(om_observation_table.c.om_observation_id)),
        Column('right_node_id', Integer, ForeignKey(om_observation_table.c.om_observation_id))
)







mapper(MD_BrowseGraphic, md_browsegraphic_table )








mapper(EX_GeographicExtent, ex_geographicextent_table   )








mapper(GenericName, genericname_table   )








mapper(TM_Object, tm_object_table       )








mapper(OM_Process, om_process_table     )








mapper(MD_Format, md_format_table       )








mapper(DQ_Result, dq_result_table       )








mapper(ClockTime, clocktime_table       )








mapper(UnitOfMeasure, unitofmeasure_table       )








mapper(MD_SpatialRepresentation, md_spatialrepresentation_table )








mapper(CI_Series, ci_series_table       )








mapper(CEDA_Citation, ceda_citation_table       )








mapper(MD_Constraints, md_constraints_table     )








mapper(MD_ContentInformation, md_contentinformation_table       )








mapper(Measure, measure_table   )








mapper(GM_Object, gm_object_table       )








mapper(TM_TemporalPosition, tm_temporalposition_table   )








mapper(Any, any_table   )








mapper(MD_Medium, md_medium_table       )








mapper(CI_Telephone, ci_telephone_table )








mapper(TM_Duration, tm_duration_table   )








mapper(CI_Address, ci_address_table     )








mapper(MD_ScopeDescription, md_scopedescription_table   )








mapper(DatePrecision, dateprecision_table       )








mapper(URL, url_table   )








mapper(GF_Constraint, gf_constraint_table       )








mapper(ScopedName, scopedname_table     )








mapper(TM_PeriodDuration, tm_periodduration_table       )








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(UomScale, uomscale_table )








mapper(MO_Process, mo_process_table     )








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(CEDA_Process, ceda_process_table )








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








mapper(LocalName, localname_table       )








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








mapper(TM_Primitive, tm_primitive_table )








mapper(UomLength, uomlength_table       )








mapper(Time, time_table )








mapper(CI_Contact, ci_contact_table     , properties  = {       'onlineResource': relationship(CI_OnlineResource, uselist=False, primaryjoin=ci_onlineresource_table.c.ci_contact_onlineResource==ci_contact_table.c.ci_contact_id
),      '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
)}
        )








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(Scale, scale_table       , properties  = {       'uom': relationship(UomScale, uselist=False, primaryjoin=uomscale_table.c.scale_uom==scale_table.c.scale_id
),      'targetUnits': relationship(UomLength, uselist=False, primaryjoin=uomlength_table.c.scale_targetUnits==scale_table.c.scale_id
),      'sourceUnits': relationship(UomLength, uselist=False, primaryjoin=uomlength_table.c.scale_sourceUnits==scale_table.c.scale_id
)}
        )








mapper(MO_OnlineResource, mo_onlineresource_table       )








mapper(TM_GeometricPrimitive, tm_geometricprimitive_table       )








mapper(MD_DigitalTransferOptions, md_digitaltransferoptions_table       , properties  = {       'offLine': relationship(MD_Medium, uselist=False, primaryjoin=md_medium_table.c.md_digitaltransferoptions_offLine==md_digitaltransferoptions_table.c.md_digitaltransferoptions_id
),      'onLine': relationship(CI_OnlineResource
, primaryjoin=ci_onlineresource_table.c.md_digitaltransferoptions_onLine==md_digitaltransferoptions_table.c.md_digitaltransferoptions_id
)}
        )








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








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(TM_Period, tm_period_table       )








mapper(DateTime, datetime_table )








mapper(Length, length_table     , properties  = {       'uom': relationship(UomLength, uselist=False, primaryjoin=uomlength_table.c.length_uom==length_table.c.length_id
)}
        )








mapper(Distance, distance_table )








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
),      'date8601': relationship(Date, uselist=False, primaryjoin=date_table.c.tm_position_date8601==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
)}
        )








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(CI_Party, ci_party_table , properties  = {       'contactInfo': relationship(CI_Contact
, primaryjoin=ci_contact_table.c.ci_party_contactInfo==ci_party_table.c.ci_party_id
)}
        )








mapper(CI_Individual, ci_individual_table       )








mapper(MO_Computation, mo_computation_table     )








mapper(LE_NominalResolution, le_nominalresolution_table , properties  = {       'groundResolution': relationship(Distance, uselist=False, primaryjoin=distance_table.c.le_nominalresolution_groundResolution==le_nominalresolution_table.c.le_nominalresolution_id
),      'scanningResolution': relationship(Distance, uselist=False, primaryjoin=distance_table.c.le_nominalresolution_scanningResolution==le_nominalresolution_table.c.le_nominalresolution_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
)}
        )








mapper(MD_Usage, md_usage_table , properties  = {       'usageDateTime': relationship(DateTime, uselist=False, primaryjoin=datetime_table.c.md_usage_usageDateTime==md_usage_table.c.md_usage_id
),      'userContactInfo': relationship(CI_ResponsibleParty
, primaryjoin=ci_responsibleparty_table.c.md_usage_userContactInfo==md_usage_table.c.md_usage_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(CI_Organisation, ci_organisation_table   , properties  = {       'individual': relationship(CI_Individual
, primaryjoin=ci_individual_table.c.ci_organisation_individual==ci_organisation_table.c.ci_organisation_id
)}
        )








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(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_MaintenanceInformation, md_maintenanceinformation_table       , properties  = {       'userDefinedMaintenanceFrequency': relationship(TM_PeriodDuration, uselist=False, primaryjoin=tm_periodduration_table.c.md_maintenanceinformation_userDefinedMaintenanceFrequency==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
),      'contact': relationship(CI_ResponsibleParty
, primaryjoin=ci_responsibleparty_table.c.md_maintenanceinformation_contact==md_maintenanceinformation_table.c.md_maintenanceinformation_id
)}
        )








mapper(MD_StandardOrderProcess, md_standardorderprocess_table   , properties  = {       'plannedAvailableDateTime': relationship(DateTime, uselist=False, primaryjoin=datetime_table.c.md_standardorderprocess_plannedAvailableDateTime==md_standardorderprocess_table.c.md_standardorderprocess_id
)}
        )








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








mapper(MD_Distributor, md_distributor_table     , properties  = {       'distributorTransferOptions': relationship(MD_DigitalTransferOptions
, primaryjoin=md_digitaltransferoptions_table.c.md_distributor_distributorTransferOptions==md_distributor_table.c.md_distributor_id
),      'distributorContact': relationship(CI_ResponsibleParty, uselist=False, primaryjoin=ci_responsibleparty_table.c.md_distributor_distributorContact==md_distributor_table.c.md_distributor_id
),      'distributionOrderProcess': relationship(MD_StandardOrderProcess
, primaryjoin=md_standardorderprocess_table.c.md_distributor_distributionOrderProcess==md_distributor_table.c.md_distributor_id
)}
        )








mapper(MD_Distribution, md_distribution_table   , properties  = {       'transferOptions': relationship(MD_DigitalTransferOptions
, primaryjoin=md_digitaltransferoptions_table.c.md_distribution_transferOptions==md_distribution_table.c.md_distribution_id
),      'distributor': relationship(MD_Distributor
, primaryjoin=md_distributor_table.c.md_distribution_distributor==md_distribution_table.c.md_distribution_id
),      'distributionFormat': relationship(MD_Format
, primaryjoin=md_format_table.c.md_distribution_distributionFormat==md_distribution_table.c.md_distribution_id
)}
        )








mapper(CEDA_Result, ceda_result_table   )


mapper(IO_IdentifiedObjectBase, io_identifiedobjectbase_table)


mapper(CEDA_Project, ceda_project_table)


mapper(LE_Algorithm, le_algorithm_table)


mapper(MO_InstrumentPlatformPair, mo_instrumentplatformpair_table)


mapper(MD_ApplicationSchemaInformation, md_applicationschemainformation_table)


mapper(OM_Observation, om_observation_table)


mapper(LI_Lineage, li_lineage_table)


mapper(RS_Identifier, rs_identifier_table)


mapper(MO_ResponsiblePartyInfo, mo_responsiblepartyinfo_table)


mapper(CI_ResponsiblePartyInfo, ci_responsiblepartyinfo_table)


mapper(MO_Instrument, mo_instrument_table)


mapper(MO_Processing, mo_processing_table)


mapper(MD_Identifier, md_identifier_table)


mapper(CEDA_Observation, ceda_observation_table)


mapper(MD_AggregateInformation, md_aggregateinformation_table)


mapper(CEDA_Review, ceda_review_table)


mapper(DQ_Element, dq_element_table)


mapper(CI_Responsibility, ci_responsibility_table)


mapper(CEDA_Processing, ceda_processing_table)


mapper(MO_Organization, mo_organization_table)


mapper(MO_Operation, mo_operation_table)


mapper(MO_Acquisition, mo_acquisition_table)


mapper(MO_CompositeProcess, mo_compositeprocess_table)


mapper(EX_GeographicDescription, ex_geographicdescription_table)


mapper(MO_ObservationCollection, mo_observationcollection_table)


mapper(DQ_Scope, dq_scope_table)


mapper(MO_Location, mo_location_table)


mapper(EX_Extent, ex_extent_table)


mapper(CEDA_Instrument, ceda_instrument_table)


mapper(MD_Identification, md_identification_table)


mapper(CEDA_Notes, ceda_notes_table)


mapper(MD_PortrayalCatalogueReference, md_portrayalcataloguereference_table)


mapper(DQ_DataQuality, dq_dataquality_table)


mapper(MD_Keywords, md_keywords_table)


mapper(MD_Metadata, md_metadata_table)


mapper(MO_Platform, mo_platform_table)


mapper(RS_ReferenceSystem, rs_referencesystem_table)


mapper(LI_Source, li_source_table)


mapper(LE_Source, le_source_table)


mapper(CEDA_Platform, ceda_platform_table)


mapper(CEDA_ObservationCollection, ceda_observationcollection_table)


mapper(MO_InputOutput, mo_inputoutput_table)


mapper(CEDA_Operation, ceda_operation_table)


mapper(CEDA_CompositeProcess, ceda_compositeprocess_table)


mapper(EX_VerticalExtent, ex_verticalextent_table)


mapper(MD_ReferenceSystem, md_referencesystem_table)


mapper(CEDA_Acquisition, ceda_acquisition_table)


mapper(CI_Citation, ci_citation_table)


mapper(SC_CRS, sc_crs_table)


mapper(MO_Project, mo_project_table)


mapper(MO_Observation, mo_observation_table)


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


class_mapper(CEDA_Project).add_properties({     'projectResource': relationship(MO_OnlineResource
, primaryjoin=mo_onlineresource_table.c.ceda_project_projectResource==ceda_project_table.c.ceda_project_id
),      'observationCollection': relationship(CEDA_ObservationCollection
, primaryjoin=ceda_observationcollection_table.c.ceda_project_observationCollection==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
)})


class_mapper(LE_Algorithm).add_properties({     'citation': relationship(CI_Citation, uselist=False, primaryjoin=ci_citation_table.c.le_algorithm_citation==le_algorithm_table.c.le_algorithm_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(OM_Observation).add_properties({   'resultQuality': relationship(DQ_Element
, primaryjoin=dq_element_table.c.om_observation_resultQuality==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
),      'metadata': relationship(MD_Metadata, uselist=False, primaryjoin=md_metadata_table.c.om_observation_metadata==om_observation_table.c.om_observation_id
),      'validTime': relationship(TM_Period, uselist=False, primaryjoin=tm_period_table.c.om_observation_validTime==om_observation_table.c.om_observation_id
),      'parameter': relationship(NamedValue
, primaryjoin=namedvalue_table.c.om_observation_parameter==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
),      'result': relationship(Any, uselist=False, primaryjoin=any_table.c.om_observation_result==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
)})


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






class_mapper(CI_ResponsiblePartyInfo).add_properties({  'extent': relationship(EX_Extent
, primaryjoin=ex_extent_table.c.ci_responsiblepartyinfo_extent==ci_responsiblepartyinfo_table.c.ci_responsiblepartyinfo_id
)})


class_mapper(MO_Instrument).add_properties({    'identifier': relationship(MD_Identifier
, primaryjoin=md_identifier_table.c.mo_instrument_identifier==mo_instrument_table.c.mo_instrument_id
),      '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
),      'type': relationship(ScopedName, uselist=False, primaryjoin=scopedname_table.c.mo_instrument_type==mo_instrument_table.c.mo_instrument_id
)})


class_mapper(MO_Processing).add_properties({    'documentation': relationship(CI_Citation
, primaryjoin=ci_citation_table.c.mo_processing_documentation==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
),      'processingOutput': relationship(MO_InputOutput, uselist=False, primaryjoin=mo_inputoutput_table.c.mo_processing_processingOutput==mo_processing_table.c.mo_processing_id
),      'identifier': relationship(MD_Identifier
, primaryjoin=md_identifier_table.c.mo_processing_identifier==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
),      'softwareReference': relationship(CI_Citation, uselist=False, primaryjoin=ci_citation_table.c.mo_processing_softwareReference==mo_processing_table.c.mo_processing_id
),      'algorithm': relationship(LE_Algorithm
, primaryjoin=le_algorithm_table.c.mo_processing_algorithm==mo_processing_table.c.mo_processing_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(CEDA_Observation).add_properties({ 'citation': relationship(CEDA_Citation
, primaryjoin=ceda_citation_table.c.ceda_observation_citation==ceda_observation_table.c.ceda_observation_id
),      'inSupportOf': relationship(CEDA_Project, uselist=False, primaryjoin=ceda_project_table.c.ceda_observation_inSupportOf==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
),      'result': relationship(CEDA_Result, uselist=False, primaryjoin=ceda_result_table.c.ceda_observation_result==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
),      'procedure': relationship(CEDA_Process, uselist=False, primaryjoin=ceda_process_table.c.ceda_observation_procedure==ceda_observation_table.c.ceda_observation_id
)})


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(CEDA_Review).add_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
)})


class_mapper(DQ_Element).add_properties({       'result': relationship(DQ_Result
, primaryjoin=dq_result_table.c.dq_element_result==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
),      'evaluationProcedure': relationship(CI_Citation, uselist=False, primaryjoin=ci_citation_table.c.dq_element_evaluationProcedure==dq_element_table.c.dq_element_id
),      'dateTime': relationship(DateTime
, primaryjoin=datetime_table.c.dq_element_dateTime==dq_element_table.c.dq_element_id
)})


class_mapper(CI_Responsibility).add_properties({        'party': relationship(CI_Party
, primaryjoin=ci_party_table.c.ci_responsibility_party==ci_responsibility_table.c.ci_responsibility_id
)})


class_mapper(CEDA_Processing).add_properties({  'review': relationship(CEDA_Review
, primaryjoin=ceda_review_table.c.ceda_processing_review==ceda_processing_table.c.ceda_processing_id
)})


class_mapper(MO_Organization).add_properties({  'relatedParty': relationship(MO_ResponsiblePartyInfo
, primaryjoin=mo_responsiblepartyinfo_table.c.mo_organization_relatedParty==mo_organization_table.c.mo_organization_id
),      'identifier': relationship(MD_Identifier
, primaryjoin=md_identifier_table.c.mo_organization_identifier==mo_organization_table.c.mo_organization_id
)})


class_mapper(MO_Operation).add_properties({     'operationTime': relationship(TM_Object, uselist=False, primaryjoin=tm_object_table.c.mo_operation_operationTime==mo_operation_table.c.mo_operation_id
),      'relatedPartyInfo': relationship(MO_ResponsiblePartyInfo
, primaryjoin=mo_responsiblepartyinfo_table.c.mo_operation_relatedPartyInfo==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
, primaryjoin=mo_platform_table.c.mo_operation_platform==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
)})


class_mapper(MO_Acquisition).add_properties({   'operation': relationship(MO_Operation
, primaryjoin=mo_operation_table.c.mo_acquisition_operation==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
),      'outputDescription': relationship(MO_InputOutput, uselist=False, primaryjoin=mo_inputoutput_table.c.mo_acquisition_outputDescription==mo_acquisition_table.c.mo_acquisition_id
),      'instrument': relationship(MO_Instrument
, primaryjoin=mo_instrument_table.c.mo_acquisition_instrument==mo_acquisition_table.c.mo_acquisition_id
),      'documentation': relationship(CI_Citation
, primaryjoin=ci_citation_table.c.mo_acquisition_documentation==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
),      'platform': relationship(MO_Platform
, primaryjoin=mo_platform_table.c.mo_acquisition_platform==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(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
, primaryjoin=mo_acquisition_table.c.mo_compositeprocess_acquisitionComponent==mo_compositeprocess_table.c.mo_compositeprocess_id
),      'documentation': relationship(CI_Citation
, primaryjoin=ci_citation_table.c.mo_compositeprocess_documentation==mo_compositeprocess_table.c.mo_compositeprocess_id
),      'computationComponent': relationship(MO_Computation
, primaryjoin=mo_computation_table.c.mo_compositeprocess_computationComponent==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
)})


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
)})


class_mapper(MO_ObservationCollection).add_properties({ 'isoMetadata': relationship(MD_Metadata
, primaryjoin=md_metadata_table.c.mo_observationcollection_isoMetadata==mo_observationcollection_table.c.mo_observationcollection_id
),      'geographicExtent': relationship(EX_GeographicExtent
, primaryjoin=ex_geographicextent_table.c.mo_observationcollection_geographicExtent==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
),      'identifier': relationship(MD_Identifier
, primaryjoin=md_identifier_table.c.mo_observationcollection_identifier==mo_observationcollection_table.c.mo_observationcollection_id
),      'member': relationship(MO_Observation
, primaryjoin=mo_observation_table.c.mo_observationcollection_member==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
),      'additionalMetadata': relationship(CI_OnlineResource
, primaryjoin=ci_onlineresource_table.c.mo_observationcollection_additionalMetadata==mo_observationcollection_table.c.mo_observationcollection_id
)})


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


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


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


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
)})


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


class_mapper(CEDA_Notes).add_properties({       'commentator': relationship(MO_ResponsiblePartyInfo, uselist=False, primaryjoin=mo_responsiblepartyinfo_table.c.ceda_notes_commentator==ceda_notes_table.c.ceda_notes_id
),      'date': relationship(DateTime, uselist=False, primaryjoin=datetime_table.c.ceda_notes_date==ceda_notes_table.c.ceda_notes_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(DQ_DataQuality).add_properties({   'lineage': relationship(LI_Lineage, uselist=False, primaryjoin=li_lineage_table.c.dq_dataquality_lineage==dq_dataquality_table.c.dq_dataquality_id
),      'report': relationship(DQ_Element
, primaryjoin=dq_element_table.c.dq_dataquality_report==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(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(MD_Metadata).add_properties({      'spatialRepresentationInfo': relationship(MD_SpatialRepresentation
, primaryjoin=md_spatialrepresentation_table.c.md_metadata_spatialRepresentationInfo==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
),      'portrayalCatalogueInfo': relationship(MD_PortrayalCatalogueReference
, primaryjoin=md_portrayalcataloguereference_table.c.md_metadata_portrayalCatalogueInfo==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
),      'metadataConstraints': relationship(MD_Constraints
, primaryjoin=md_constraints_table.c.md_metadata_metadataConstraints==md_metadata_table.c.md_metadata_id
),      'metadataExtensionInfo': relationship(MD_MetadataExtensionInformation
, primaryjoin=md_metadataextensioninformation_table.c.md_metadata_metadataExtensionInfo==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
),      'dataQualityInfo': relationship(DQ_DataQuality
, primaryjoin=dq_dataquality_table.c.md_metadata_dataQualityInfo==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
),      'identificationInfo': relationship(MD_Identification
, primaryjoin=md_identification_table.c.md_metadata_identificationInfo==md_metadata_table.c.md_metadata_id
),      'referenceSystemInfo': relationship(MD_ReferenceSystem
, primaryjoin=md_referencesystem_table.c.md_metadata_referenceSystemInfo==md_metadata_table.c.md_metadata_id
),      'contentInfo': relationship(MD_ContentInformation
, primaryjoin=md_contentinformation_table.c.md_metadata_contentInfo==md_metadata_table.c.md_metadata_id
),      'applicationSchemaInfo': relationship(MD_ApplicationSchemaInformation
, primaryjoin=md_applicationschemainformation_table.c.md_metadata_applicationSchemaInfo==md_metadata_table.c.md_metadata_id
)})


class_mapper(MO_Platform).add_properties({      'location': relationship(MO_Location, uselist=False, primaryjoin=mo_location_table.c.mo_platform_location==mo_platform_table.c.mo_platform_id
),      'identifier': relationship(MD_Identifier
, primaryjoin=md_identifier_table.c.mo_platform_identifier==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
),      'documentation': relationship(CI_Citation
, primaryjoin=ci_citation_table.c.mo_platform_documentation==mo_platform_table.c.mo_platform_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(LI_Source).add_properties({        'scaleDenominator': relationship(MD_RepresentativeFraction, uselist=False, primaryjoin=md_representativefraction_table.c.li_source_scaleDenominator==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
),      'sourceCitation': relationship(CI_Citation, uselist=False, primaryjoin=ci_citation_table.c.li_source_sourceCitation==li_source_table.c.li_source_id
),      'sourceExtent': relationship(EX_Extent
, primaryjoin=ex_extent_table.c.li_source_sourceExtent==li_source_table.c.li_source_id
)})


class_mapper(LE_Source).add_properties({        'resolution': relationship(LE_NominalResolution, uselist=False, primaryjoin=le_nominalresolution_table.c.le_source_resolution==le_source_table.c.le_source_id
),      'processedLevel': relationship(MD_Identifier, uselist=False, primaryjoin=md_identifier_table.c.le_source_processedLevel==le_source_table.c.le_source_id
)})


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
)})


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
),      'member': relationship(CEDA_Observation
, primaryjoin=ceda_observation_table.c.ceda_observationcollection_member==ceda_observationcollection_table.c.ceda_observationcollection_id
)})


class_mapper(MO_InputOutput).add_properties({   'name': relationship(GenericName, uselist=False, primaryjoin=genericname_table.c.mo_inputoutput_name==mo_inputoutput_table.c.mo_inputoutput_id
),      'description': relationship(LE_Source, uselist=False, primaryjoin=le_source_table.c.mo_inputoutput_description==mo_inputoutput_table.c.mo_inputoutput_id
)})


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
)})


class_mapper(CEDA_CompositeProcess).add_properties({    'aquisitionComponent': relationship(CEDA_Acquisition
, 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
),      'computationComponent': relationship(CEDA_Processing
, primaryjoin=ceda_processing_table.c.ceda_compositeprocess_computationComponent==ceda_compositeprocess_table.c.ceda_compositeprocess_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(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(CEDA_Acquisition).add_properties({ 'review': relationship(CEDA_Review
, primaryjoin=ceda_review_table.c.ceda_acquisition_review==ceda_acquisition_table.c.ceda_acquisition_id
),      'instrument': relationship(CEDA_Instrument
, primaryjoin=ceda_instrument_table.c.ceda_acquisition_instrument==ceda_acquisition_table.c.ceda_acquisition_id
),      'platform': relationship(CEDA_Platform
, primaryjoin=ceda_platform_table.c.ceda_acquisition_platform==ceda_acquisition_table.c.ceda_acquisition_id
),      'operation': relationship(CEDA_Operation
, primaryjoin=ceda_operation_table.c.ceda_acquisition_operation==ceda_acquisition_table.c.ceda_acquisition_id
)})


class_mapper(CI_Citation).add_properties({      'series': relationship(CI_Series, uselist=False, primaryjoin=ci_series_table.c.ci_citation_series==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
),      'editionDate': relationship(Date, uselist=False, primaryjoin=date_table.c.ci_citation_editionDate==ci_citation_table.c.ci_citation_id
)})




class_mapper(MO_Project).add_properties({       'keywords': relationship(MD_Keywords
, primaryjoin=md_keywords_table.c.mo_project_keywords==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
),      'dmp': relationship(CI_Citation, uselist=False, primaryjoin=ci_citation_table.c.mo_project_dmp==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
),      'observationCollection': relationship(MO_ObservationCollection
, primaryjoin=mo_observationcollection_table.c.mo_project_observationCollection==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
)})


class_mapper(MO_Observation).add_properties({   '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
),      'documentation': relationship(CI_Citation
, primaryjoin=ci_citation_table.c.mo_observation_documentation==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
),      '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
),      'permission': relationship(MD_Constraints, uselist=False, primaryjoin=md_constraints_table.c.mo_observation_permission==mo_observation_table.c.mo_observation_id
),      'verticalExtent': relationship(EX_VerticalExtent
, primaryjoin=ex_verticalextent_table.c.mo_observation_verticalExtent==mo_observation_table.c.mo_observation_id
)})

metadata.create_all(engine)