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

Subversion URL: http://proj.badc.rl.ac.uk/svn/ndg/mauRepo/MolesManager/trunk/src/sqlTables.py@8014
Revision 8014, 127.0 KB checked in by mnagni, 8 years ago (diff)

The tables are correctly generated and the migration does not show major problem. Good!

Line 
1from sqlalchemy import Table, Column, Integer, String, ForeignKey, Sequence, event, MetaData
2from sqlalchemy.orm import relationship, backref, mapper, clear_mappers
3from sqlalchemy.ext.declarative import declarative_base
4from sqlalchemy.dialects.postgresql import ARRAY, TEXT, NUMERIC, BOOLEAN, DATE
5from sqlalchemy.types import DateTime
6from sqlalchemy.orm.util import class_mapper
7from sqlalchemy.schema import ForeignKeyConstraint
8
9from ascore.astext import ASText
10
11
12       
13from ea_model.iso_19111_referencing_by_coordinates.coordinate_reference_systems.sc_crs import  SC_CRS   
14from ea_model.moles3_4.acquisition.mo_acquisition import  MO_Acquisition       
15from ea_model.iso_19115_2006_metadata_corrigendum.metadata_entity_set_information.md_metadata import  MD_Metadata       
16from ea_model.iso_19115_2006_metadata_corrigendum.metadata_extension_information.md_obligationcode import  MD_ObligationCode   
17from ea_model.iso_19115_2006_metadata_corrigendum.identification_information.md_charactersetcode import  MD_CharacterSetCode   
18from ea_model.iso_19115_2006_metadata_corrigendum.identification_information.ds_initiativetypecode import  DS_InitiativeTypeCode       
19from ea_model.moles3_4.computation.mo_processing import  MO_Processing 
20from ea_model.iso_19115_2006_metadata_corrigendum.citation_and_responsible_party_information.ci_date import  CI_Date   
21from ea_model.moles3_4.acquisition.mo_operation import  MO_Operation   
22from ea_model.iso_19108_2006_temporal_schema.temporal_reference_system.tm_position import  TM_Position 
23from ea_model.iso_19115_2006_metadata_corrigendum.identification_information.md_progresscode import  MD_ProgressCode   
24from ea_model.iso_19103_2005_schema_language.basic_types.derived.units_of_measure.scale import  Scale   
25from ea_model.iso_19115_2006_metadata_corrigendum.distribution_information.md_distribution import  MD_Distribution     
26from ea_model.iso_19111_referencing_by_coordinates.reference_systems.rs_referencesystem import  RS_ReferenceSystem     
27from ea_model.iso_19115_2006_metadata_corrigendum.content_information.md_contentinformation import  MD_ContentInformation       
28from ea_model.iso_19115_2006_metadata_corrigendum.reference_system_information.md_referencesystem import  MD_ReferenceSystem   
29from ea_model.ceda_moles.ceda_acquisition.ceda_operation import  CEDA_Operation
30from ea_model.iso_19115_2006_metadata_corrigendum.citation_and_responsible_party_information.ci_address import  CI_Address     
31from ea_model.iso_19115_2006_metadata_corrigendum.metadata_extension_information.md_datatypecode import  MD_DatatypeCode       
32from ea_model.iso_19115_2006_metadata_corrigendum.portrayal_catalogue_information.md_portrayalcataloguereference import  MD_PortrayalCatalogueReference
33from ea_model.ceda_moles.ceda_acquisition.ceda_acquisition import  CEDA_Acquisition     
34from ea_model.iso_19109_2005_application_schema.general_feature_model.gf_attributetype import  GF_AttributeType
35from ea_model.moles3_4.computation.mo_computation import  MO_Computation       
36from ea_model.iso_19115_2006_metadata_corrigendum.citation_and_responsible_party_information.ci_telephone import  CI_Telephone 
37from ea_model.iso_19108_2006_temporal_schema.temporal_reference_system.tm_indeterminatevalue import  TM_IndeterminateValue     
38from ea_model.iso_19115_2006_metadata_corrigendum.citation_and_responsible_party_information.ci_onlineresource import  CI_OnlineResource       
39from ea_model.iso_19103_2005_schema_language.basic_types.derived.units_of_measure.unitofmeasure import  UnitOfMeasure   
40from ea_model.iso_19115_2006_metadata_corrigendum.extent_information.ex_extent import  EX_Extent       
41from ea_model.iso_19115_2006_metadata_corrigendum.identification_information.md_aggregateinformation import  MD_AggregateInformation   
42from ea_model.ceda_moles.ceda_observation.ceda_observation import  CEDA_Observation     
43from ea_model.iso_19103_2005_schema_language.basic_types.implementation.names.genericname import  GenericName   
44from ea_model.iso_19115_2006_metadata_corrigendum.identification_information.md_identification import  MD_Identification       
45from ea_model.iso_19108_2006_temporal_schema.temporal_objects.tm_duration import  TM_Duration   
46from ea_model.iso_19115_2006_metadata_corrigendum.citation_and_responsible_party_information.ci_responsibleparty import  CI_ResponsibleParty   
47from ea_model.moles3_4.utilities.mo_rolevalue import  MO_RoleValue     
48from ea_model.ceda_moles.ceda_utilities.ceda_reviewfrequencyvalue import  CEDA_ReviewFrequencyValue     
49from ea_model.iso_19103_2005_schema_language.basic_types.primitive.date_and_time.datetime import  DateTime     
50from ea_model.iso_19107_2003_spatial_schema.geometry.geometry_root.gm_object import  GM_Object 
51from ea_model.iso_19115_2006_metadata_corrigendum.extent_information.ex_verticalextent import  EX_VerticalExtent       
52from ea_model.moles3_4.observationcollection.mo_observationcollection import  MO_ObservationCollection 
53from ea_model.iso_19115_2006_metadata_corrigendum.reference_system_information.rs_identifier import  RS_Identifier     
54from ea_model.moles3_4.acquisition.mo_platform import  MO_Platform     
55from ea_model.ceda_moles.ceda_computation.ceda_processing import  CEDA_Processing       
56from ea_model.ceda_moles.ceda_acquisition.ceda_platform import  CEDA_Platform   
57from ea_model.iso_19115_2006_metadata_corrigendum.extent_information.ex_geographicextent import  EX_GeographicExtent   
58from ea_model.ceda_moles.ceda_result.ceda_result import  CEDA_Result   
59from ea_model.ceda_moles.ceda_acquisition.ceda_instrument import  CEDA_Instrument       
60from ea_model.moles3_4.acquisition.mo_platformtypevalue import  MO_PlatformTypeValue   
61from ea_model.ceda_moles.ceda_result.ceda_curationvalue import  CEDA_CurationValue     
62from ea_model.iso_19115_2006_metadata_corrigendum.maintenance_information.md_scopecode import  MD_ScopeCode     
63from ea_model.iso_fdis_19156_2011_observations_and_measurements.observation_schema.observation.namedvalue import  NamedValue   
64from ea_model.iso_19103_2005_schema_language.basic_types.implementation.records_and_class_metadata.any import  Any     
65from ea_model.iso_19103_2005_schema_language.basic_types.derived.units_of_measure.time import  Time     
66from ea_model.iso_19103_2005_schema_language.basic_types.primitive.date_and_time.clocktime import  ClockTime   
67from ea_model.iso_fdis_19156_2011_observations_and_measurements.observation_schema.observation.om_process import  OM_Process   
68from ea_model.iso_19115_2006_metadata_corrigendum.identification_information.md_keywordtypecode import  MD_KeywordTypeCode     
69from ea_model.iso_19115_2006_metadata_corrigendum.data_quality_information.dq_scope import  DQ_Scope   
70from ea_model.iso_19103_2005_schema_language.basic_types.implementation.names.localname import  LocalName       
71from ea_model.iso_19115_2006_metadata_corrigendum.identification_information.md_keywords import  MD_Keywords   
72from ea_model.moles3_4.computation.mo_inputoutput import  MO_InputOutput       
73from ea_model.iso_19108_2006_temporal_schema.temporal_objects.tm_geometricprimitive import  TM_GeometricPrimitive       
74from ea_model.iso_19103_2005_schema_language.basic_types.derived.units_of_measure.measuretype import  MeasureType       
75from ea_model.iso_19108_2006_temporal_schema.temporal_objects.tm_primitive import  TM_Primitive
76from ea_model.moles3_4.observationprocess.mo_process import  MO_Process
77from ea_model.iso_19115_2006_metadata_corrigendum.maintenance_information.md_maintenancefrequencycode import  MD_MaintenanceFrequencyCode       
78from ea_model.moles3_4.utilities.mo_publicationstatevalue import  MO_PublicationStateValue     
79from ea_model.iso_19115_2006_metadata_corrigendum.citation_and_responsible_party_information.url import  URL   
80from ea_model.iso_19115_2006_metadata_corrigendum.distribution_information.md_format import  MD_Format 
81from ea_model.iso_19109_2005_application_schema.general_feature_model.gf_propertytype import  GF_PropertyType   
82from ea_model.moles3_4.observation.mo_observation import  MO_Observation       
83from ea_model.iso_19115_2006_metadata_corrigendum.identification_information.ds_associationtypecode import  DS_AssociationTypeCode     
84from ea_model.iso_19115_2006_metadata_corrigendum.citation_and_responsible_party_information.ci_series import  CI_Series       
85from ea_model.iso_19115_2006_metadata_corrigendum.citation_and_responsible_party_information.ci_datetypecode import  CI_DateTypeCode   
86from ea_model.moles3_4.result.mo_onlineresource import  MO_OnlineResource       
87from ea_model.iso_19103_2005_schema_language.basic_types.derived.units_of_measure.uomscale import  UomScale     
88from ea_model.iso_19115_2006_metadata_corrigendum.data_quality_information.li_lineage import  LI_Lineage       
89from ea_model.iso_19108_2006_temporal_schema.temporal_reference_system.tm_temporalposition import  TM_TemporalPosition 
90from ea_model.iso_19103_2005_schema_language.basic_types.primitive.multiplicities.multiplicity import  Multiplicity     
91from ea_model.iso_19108_2006_temporal_schema.temporal_objects.tm_period import  TM_Period       
92from ea_model.ceda_moles.ceda_observationprocess.ceda_compositeprocess import  CEDA_CompositeProcess   
93from ea_model.iso_19115_2006_metadata_corrigendum.spatial_representation_information.md_spatialrepresentation import  MD_SpatialRepresentation 
94from ea_model.ceda_moles.ceda_project.ceda_project import  CEDA_Project
95from ea_model.iso_19115_2006_metadata_corrigendum.data_quality_information.dq_dataquality import  DQ_DataQuality       
96from ea_model.iso_19115_2006_metadata_corrigendum.identification_information.md_browsegraphic import  MD_BrowseGraphic 
97from ea_model.moles3_4.result.mo_result import  MO_Result       
98from ea_model.iso_19115_2006_metadata_corrigendum.extent_information.ex_temporalextent import  EX_TemporalExtent       
99from ea_model.iso_19103_2005_schema_language.basic_types.derived.units_of_measure.measure import  Measure       
100from ea_model.iso_19103_2005_schema_language.basic_types.primitive.date_and_time.date import  Date     
101from ea_model.iso_fdis_19156_2011_observations_and_measurements.observation_schema.observation.om_observation import  OM_Observation   
102from ea_model.iso_19115_2006_metadata_corrigendum.data_quality_information.li_processstep import  LI_ProcessStep       
103from ea_model.moles3_4.project.mo_project import  MO_Project   
104from ea_model.iso_19115_2006_metadata_corrigendum.data_quality_information.dq_element import  DQ_Element       
105from ea_model.iso_19115_2006_metadata_corrigendum.application_schema_information.md_applicationschemainformation import  MD_ApplicationSchemaInformation       
106from ea_model.iso_19115_2006_metadata_corrigendum.reference_system_information.md_identifier import  MD_Identifier     
107from ea_model.moles3_4.result.mo_onlinefunctionvalue import  MO_OnLineFunctionValue     
108from ea_model.iso_19108_2006_temporal_schema.temporal_objects.tm_periodduration import  TM_PeriodDuration       
109from ea_model.iso_19115_2006_metadata_corrigendum.citation_and_responsible_party_information.ci_onlinefunctioncode import  CI_OnLineFunctionCode       
110from ea_model.ceda_moles.ceda_utilities.ceda_review import  CEDA_Review
111from ea_model.iso_19115_2006_metadata_corrigendum.data_quality_information.dq_result import  DQ_Result 
112from ea_model.moles3_4.result.mo_applicationprofilevalue import  MO_ApplicationProfileValue     
113from ea_model.iso_19115_2006_metadata_corrigendum.citation_and_responsible_party_information.ci_presentationformcode import  CI_PresentationFormCode   
114from ea_model.iso_19115_2006_metadata_corrigendum.constraint_information.md_constraints import  MD_Constraints 
115from ea_model.iso_19109_2005_application_schema.general_feature_model.gf_featuretype import  GF_FeatureType     
116from ea_model.iso_19111_referencing_by_coordinates.identified_objects.io_identifiedobjectbase import  IO_IdentifiedObjectBase   
117from ea_model.ceda_moles.ceda_utilities.ceda_reviewstatusvalue import  CEDA_ReviewStatusValue   
118from ea_model.iso_19115_2006_metadata_corrigendum.maintenance_information.md_scopedescription import  MD_ScopeDescription       
119from ea_model.ceda_moles.ceda_observationcollection.ceda_observationcollection import  CEDA_ObservationCollection       
120from ea_model.ceda_moles.ceda_observation.ceda_citation import  CEDA_Citation   
121from ea_model.iso_19115_2006_metadata_corrigendum.citation_and_responsible_party_information.ci_contact import  CI_Contact     
122from ea_model.iso_19115_2006_metadata_corrigendum.identification_information.md_usage import  MD_Usage 
123from ea_model.iso_19115_2006_metadata_corrigendum.metadata_extension_information.md_extendedelementinformation import  MD_ExtendedElementInformation   
124from ea_model.iso_19103_2005_schema_language.basic_types.derived.units_of_measure.uomlength import  UomLength   
125from ea_model.iso_19115_2006_metadata_corrigendum.metadata_extension_information.md_metadataextensioninformation import  MD_MetadataExtensionInformation       
126from ea_model.moles3_4.acquisition.mo_instrument import  MO_Instrument 
127from ea_model.iso_19115_2006_metadata_corrigendum.identification_information.md_representativefraction import  MD_RepresentativeFraction       
128from ea_model.iso_19115_2006_metadata_corrigendum.citation_and_responsible_party_information.ci_rolecode import  CI_RoleCode   
129from ea_model.iso_19108_2006_temporal_schema.temporal_objects.tm_instant import  TM_Instant     
130from ea_model.moles3_4.acquisition.mo_location import  MO_Location     
131from ea_model.iso_19115_2006_metadata_corrigendum.data_quality_information.dq_evaluationmethodtypecode import  DQ_EvaluationMethodTypeCode     
132from ea_model.iso_19115_2006_metadata_corrigendum.citation_and_responsible_party_information.ci_citation import  CI_Citation   
133from ea_model.moles3_4.observationprocess.mo_compositeprocess import  MO_CompositeProcess       
134from ea_model.ceda_moles.ceda_observationprocess.ceda_process import  CEDA_Process     
135from ea_model.iso_19103_2005_schema_language.basic_types.implementation.names.typename import  TypeName
136from ea_model.iso_19115_2006_metadata_corrigendum.data_quality_information.li_source import  LI_Source 
137from ea_model.moles3_4.utilities.mo_responsiblepartyinfo import  MO_ResponsiblePartyInfo       
138from ea_model.iso_19115_2006_metadata_corrigendum.extent_information.ex_geographicdescription import  EX_GeographicDescription 
139from ea_model.iso_19115_2006_metadata_corrigendum.maintenance_information.md_maintenanceinformation import  MD_MaintenanceInformation   
140from ea_model.iso_19109_2005_application_schema.general_feature_model.gf_constraint import  GF_Constraint       
141from ea_model.moles3_4.acquisition.mo_instrumentplatformpair import  MO_InstrumentPlatformPair 
142from ea_model.iso_19103_2005_schema_language.basic_types.primitive.date_and_time.dateprecision import  DatePrecision   
143from ea_model.iso_19103_2005_schema_language.basic_types.implementation.names.scopedname import  ScopedName     
144from ea_model.ceda_moles.ceda_utilities.ceda_notes import  CEDA_Notes   
145from ea_model.iso_19108_2006_temporal_schema.temporal_objects.tm_object import  TM_Object
146
147clear_mappers()
148metadata = MetaData()
149def next_id(connection, seq_name):
150    seq = Sequence(seq_name)
151    seq.create(bind=connection)
152    return connection.execute(seq)
153
154
155
156
157
158
159
160
161
162
163
164
165ci_series_table = Table('ci_series', metadata,
166        Column('ci_series_id', Integer, Sequence('ci_series_id_seq'), primary_key=True),
167        Column('ci_citation_series', Integer, ForeignKey('ci_citation.ci_citation_id')),
168        Column('issueIdentification', TEXT , nullable=True),
169        Column('name', TEXT , nullable=True),
170        Column('page', TEXT , nullable=True),
171Column('t_type', String(30), nullable=False, default='ci_series'),
172        extend_existing=False,)
173 
174 
175
176
177
178
179
180
181
182
183
184
185clocktime_table = Table('clocktime', metadata,
186        Column('clocktime_id', Integer, Sequence('clocktime_id_seq'), primary_key=True),
187        Column('minute', TEXT , nullable=True),
188        Column('timeZone', TEXT , nullable=True),
189        Column('second', TEXT , nullable=True),
190        Column('hour', TEXT , nullable=False),
191Column('t_type', String(30), nullable=False, default='clocktime'),
192        extend_existing=False,)
193 
194 
195
196
197
198
199
200
201
202
203
204
205md_distribution_table = Table('md_distribution', metadata,
206        Column('md_distribution_id', Integer, Sequence('md_distribution_id_seq'), primary_key=True),
207        Column('md_metadata_distributionInfo', Integer, ForeignKey('md_metadata.md_metadata_id')),
208Column('t_type', String(30), nullable=False, default='md_distribution'),
209        extend_existing=False,)
210 
211 
212
213
214
215
216
217
218
219
220
221
222ci_telephone_table = Table('ci_telephone', metadata,
223        Column('ci_telephone_id', Integer, Sequence('ci_telephone_id_seq'), primary_key=True),
224        Column('ci_contact_phone', Integer, ForeignKey('ci_contact.ci_contact_id')),
225        Column('voice', ARRAY(TEXT) , nullable=True),
226        Column('facsimile', ARRAY(TEXT) , nullable=True),
227Column('t_type', String(30), nullable=False, default='ci_telephone'),
228        extend_existing=False,)
229 
230 
231
232
233
234
235
236
237
238
239
240
241md_contentinformation_table = Table('md_contentinformation', metadata,
242        Column('md_contentinformation_id', Integer, Sequence('md_contentinformation_id_seq'), primary_key=True),
243        Column('md_metadata_contentInfo', Integer, ForeignKey('md_metadata.md_metadata_id')),
244Column('t_type', String(30), nullable=False, default='md_contentinformation'),
245        extend_existing=False,)
246 
247 
248
249
250
251
252
253
254
255
256
257
258mo_responsiblepartyinfo_table = Table('mo_responsiblepartyinfo', metadata,
259        Column('mo_responsiblepartyinfo_id', Integer, Sequence('mo_responsiblepartyinfo_id_seq'), primary_key=True),
260        Column('mo_observation_relatedParty', Integer, ForeignKey('mo_observation.mo_observation_id')),
261        Column('mo_acquisition_realatedParty', Integer, ForeignKey('mo_acquisition.mo_acquisition_id')),
262        Column('mo_instrument_realatedParty', Integer, ForeignKey('mo_instrument.mo_instrument_id')),
263        Column('mo_platform_relatedParty', Integer, ForeignKey('mo_platform.mo_platform_id')),
264        Column('mo_compositeprocess_relatedParty', Integer, ForeignKey('mo_compositeprocess.mo_compositeprocess_id')),
265        Column('ceda_notes_commentator', Integer, ForeignKey('ceda_notes.ceda_notes_id')),
266        Column('ceda_review_reviewer', Integer, ForeignKey('ceda_review.ceda_review_id')),
267        Column('mo_project_relatedParty', Integer, ForeignKey('mo_project.mo_project_id')),
268        Column('mo_operation_relatedPartyInfo', Integer, ForeignKey('mo_operation.mo_operation_id')),
269        Column('mo_processing_relatedParty', Integer, ForeignKey('mo_processing.mo_processing_id')),
270        Column('role', MO_RoleValue.db_type() , nullable=False),
271Column('t_type', String(30), nullable=False, default='mo_responsiblepartyinfo'),
272        extend_existing=False,)
273 
274 
275
276
277
278
279
280
281
282
283
284
285multiplicity_table = Table('multiplicity', metadata,
286        Column('multiplicity_id', Integer, Sequence('multiplicity_id_seq'), primary_key=True),
287        Column('gf_attributetype_cardinality', Integer, ForeignKey('gf_attributetype.gf_attributetype_id')),
288Column('t_type', String(30), nullable=False, default='multiplicity'),
289        extend_existing=False,)
290 
291 
292
293
294
295
296
297
298
299
300
301
302tm_temporalposition_table = Table('tm_temporalposition', metadata,
303        Column('tm_temporalposition_id', Integer, Sequence('tm_temporalposition_id_seq'), primary_key=True),
304        Column('tm_position_anyOther', Integer, ForeignKey('tm_position.tm_position_id')),
305        Column('indeterminatePosition', TM_IndeterminateValue.db_type() , nullable=True),
306Column('t_type', String(30), nullable=False, default='tm_temporalposition'),
307        extend_existing=False,)
308 
309 
310
311
312
313
314
315
316
317
318
319
320genericname_table = Table('genericname', metadata,
321        Column('genericname_id', Integer, Sequence('genericname_id_seq'), primary_key=True),
322        Column('namedvalue_name', Integer, ForeignKey('namedvalue.namedvalue_id')),
323        Column('io_identifiedobjectbase_alias', Integer, ForeignKey('io_identifiedobjectbase.io_identifiedobjectbase_id')),
324        Column('mo_inputoutput_name', Integer, ForeignKey('mo_inputoutput.mo_inputoutput_id')),
325Column('t_type', String(30), nullable=False, default='genericname'),
326        extend_existing=False,)
327 
328 
329
330
331
332
333
334
335
336
337
338
339om_process_table = Table('om_process', metadata,
340        Column('om_process_id', Integer, Sequence('om_process_id_seq'), primary_key=True),
341Column('t_type', String(30), nullable=False, default='om_process'),
342        extend_existing=False,)
343 
344 
345
346
347
348
349
350
351
352
353
354
355gf_constraint_table = Table('gf_constraint', metadata,
356        Column('gf_constraint_id', Integer, Sequence('gf_constraint_id_seq'), primary_key=True),
357        Column('gf_featuretype_constrainedBy', Integer, ForeignKey('gf_featuretype.gf_featuretype_id')),
358        Column('gf_propertytype_constrainedBy', Integer, ForeignKey('gf_propertytype.gf_propertytype_id')),
359        Column('description', TEXT , nullable=False),
360Column('t_type', String(30), nullable=False, default='gf_constraint'),
361        extend_existing=False,)
362 
363 
364
365
366
367
368
369
370
371
372
373
374any_table = Table('any', metadata,
375        Column('any_id', Integer, Sequence('any_id_seq'), primary_key=True),
376        Column('om_observation_result', Integer, ForeignKey('om_observation.om_observation_id')),
377        Column('namedvalue_value', Integer, ForeignKey('namedvalue.namedvalue_id')),
378Column('t_type', String(30), nullable=False, default='any'),
379        extend_existing=False,)
380 
381 
382
383
384
385
386
387
388
389
390
391
392gm_object_table = Table('gm_object', metadata,
393        Column('gm_object_id', Integer, Sequence('gm_object_id_seq'), primary_key=True),
394        Column('mo_location_geometryLocation', Integer, ForeignKey('mo_location.mo_location_id')),
395Column('t_type', String(30), nullable=False, default='gm_object'),
396        extend_existing=False,)
397 
398 
399
400
401
402
403
404
405
406
407
408
409ceda_citation_table = Table('ceda_citation', metadata,
410        Column('ceda_citation_id', Integer, Sequence('ceda_citation_id_seq'), primary_key=True),
411        Column('ceda_observation_citation', Integer, ForeignKey('ceda_observation.ceda_observation_id')),
412        Column('author', ARRAY(TEXT) , nullable=False),
413        Column('title', TEXT , nullable=False),
414Column('t_type', String(30), nullable=False, default='ceda_citation'),
415        extend_existing=False,)
416 
417 
418
419
420
421
422
423
424
425
426
427
428dateprecision_table = Table('dateprecision', metadata,
429        Column('dateprecision_id', Integer, Sequence('dateprecision_id_seq'), primary_key=True),
430        Column('date_precision', Integer, ForeignKey('date.date_id')),
431        Column('determinationMethod', TEXT , nullable=False),
432        Column('precision', TEXT , nullable=False),
433Column('t_type', String(30), nullable=False, default='dateprecision'),
434        extend_existing=False,)
435 
436 
437
438
439
440
441
442
443
444
445
446
447md_spatialrepresentation_table = Table('md_spatialrepresentation', metadata,
448        Column('md_spatialrepresentation_id', Integer, Sequence('md_spatialrepresentation_id_seq'), primary_key=True),
449        Column('md_metadata_spatialRepresentationInfo', Integer, ForeignKey('md_metadata.md_metadata_id')),
450Column('t_type', String(30), nullable=False, default='md_spatialrepresentation'),
451        extend_existing=False,)
452 
453 
454
455
456
457
458
459
460
461
462
463
464md_format_table = Table('md_format', metadata,
465        Column('md_format_id', Integer, Sequence('md_format_id_seq'), primary_key=True),
466        Column('md_identification_resourceFormat', Integer, ForeignKey('md_identification.md_identification_id')),
467        Column('amendmentNumber', TEXT , nullable=True),
468        Column('name', TEXT , nullable=False),
469        Column('specification', TEXT , nullable=True),
470        Column('version', TEXT , nullable=False),
471        Column('fileDecompressionTechnique', TEXT , nullable=True),
472Column('t_type', String(30), nullable=False, default='md_format'),
473        extend_existing=False,)
474 
475 
476
477
478
479
480
481
482
483
484
485
486unitofmeasure_table = Table('unitofmeasure', metadata,
487        Column('unitofmeasure_id', Integer, Sequence('unitofmeasure_id_seq'), primary_key=True),
488        Column('offsetToStandardUnit', NUMERIC , nullable=True),
489        Column('scaleToStandardUnit', NUMERIC , nullable=True),
490        Column('uomName', TEXT , nullable=False),
491        Column('measureType', MeasureType.db_type() , nullable=False),
492        Column('formula', TEXT , nullable=True),
493        Column('nameStandardUnit', TEXT , nullable=True),
494        Column('uomSymbol', TEXT , nullable=False),
495Column('t_type', String(30), nullable=False, default='unitofmeasure'),
496        extend_existing=False,)
497 
498 
499
500
501
502
503
504
505
506
507
508
509tm_duration_table = Table('tm_duration', metadata,
510        Column('tm_duration_id', Integer, Sequence('tm_duration_id_seq'), primary_key=True),
511Column('t_type', String(30), nullable=False, default='tm_duration'),
512        extend_existing=False,)
513 
514 
515
516
517
518
519
520
521
522
523
524
525measure_table = Table('measure', metadata,
526        Column('measure_id', Integer, Sequence('measure_id_seq'), primary_key=True),
527        Column('value', NUMERIC , nullable=False),
528Column('t_type', String(30), nullable=False, default='measure'),
529        extend_existing=False,)
530 
531 
532
533
534
535
536
537
538
539
540
541
542ci_address_table = Table('ci_address', metadata,
543        Column('ci_address_id', Integer, Sequence('ci_address_id_seq'), primary_key=True),
544        Column('ci_contact_address', Integer, ForeignKey('ci_contact.ci_contact_id')),
545        Column('deliveryPoint', ARRAY(TEXT) , nullable=True),
546        Column('city', TEXT , nullable=True),
547        Column('electronicMailAddress', ARRAY(TEXT) , nullable=True),
548        Column('country', TEXT , nullable=True),
549        Column('administrativeArea', TEXT , nullable=True),
550        Column('postalCode', TEXT , nullable=True),
551Column('t_type', String(30), nullable=False, default='ci_address'),
552        extend_existing=False,)
553 
554 
555
556
557
558
559
560
561
562
563
564
565earootclass_table = Table('earootclass', metadata,
566        Column('earootclass_id', Integer, Sequence('earootclass_id_seq'), primary_key=True),
567Column('t_type', String(30), nullable=False, default='earootclass'),
568        extend_existing=False,)
569 
570 
571
572
573
574
575
576
577
578
579
580
581tm_object_table = Table('tm_object', metadata,
582        Column('tm_object_id', Integer, Sequence('tm_object_id_seq'), primary_key=True),
583        Column('om_observation_phenomenonTime', Integer, ForeignKey('om_observation.om_observation_id')),
584        Column('mo_operation_operationTime', Integer, ForeignKey('mo_operation.mo_operation_id')),
585        Column('mo_observationcollection_phenomenonTime', Integer, ForeignKey('mo_observationcollection.mo_observationcollection_id')),
586Column('t_type', String(30), nullable=False, default='tm_object'),
587        extend_existing=False,)
588 
589 
590
591
592
593
594
595
596
597
598
599
600dq_result_table = Table('dq_result', metadata,
601        Column('dq_result_id', Integer, Sequence('dq_result_id_seq'), primary_key=True),
602        Column('dq_element_result', Integer, ForeignKey('dq_element.dq_element_id')),
603Column('t_type', String(30), nullable=False, default='dq_result'),
604        extend_existing=False,)
605 
606 
607
608
609
610
611
612
613
614
615
616
617url_table = Table('url', metadata,
618        Column('url_id', Integer, Sequence('url_id_seq'), primary_key=True),
619        Column('ci_onlineresource_linkage', Integer, ForeignKey('ci_onlineresource.ci_onlineresource_id')),
620Column('t_type', String(30), nullable=False, default='url'),
621        extend_existing=False,)
622 
623 
624
625
626
627
628
629
630
631
632
633
634ex_geographicextent_table = Table('ex_geographicextent', metadata,
635        Column('ex_geographicextent_id', Integer, Sequence('ex_geographicextent_id_seq'), primary_key=True),
636        Column('ex_extent_geographicElement', Integer, ForeignKey('ex_extent.ex_extent_id')),
637        Column('mo_observationcollection_geographicExtent', Integer, ForeignKey('mo_observationcollection.mo_observationcollection_id')),
638        Column('mo_observation_geographicExtent', Integer, ForeignKey('mo_observation.mo_observation_id')),
639        Column('extentTypeCode', BOOLEAN , nullable=True),
640Column('t_type', String(30), nullable=False, default='ex_geographicextent'),
641        extend_existing=False,)
642 
643 
644
645
646
647
648
649
650
651
652
653
654md_browsegraphic_table = Table('md_browsegraphic', metadata,
655        Column('md_browsegraphic_id', Integer, Sequence('md_browsegraphic_id_seq'), primary_key=True),
656        Column('md_identification_graphicOverview', Integer, ForeignKey('md_identification.md_identification_id')),
657        Column('fileType', TEXT , nullable=True),
658        Column('fileName', TEXT , nullable=False),
659        Column('fileDescription', TEXT , nullable=True),
660Column('t_type', String(30), nullable=False, default='md_browsegraphic'),
661        extend_existing=False,)
662 
663 
664
665
666
667
668
669
670
671
672
673
674md_constraints_table = Table('md_constraints', metadata,
675        Column('md_constraints_id', Integer, Sequence('md_constraints_id_seq'), primary_key=True),
676        Column('mo_observation_permission', Integer, ForeignKey('mo_observation.mo_observation_id')),
677        Column('md_identification_resourceConstraints', Integer, ForeignKey('md_identification.md_identification_id')),
678        Column('md_metadata_metadataConstraints', Integer, ForeignKey('md_metadata.md_metadata_id')),
679        Column('useLimitation', ARRAY(TEXT) , nullable=True),
680Column('t_type', String(30), nullable=False, default='md_constraints'),
681        extend_existing=False,)
682 
683 
684
685
686
687
688
689
690
691
692
693
694time_table = Table('time', metadata,
695        Column('time_id', Integer, Sequence('time_id_seq'), primary_key=True),
696                                Column('measure_id', Integer, ForeignKey('measure.measure_id')),        Column('tm_position_time8601', Integer, ForeignKey('tm_position.tm_position_id')),
697Column('t_type', String(30), nullable=False, default='time'),
698        extend_existing=False,)
699 
700 
701
702
703
704
705
706
707
708
709
710
711scopedname_table = Table('scopedname', metadata,
712        Column('scopedname_id', Integer, Sequence('scopedname_id_seq'), primary_key=True),
713                                Column('genericname_id', Integer, ForeignKey('genericname.genericname_id')),    Column('mo_instrument_type', Integer, ForeignKey('mo_instrument.mo_instrument_id')),
714Column('t_type', String(30), nullable=False, default='scopedname'),
715        extend_existing=False,)
716 
717 
718
719
720
721
722
723
724
725
726
727
728namedvalue_table = Table('namedvalue', metadata,
729        Column('namedvalue_id', Integer, Sequence('namedvalue_id_seq'), primary_key=True),
730        Column('om_observation_parameter', Integer, ForeignKey('om_observation.om_observation_id')),
731Column('t_type', String(30), nullable=False, default='namedvalue'),
732        extend_existing=False,)
733 
734 
735
736
737
738
739
740
741
742
743
744
745tm_primitive_table = Table('tm_primitive', metadata,
746        Column('tm_primitive_id', Integer, Sequence('tm_primitive_id_seq'), primary_key=True),
747                                Column('tm_object_id', Integer, ForeignKey('tm_object.tm_object_id')),  Column('ex_temporalextent_extent', Integer, ForeignKey('ex_temporalextent.ex_temporalextent_id')),
748Column('t_type', String(30), nullable=False, default='tm_primitive'),
749        extend_existing=False,)
750 
751 
752
753
754
755
756
757
758
759
760
761
762uomscale_table = Table('uomscale', metadata,
763        Column('uomscale_id', Integer, Sequence('uomscale_id_seq'), primary_key=True),
764                                Column('unitofmeasure_id', Integer, ForeignKey('unitofmeasure.unitofmeasure_id')),      Column('scale_uom', Integer, ForeignKey('scale.scale_id')),
765Column('t_type', String(30), nullable=False, default='uomscale'),
766        extend_existing=False,)
767 
768 
769
770
771
772
773
774
775
776
777
778
779tm_periodduration_table = Table('tm_periodduration', metadata,
780        Column('tm_periodduration_id', Integer, Sequence('tm_periodduration_id_seq'), primary_key=True),
781                                Column('tm_duration_id', Integer, ForeignKey('tm_duration.tm_duration_id')),    Column('md_maintenanceinformation_userDefinedMaintenanceFrequency', Integer, ForeignKey('md_maintenanceinformation.md_maintenanceinformation_id')),
782        Column('hours', TEXT , nullable=True),
783        Column('designator', TEXT , nullable=False),
784        Column('years', TEXT , nullable=True),
785        Column('timeIndicator', TEXT , nullable=True),
786        Column('minutes', TEXT , nullable=True),
787        Column('months', TEXT , nullable=True),
788        Column('days', TEXT , nullable=True),
789        Column('seconds', TEXT , nullable=True),
790Column('t_type', String(30), nullable=False, default='tm_periodduration'),
791        extend_existing=False,)
792 
793 
794
795
796
797
798
799
800
801
802
803
804date_table = Table('date', metadata,
805        Column('date_id', Integer, Sequence('date_id_seq'), primary_key=True),
806        Column('ci_citation_editionDate', Integer, ForeignKey('ci_citation.ci_citation_id')),
807        Column('md_maintenanceinformation_dateOfNextUpdate', Integer, ForeignKey('md_maintenanceinformation.md_maintenanceinformation_id')),
808        Column('tm_position_date8601', Integer, ForeignKey('tm_position.tm_position_id')),
809        Column('ci_date_date', Integer, ForeignKey('ci_date.ci_date_id')),
810        Column('md_metadata_dateStamp', Integer, ForeignKey('md_metadata.md_metadata_id')),
811        Column('day', TEXT , nullable=True),
812        Column('century', TEXT , nullable=False),
813        Column('month', TEXT , nullable=True),
814        Column('year', TEXT , nullable=True),
815Column('t_type', String(30), nullable=False, default='date'),
816        extend_existing=False,)
817 
818 
819
820
821
822
823
824
825
826
827
828
829mo_process_table = Table('mo_process', metadata,
830        Column('mo_process_id', Integer, Sequence('mo_process_id_seq'), primary_key=True),
831                                Column('om_process_id', Integer, ForeignKey('om_process.om_process_id')),Column('t_type', String(30), nullable=False, default='mo_process'),
832        extend_existing=False,)
833 
834 
835
836
837
838
839
840
841
842
843
844
845mo_inputoutput_table = Table('mo_inputoutput', metadata,
846        Column('mo_inputoutput_id', Integer, Sequence('mo_inputoutput_id_seq'), primary_key=True),
847        Column('mo_processing_processingInput', Integer, ForeignKey('mo_processing.mo_processing_id')),
848        Column('mo_processing_processingOutput', Integer, ForeignKey('mo_processing.mo_processing_id')),
849        Column('mo_acquisition_outputDescription', Integer, ForeignKey('mo_acquisition.mo_acquisition_id')),
850Column('t_type', String(30), nullable=False, default='mo_inputoutput'),
851        extend_existing=False,)
852 
853 
854
855
856
857
858
859
860
861
862
863
864mo_computation_table = Table('mo_computation', metadata,
865        Column('mo_computation_id', Integer, Sequence('mo_computation_id_seq'), primary_key=True),
866                                Column('mo_process_id', Integer, ForeignKey('mo_process.mo_process_id')),       Column('mo_compositeprocess_computationComponent', Integer, ForeignKey('mo_compositeprocess.mo_compositeprocess_id')),
867Column('t_type', String(30), nullable=False, default='mo_computation'),
868        extend_existing=False,)
869 
870 
871
872
873
874
875
876
877
878
879
880
881ci_onlineresource_table = Table('ci_onlineresource', metadata,
882        Column('ci_onlineresource_id', Integer, Sequence('ci_onlineresource_id_seq'), primary_key=True),
883        Column('md_metadataextensioninformation_extensionOnLineResource', Integer, ForeignKey('md_metadataextensioninformation.md_metadataextensioninformation_id')),
884        Column('ci_contact_onlineResource', Integer, ForeignKey('ci_contact.ci_contact_id')),
885        Column('mo_observationcollection_additionalMetadata', Integer, ForeignKey('mo_observationcollection.mo_observationcollection_id')),
886        Column('name', TEXT , nullable=True),
887        Column('function', CI_OnLineFunctionCode.db_type() , nullable=True),
888        Column('applicationProfile', TEXT , nullable=True),
889        Column('description', TEXT , nullable=True),
890        Column('protocol', TEXT , nullable=True),
891Column('t_type', String(30), nullable=False, default='ci_onlineresource'),
892        extend_existing=False,)
893 
894 
895
896
897
898
899
900
901
902
903
904
905localname_table = Table('localname', metadata,
906        Column('localname_id', Integer, Sequence('localname_id_seq'), primary_key=True),
907                                Column('genericname_id', Integer, ForeignKey('genericname.genericname_id')),    Column('gf_featuretype_typeName', Integer, ForeignKey('gf_featuretype.gf_featuretype_id')),
908        Column('gf_propertytype_memberName', Integer, ForeignKey('gf_propertytype.gf_propertytype_id')),
909Column('t_type', String(30), nullable=False, default='localname'),
910        extend_existing=False,)
911 
912 
913
914
915
916
917
918
919
920
921
922
923uomlength_table = Table('uomlength', metadata,
924        Column('uomlength_id', Integer, Sequence('uomlength_id_seq'), primary_key=True),
925                                Column('unitofmeasure_id', Integer, ForeignKey('unitofmeasure.unitofmeasure_id')),      Column('scale_sourceUnits', Integer, ForeignKey('scale.scale_id')),
926        Column('scale_targetUnits', Integer, ForeignKey('scale.scale_id')),
927Column('t_type', String(30), nullable=False, default='uomlength'),
928        extend_existing=False,)
929 
930 
931
932
933
934
935
936
937
938
939
940
941ceda_process_table = Table('ceda_process', metadata,
942        Column('ceda_process_id', Integer, Sequence('ceda_process_id_seq'), primary_key=True),
943                                Column('mo_process_id', Integer, ForeignKey('mo_process.mo_process_id')),       Column('ceda_observation_procedure', Integer, ForeignKey('ceda_observation.ceda_observation_id')),
944Column('t_type', String(30), nullable=False, default='ceda_process'),
945        extend_existing=False,)
946 
947 
948
949
950
951
952
953
954
955
956
957
958mo_onlineresource_table = Table('mo_onlineresource', metadata,
959        Column('mo_onlineresource_id', Integer, Sequence('mo_onlineresource_id_seq'), primary_key=True),
960                                Column('ci_onlineresource_id', Integer, ForeignKey('ci_onlineresource.ci_onlineresource_id')),  Column('mo_result_source', Integer, ForeignKey('mo_result.mo_result_id')),
961        Column('mo_result_sample', Integer, ForeignKey('mo_result.mo_result_id')),
962        Column('ceda_project_projectResource', Integer, ForeignKey('ceda_project.ceda_project_id')),
963        Column('applicationProfile', MO_ApplicationProfileValue.db_type() , nullable=False),
964        Column('function', MO_OnLineFunctionValue.db_type() , nullable=False),
965Column('t_type', String(30), nullable=False, default='mo_onlineresource'),
966        extend_existing=False,)
967 
968 
969
970
971
972
973
974
975
976
977
978
979scale_table = Table('scale', metadata,
980        Column('scale_id', Integer, Sequence('scale_id_seq'), primary_key=True),
981                                Column('measure_id', Integer, ForeignKey('measure.measure_id')),        Column('md_representativefraction_equivalentScale', Integer, ForeignKey('md_representativefraction.md_representativefraction_id')),
982Column('t_type', String(30), nullable=False, default='scale'),
983        extend_existing=False,)
984 
985 
986
987
988
989
990
991
992
993
994
995
996typename_table = Table('typename', metadata,
997        Column('typename_id', Integer, Sequence('typename_id_seq'), primary_key=True),
998                                Column('localname_id', Integer, ForeignKey('localname.localname_id')),  Column('gf_attributetype_valueType', Integer, ForeignKey('gf_attributetype.gf_attributetype_id')),
999        Column('aName', TEXT , nullable=False),
1000Column('t_type', String(30), nullable=False, default='typename'),
1001        extend_existing=False,)
1002 
1003 
1004
1005
1006
1007
1008
1009
1010
1011
1012
1013
1014mo_result_table = Table('mo_result', metadata,
1015        Column('mo_result_id', Integer, Sequence('mo_result_id_seq'), primary_key=True),
1016        Column('mo_observation_result', Integer, ForeignKey('mo_observation.mo_observation_id')),
1017Column('t_type', String(30), nullable=False, default='mo_result'),
1018        extend_existing=False,)
1019 
1020 
1021
1022
1023
1024
1025
1026
1027
1028
1029
1030
1031datetime_table = Table('datetime', metadata,
1032        Column('datetime_id', Integer, Sequence('datetime_id_seq'), primary_key=True),
1033                                Column('date_id', Integer, ForeignKey('date.date_id')),                 Column('clocktime_id', Integer, ForeignKey('clocktime.clocktime_id')),  Column('li_processstep_dateTime', Integer, ForeignKey('li_processstep.li_processstep_id')),
1034        Column('md_usage_usageDateTime', Integer, ForeignKey('md_usage.md_usage_id')),
1035        Column('tm_position_dateTime8601', Integer, ForeignKey('tm_position.tm_position_id')),
1036        Column('dq_element_dateTime', Integer, ForeignKey('dq_element.dq_element_id')),
1037        Column('ceda_notes_date', Integer, ForeignKey('ceda_notes.ceda_notes_id')),
1038Column('t_type', String(30), nullable=False, default='datetime'),
1039        extend_existing=False,)
1040 
1041 
1042
1043
1044
1045
1046
1047
1048
1049
1050
1051
1052gf_featuretype_table = Table('gf_featuretype', metadata,
1053        Column('gf_featuretype_id', Integer, Sequence('gf_featuretype_id_seq'), primary_key=True),
1054        Column('md_scopedescription_features', Integer, ForeignKey('md_scopedescription.md_scopedescription_id')),
1055        Column('md_scopedescription_featureInstances', Integer, ForeignKey('md_scopedescription.md_scopedescription_id')),
1056        Column('definition', TEXT , nullable=False),
1057        Column('isAbstract', BOOLEAN , nullable=False),
1058Column('t_type', String(30), nullable=False, default='gf_featuretype'),
1059        extend_existing=False,)
1060 
1061 
1062
1063
1064
1065
1066
1067
1068
1069
1070
1071
1072ceda_result_table = Table('ceda_result', metadata,
1073        Column('ceda_result_id', Integer, Sequence('ceda_result_id_seq'), primary_key=True),
1074                                Column('mo_result_id', Integer, ForeignKey('mo_result.mo_result_id')),  Column('ceda_observation_result', Integer, ForeignKey('ceda_observation.ceda_observation_id')),
1075        Column('numberOfFiles', Integer , nullable=True),
1076        Column('internalPath', TEXT , nullable=False),
1077        Column('curationCategory', CEDA_CurationValue.db_type() , nullable=False),
1078        Column('volume', Integer , nullable=True),
1079Column('t_type', String(30), nullable=False, default='ceda_result'),
1080        extend_existing=False,)
1081 
1082 
1083
1084
1085
1086
1087
1088
1089
1090
1091
1092
1093gf_propertytype_table = Table('gf_propertytype', metadata,
1094        Column('gf_propertytype_id', Integer, Sequence('gf_propertytype_id_seq'), primary_key=True),
1095        Column('om_observation_observedProperty', Integer, ForeignKey('om_observation.om_observation_id')),
1096        Column('definition', TEXT , nullable=False),
1097Column('t_type', String(30), nullable=False, default='gf_propertytype'),
1098        extend_existing=False,)
1099 
1100 
1101
1102
1103
1104
1105
1106
1107
1108
1109
1110
1111ci_date_table = Table('ci_date', metadata,
1112        Column('ci_date_id', Integer, Sequence('ci_date_id_seq'), primary_key=True),
1113        Column('ci_citation_date', Integer, ForeignKey('ci_citation.ci_citation_id')),
1114        Column('dateType', CI_DateTypeCode.db_type() , nullable=False),
1115Column('t_type', String(30), nullable=False, default='ci_date'),
1116        extend_existing=False,)
1117 
1118 
1119
1120
1121
1122
1123
1124
1125
1126
1127
1128
1129tm_geometricprimitive_table = Table('tm_geometricprimitive', metadata,
1130        Column('tm_geometricprimitive_id', Integer, Sequence('tm_geometricprimitive_id_seq'), primary_key=True),
1131                                Column('tm_primitive_id', Integer, ForeignKey('tm_primitive.tm_primitive_id')),Column('t_type', String(30), nullable=False, default='tm_geometricprimitive'),
1132        extend_existing=False,)
1133 
1134 
1135
1136
1137
1138
1139
1140
1141
1142
1143
1144
1145ex_temporalextent_table = Table('ex_temporalextent', metadata,
1146        Column('ex_temporalextent_id', Integer, Sequence('ex_temporalextent_id_seq'), primary_key=True),
1147        Column('ex_extent_temporalElement', Integer, ForeignKey('ex_extent.ex_extent_id')),
1148Column('t_type', String(30), nullable=False, default='ex_temporalextent'),
1149        extend_existing=False,)
1150 
1151 
1152
1153
1154
1155
1156
1157
1158
1159
1160
1161
1162ceda_notes_table = Table('ceda_notes', metadata,
1163        Column('ceda_notes_id', Integer, Sequence('ceda_notes_id_seq'), primary_key=True),
1164        Column('ceda_review_notes', Integer, ForeignKey('ceda_review.ceda_review_id')),
1165        Column('comments', TEXT , nullable=False),
1166Column('t_type', String(30), nullable=False, default='ceda_notes'),
1167        extend_existing=False,)
1168 
1169 
1170
1171
1172
1173
1174
1175
1176
1177
1178
1179
1180ci_contact_table = Table('ci_contact', metadata,
1181        Column('ci_contact_id', Integer, Sequence('ci_contact_id_seq'), primary_key=True),
1182        Column('ci_responsibleparty_contactInfo', Integer, ForeignKey('ci_responsibleparty.ci_responsibleparty_id')),
1183        Column('hoursOfService', TEXT , nullable=True),
1184        Column('contactInstructions', TEXT , nullable=True),
1185Column('t_type', String(30), nullable=False, default='ci_contact'),
1186        extend_existing=False,)
1187 
1188 
1189
1190
1191
1192
1193
1194
1195
1196
1197
1198
1199tm_position_table = Table('tm_position', metadata,
1200        Column('tm_position_id', Integer, Sequence('tm_position_id_seq'), primary_key=True),
1201        Column('tm_instant_position', Integer, ForeignKey('tm_instant.tm_instant_id')),
1202Column('t_type', String(30), nullable=False, default='tm_position'),
1203        extend_existing=False,)
1204 
1205 
1206
1207
1208
1209
1210
1211
1212
1213
1214
1215
1216tm_period_table = Table('tm_period', metadata,
1217        Column('tm_period_id', Integer, Sequence('tm_period_id_seq'), primary_key=True),
1218                                Column('tm_geometricprimitive_id', Integer, ForeignKey('tm_geometricprimitive.tm_geometricprimitive_id')),      Column('om_observation_validTime', Integer, ForeignKey('om_observation.om_observation_id')),
1219Column('t_type', String(30), nullable=False, default='tm_period'),
1220        extend_existing=False,)
1221 
1222 
1223
1224
1225
1226
1227
1228
1229
1230
1231
1232
1233md_representativefraction_table = Table('md_representativefraction', metadata,
1234        Column('md_representativefraction_id', Integer, Sequence('md_representativefraction_id_seq'), primary_key=True),
1235        Column('li_source_scaleDenominator', Integer, ForeignKey('li_source.li_source_id')),
1236        Column('denominator', Integer , nullable=False),
1237Column('t_type', String(30), nullable=False, default='md_representativefraction'),
1238        extend_existing=False,)
1239 
1240 
1241
1242
1243
1244
1245
1246
1247
1248
1249
1250
1251ci_responsibleparty_table = Table('ci_responsibleparty', metadata,
1252        Column('ci_responsibleparty_id', Integer, Sequence('ci_responsibleparty_id_seq'), primary_key=True),
1253        Column('md_extendedelementinformation_source', Integer, ForeignKey('md_extendedelementinformation.md_extendedelementinformation_id')),
1254        Column('md_metadata_contact', Integer, ForeignKey('md_metadata.md_metadata_id')),
1255        Column('md_usage_userContactInfo', Integer, ForeignKey('md_usage.md_usage_id')),
1256        Column('li_processstep_processor', Integer, ForeignKey('li_processstep.li_processstep_id')),
1257        Column('md_identification_pointOfContact', Integer, ForeignKey('md_identification.md_identification_id')),
1258        Column('md_maintenanceinformation_contact', Integer, ForeignKey('md_maintenanceinformation.md_maintenanceinformation_id')),
1259        Column('ci_citation_citedResponsibleParty', Integer, ForeignKey('ci_citation.ci_citation_id')),
1260        Column('role', CI_RoleCode.db_type() , nullable=False),
1261        Column('individualName', TEXT , nullable=True),
1262        Column('organisationName', TEXT , nullable=True),
1263        Column('positionName', TEXT , nullable=True),
1264Column('t_type', String(30), nullable=False, default='ci_responsibleparty'),
1265        extend_existing=False,)
1266 
1267 
1268
1269
1270
1271
1272
1273
1274
1275
1276
1277
1278li_processstep_table = Table('li_processstep', metadata,
1279        Column('li_processstep_id', Integer, Sequence('li_processstep_id_seq'), primary_key=True),
1280        Column('li_lineage_processStep', Integer, ForeignKey('li_lineage.li_lineage_id')),
1281        Column('description', TEXT , nullable=False),
1282        Column('rationale', TEXT , nullable=True),
1283Column('t_type', String(30), nullable=False, default='li_processstep'),
1284        extend_existing=False,)
1285 
1286 
1287
1288
1289
1290
1291
1292
1293
1294
1295
1296
1297gf_attributetype_table = Table('gf_attributetype', metadata,
1298        Column('gf_attributetype_id', Integer, Sequence('gf_attributetype_id_seq'), primary_key=True),
1299                                Column('gf_propertytype_id', Integer, ForeignKey('gf_propertytype.gf_propertytype_id')),        Column('md_scopedescription_attributes', Integer, ForeignKey('md_scopedescription.md_scopedescription_id')),
1300        Column('md_scopedescription_attributeInstances', Integer, ForeignKey('md_scopedescription.md_scopedescription_id')),
1301        Column('valueDomain', TEXT , nullable=False),
1302Column('t_type', String(30), nullable=False, default='gf_attributetype'),
1303        extend_existing=False,)
1304 
1305 
1306
1307
1308
1309
1310
1311
1312
1313
1314
1315
1316md_usage_table = Table('md_usage', metadata,
1317        Column('md_usage_id', Integer, Sequence('md_usage_id_seq'), primary_key=True),
1318        Column('md_identification_resourceSpecificUsage', Integer, ForeignKey('md_identification.md_identification_id')),
1319        Column('userDeterminedLimitations', TEXT , nullable=True),
1320        Column('specificUsage', TEXT , nullable=False),
1321Column('t_type', String(30), nullable=False, default='md_usage'),
1322        extend_existing=False,)
1323 
1324 
1325
1326
1327
1328
1329
1330
1331
1332
1333
1334
1335tm_instant_table = Table('tm_instant', metadata,
1336        Column('tm_instant_id', Integer, Sequence('tm_instant_id_seq'), primary_key=True),
1337                                Column('tm_geometricprimitive_id', Integer, ForeignKey('tm_geometricprimitive.tm_geometricprimitive_id')),      Column('om_observation_resultTime', Integer, ForeignKey('om_observation.om_observation_id')),
1338Column('t_type', String(30), nullable=False, default='tm_instant'),
1339        extend_existing=False,)
1340 
1341 
1342
1343
1344
1345
1346
1347
1348
1349
1350
1351
1352ceda_review_table = Table('ceda_review', metadata,
1353        Column('ceda_review_id', Integer, Sequence('ceda_review_id_seq'), primary_key=True),
1354        Column('ceda_processing_review', Integer, ForeignKey('ceda_processing.ceda_processing_id')),
1355        Column('ceda_acquisition_review', Integer, ForeignKey('ceda_acquisition.ceda_acquisition_id')),
1356        Column('ceda_observationcollection_review', Integer, ForeignKey('ceda_observationcollection.ceda_observationcollection_id')),
1357        Column('ceda_project_review', Integer, ForeignKey('ceda_project.ceda_project_id')),
1358        Column('ceda_platform_review', Integer, ForeignKey('ceda_platform.ceda_platform_id')),
1359        Column('ceda_compositeprocess_review', Integer, ForeignKey('ceda_compositeprocess.ceda_compositeprocess_id')),
1360        Column('ceda_instrument_review', Integer, ForeignKey('ceda_instrument.ceda_instrument_id')),
1361        Column('ceda_observation_internalReview', Integer, ForeignKey('ceda_observation.ceda_observation_id')),
1362        Column('ceda_operation_review', Integer, ForeignKey('ceda_operation.ceda_operation_id')),
1363        Column('reviewFrequency', CEDA_ReviewFrequencyValue.db_type() , nullable=False),
1364        Column('reviewStatus', CEDA_ReviewStatusValue.db_type() , nullable=False),
1365Column('t_type', String(30), nullable=False, default='ceda_review'),
1366        extend_existing=False,)
1367 
1368 
1369
1370
1371
1372
1373
1374
1375
1376
1377
1378
1379md_scopedescription_table = Table('md_scopedescription', metadata,
1380        Column('md_scopedescription_id', Integer, Sequence('md_scopedescription_id_seq'), primary_key=True),
1381        Column('md_maintenanceinformation_updateScopeDescription', Integer, ForeignKey('md_maintenanceinformation.md_maintenanceinformation_id')),
1382        Column('dq_scope_levelDescription', Integer, ForeignKey('dq_scope.dq_scope_id')),
1383        Column('other', TEXT , nullable=False),
1384        Column('dataset', TEXT , nullable=False),
1385Column('t_type', String(30), nullable=False, default='md_scopedescription'),
1386        extend_existing=False,)
1387 
1388 
1389
1390
1391
1392
1393
1394
1395
1396
1397
1398
1399md_extendedelementinformation_table = Table('md_extendedelementinformation', metadata,
1400        Column('md_extendedelementinformation_id', Integer, Sequence('md_extendedelementinformation_id_seq'), primary_key=True),
1401        Column('md_metadataextensioninformation_extendedElementInformation', Integer, ForeignKey('md_metadataextensioninformation.md_metadataextensioninformation_id')),
1402        Column('domainValue', TEXT , nullable=True),
1403        Column('definition', TEXT , nullable=False),
1404        Column('name', TEXT , nullable=False),
1405        Column('dataType', MD_DatatypeCode.db_type() , nullable=False),
1406        Column('domainCode', Integer , nullable=True),
1407        Column('rationale', ARRAY(TEXT) , nullable=True),
1408        Column('parentEntity', ARRAY(TEXT) , nullable=False),
1409        Column('condition', TEXT , nullable=True),
1410        Column('obligation', MD_ObligationCode.db_type() , nullable=True),
1411        Column('maximumOccurrence', TEXT , nullable=True),
1412        Column('rule', TEXT , nullable=False),
1413        Column('shortName', TEXT , nullable=True),
1414Column('t_type', String(30), nullable=False, default='md_extendedelementinformation'),
1415        extend_existing=False,)
1416 
1417 
1418
1419
1420
1421
1422
1423
1424
1425
1426
1427
1428md_metadataextensioninformation_table = Table('md_metadataextensioninformation', metadata,
1429        Column('md_metadataextensioninformation_id', Integer, Sequence('md_metadataextensioninformation_id_seq'), primary_key=True),
1430        Column('md_metadata_metadataExtensionInfo', Integer, ForeignKey('md_metadata.md_metadata_id')),
1431Column('t_type', String(30), nullable=False, default='md_metadataextensioninformation'),
1432        extend_existing=False,)
1433 
1434 
1435
1436
1437
1438
1439
1440
1441
1442
1443
1444
1445md_maintenanceinformation_table = Table('md_maintenanceinformation', metadata,
1446        Column('md_maintenanceinformation_id', Integer, Sequence('md_maintenanceinformation_id_seq'), primary_key=True),
1447        Column('md_identification_resourceMaintenance', Integer, ForeignKey('md_identification.md_identification_id')),
1448        Column('md_metadata_metadataMaintenance', Integer, ForeignKey('md_metadata.md_metadata_id')),
1449        Column('maintenanceNote', ARRAY(TEXT) , nullable=True),
1450        Column('updateScope', MD_ScopeCode.db_type() , nullable=True),
1451        Column('maintenanceAndUpdateFrequency', MD_MaintenanceFrequencyCode.db_type() , nullable=False),
1452Column('t_type', String(30), nullable=False, default='md_maintenanceinformation'),
1453        extend_existing=False,)
1454 
1455 
1456
1457
1458
1459
1460
1461
1462
1463
1464
1465
1466rs_referencesystem_table = Table('rs_referencesystem', metadata,
1467        Column('rs_referencesystem_id', Integer, Sequence('rs_referencesystem_id_seq'), primary_key=True),
1468Column('t_type', String(30), nullable=False, default='rs_referencesystem'),
1469        extend_existing=False,)
1470 
1471 
1472
1473
1474
1475
1476
1477
1478
1479
1480
1481
1482md_identifier_table = Table('md_identifier', metadata,
1483        Column('md_identifier_id', Integer, Sequence('md_identifier_id_seq'), primary_key=True),
1484        Column('mo_project_identifier', Integer, ForeignKey('mo_project.mo_project_id')),
1485        Column('mo_processing_identifier', Integer, ForeignKey('mo_processing.mo_processing_id')),
1486        Column('mo_platform_identifier', Integer, ForeignKey('mo_platform.mo_platform_id')),
1487        Column('dq_element_measureIdentification', Integer, ForeignKey('dq_element.dq_element_id')),
1488        Column('mo_acquisition_identifier', Integer, ForeignKey('mo_acquisition.mo_acquisition_id')),
1489        Column('mo_observationcollection_identifier', Integer, ForeignKey('mo_observationcollection.mo_observationcollection_id')),
1490        Column('mo_observation_identifier', Integer, ForeignKey('mo_observation.mo_observation_id')),
1491        Column('ci_citation_identifier', Integer, ForeignKey('ci_citation.ci_citation_id', use_alter=True, name='fk_ci_citation')),
1492        Column('mo_instrument_identifier', Integer, ForeignKey('mo_instrument.mo_instrument_id')),
1493        Column('md_aggregateinformation_aggregateDataSetIdentifier', Integer, ForeignKey('md_aggregateinformation.md_aggregateinformation_id')),
1494        Column('mo_compositeprocess_identifier', Integer, ForeignKey('mo_compositeprocess.mo_compositeprocess_id')),
1495        Column('ex_geographicdescription_geographicIdentifier', Integer, ForeignKey('ex_geographicdescription.ex_geographicdescription_id')),
1496        Column('mo_operation_identifier', Integer, ForeignKey('mo_operation.mo_operation_id')),
1497        Column('code', TEXT , nullable=False),
1498Column('t_type', String(30), nullable=False, default='md_identifier'),
1499        extend_existing=False,)
1500 
1501 
1502
1503
1504
1505
1506
1507
1508
1509
1510
1511
1512ex_verticalextent_table = Table('ex_verticalextent', metadata,
1513        Column('ex_verticalextent_id', Integer, Sequence('ex_verticalextent_id_seq'), primary_key=True),
1514        Column('mo_observationcollection_verticalExtent', Integer, ForeignKey('mo_observationcollection.mo_observationcollection_id')),
1515        Column('mo_observation_verticalExtent', Integer, ForeignKey('mo_observation.mo_observation_id')),
1516        Column('ex_extent_verticalElement', Integer, ForeignKey('ex_extent.ex_extent_id', use_alter=True, name='fk_ex_extent')),
1517        Column('minimumValue', NUMERIC , nullable=False),
1518        Column('maximumValue', NUMERIC , nullable=False),
1519Column('t_type', String(30), nullable=False, default='ex_verticalextent'),
1520        extend_existing=False,)
1521 
1522 
1523
1524
1525
1526
1527
1528
1529
1530
1531
1532
1533ex_extent_table = Table('ex_extent', metadata,
1534        Column('ex_extent_id', Integer, Sequence('ex_extent_id_seq'), primary_key=True),
1535        Column('li_source_sourceExtent', Integer, ForeignKey('li_source.li_source_id')),
1536        Column('dq_scope_extent', Integer, ForeignKey('dq_scope.dq_scope_id')),
1537        Column('rs_referencesystem_domainOfValidity', Integer, ForeignKey('rs_referencesystem.rs_referencesystem_id', use_alter=True, name='fk_rs_referencesystem')),
1538        Column('description', TEXT , nullable=True),
1539Column('t_type', String(30), nullable=False, default='ex_extent'),
1540        extend_existing=False,)
1541 
1542 
1543
1544
1545
1546
1547
1548
1549
1550
1551
1552
1553ceda_observationcollection_table = Table('ceda_observationcollection', metadata,
1554        Column('ceda_observationcollection_id', Integer, Sequence('ceda_observationcollection_id_seq'), primary_key=True),
1555                                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')),
1556Column('t_type', String(30), nullable=False, default='ceda_observationcollection'),
1557        extend_existing=False,)
1558 
1559 
1560
1561
1562
1563
1564
1565
1566
1567
1568
1569
1570io_identifiedobjectbase_table = Table('io_identifiedobjectbase', metadata,
1571        Column('io_identifiedobjectbase_id', Integer, Sequence('io_identifiedobjectbase_id_seq'), primary_key=True),
1572        Column('remarks', TEXT , nullable=True),
1573Column('t_type', String(30), nullable=False, default='io_identifiedobjectbase'),
1574        extend_existing=False,)
1575 
1576 
1577
1578
1579
1580
1581
1582
1583
1584
1585
1586
1587md_keywords_table = Table('md_keywords', metadata,
1588        Column('md_keywords_id', Integer, Sequence('md_keywords_id_seq'), primary_key=True),
1589        Column('md_identification_descriptiveKeywords', Integer, ForeignKey('md_identification.md_identification_id')),
1590        Column('mo_project_keywords', Integer, ForeignKey('mo_project.mo_project_id')),
1591        Column('ceda_observation_keywords', Integer, ForeignKey('ceda_observation.ceda_observation_id')),
1592        Column('type', MD_KeywordTypeCode.db_type() , nullable=True),
1593        Column('keyword', ARRAY(TEXT) , nullable=False),
1594Column('t_type', String(30), nullable=False, default='md_keywords'),
1595        extend_existing=False,)
1596 
1597 
1598
1599
1600
1601
1602
1603
1604
1605
1606
1607
1608ex_geographicdescription_table = Table('ex_geographicdescription', metadata,
1609        Column('ex_geographicdescription_id', Integer, Sequence('ex_geographicdescription_id_seq'), primary_key=True),
1610                                Column('ex_geographicextent_id', Integer, ForeignKey('ex_geographicextent.ex_geographicextent_id')),    Column('mo_location_nameLocation', Integer, ForeignKey('mo_location.mo_location_id')),
1611Column('t_type', String(30), nullable=False, default='ex_geographicdescription'),
1612        extend_existing=False,)
1613 
1614 
1615
1616
1617
1618
1619
1620
1621
1622
1623
1624
1625md_aggregateinformation_table = Table('md_aggregateinformation', metadata,
1626        Column('md_aggregateinformation_id', Integer, Sequence('md_aggregateinformation_id_seq'), primary_key=True),
1627        Column('md_identification_aggregationInfo', Integer, ForeignKey('md_identification.md_identification_id')),
1628        Column('associationType', DS_AssociationTypeCode.db_type() , nullable=False),
1629        Column('initiativeType', DS_InitiativeTypeCode.db_type() , nullable=True),
1630Column('t_type', String(30), nullable=False, default='md_aggregateinformation'),
1631        extend_existing=False,)
1632 
1633 
1634
1635
1636
1637
1638
1639
1640
1641
1642
1643
1644dq_dataquality_table = Table('dq_dataquality', metadata,
1645        Column('dq_dataquality_id', Integer, Sequence('dq_dataquality_id_seq'), primary_key=True),
1646        Column('md_metadata_dataQualityInfo', Integer, ForeignKey('md_metadata.md_metadata_id')),
1647Column('t_type', String(30), nullable=False, default='dq_dataquality'),
1648        extend_existing=False,)
1649 
1650 
1651
1652
1653
1654
1655
1656
1657
1658
1659
1660
1661mo_compositeprocess_table = Table('mo_compositeprocess', metadata,
1662        Column('mo_compositeprocess_id', Integer, Sequence('mo_compositeprocess_id_seq'), primary_key=True),
1663                                Column('mo_process_id', Integer, ForeignKey('mo_process.mo_process_id')),       Column('description', TEXT , nullable=True),
1664Column('t_type', String(30), nullable=False, default='mo_compositeprocess'),
1665        extend_existing=False,)
1666 
1667 
1668
1669
1670
1671
1672
1673
1674
1675
1676
1677
1678mo_observation_table = Table('mo_observation', metadata,
1679        Column('mo_observation_id', Integer, Sequence('mo_observation_id_seq'), primary_key=True),
1680                                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')),
1681        Column('status', MD_ProgressCode.db_type() , nullable=True),
1682        Column('resolution', TEXT , nullable=True),
1683        Column('publicationState', MO_PublicationStateValue.db_type() , nullable=True),
1684        Column('description', TEXT , nullable=True),
1685        Column('resultAccumulation', MD_MaintenanceFrequencyCode.db_type() , nullable=True),
1686Column('t_type', String(30), nullable=False, default='mo_observation'),
1687        extend_existing=False,)
1688 
1689 
1690
1691
1692
1693
1694
1695
1696
1697
1698
1699
1700dq_scope_table = Table('dq_scope', metadata,
1701        Column('dq_scope_id', Integer, Sequence('dq_scope_id_seq'), primary_key=True),
1702        Column('dq_dataquality_scope', Integer, ForeignKey('dq_dataquality.dq_dataquality_id')),
1703        Column('level', MD_ScopeCode.db_type() , nullable=False),
1704Column('t_type', String(30), nullable=False, default='dq_scope'),
1705        extend_existing=False,)
1706 
1707 
1708
1709
1710
1711
1712
1713
1714
1715
1716
1717
1718ceda_compositeprocess_table = Table('ceda_compositeprocess', metadata,
1719        Column('ceda_compositeprocess_id', Integer, Sequence('ceda_compositeprocess_id_seq'), primary_key=True),
1720                                Column('mo_compositeprocess_id', Integer, ForeignKey('mo_compositeprocess.mo_compositeprocess_id')),                    Column('ceda_process_id', Integer, ForeignKey('ceda_process.ceda_process_id')),Column('t_type', String(30), nullable=False, default='ceda_compositeprocess'),
1721        extend_existing=False,)
1722 
1723 
1724
1725
1726
1727
1728
1729
1730
1731
1732
1733
1734md_metadata_table = Table('md_metadata', metadata,
1735        Column('md_metadata_id', Integer, Sequence('md_metadata_id_seq'), primary_key=True),
1736        Column('om_observation_metadata', Integer, ForeignKey('om_observation.om_observation_id')),
1737        Column('mo_observationcollection_isoMetadata', Integer, ForeignKey('mo_observationcollection.mo_observationcollection_id')),
1738        Column('metadataStandardName', TEXT , nullable=True),
1739        Column('language', TEXT , nullable=True),
1740        Column('fileIdentifier', TEXT , nullable=True),
1741        Column('hierarchyLevel', MD_ScopeCode.db_type() , nullable=True),
1742        Column('parentIdentifier', TEXT , nullable=True),
1743        Column('metadataStandardVersion', TEXT , nullable=True),
1744        Column('hierarchyLevelName', ARRAY(TEXT) , nullable=True),
1745        Column('characterSet', MD_CharacterSetCode.db_type() , nullable=True),
1746        Column('dataSet', TEXT , nullable=True),
1747Column('t_type', String(30), nullable=False, default='md_metadata'),
1748        extend_existing=False,)
1749 
1750 
1751
1752
1753
1754
1755
1756
1757
1758
1759
1760
1761li_source_table = Table('li_source', metadata,
1762        Column('li_source_id', Integer, Sequence('li_source_id_seq'), primary_key=True),
1763        Column('li_lineage_source', Integer, ForeignKey('li_lineage.li_lineage_id')),
1764        Column('description', TEXT , nullable=True),
1765Column('t_type', String(30), nullable=False, default='li_source'),
1766        extend_existing=False,)
1767 
1768 
1769
1770
1771
1772
1773
1774
1775
1776
1777
1778
1779md_referencesystem_table = Table('md_referencesystem', metadata,
1780        Column('md_referencesystem_id', Integer, Sequence('md_referencesystem_id_seq'), primary_key=True),
1781        Column('li_source_sourceReferenceSystem', Integer, ForeignKey('li_source.li_source_id')),
1782        Column('md_metadata_referenceSystemInfo', Integer, ForeignKey('md_metadata.md_metadata_id')),
1783Column('t_type', String(30), nullable=False, default='md_referencesystem'),
1784        extend_existing=False,)
1785 
1786 
1787
1788
1789
1790
1791
1792
1793
1794
1795
1796
1797om_observation_table = Table('om_observation', metadata,
1798        Column('om_observation_id', Integer, Sequence('om_observation_id_seq'), primary_key=True),
1799Column('t_type', String(30), nullable=False, default='om_observation'),
1800        extend_existing=False,)
1801 
1802 
1803
1804
1805
1806
1807
1808
1809
1810
1811
1812
1813sc_crs_table = Table('sc_crs', metadata,
1814        Column('sc_crs_id', Integer, Sequence('sc_crs_id_seq'), primary_key=True),
1815                                Column('io_identifiedobjectbase_id', Integer, ForeignKey('io_identifiedobjectbase.io_identifiedobjectbase_id')),                        Column('rs_referencesystem_id', Integer, ForeignKey('rs_referencesystem.rs_referencesystem_id')),       Column('ex_verticalextent_verticalCRS', Integer, ForeignKey('ex_verticalextent.ex_verticalextent_id', use_alter=True, name='fk_ex_verticalextent')),
1816        Column('scope', ARRAY(TEXT) , nullable=False),
1817Column('t_type', String(30), nullable=False, default='sc_crs'),
1818        extend_existing=False,)
1819 
1820 
1821
1822
1823
1824
1825
1826
1827
1828
1829
1830
1831mo_location_table = Table('mo_location', metadata,
1832        Column('mo_location_id', Integer, Sequence('mo_location_id_seq'), primary_key=True),
1833        Column('mo_platform_location', Integer, ForeignKey('mo_platform.mo_platform_id')),
1834        Column('mo_operation_location', Integer, ForeignKey('mo_operation.mo_operation_id')),
1835Column('t_type', String(30), nullable=False, default='mo_location'),
1836        extend_existing=False,)
1837 
1838 
1839
1840
1841
1842
1843
1844
1845
1846
1847
1848
1849mo_observationcollection_table = Table('mo_observationcollection', metadata,
1850        Column('mo_observationcollection_id', Integer, Sequence('mo_observationcollection_id_seq'), primary_key=True),
1851        Column('mo_project_observationCollection', Integer, ForeignKey('mo_project.mo_project_id', use_alter=True, name='fk_mo_project')),
1852        Column('publicationState', MO_PublicationStateValue.db_type() , nullable=True),
1853        Column('description', TEXT , nullable=True),
1854Column('t_type', String(30), nullable=False, default='mo_observationcollection'),
1855        extend_existing=False,)
1856 
1857 
1858
1859
1860
1861
1862
1863
1864
1865
1866
1867
1868ceda_operation_table = Table('ceda_operation', metadata,
1869        Column('ceda_operation_id', Integer, Sequence('ceda_operation_id_seq'), primary_key=True),
1870                                Column('mo_operation_id', Integer, ForeignKey('mo_operation.mo_operation_id')), Column('ceda_acquisition_operation', Integer, ForeignKey('ceda_acquisition.ceda_acquisition_id')),
1871Column('t_type', String(30), nullable=False, default='ceda_operation'),
1872        extend_existing=False,)
1873 
1874 
1875
1876
1877
1878
1879
1880
1881
1882
1883
1884
1885ceda_processing_table = Table('ceda_processing', metadata,
1886        Column('ceda_processing_id', Integer, Sequence('ceda_processing_id_seq'), primary_key=True),
1887                                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')),
1888Column('t_type', String(30), nullable=False, default='ceda_processing'),
1889        extend_existing=False,)
1890 
1891 
1892
1893
1894
1895
1896
1897
1898
1899
1900
1901
1902ceda_project_table = Table('ceda_project', metadata,
1903        Column('ceda_project_id', Integer, Sequence('ceda_project_id_seq'), primary_key=True),
1904                                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')),
1905Column('t_type', String(30), nullable=False, default='ceda_project'),
1906        extend_existing=False,)
1907 
1908 
1909
1910
1911
1912
1913
1914
1915
1916
1917
1918
1919md_identification_table = Table('md_identification', metadata,
1920        Column('md_identification_id', Integer, Sequence('md_identification_id_seq'), primary_key=True),
1921        Column('md_metadata_identificationInfo', Integer, ForeignKey('md_metadata.md_metadata_id')),
1922        Column('purpose', TEXT , nullable=True),
1923        Column('credit', ARRAY(TEXT) , nullable=True),
1924        Column('status', MD_ProgressCode.db_type() , nullable=True),
1925        Column('abstract', TEXT , nullable=False),
1926Column('t_type', String(30), nullable=False, default='md_identification'),
1927        extend_existing=False,)
1928 
1929 
1930
1931
1932
1933
1934
1935
1936
1937
1938
1939
1940mo_operation_table = Table('mo_operation', metadata,
1941        Column('mo_operation_id', Integer, Sequence('mo_operation_id_seq'), primary_key=True),
1942        Column('mo_acquisition_operation', Integer, ForeignKey('mo_acquisition.mo_acquisition_id')),
1943        Column('status', MD_ProgressCode.db_type() , nullable=True),
1944        Column('description', TEXT , nullable=True),
1945Column('t_type', String(30), nullable=False, default='mo_operation'),
1946        extend_existing=False,)
1947 
1948 
1949
1950
1951
1952
1953
1954
1955
1956
1957
1958
1959ceda_instrument_table = Table('ceda_instrument', metadata,
1960        Column('ceda_instrument_id', Integer, Sequence('ceda_instrument_id_seq'), primary_key=True),
1961                                Column('mo_instrument_id', Integer, ForeignKey('mo_instrument.mo_instrument_id')),      Column('ceda_acquisition_instrument', Integer, ForeignKey('ceda_acquisition.ceda_acquisition_id')),
1962Column('t_type', String(30), nullable=False, default='ceda_instrument'),
1963        extend_existing=False,)
1964 
1965 
1966
1967
1968
1969
1970
1971
1972
1973
1974
1975
1976ceda_observation_table = Table('ceda_observation', metadata,
1977        Column('ceda_observation_id', Integer, Sequence('ceda_observation_id_seq'), primary_key=True),
1978                                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')),
1979        Column('dataLineage', TEXT , nullable=False),
1980Column('t_type', String(30), nullable=False, default='ceda_observation'),
1981        extend_existing=False,)
1982 
1983 
1984
1985
1986
1987
1988
1989
1990
1991
1992
1993
1994mo_project_table = Table('mo_project', metadata,
1995        Column('mo_project_id', Integer, Sequence('mo_project_id_seq'), primary_key=True),
1996        Column('mo_observation_inSupportOf', Integer, ForeignKey('mo_observation.mo_observation_id', use_alter=True, name='fk_mo_observation')),
1997        Column('status', MD_ProgressCode.db_type() , nullable=True),
1998        Column('abstract', TEXT , nullable=True),
1999        Column('publicationState', MO_PublicationStateValue.db_type() , nullable=True),
2000        Column('description', TEXT , nullable=True),
2001Column('t_type', String(30), nullable=False, default='mo_project'),
2002        extend_existing=False,)
2003 
2004 
2005
2006
2007
2008
2009
2010
2011
2012
2013
2014
2015mo_platform_table = Table('mo_platform', metadata,
2016        Column('mo_platform_id', Integer, Sequence('mo_platform_id_seq'), primary_key=True),
2017        Column('mo_instrumentplatformpair_platform', Integer, ForeignKey('mo_instrumentplatformpair.mo_instrumentplatformpair_id')),
2018        Column('mo_operation_platform', Integer, ForeignKey('mo_operation.mo_operation_id')),
2019        Column('mo_acquisition_platform', Integer, ForeignKey('mo_acquisition.mo_acquisition_id')),
2020        Column('description', TEXT , nullable=True),
2021        Column('type', MO_PlatformTypeValue.db_type() , nullable=True),
2022Column('t_type', String(30), nullable=False, default='mo_platform'),
2023        extend_existing=False,)
2024 
2025 
2026
2027
2028
2029
2030
2031
2032
2033
2034
2035
2036mo_acquisition_table = Table('mo_acquisition', metadata,
2037        Column('mo_acquisition_id', Integer, Sequence('mo_acquisition_id_seq'), primary_key=True),
2038                                Column('mo_process_id', Integer, ForeignKey('mo_process.mo_process_id')),       Column('mo_compositeprocess_acquisitionComponent', Integer, ForeignKey('mo_compositeprocess.mo_compositeprocess_id')),
2039        Column('description', TEXT , nullable=True),
2040Column('t_type', String(30), nullable=False, default='mo_acquisition'),
2041        extend_existing=False,)
2042 
2043 
2044
2045
2046
2047
2048
2049
2050
2051
2052
2053
2054mo_instrument_table = Table('mo_instrument', metadata,
2055        Column('mo_instrument_id', Integer, Sequence('mo_instrument_id_seq'), primary_key=True),
2056        Column('mo_acquisition_instrument', Integer, ForeignKey('mo_acquisition.mo_acquisition_id')),
2057        Column('mo_instrumentplatformpair_instrument', Integer, ForeignKey('mo_instrumentplatformpair.mo_instrumentplatformpair_id')),
2058        Column('description', TEXT , nullable=True),
2059Column('t_type', String(30), nullable=False, default='mo_instrument'),
2060        extend_existing=False,)
2061 
2062 
2063
2064
2065
2066
2067
2068
2069
2070
2071
2072
2073li_lineage_table = Table('li_lineage', metadata,
2074        Column('li_lineage_id', Integer, Sequence('li_lineage_id_seq'), primary_key=True),
2075        Column('dq_dataquality_lineage', Integer, ForeignKey('dq_dataquality.dq_dataquality_id')),
2076        Column('statement', TEXT , nullable=True),
2077Column('t_type', String(30), nullable=False, default='li_lineage'),
2078        extend_existing=False,)
2079 
2080 
2081
2082
2083
2084
2085
2086
2087
2088
2089
2090
2091mo_instrumentplatformpair_table = Table('mo_instrumentplatformpair', metadata,
2092        Column('mo_instrumentplatformpair_id', Integer, Sequence('mo_instrumentplatformpair_id_seq'), primary_key=True),
2093        Column('mo_acquisition_instrumentPlatformPair', Integer, ForeignKey('mo_acquisition.mo_acquisition_id')),
2094Column('t_type', String(30), nullable=False, default='mo_instrumentplatformpair'),
2095        extend_existing=False,)
2096 
2097 
2098
2099
2100
2101
2102
2103
2104
2105
2106
2107
2108md_applicationschemainformation_table = Table('md_applicationschemainformation', metadata,
2109        Column('md_applicationschemainformation_id', Integer, Sequence('md_applicationschemainformation_id_seq'), primary_key=True),
2110        Column('md_metadata_applicationSchemaInfo', Integer, ForeignKey('md_metadata.md_metadata_id')),
2111        Column('softwareDevelopmentFileFormat', TEXT , nullable=True),
2112        Column('schemaLanguage', TEXT , nullable=False),
2113        Column('constraintLanguage', TEXT , nullable=False),
2114        Column('schemaAscii', TEXT , nullable=True),
2115Column('t_type', String(30), nullable=False, default='md_applicationschemainformation'),
2116        extend_existing=False,)
2117 
2118 
2119
2120
2121
2122
2123
2124
2125
2126
2127
2128
2129dq_element_table = Table('dq_element', metadata,
2130        Column('dq_element_id', Integer, Sequence('dq_element_id_seq'), primary_key=True),
2131        Column('dq_dataquality_report', Integer, ForeignKey('dq_dataquality.dq_dataquality_id')),
2132        Column('om_observation_resultQuality', Integer, ForeignKey('om_observation.om_observation_id')),
2133        Column('nameOfMeasure', ARRAY(TEXT) , nullable=True),
2134        Column('evaluationMethodDescription', TEXT , nullable=True),
2135        Column('evaluationMethodType', DQ_EvaluationMethodTypeCode.db_type() , nullable=True),
2136        Column('measureDescription', TEXT , nullable=True),
2137Column('t_type', String(30), nullable=False, default='dq_element'),
2138        extend_existing=False,)
2139 
2140 
2141
2142
2143
2144
2145
2146
2147
2148
2149
2150
2151ceda_acquisition_table = Table('ceda_acquisition', metadata,
2152        Column('ceda_acquisition_id', Integer, Sequence('ceda_acquisition_id_seq'), primary_key=True),
2153                                Column('mo_acquisition_id', Integer, ForeignKey('mo_acquisition.mo_acquisition_id')),                   Column('ceda_process_id', Integer, ForeignKey('ceda_process.ceda_process_id')), Column('ceda_compositeprocess_aquisitionComponent', Integer, ForeignKey('ceda_compositeprocess.ceda_compositeprocess_id')),
2154Column('t_type', String(30), nullable=False, default='ceda_acquisition'),
2155        extend_existing=False,)
2156 
2157 
2158
2159
2160
2161
2162
2163
2164
2165
2166
2167
2168rs_identifier_table = Table('rs_identifier', metadata,
2169        Column('rs_identifier_id', Integer, Sequence('rs_identifier_id_seq'), primary_key=True),
2170                                Column('md_identifier_id', Integer, ForeignKey('md_identifier.md_identifier_id')),      Column('io_identifiedobjectbase_identifier', Integer, ForeignKey('io_identifiedobjectbase.io_identifiedobjectbase_id')),
2171        Column('md_referencesystem_referenceSystemIdentifier', Integer, ForeignKey('md_referencesystem.md_referencesystem_id')),
2172        Column('rs_referencesystem_name', Integer, ForeignKey('rs_referencesystem.rs_referencesystem_id')),
2173        Column('version', TEXT , nullable=True),
2174        Column('codeSpace', TEXT , nullable=True),
2175Column('t_type', String(30), nullable=False, default='rs_identifier'),
2176        extend_existing=False,)
2177 
2178 
2179
2180
2181
2182
2183
2184
2185
2186
2187
2188
2189ceda_platform_table = Table('ceda_platform', metadata,
2190        Column('ceda_platform_id', Integer, Sequence('ceda_platform_id_seq'), primary_key=True),
2191                                Column('mo_platform_id', Integer, ForeignKey('mo_platform.mo_platform_id')),    Column('ceda_acquisition_platform', Integer, ForeignKey('ceda_acquisition.ceda_acquisition_id')),
2192Column('t_type', String(30), nullable=False, default='ceda_platform'),
2193        extend_existing=False,)
2194 
2195 
2196
2197
2198
2199
2200
2201
2202
2203
2204
2205
2206ci_citation_table = Table('ci_citation', metadata,
2207        Column('ci_citation_id', Integer, Sequence('ci_citation_id_seq'), primary_key=True),
2208        Column('mo_platform_documentation', Integer, ForeignKey('mo_platform.mo_platform_id')),
2209        Column('md_portrayalcataloguereference_portrayalCatalogueCitation', Integer, ForeignKey('md_portrayalcataloguereference.md_portrayalcataloguereference_id')),
2210        Column('md_applicationschemainformation_name', Integer, ForeignKey('md_applicationschemainformation.md_applicationschemainformation_id')),
2211        Column('mo_observation_documentation', Integer, ForeignKey('mo_observation.mo_observation_id')),
2212        Column('mo_processing_softwareReference', Integer, ForeignKey('mo_processing.mo_processing_id')),
2213        Column('mo_compositeprocess_documentation', Integer, ForeignKey('mo_compositeprocess.mo_compositeprocess_id')),
2214        Column('mo_project_documentation', Integer, ForeignKey('mo_project.mo_project_id')),
2215        Column('mo_project_dmp', Integer, ForeignKey('mo_project.mo_project_id')),
2216        Column('mo_instrument_documentation', Integer, ForeignKey('mo_instrument.mo_instrument_id')),
2217        Column('md_aggregateinformation_aggregateDataSetName', Integer, ForeignKey('md_aggregateinformation.md_aggregateinformation_id')),
2218        Column('mo_acquisition_documentation', Integer, ForeignKey('mo_acquisition.mo_acquisition_id')),
2219        Column('mo_operation_documentation', Integer, ForeignKey('mo_operation.mo_operation_id')),
2220        Column('mo_processing_documentation', Integer, ForeignKey('mo_processing.mo_processing_id')),
2221        Column('dq_element_evaluationProcedure', Integer, ForeignKey('dq_element.dq_element_id')),
2222        Column('md_identifier_authority', Integer, ForeignKey('md_identifier.md_identifier_id', use_alter=True, name='fk_md_identifier')),
2223        Column('md_keywords_thesaurusName', Integer, ForeignKey('md_keywords.md_keywords_id')),
2224        Column('md_identification_citation', Integer, ForeignKey('md_identification.md_identification_id')),
2225        Column('li_source_sourceCitation', Integer, ForeignKey('li_source.li_source_id')),
2226        Column('ISSN', TEXT , nullable=True),
2227        Column('otherCitationDetails', TEXT , nullable=True),
2228        Column('edition', TEXT , nullable=True),
2229        Column('alternateTitle', ARRAY(TEXT) , nullable=True),
2230        Column('collectiveTitle', TEXT , nullable=True),
2231        Column('title', TEXT , nullable=False),
2232        Column('ISBN', TEXT , nullable=True),
2233        Column('presentationForm', CI_PresentationFormCode.db_type() , nullable=True),
2234Column('t_type', String(30), nullable=False, default='ci_citation'),
2235        extend_existing=False,)
2236 
2237 
2238
2239
2240
2241
2242
2243
2244
2245
2246
2247
2248md_portrayalcataloguereference_table = Table('md_portrayalcataloguereference', metadata,
2249        Column('md_portrayalcataloguereference_id', Integer, Sequence('md_portrayalcataloguereference_id_seq'), primary_key=True),
2250        Column('md_metadata_portrayalCatalogueInfo', Integer, ForeignKey('md_metadata.md_metadata_id')),
2251Column('t_type', String(30), nullable=False, default='md_portrayalcataloguereference'),
2252        extend_existing=False,)
2253 
2254 
2255
2256
2257
2258
2259
2260
2261
2262
2263
2264
2265mo_processing_table = Table('mo_processing', metadata,
2266        Column('mo_processing_id', Integer, Sequence('mo_processing_id_seq'), primary_key=True),
2267                                Column('mo_computation_id', Integer, ForeignKey('mo_computation.mo_computation_id')),   Column('description', TEXT , nullable=True),
2268Column('t_type', String(30), nullable=False, default='mo_processing'),
2269        extend_existing=False,)
2270 
2271 
2272mo_computation_mo_processing_table = Table('mo_computation_mo_processing', metadata,
2273        Column('left_node_id', Integer, ForeignKey(mo_computation_table.c.mo_computation_id)),
2274        Column('right_node_id', Integer, ForeignKey(mo_processing_table.c.mo_processing_id))
2275)
2276mo_project_ceda_project_table = Table('mo_project_ceda_project', metadata,
2277        Column('left_node_id', Integer, ForeignKey(mo_project_table.c.mo_project_id)),
2278        Column('right_node_id', Integer, ForeignKey(ceda_project_table.c.ceda_project_id))
2279)
2280mo_compositeprocess_ceda_compositeprocess_table = Table('mo_compositeprocess_ceda_compositeprocess', metadata,
2281        Column('left_node_id', Integer, ForeignKey(mo_compositeprocess_table.c.mo_compositeprocess_id)),
2282        Column('right_node_id', Integer, ForeignKey(ceda_compositeprocess_table.c.ceda_compositeprocess_id))
2283)
2284tm_geometricprimitive_tm_instant_table = Table('tm_geometricprimitive_tm_instant', metadata,
2285        Column('left_node_id', Integer, ForeignKey(tm_geometricprimitive_table.c.tm_geometricprimitive_id)),
2286        Column('right_node_id', Integer, ForeignKey(tm_instant_table.c.tm_instant_id))
2287)
2288ceda_process_ceda_processing_table = Table('ceda_process_ceda_processing', metadata,
2289        Column('left_node_id', Integer, ForeignKey(ceda_process_table.c.ceda_process_id)),
2290        Column('right_node_id', Integer, ForeignKey(ceda_processing_table.c.ceda_processing_id))
2291)
2292mo_result_ceda_result_table = Table('mo_result_ceda_result', metadata,
2293        Column('left_node_id', Integer, ForeignKey(mo_result_table.c.mo_result_id)),
2294        Column('right_node_id', Integer, ForeignKey(ceda_result_table.c.ceda_result_id))
2295)
2296mo_observation_ceda_observation_table = Table('mo_observation_ceda_observation', metadata,
2297        Column('left_node_id', Integer, ForeignKey(mo_observation_table.c.mo_observation_id)),
2298        Column('right_node_id', Integer, ForeignKey(ceda_observation_table.c.ceda_observation_id))
2299)
2300mo_platform_ceda_platform_table = Table('mo_platform_ceda_platform', metadata,
2301        Column('left_node_id', Integer, ForeignKey(mo_platform_table.c.mo_platform_id)),
2302        Column('right_node_id', Integer, ForeignKey(ceda_platform_table.c.ceda_platform_id))
2303)
2304genericname_scopedname_table = Table('genericname_scopedname', metadata,
2305        Column('left_node_id', Integer, ForeignKey(genericname_table.c.genericname_id)),
2306        Column('right_node_id', Integer, ForeignKey(scopedname_table.c.scopedname_id))
2307)
2308genericname_localname_table = Table('genericname_localname', metadata,
2309        Column('left_node_id', Integer, ForeignKey(genericname_table.c.genericname_id)),
2310        Column('right_node_id', Integer, ForeignKey(localname_table.c.localname_id))
2311)
2312tm_geometricprimitive_tm_period_table = Table('tm_geometricprimitive_tm_period', metadata,
2313        Column('left_node_id', Integer, ForeignKey(tm_geometricprimitive_table.c.tm_geometricprimitive_id)),
2314        Column('right_node_id', Integer, ForeignKey(tm_period_table.c.tm_period_id))
2315)
2316md_identifier_rs_identifier_table = Table('md_identifier_rs_identifier', metadata,
2317        Column('left_node_id', Integer, ForeignKey(md_identifier_table.c.md_identifier_id)),
2318        Column('right_node_id', Integer, ForeignKey(rs_identifier_table.c.rs_identifier_id))
2319)
2320mo_observationcollection_ceda_observationcollection_table = Table('mo_observationcollection_ceda_observationcollection', metadata,
2321        Column('left_node_id', Integer, ForeignKey(mo_observationcollection_table.c.mo_observationcollection_id)),
2322        Column('right_node_id', Integer, ForeignKey(ceda_observationcollection_table.c.ceda_observationcollection_id))
2323)
2324mo_acquisition_ceda_acquisition_table = Table('mo_acquisition_ceda_acquisition', metadata,
2325        Column('left_node_id', Integer, ForeignKey(mo_acquisition_table.c.mo_acquisition_id)),
2326        Column('right_node_id', Integer, ForeignKey(ceda_acquisition_table.c.ceda_acquisition_id))
2327)
2328rs_referencesystem_sc_crs_table = Table('rs_referencesystem_sc_crs', metadata,
2329        Column('left_node_id', Integer, ForeignKey(rs_referencesystem_table.c.rs_referencesystem_id)),
2330        Column('right_node_id', Integer, ForeignKey(sc_crs_table.c.sc_crs_id))
2331)
2332measure_time_table = Table('measure_time', metadata,
2333        Column('left_node_id', Integer, ForeignKey(measure_table.c.measure_id)),
2334        Column('right_node_id', Integer, ForeignKey(time_table.c.time_id))
2335)
2336ci_onlineresource_mo_onlineresource_table = Table('ci_onlineresource_mo_onlineresource', metadata,
2337        Column('left_node_id', Integer, ForeignKey(ci_onlineresource_table.c.ci_onlineresource_id)),
2338        Column('right_node_id', Integer, ForeignKey(mo_onlineresource_table.c.mo_onlineresource_id))
2339)
2340mo_operation_ceda_operation_table = Table('mo_operation_ceda_operation', metadata,
2341        Column('left_node_id', Integer, ForeignKey(mo_operation_table.c.mo_operation_id)),
2342        Column('right_node_id', Integer, ForeignKey(ceda_operation_table.c.ceda_operation_id))
2343)
2344gf_propertytype_gf_attributetype_table = Table('gf_propertytype_gf_attributetype', metadata,
2345        Column('left_node_id', Integer, ForeignKey(gf_propertytype_table.c.gf_propertytype_id)),
2346        Column('right_node_id', Integer, ForeignKey(gf_attributetype_table.c.gf_attributetype_id))
2347)
2348om_observation_mo_observation_table = Table('om_observation_mo_observation', metadata,
2349        Column('left_node_id', Integer, ForeignKey(om_observation_table.c.om_observation_id)),
2350        Column('right_node_id', Integer, ForeignKey(mo_observation_table.c.mo_observation_id))
2351)
2352ceda_process_ceda_acquisition_table = Table('ceda_process_ceda_acquisition', metadata,
2353        Column('left_node_id', Integer, ForeignKey(ceda_process_table.c.ceda_process_id)),
2354        Column('right_node_id', Integer, ForeignKey(ceda_acquisition_table.c.ceda_acquisition_id))
2355)
2356unitofmeasure_uomlength_table = Table('unitofmeasure_uomlength', metadata,
2357        Column('left_node_id', Integer, ForeignKey(unitofmeasure_table.c.unitofmeasure_id)),
2358        Column('right_node_id', Integer, ForeignKey(uomlength_table.c.uomlength_id))
2359)
2360mo_instrument_ceda_instrument_table = Table('mo_instrument_ceda_instrument', metadata,
2361        Column('left_node_id', Integer, ForeignKey(mo_instrument_table.c.mo_instrument_id)),
2362        Column('right_node_id', Integer, ForeignKey(ceda_instrument_table.c.ceda_instrument_id))
2363)
2364tm_object_tm_primitive_table = Table('tm_object_tm_primitive', metadata,
2365        Column('left_node_id', Integer, ForeignKey(tm_object_table.c.tm_object_id)),
2366        Column('right_node_id', Integer, ForeignKey(tm_primitive_table.c.tm_primitive_id))
2367)
2368mo_process_mo_computation_table = Table('mo_process_mo_computation', metadata,
2369        Column('left_node_id', Integer, ForeignKey(mo_process_table.c.mo_process_id)),
2370        Column('right_node_id', Integer, ForeignKey(mo_computation_table.c.mo_computation_id))
2371)
2372mo_process_mo_acquisition_table = Table('mo_process_mo_acquisition', metadata,
2373        Column('left_node_id', Integer, ForeignKey(mo_process_table.c.mo_process_id)),
2374        Column('right_node_id', Integer, ForeignKey(mo_acquisition_table.c.mo_acquisition_id))
2375)
2376mo_process_mo_compositeprocess_table = Table('mo_process_mo_compositeprocess', metadata,
2377        Column('left_node_id', Integer, ForeignKey(mo_process_table.c.mo_process_id)),
2378        Column('right_node_id', Integer, ForeignKey(mo_compositeprocess_table.c.mo_compositeprocess_id))
2379)
2380tm_primitive_tm_geometricprimitive_table = Table('tm_primitive_tm_geometricprimitive', metadata,
2381        Column('left_node_id', Integer, ForeignKey(tm_primitive_table.c.tm_primitive_id)),
2382        Column('right_node_id', Integer, ForeignKey(tm_geometricprimitive_table.c.tm_geometricprimitive_id))
2383)
2384date_datetime_table = Table('date_datetime', metadata,
2385        Column('left_node_id', Integer, ForeignKey(date_table.c.date_id)),
2386        Column('right_node_id', Integer, ForeignKey(datetime_table.c.datetime_id))
2387)
2388om_process_mo_process_table = Table('om_process_mo_process', metadata,
2389        Column('left_node_id', Integer, ForeignKey(om_process_table.c.om_process_id)),
2390        Column('right_node_id', Integer, ForeignKey(mo_process_table.c.mo_process_id))
2391)
2392localname_typename_table = Table('localname_typename', metadata,
2393        Column('left_node_id', Integer, ForeignKey(localname_table.c.localname_id)),
2394        Column('right_node_id', Integer, ForeignKey(typename_table.c.typename_id))
2395)
2396tm_duration_tm_periodduration_table = Table('tm_duration_tm_periodduration', metadata,
2397        Column('left_node_id', Integer, ForeignKey(tm_duration_table.c.tm_duration_id)),
2398        Column('right_node_id', Integer, ForeignKey(tm_periodduration_table.c.tm_periodduration_id))
2399)
2400ex_geographicextent_ex_geographicdescription_table = Table('ex_geographicextent_ex_geographicdescription', metadata,
2401        Column('left_node_id', Integer, ForeignKey(ex_geographicextent_table.c.ex_geographicextent_id)),
2402        Column('right_node_id', Integer, ForeignKey(ex_geographicdescription_table.c.ex_geographicdescription_id))
2403)
2404unitofmeasure_uomscale_table = Table('unitofmeasure_uomscale', metadata,
2405        Column('left_node_id', Integer, ForeignKey(unitofmeasure_table.c.unitofmeasure_id)),
2406        Column('right_node_id', Integer, ForeignKey(uomscale_table.c.uomscale_id))
2407)
2408mo_processing_ceda_processing_table = Table('mo_processing_ceda_processing', metadata,
2409        Column('left_node_id', Integer, ForeignKey(mo_processing_table.c.mo_processing_id)),
2410        Column('right_node_id', Integer, ForeignKey(ceda_processing_table.c.ceda_processing_id))
2411)
2412clocktime_datetime_table = Table('clocktime_datetime', metadata,
2413        Column('left_node_id', Integer, ForeignKey(clocktime_table.c.clocktime_id)),
2414        Column('right_node_id', Integer, ForeignKey(datetime_table.c.datetime_id))
2415)
2416measure_scale_table = Table('measure_scale', metadata,
2417        Column('left_node_id', Integer, ForeignKey(measure_table.c.measure_id)),
2418        Column('right_node_id', Integer, ForeignKey(scale_table.c.scale_id))
2419)
2420ceda_process_ceda_compositeprocess_table = Table('ceda_process_ceda_compositeprocess', metadata,
2421        Column('left_node_id', Integer, ForeignKey(ceda_process_table.c.ceda_process_id)),
2422        Column('right_node_id', Integer, ForeignKey(ceda_compositeprocess_table.c.ceda_compositeprocess_id))
2423)
2424mo_process_ceda_process_table = Table('mo_process_ceda_process', metadata,
2425        Column('left_node_id', Integer, ForeignKey(mo_process_table.c.mo_process_id)),
2426        Column('right_node_id', Integer, ForeignKey(ceda_process_table.c.ceda_process_id))
2427)
2428io_identifiedobjectbase_sc_crs_table = Table('io_identifiedobjectbase_sc_crs', metadata,
2429        Column('left_node_id', Integer, ForeignKey(io_identifiedobjectbase_table.c.io_identifiedobjectbase_id)),
2430        Column('right_node_id', Integer, ForeignKey(sc_crs_table.c.sc_crs_id))
2431)
2432
2433
2434
2435mapper(CI_Series, ci_series_table, properties  = {})
2436
2437
2438
2439
2440mapper(ClockTime, clocktime_table, properties  = {})
2441
2442
2443
2444
2445mapper(MD_Distribution, md_distribution_table, properties  = {})
2446
2447
2448
2449
2450mapper(CI_Telephone, ci_telephone_table, properties  = {})
2451
2452
2453
2454
2455mapper(MD_ContentInformation, md_contentinformation_table, properties  = {})
2456
2457
2458
2459
2460mapper(MO_ResponsiblePartyInfo, mo_responsiblepartyinfo_table, properties  = {})
2461
2462
2463
2464
2465mapper(Multiplicity, multiplicity_table, properties  = {})
2466
2467
2468
2469
2470mapper(TM_TemporalPosition, tm_temporalposition_table, properties  = {})
2471
2472
2473
2474
2475mapper(GenericName, genericname_table, properties  = {})
2476
2477
2478
2479
2480mapper(OM_Process, om_process_table, properties  = {})
2481
2482
2483
2484
2485mapper(GF_Constraint, gf_constraint_table, properties  = {})
2486
2487
2488
2489
2490mapper(Any, any_table, properties  = {})
2491
2492
2493
2494
2495mapper(GM_Object, gm_object_table, properties  = {})
2496
2497
2498
2499
2500mapper(CEDA_Citation, ceda_citation_table, properties  = {})
2501
2502
2503
2504
2505mapper(DatePrecision, dateprecision_table, properties  = {})
2506
2507
2508
2509
2510mapper(MD_SpatialRepresentation, md_spatialrepresentation_table, properties  = {})
2511
2512
2513
2514
2515mapper(MD_Format, md_format_table, properties  = {})
2516
2517
2518
2519
2520mapper(UnitOfMeasure, unitofmeasure_table, properties  = {})
2521
2522
2523
2524
2525mapper(TM_Duration, tm_duration_table, properties  = {})
2526
2527
2528
2529
2530mapper(Measure, measure_table, properties  = {})
2531
2532
2533
2534
2535mapper(CI_Address, ci_address_table, properties  = {})
2536
2537
2538
2539
2540
2541
2542
2543
2544mapper(TM_Object, tm_object_table, properties  = {})
2545
2546
2547
2548
2549mapper(DQ_Result, dq_result_table, properties  = {})
2550
2551
2552
2553
2554mapper(URL, url_table, properties  = {})
2555
2556
2557
2558
2559mapper(EX_GeographicExtent, ex_geographicextent_table, properties  = {})
2560
2561
2562
2563
2564mapper(MD_BrowseGraphic, md_browsegraphic_table, properties  = {})
2565
2566
2567
2568
2569mapper(MD_Constraints, md_constraints_table, properties  = {})
2570
2571
2572
2573
2574mapper(Time, time_table, properties  = {        '_measure': relationship(Measure, 
2575secondary=measure_time_table
2576, uselist=False
2577)})
2578
2579
2580
2581
2582mapper(ScopedName, scopedname_table, properties  = {    '_genericname': relationship(GenericName, 
2583secondary=genericname_scopedname_table
2584, uselist=False
2585)})
2586
2587
2588
2589
2590mapper(NamedValue, namedvalue_table, properties  = {    'name': relationship(GenericName, uselist=False
2591, primaryjoin=genericname_table.c.namedvalue_name==namedvalue_table.c.namedvalue_id
2592),      'value': relationship(Any, uselist=False
2593, primaryjoin=any_table.c.namedvalue_value==namedvalue_table.c.namedvalue_id
2594)})
2595
2596
2597
2598
2599mapper(TM_Primitive, tm_primitive_table, properties  = {        '_tm_object': relationship(TM_Object, 
2600secondary=tm_object_tm_primitive_table
2601, uselist=False
2602)})
2603
2604
2605
2606
2607mapper(UomScale, uomscale_table, properties  = {        '_unitofmeasure': relationship(UnitOfMeasure, 
2608secondary=unitofmeasure_uomscale_table
2609, uselist=False
2610)})
2611
2612
2613
2614
2615mapper(TM_PeriodDuration, tm_periodduration_table, properties  = {      '_tm_duration': relationship(TM_Duration, 
2616secondary=tm_duration_tm_periodduration_table
2617, uselist=False
2618)})
2619
2620
2621
2622
2623mapper(Date, date_table, properties  = {        'precision': relationship(DatePrecision, uselist=False
2624, primaryjoin=dateprecision_table.c.date_precision==date_table.c.date_id
2625)})
2626
2627
2628
2629
2630mapper(MO_Process, mo_process_table, properties  = {    '_om_process': relationship(OM_Process, 
2631secondary=om_process_mo_process_table
2632, uselist=False
2633)})
2634
2635
2636
2637
2638mapper(MO_InputOutput, mo_inputoutput_table, properties  = {    'name': relationship(GenericName, uselist=False
2639, primaryjoin=genericname_table.c.mo_inputoutput_name==mo_inputoutput_table.c.mo_inputoutput_id
2640)})
2641
2642
2643
2644
2645mapper(MO_Computation, mo_computation_table, properties  = {    '_mo_process': relationship(MO_Process, 
2646secondary=mo_process_mo_computation_table
2647, uselist=False
2648)})
2649
2650
2651
2652
2653mapper(CI_OnlineResource, ci_onlineresource_table, properties  = {      'linkage': relationship(URL, uselist=False
2654, primaryjoin=url_table.c.ci_onlineresource_linkage==ci_onlineresource_table.c.ci_onlineresource_id
2655)})
2656
2657
2658
2659
2660mapper(LocalName, localname_table, properties  = {      '_genericname': relationship(GenericName, 
2661secondary=genericname_localname_table
2662, uselist=False
2663)})
2664
2665
2666
2667
2668mapper(UomLength, uomlength_table, properties  = {      '_unitofmeasure': relationship(UnitOfMeasure, 
2669secondary=unitofmeasure_uomlength_table
2670, uselist=False
2671)})
2672
2673
2674
2675
2676mapper(CEDA_Process, ceda_process_table, properties  = {        '_mo_process': relationship(MO_Process, 
2677secondary=mo_process_ceda_process_table
2678, uselist=False
2679)})
2680
2681
2682
2683
2684mapper(MO_OnlineResource, mo_onlineresource_table, properties  = {      '_ci_onlineresource': relationship(CI_OnlineResource, 
2685secondary=ci_onlineresource_mo_onlineresource_table
2686, uselist=False
2687)})
2688
2689
2690
2691
2692mapper(Scale, scale_table, properties  = {      'targetUnits': relationship(UomLength, uselist=False
2693, primaryjoin=uomlength_table.c.scale_targetUnits==scale_table.c.scale_id
2694),      'uom': relationship(UomScale, uselist=False
2695, primaryjoin=uomscale_table.c.scale_uom==scale_table.c.scale_id
2696),      '_measure': relationship(Measure, 
2697secondary=measure_scale_table
2698, uselist=False
2699),      'sourceUnits': relationship(UomLength, uselist=False
2700, primaryjoin=uomlength_table.c.scale_sourceUnits==scale_table.c.scale_id
2701)})
2702
2703
2704
2705
2706mapper(TypeName, typename_table, properties  = {        '_localname': relationship(LocalName, 
2707secondary=localname_typename_table
2708, uselist=False
2709)})
2710
2711
2712
2713
2714mapper(MO_Result, mo_result_table, properties  = {      'source': relationship(MO_OnlineResource
2715, primaryjoin=mo_onlineresource_table.c.mo_result_source==mo_result_table.c.mo_result_id
2716),      'sample': relationship(MO_OnlineResource
2717, primaryjoin=mo_onlineresource_table.c.mo_result_sample==mo_result_table.c.mo_result_id
2718)})
2719
2720
2721
2722
2723mapper(DateTime, datetime_table, properties  = {        '_clocktime': relationship(ClockTime, 
2724secondary=clocktime_datetime_table
2725, uselist=False
2726),      '_date': relationship(Date, 
2727secondary=date_datetime_table
2728, uselist=False
2729)})
2730
2731
2732
2733
2734mapper(GF_FeatureType, gf_featuretype_table, properties  = {    'typeName': relationship(LocalName, uselist=False
2735, primaryjoin=localname_table.c.gf_featuretype_typeName==gf_featuretype_table.c.gf_featuretype_id
2736),      'constrainedBy': relationship(GF_Constraint, uselist=False
2737, primaryjoin=gf_constraint_table.c.gf_featuretype_constrainedBy==gf_featuretype_table.c.gf_featuretype_id
2738)})
2739
2740
2741
2742
2743mapper(CEDA_Result, ceda_result_table, properties  = {  '_mo_result': relationship(MO_Result, 
2744secondary=mo_result_ceda_result_table
2745, uselist=False
2746)})
2747
2748
2749
2750
2751mapper(GF_PropertyType, gf_propertytype_table, properties  = {  'constrainedBy': relationship(GF_Constraint, uselist=False
2752, primaryjoin=gf_constraint_table.c.gf_propertytype_constrainedBy==gf_propertytype_table.c.gf_propertytype_id
2753),      'memberName': relationship(LocalName, uselist=False
2754, primaryjoin=localname_table.c.gf_propertytype_memberName==gf_propertytype_table.c.gf_propertytype_id
2755)})
2756
2757
2758
2759
2760mapper(CI_Date, ci_date_table, properties  = {  'date': relationship(Date, uselist=False
2761, primaryjoin=date_table.c.ci_date_date==ci_date_table.c.ci_date_id
2762)})
2763
2764
2765
2766
2767mapper(TM_GeometricPrimitive, tm_geometricprimitive_table, properties  = {      '_tm_primitive': relationship(TM_Primitive, 
2768secondary=tm_primitive_tm_geometricprimitive_table
2769, uselist=False
2770)})
2771
2772
2773
2774
2775mapper(EX_TemporalExtent, ex_temporalextent_table, properties  = {      'extent': relationship(TM_Primitive, uselist=False
2776, primaryjoin=tm_primitive_table.c.ex_temporalextent_extent==ex_temporalextent_table.c.ex_temporalextent_id
2777)})
2778
2779
2780
2781
2782mapper(CEDA_Notes, ceda_notes_table, properties  = {    'date': relationship(DateTime, uselist=False
2783, primaryjoin=datetime_table.c.ceda_notes_date==ceda_notes_table.c.ceda_notes_id
2784),      'commentator': relationship(MO_ResponsiblePartyInfo, uselist=False
2785, primaryjoin=mo_responsiblepartyinfo_table.c.ceda_notes_commentator==ceda_notes_table.c.ceda_notes_id
2786)})
2787
2788
2789
2790
2791mapper(CI_Contact, ci_contact_table, properties  = {    'address': relationship(CI_Address, uselist=False
2792, primaryjoin=ci_address_table.c.ci_contact_address==ci_contact_table.c.ci_contact_id
2793),      'phone': relationship(CI_Telephone, uselist=False
2794, primaryjoin=ci_telephone_table.c.ci_contact_phone==ci_contact_table.c.ci_contact_id
2795),      'onlineResource': relationship(CI_OnlineResource, uselist=False
2796, primaryjoin=ci_onlineresource_table.c.ci_contact_onlineResource==ci_contact_table.c.ci_contact_id
2797)})
2798
2799
2800
2801
2802mapper(TM_Position, tm_position_table, properties  = {  'dateTime8601': relationship(DateTime, uselist=False
2803, primaryjoin=datetime_table.c.tm_position_dateTime8601==tm_position_table.c.tm_position_id
2804),      'anyOther': relationship(TM_TemporalPosition, uselist=False
2805, primaryjoin=tm_temporalposition_table.c.tm_position_anyOther==tm_position_table.c.tm_position_id
2806),      'time8601': relationship(Time, uselist=False
2807, primaryjoin=time_table.c.tm_position_time8601==tm_position_table.c.tm_position_id
2808),      'date8601': relationship(Date, uselist=False
2809, primaryjoin=date_table.c.tm_position_date8601==tm_position_table.c.tm_position_id
2810)})
2811
2812
2813
2814
2815mapper(TM_Period, tm_period_table, properties  = {      '_tm_geometricprimitive': relationship(TM_GeometricPrimitive, 
2816secondary=tm_geometricprimitive_tm_period_table
2817, uselist=False
2818)})
2819
2820
2821
2822
2823mapper(MD_RepresentativeFraction, md_representativefraction_table, properties  = {      'equivalentScale': relationship(Scale, uselist=False
2824, primaryjoin=scale_table.c.md_representativefraction_equivalentScale==md_representativefraction_table.c.md_representativefraction_id
2825)})
2826
2827
2828
2829
2830mapper(CI_ResponsibleParty, ci_responsibleparty_table, properties  = {  'contactInfo': relationship(CI_Contact, uselist=False
2831, primaryjoin=ci_contact_table.c.ci_responsibleparty_contactInfo==ci_responsibleparty_table.c.ci_responsibleparty_id
2832)})
2833
2834
2835
2836
2837mapper(LI_ProcessStep, li_processstep_table, properties  = {    'processor': relationship(CI_ResponsibleParty
2838, primaryjoin=ci_responsibleparty_table.c.li_processstep_processor==li_processstep_table.c.li_processstep_id
2839),      'dateTime': relationship(DateTime, uselist=False
2840, primaryjoin=datetime_table.c.li_processstep_dateTime==li_processstep_table.c.li_processstep_id
2841)})
2842
2843
2844
2845
2846mapper(GF_AttributeType, gf_attributetype_table, properties  = {        '_gf_propertytype': relationship(GF_PropertyType, 
2847secondary=gf_propertytype_gf_attributetype_table
2848, uselist=False
2849),      'cardinality': relationship(Multiplicity, uselist=False
2850, primaryjoin=multiplicity_table.c.gf_attributetype_cardinality==gf_attributetype_table.c.gf_attributetype_id
2851),      'valueType': relationship(TypeName, uselist=False
2852, primaryjoin=typename_table.c.gf_attributetype_valueType==gf_attributetype_table.c.gf_attributetype_id
2853)})
2854
2855
2856
2857
2858mapper(MD_Usage, md_usage_table, properties  = {        'userContactInfo': relationship(CI_ResponsibleParty
2859, primaryjoin=ci_responsibleparty_table.c.md_usage_userContactInfo==md_usage_table.c.md_usage_id
2860),      'usageDateTime': relationship(DateTime, uselist=False
2861, primaryjoin=datetime_table.c.md_usage_usageDateTime==md_usage_table.c.md_usage_id
2862)})
2863
2864
2865
2866
2867mapper(TM_Instant, tm_instant_table, properties  = {    'position': relationship(TM_Position, uselist=False
2868, primaryjoin=tm_position_table.c.tm_instant_position==tm_instant_table.c.tm_instant_id
2869),      '_tm_geometricprimitive': relationship(TM_GeometricPrimitive, 
2870secondary=tm_geometricprimitive_tm_instant_table
2871, uselist=False
2872)})
2873
2874
2875
2876
2877mapper(CEDA_Review, ceda_review_table, properties  = {  'notes': relationship(CEDA_Notes
2878, primaryjoin=ceda_notes_table.c.ceda_review_notes==ceda_review_table.c.ceda_review_id
2879),      'reviewer': relationship(MO_ResponsiblePartyInfo, uselist=False
2880, primaryjoin=mo_responsiblepartyinfo_table.c.ceda_review_reviewer==ceda_review_table.c.ceda_review_id
2881)})
2882
2883
2884
2885
2886mapper(MD_ScopeDescription, md_scopedescription_table, properties  = {  'attributeInstances': relationship(GF_AttributeType
2887, primaryjoin=gf_attributetype_table.c.md_scopedescription_attributeInstances==md_scopedescription_table.c.md_scopedescription_id
2888),      'attributes': relationship(GF_AttributeType
2889, primaryjoin=gf_attributetype_table.c.md_scopedescription_attributes==md_scopedescription_table.c.md_scopedescription_id
2890),      'features': relationship(GF_FeatureType
2891, primaryjoin=gf_featuretype_table.c.md_scopedescription_features==md_scopedescription_table.c.md_scopedescription_id
2892),      'featureInstances': relationship(GF_FeatureType
2893, primaryjoin=gf_featuretype_table.c.md_scopedescription_featureInstances==md_scopedescription_table.c.md_scopedescription_id
2894)})
2895
2896
2897
2898
2899mapper(MD_ExtendedElementInformation, md_extendedelementinformation_table, properties  = {      'source': relationship(CI_ResponsibleParty
2900, primaryjoin=ci_responsibleparty_table.c.md_extendedelementinformation_source==md_extendedelementinformation_table.c.md_extendedelementinformation_id
2901)})
2902
2903
2904
2905
2906mapper(MD_MetadataExtensionInformation, md_metadataextensioninformation_table, properties  = {  'extensionOnLineResource': relationship(CI_OnlineResource, uselist=False
2907, primaryjoin=ci_onlineresource_table.c.md_metadataextensioninformation_extensionOnLineResource==md_metadataextensioninformation_table.c.md_metadataextensioninformation_id
2908),      'extendedElementInformation': relationship(MD_ExtendedElementInformation, uselist=False
2909, primaryjoin=md_extendedelementinformation_table.c.md_metadataextensioninformation_extendedElementInformation==md_metadataextensioninformation_table.c.md_metadataextensioninformation_id
2910)})
2911
2912
2913
2914
2915mapper(MD_MaintenanceInformation, md_maintenanceinformation_table, properties  = {      'contact': relationship(CI_ResponsibleParty
2916, primaryjoin=ci_responsibleparty_table.c.md_maintenanceinformation_contact==md_maintenanceinformation_table.c.md_maintenanceinformation_id
2917),      'dateOfNextUpdate': relationship(Date, uselist=False
2918, primaryjoin=date_table.c.md_maintenanceinformation_dateOfNextUpdate==md_maintenanceinformation_table.c.md_maintenanceinformation_id
2919),      'updateScopeDescription': relationship(MD_ScopeDescription
2920, primaryjoin=md_scopedescription_table.c.md_maintenanceinformation_updateScopeDescription==md_maintenanceinformation_table.c.md_maintenanceinformation_id
2921),      'userDefinedMaintenanceFrequency': relationship(TM_PeriodDuration, uselist=False
2922, primaryjoin=tm_periodduration_table.c.md_maintenanceinformation_userDefinedMaintenanceFrequency==md_maintenanceinformation_table.c.md_maintenanceinformation_id
2923)})
2924
2925
2926mapper(MD_AggregateInformation, md_aggregateinformation_table)
2927
2928
2929mapper(MO_Location, mo_location_table)
2930
2931
2932mapper(MO_ObservationCollection, mo_observationcollection_table)
2933
2934
2935mapper(RS_ReferenceSystem, rs_referencesystem_table)
2936
2937
2938mapper(MO_Platform, mo_platform_table)
2939
2940
2941mapper(MD_Identifier, md_identifier_table)
2942
2943
2944mapper(EX_VerticalExtent, ex_verticalextent_table)
2945
2946
2947mapper(EX_Extent, ex_extent_table)
2948
2949
2950mapper(DQ_DataQuality, dq_dataquality_table)
2951
2952
2953mapper(MO_Instrument, mo_instrument_table)
2954
2955
2956mapper(LI_Lineage, li_lineage_table)
2957
2958
2959mapper(MO_InstrumentPlatformPair, mo_instrumentplatformpair_table)
2960
2961
2962mapper(MD_ApplicationSchemaInformation, md_applicationschemainformation_table)
2963
2964
2965mapper(DQ_Scope, dq_scope_table)
2966
2967
2968mapper(DQ_Element, dq_element_table)
2969
2970
2971mapper(MD_Metadata, md_metadata_table)
2972
2973
2974mapper(MD_Identification, md_identification_table)
2975
2976
2977mapper(LI_Source, li_source_table)
2978
2979
2980mapper(CI_Citation, ci_citation_table)
2981
2982
2983mapper(MO_Operation, mo_operation_table)
2984
2985
2986mapper(IO_IdentifiedObjectBase, io_identifiedobjectbase_table)
2987
2988
2989mapper(MD_ReferenceSystem, md_referencesystem_table)
2990
2991
2992mapper(OM_Observation, om_observation_table)
2993
2994
2995mapper(MD_Keywords, md_keywords_table)
2996
2997
2998mapper(MO_Project, mo_project_table)
2999
3000
3001mapper(MD_PortrayalCatalogueReference, md_portrayalcataloguereference_table)
3002
3003
3004mapper(CEDA_ObservationCollection, ceda_observationcollection_table)
3005
3006
3007mapper(EX_GeographicDescription, ex_geographicdescription_table)
3008
3009
3010mapper(MO_CompositeProcess, mo_compositeprocess_table)
3011
3012
3013mapper(MO_Observation, mo_observation_table)
3014
3015
3016mapper(CEDA_CompositeProcess, ceda_compositeprocess_table)
3017
3018
3019mapper(SC_CRS, sc_crs_table)
3020
3021
3022mapper(CEDA_Operation, ceda_operation_table)
3023
3024
3025mapper(CEDA_Processing, ceda_processing_table)
3026
3027
3028mapper(CEDA_Project, ceda_project_table)
3029
3030
3031mapper(CEDA_Instrument, ceda_instrument_table)
3032
3033
3034mapper(CEDA_Observation, ceda_observation_table)
3035
3036
3037mapper(MO_Acquisition, mo_acquisition_table)
3038
3039
3040mapper(CEDA_Acquisition, ceda_acquisition_table)
3041
3042
3043mapper(RS_Identifier, rs_identifier_table)
3044
3045
3046mapper(CEDA_Platform, ceda_platform_table)
3047
3048
3049mapper(MO_Processing, mo_processing_table)
3050
3051
3052class_mapper(MD_AggregateInformation).add_properties({  'aggregateDataSetName': relationship(CI_Citation, uselist=False
3053, primaryjoin=ci_citation_table.c.md_aggregateinformation_aggregateDataSetName==md_aggregateinformation_table.c.md_aggregateinformation_id
3054),      'aggregateDataSetIdentifier': relationship(MD_Identifier, uselist=False
3055, primaryjoin=md_identifier_table.c.md_aggregateinformation_aggregateDataSetIdentifier==md_aggregateinformation_table.c.md_aggregateinformation_id
3056)})
3057
3058
3059class_mapper(MO_Location).add_properties({      'nameLocation': relationship(EX_GeographicDescription, uselist=False
3060, primaryjoin=ex_geographicdescription_table.c.mo_location_nameLocation==mo_location_table.c.mo_location_id
3061),      'geometryLocation': relationship(GM_Object, uselist=False
3062, primaryjoin=gm_object_table.c.mo_location_geometryLocation==mo_location_table.c.mo_location_id
3063)})
3064
3065
3066class_mapper(MO_ObservationCollection).add_properties({ 'geographicExtent': relationship(EX_GeographicExtent
3067, primaryjoin=ex_geographicextent_table.c.mo_observationcollection_geographicExtent==mo_observationcollection_table.c.mo_observationcollection_id
3068),      'member': relationship(MO_Observation, uselist=False
3069, primaryjoin=mo_observation_table.c.mo_observationcollection_member==mo_observationcollection_table.c.mo_observationcollection_id
3070),      'identifier': relationship(MD_Identifier
3071, primaryjoin=md_identifier_table.c.mo_observationcollection_identifier==mo_observationcollection_table.c.mo_observationcollection_id
3072),      'isoMetadata': relationship(MD_Metadata, uselist=False
3073, primaryjoin=md_metadata_table.c.mo_observationcollection_isoMetadata==mo_observationcollection_table.c.mo_observationcollection_id
3074),      'additionalMetadata': relationship(CI_OnlineResource
3075, primaryjoin=ci_onlineresource_table.c.mo_observationcollection_additionalMetadata==mo_observationcollection_table.c.mo_observationcollection_id
3076),      'verticalExtent': relationship(EX_VerticalExtent
3077, primaryjoin=ex_verticalextent_table.c.mo_observationcollection_verticalExtent==mo_observationcollection_table.c.mo_observationcollection_id
3078),      'phenomenonTime': relationship(TM_Object
3079, primaryjoin=tm_object_table.c.mo_observationcollection_phenomenonTime==mo_observationcollection_table.c.mo_observationcollection_id
3080)})
3081
3082
3083class_mapper(RS_ReferenceSystem).add_properties({       'domainOfValidity': relationship(EX_Extent, uselist=False
3084, primaryjoin=ex_extent_table.c.rs_referencesystem_domainOfValidity==rs_referencesystem_table.c.rs_referencesystem_id
3085),      'name': relationship(RS_Identifier, uselist=False
3086, primaryjoin=rs_identifier_table.c.rs_referencesystem_name==rs_referencesystem_table.c.rs_referencesystem_id
3087)})
3088
3089
3090class_mapper(MO_Platform).add_properties({      'identifier': relationship(MD_Identifier
3091, primaryjoin=md_identifier_table.c.mo_platform_identifier==mo_platform_table.c.mo_platform_id
3092),      'documentation': relationship(CI_Citation
3093, primaryjoin=ci_citation_table.c.mo_platform_documentation==mo_platform_table.c.mo_platform_id
3094),      'relatedParty': relationship(MO_ResponsiblePartyInfo
3095, primaryjoin=mo_responsiblepartyinfo_table.c.mo_platform_relatedParty==mo_platform_table.c.mo_platform_id
3096),      'location': relationship(MO_Location, uselist=False
3097, primaryjoin=mo_location_table.c.mo_platform_location==mo_platform_table.c.mo_platform_id
3098)})
3099
3100
3101class_mapper(MD_Identifier).add_properties({    'authority': relationship(CI_Citation, uselist=False
3102, primaryjoin=ci_citation_table.c.md_identifier_authority==md_identifier_table.c.md_identifier_id
3103)})
3104
3105
3106class_mapper(EX_VerticalExtent).add_properties({        'verticalCRS': relationship(SC_CRS, uselist=False
3107, primaryjoin=sc_crs_table.c.ex_verticalextent_verticalCRS==ex_verticalextent_table.c.ex_verticalextent_id
3108)})
3109
3110
3111class_mapper(EX_Extent).add_properties({        'verticalElement': relationship(EX_VerticalExtent, uselist=False
3112, primaryjoin=ex_verticalextent_table.c.ex_extent_verticalElement==ex_extent_table.c.ex_extent_id
3113),      'temporalElement': relationship(EX_TemporalExtent, uselist=False
3114, primaryjoin=ex_temporalextent_table.c.ex_extent_temporalElement==ex_extent_table.c.ex_extent_id
3115),      'geographicElement': relationship(EX_GeographicExtent, uselist=False
3116, primaryjoin=ex_geographicextent_table.c.ex_extent_geographicElement==ex_extent_table.c.ex_extent_id
3117)})
3118
3119
3120class_mapper(DQ_DataQuality).add_properties({   'report': relationship(DQ_Element, uselist=False
3121, primaryjoin=dq_element_table.c.dq_dataquality_report==dq_dataquality_table.c.dq_dataquality_id
3122),      'lineage': relationship(LI_Lineage, uselist=False
3123, primaryjoin=li_lineage_table.c.dq_dataquality_lineage==dq_dataquality_table.c.dq_dataquality_id
3124),      'scope': relationship(DQ_Scope, uselist=False
3125, primaryjoin=dq_scope_table.c.dq_dataquality_scope==dq_dataquality_table.c.dq_dataquality_id
3126)})
3127
3128
3129class_mapper(MO_Instrument).add_properties({    'realatedParty': relationship(MO_ResponsiblePartyInfo
3130, primaryjoin=mo_responsiblepartyinfo_table.c.mo_instrument_realatedParty==mo_instrument_table.c.mo_instrument_id
3131),      'documentation': relationship(CI_Citation
3132, primaryjoin=ci_citation_table.c.mo_instrument_documentation==mo_instrument_table.c.mo_instrument_id
3133),      'identifier': relationship(MD_Identifier
3134, primaryjoin=md_identifier_table.c.mo_instrument_identifier==mo_instrument_table.c.mo_instrument_id
3135),      'type': relationship(ScopedName, uselist=False
3136, primaryjoin=scopedname_table.c.mo_instrument_type==mo_instrument_table.c.mo_instrument_id
3137)})
3138
3139
3140class_mapper(LI_Lineage).add_properties({       'source': relationship(LI_Source, uselist=False
3141, primaryjoin=li_source_table.c.li_lineage_source==li_lineage_table.c.li_lineage_id
3142),      'processStep': relationship(LI_ProcessStep, uselist=False
3143, primaryjoin=li_processstep_table.c.li_lineage_processStep==li_lineage_table.c.li_lineage_id
3144)})
3145
3146
3147class_mapper(MO_InstrumentPlatformPair).add_properties({        'instrument': relationship(MO_Instrument, uselist=False
3148, primaryjoin=mo_instrument_table.c.mo_instrumentplatformpair_instrument==mo_instrumentplatformpair_table.c.mo_instrumentplatformpair_id
3149),      'platform': relationship(MO_Platform, uselist=False
3150, primaryjoin=mo_platform_table.c.mo_instrumentplatformpair_platform==mo_instrumentplatformpair_table.c.mo_instrumentplatformpair_id
3151)})
3152
3153
3154class_mapper(MD_ApplicationSchemaInformation).add_properties({  'name': relationship(CI_Citation, uselist=False
3155, primaryjoin=ci_citation_table.c.md_applicationschemainformation_name==md_applicationschemainformation_table.c.md_applicationschemainformation_id
3156)})
3157
3158
3159class_mapper(DQ_Scope).add_properties({ 'extent': relationship(EX_Extent, uselist=False
3160, primaryjoin=ex_extent_table.c.dq_scope_extent==dq_scope_table.c.dq_scope_id
3161),      'levelDescription': relationship(MD_ScopeDescription
3162, primaryjoin=md_scopedescription_table.c.dq_scope_levelDescription==dq_scope_table.c.dq_scope_id
3163)})
3164
3165
3166class_mapper(DQ_Element).add_properties({       'evaluationProcedure': relationship(CI_Citation, uselist=False
3167, primaryjoin=ci_citation_table.c.dq_element_evaluationProcedure==dq_element_table.c.dq_element_id
3168),      'result': relationship(DQ_Result
3169, primaryjoin=dq_result_table.c.dq_element_result==dq_element_table.c.dq_element_id
3170),      'dateTime': relationship(DateTime
3171, primaryjoin=datetime_table.c.dq_element_dateTime==dq_element_table.c.dq_element_id
3172),      'measureIdentification': relationship(MD_Identifier, uselist=False
3173, primaryjoin=md_identifier_table.c.dq_element_measureIdentification==dq_element_table.c.dq_element_id
3174)})
3175
3176
3177class_mapper(MD_Metadata).add_properties({      'portrayalCatalogueInfo': relationship(MD_PortrayalCatalogueReference, uselist=False
3178, primaryjoin=md_portrayalcataloguereference_table.c.md_metadata_portrayalCatalogueInfo==md_metadata_table.c.md_metadata_id
3179),      'applicationSchemaInfo': relationship(MD_ApplicationSchemaInformation, uselist=False
3180, primaryjoin=md_applicationschemainformation_table.c.md_metadata_applicationSchemaInfo==md_metadata_table.c.md_metadata_id
3181),      'identificationInfo': relationship(MD_Identification, uselist=False
3182, primaryjoin=md_identification_table.c.md_metadata_identificationInfo==md_metadata_table.c.md_metadata_id
3183),      'contentInfo': relationship(MD_ContentInformation, uselist=False
3184, primaryjoin=md_contentinformation_table.c.md_metadata_contentInfo==md_metadata_table.c.md_metadata_id
3185),      'distributionInfo': relationship(MD_Distribution, uselist=False
3186, primaryjoin=md_distribution_table.c.md_metadata_distributionInfo==md_metadata_table.c.md_metadata_id
3187),      'referenceSystemInfo': relationship(MD_ReferenceSystem, uselist=False
3188, primaryjoin=md_referencesystem_table.c.md_metadata_referenceSystemInfo==md_metadata_table.c.md_metadata_id
3189),      'spatialRepresentationInfo': relationship(MD_SpatialRepresentation, uselist=False
3190, primaryjoin=md_spatialrepresentation_table.c.md_metadata_spatialRepresentationInfo==md_metadata_table.c.md_metadata_id
3191),      'metadataConstraints': relationship(MD_Constraints, uselist=False
3192, primaryjoin=md_constraints_table.c.md_metadata_metadataConstraints==md_metadata_table.c.md_metadata_id
3193),      'metadataMaintenance': relationship(MD_MaintenanceInformation, uselist=False
3194, primaryjoin=md_maintenanceinformation_table.c.md_metadata_metadataMaintenance==md_metadata_table.c.md_metadata_id
3195),      'dataQualityInfo': relationship(DQ_DataQuality, uselist=False
3196, primaryjoin=dq_dataquality_table.c.md_metadata_dataQualityInfo==md_metadata_table.c.md_metadata_id
3197),      'metadataExtensionInfo': relationship(MD_MetadataExtensionInformation, uselist=False
3198, primaryjoin=md_metadataextensioninformation_table.c.md_metadata_metadataExtensionInfo==md_metadata_table.c.md_metadata_id
3199),      'dateStamp': relationship(Date, uselist=False
3200, primaryjoin=date_table.c.md_metadata_dateStamp==md_metadata_table.c.md_metadata_id
3201),      'contact': relationship(CI_ResponsibleParty
3202, primaryjoin=ci_responsibleparty_table.c.md_metadata_contact==md_metadata_table.c.md_metadata_id
3203)})
3204
3205
3206class_mapper(MD_Identification).add_properties({        'pointOfContact': relationship(CI_ResponsibleParty
3207, primaryjoin=ci_responsibleparty_table.c.md_identification_pointOfContact==md_identification_table.c.md_identification_id
3208),      'citation': relationship(CI_Citation, uselist=False
3209, primaryjoin=ci_citation_table.c.md_identification_citation==md_identification_table.c.md_identification_id
3210),      'aggregationInfo': relationship(MD_AggregateInformation, uselist=False
3211, primaryjoin=md_aggregateinformation_table.c.md_identification_aggregationInfo==md_identification_table.c.md_identification_id
3212),      'resourceFormat': relationship(MD_Format, uselist=False
3213, primaryjoin=md_format_table.c.md_identification_resourceFormat==md_identification_table.c.md_identification_id
3214),      'descriptiveKeywords': relationship(MD_Keywords, uselist=False
3215, primaryjoin=md_keywords_table.c.md_identification_descriptiveKeywords==md_identification_table.c.md_identification_id
3216),      'resourceMaintenance': relationship(MD_MaintenanceInformation, uselist=False
3217, primaryjoin=md_maintenanceinformation_table.c.md_identification_resourceMaintenance==md_identification_table.c.md_identification_id
3218),      'resourceConstraints': relationship(MD_Constraints, uselist=False
3219, primaryjoin=md_constraints_table.c.md_identification_resourceConstraints==md_identification_table.c.md_identification_id
3220),      'resourceSpecificUsage': relationship(MD_Usage, uselist=False
3221, primaryjoin=md_usage_table.c.md_identification_resourceSpecificUsage==md_identification_table.c.md_identification_id
3222),      'graphicOverview': relationship(MD_BrowseGraphic, uselist=False
3223, primaryjoin=md_browsegraphic_table.c.md_identification_graphicOverview==md_identification_table.c.md_identification_id
3224)})
3225
3226
3227class_mapper(LI_Source).add_properties({        'sourceExtent': relationship(EX_Extent
3228, primaryjoin=ex_extent_table.c.li_source_sourceExtent==li_source_table.c.li_source_id
3229),      'sourceCitation': relationship(CI_Citation, uselist=False
3230, primaryjoin=ci_citation_table.c.li_source_sourceCitation==li_source_table.c.li_source_id
3231),      'sourceReferenceSystem': relationship(MD_ReferenceSystem, uselist=False
3232, primaryjoin=md_referencesystem_table.c.li_source_sourceReferenceSystem==li_source_table.c.li_source_id
3233),      'scaleDenominator': relationship(MD_RepresentativeFraction, uselist=False
3234, primaryjoin=md_representativefraction_table.c.li_source_scaleDenominator==li_source_table.c.li_source_id
3235)})
3236
3237
3238class_mapper(CI_Citation).add_properties({      'editionDate': relationship(Date, uselist=False
3239, primaryjoin=date_table.c.ci_citation_editionDate==ci_citation_table.c.ci_citation_id
3240),      'citedResponsibleParty': relationship(CI_ResponsibleParty
3241, primaryjoin=ci_responsibleparty_table.c.ci_citation_citedResponsibleParty==ci_citation_table.c.ci_citation_id
3242),      'date': relationship(CI_Date
3243, primaryjoin=ci_date_table.c.ci_citation_date==ci_citation_table.c.ci_citation_id
3244),      'identifier': relationship(MD_Identifier
3245, primaryjoin=md_identifier_table.c.ci_citation_identifier==ci_citation_table.c.ci_citation_id
3246),      'series': relationship(CI_Series, uselist=False
3247, primaryjoin=ci_series_table.c.ci_citation_series==ci_citation_table.c.ci_citation_id
3248)})
3249
3250
3251class_mapper(MO_Operation).add_properties({     'relatedPartyInfo': relationship(MO_ResponsiblePartyInfo
3252, primaryjoin=mo_responsiblepartyinfo_table.c.mo_operation_relatedPartyInfo==mo_operation_table.c.mo_operation_id
3253),      'operationTime': relationship(TM_Object, uselist=False
3254, primaryjoin=tm_object_table.c.mo_operation_operationTime==mo_operation_table.c.mo_operation_id
3255),      'location': relationship(MO_Location, uselist=False
3256, primaryjoin=mo_location_table.c.mo_operation_location==mo_operation_table.c.mo_operation_id
3257),      'identifier': relationship(MD_Identifier
3258, primaryjoin=md_identifier_table.c.mo_operation_identifier==mo_operation_table.c.mo_operation_id
3259),      'documentation': relationship(CI_Citation
3260, primaryjoin=ci_citation_table.c.mo_operation_documentation==mo_operation_table.c.mo_operation_id
3261),      'platform': relationship(MO_Platform, uselist=False
3262, primaryjoin=mo_platform_table.c.mo_operation_platform==mo_operation_table.c.mo_operation_id
3263)})
3264
3265
3266class_mapper(IO_IdentifiedObjectBase).add_properties({  'alias': relationship(GenericName
3267, primaryjoin=genericname_table.c.io_identifiedobjectbase_alias==io_identifiedobjectbase_table.c.io_identifiedobjectbase_id
3268),      'identifier': relationship(RS_Identifier
3269, primaryjoin=rs_identifier_table.c.io_identifiedobjectbase_identifier==io_identifiedobjectbase_table.c.io_identifiedobjectbase_id
3270)})
3271
3272
3273class_mapper(MD_ReferenceSystem).add_properties({       'referenceSystemIdentifier': relationship(RS_Identifier, uselist=False
3274, primaryjoin=rs_identifier_table.c.md_referencesystem_referenceSystemIdentifier==md_referencesystem_table.c.md_referencesystem_id
3275)})
3276
3277
3278class_mapper(OM_Observation).add_properties({   'validTime': relationship(TM_Period, uselist=False
3279, primaryjoin=tm_period_table.c.om_observation_validTime==om_observation_table.c.om_observation_id
3280),      'resultTime': relationship(TM_Instant, uselist=False
3281, primaryjoin=tm_instant_table.c.om_observation_resultTime==om_observation_table.c.om_observation_id
3282),      'parameter': relationship(NamedValue
3283, primaryjoin=namedvalue_table.c.om_observation_parameter==om_observation_table.c.om_observation_id
3284),      'metadata': relationship(MD_Metadata, uselist=False
3285, primaryjoin=md_metadata_table.c.om_observation_metadata==om_observation_table.c.om_observation_id
3286),      'observedProperty': relationship(GF_PropertyType, uselist=False
3287, primaryjoin=gf_propertytype_table.c.om_observation_observedProperty==om_observation_table.c.om_observation_id
3288),      'phenomenonTime': relationship(TM_Object, uselist=False
3289, primaryjoin=tm_object_table.c.om_observation_phenomenonTime==om_observation_table.c.om_observation_id
3290),      'result': relationship(Any, uselist=False
3291, primaryjoin=any_table.c.om_observation_result==om_observation_table.c.om_observation_id
3292),      'resultQuality': relationship(DQ_Element
3293, primaryjoin=dq_element_table.c.om_observation_resultQuality==om_observation_table.c.om_observation_id
3294)})
3295
3296
3297class_mapper(MD_Keywords).add_properties({      'thesaurusName': relationship(CI_Citation, uselist=False
3298, primaryjoin=ci_citation_table.c.md_keywords_thesaurusName==md_keywords_table.c.md_keywords_id
3299)})
3300
3301
3302class_mapper(MO_Project).add_properties({       'dmp': relationship(CI_Citation, uselist=False
3303, primaryjoin=ci_citation_table.c.mo_project_dmp==mo_project_table.c.mo_project_id
3304),      'observationCollection': relationship(MO_ObservationCollection, uselist=False
3305, primaryjoin=mo_observationcollection_table.c.mo_project_observationCollection==mo_project_table.c.mo_project_id
3306),      'relatedParty': relationship(MO_ResponsiblePartyInfo
3307, primaryjoin=mo_responsiblepartyinfo_table.c.mo_project_relatedParty==mo_project_table.c.mo_project_id
3308),      'documentation': relationship(CI_Citation
3309, primaryjoin=ci_citation_table.c.mo_project_documentation==mo_project_table.c.mo_project_id
3310),      'identifier': relationship(MD_Identifier
3311, primaryjoin=md_identifier_table.c.mo_project_identifier==mo_project_table.c.mo_project_id
3312),      'keywords': relationship(MD_Keywords
3313, primaryjoin=md_keywords_table.c.mo_project_keywords==mo_project_table.c.mo_project_id
3314)})
3315
3316
3317class_mapper(MD_PortrayalCatalogueReference).add_properties({   'portrayalCatalogueCitation': relationship(CI_Citation
3318, primaryjoin=ci_citation_table.c.md_portrayalcataloguereference_portrayalCatalogueCitation==md_portrayalcataloguereference_table.c.md_portrayalcataloguereference_id
3319)})
3320
3321
3322class_mapper(CEDA_ObservationCollection).add_properties({       'review': relationship(CEDA_Review
3323, primaryjoin=ceda_review_table.c.ceda_observationcollection_review==ceda_observationcollection_table.c.ceda_observationcollection_id
3324),      '_mo_observationcollection': relationship(MO_ObservationCollection, 
3325secondary=mo_observationcollection_ceda_observationcollection_table
3326, uselist=False
3327),      'member': relationship(CEDA_Observation, uselist=False
3328, primaryjoin=ceda_observation_table.c.ceda_observationcollection_member==ceda_observationcollection_table.c.ceda_observationcollection_id
3329)})
3330
3331
3332class_mapper(EX_GeographicDescription).add_properties({ 'geographicIdentifier': relationship(MD_Identifier, uselist=False
3333, primaryjoin=md_identifier_table.c.ex_geographicdescription_geographicIdentifier==ex_geographicdescription_table.c.ex_geographicdescription_id
3334),      '_ex_geographicextent': relationship(EX_GeographicExtent, 
3335secondary=ex_geographicextent_ex_geographicdescription_table
3336, uselist=False
3337)})
3338
3339
3340class_mapper(MO_CompositeProcess).add_properties({      'relatedParty': relationship(MO_ResponsiblePartyInfo
3341, primaryjoin=mo_responsiblepartyinfo_table.c.mo_compositeprocess_relatedParty==mo_compositeprocess_table.c.mo_compositeprocess_id
3342),      'acquisitionComponent': relationship(MO_Acquisition, uselist=False
3343, primaryjoin=mo_acquisition_table.c.mo_compositeprocess_acquisitionComponent==mo_compositeprocess_table.c.mo_compositeprocess_id
3344),      'identifier': relationship(MD_Identifier
3345, primaryjoin=md_identifier_table.c.mo_compositeprocess_identifier==mo_compositeprocess_table.c.mo_compositeprocess_id
3346),      'computationComponent': relationship(MO_Computation, uselist=False
3347, primaryjoin=mo_computation_table.c.mo_compositeprocess_computationComponent==mo_compositeprocess_table.c.mo_compositeprocess_id
3348),      '_mo_process': relationship(MO_Process, 
3349secondary=mo_process_mo_compositeprocess_table
3350, uselist=False
3351),      'documentation': relationship(CI_Citation
3352, primaryjoin=ci_citation_table.c.mo_compositeprocess_documentation==mo_compositeprocess_table.c.mo_compositeprocess_id
3353)})
3354
3355
3356class_mapper(MO_Observation).add_properties({   'verticalExtent': relationship(EX_VerticalExtent
3357, primaryjoin=ex_verticalextent_table.c.mo_observation_verticalExtent==mo_observation_table.c.mo_observation_id
3358),      'relatedParty': relationship(MO_ResponsiblePartyInfo
3359, primaryjoin=mo_responsiblepartyinfo_table.c.mo_observation_relatedParty==mo_observation_table.c.mo_observation_id
3360),      'result': relationship(MO_Result, uselist=False
3361, primaryjoin=mo_result_table.c.mo_observation_result==mo_observation_table.c.mo_observation_id
3362),      'permission': relationship(MD_Constraints, uselist=False
3363, primaryjoin=md_constraints_table.c.mo_observation_permission==mo_observation_table.c.mo_observation_id
3364),      'inSupportOf': relationship(MO_Project, uselist=False
3365, primaryjoin=mo_project_table.c.mo_observation_inSupportOf==mo_observation_table.c.mo_observation_id
3366),      '_om_observation': relationship(OM_Observation, 
3367secondary=om_observation_mo_observation_table
3368, uselist=False
3369),      'identifier': relationship(MD_Identifier
3370, primaryjoin=md_identifier_table.c.mo_observation_identifier==mo_observation_table.c.mo_observation_id
3371),      'geographicExtent': relationship(EX_GeographicExtent
3372, primaryjoin=ex_geographicextent_table.c.mo_observation_geographicExtent==mo_observation_table.c.mo_observation_id
3373),      'documentation': relationship(CI_Citation
3374, primaryjoin=ci_citation_table.c.mo_observation_documentation==mo_observation_table.c.mo_observation_id
3375)})
3376
3377
3378class_mapper(CEDA_CompositeProcess).add_properties({    '_ceda_process': relationship(CEDA_Process, 
3379secondary=ceda_process_ceda_compositeprocess_table
3380, uselist=False
3381),      '_mo_compositeprocess': relationship(MO_CompositeProcess, 
3382secondary=mo_compositeprocess_ceda_compositeprocess_table
3383, uselist=False
3384),      'computationComponent': relationship(CEDA_Processing, uselist=False
3385, primaryjoin=ceda_processing_table.c.ceda_compositeprocess_computationComponent==ceda_compositeprocess_table.c.ceda_compositeprocess_id
3386),      'aquisitionComponent': relationship(CEDA_Acquisition, uselist=False
3387, primaryjoin=ceda_acquisition_table.c.ceda_compositeprocess_aquisitionComponent==ceda_compositeprocess_table.c.ceda_compositeprocess_id
3388),      'review': relationship(CEDA_Review
3389, primaryjoin=ceda_review_table.c.ceda_compositeprocess_review==ceda_compositeprocess_table.c.ceda_compositeprocess_id
3390)})
3391
3392
3393class_mapper(SC_CRS).add_properties({   '_rs_referencesystem': relationship(RS_ReferenceSystem, 
3394secondary=rs_referencesystem_sc_crs_table
3395, uselist=False
3396),      '_io_identifiedobjectbase': relationship(IO_IdentifiedObjectBase, 
3397secondary=io_identifiedobjectbase_sc_crs_table
3398, uselist=False
3399)})
3400
3401
3402class_mapper(CEDA_Operation).add_properties({   'review': relationship(CEDA_Review
3403, primaryjoin=ceda_review_table.c.ceda_operation_review==ceda_operation_table.c.ceda_operation_id
3404),      '_mo_operation': relationship(MO_Operation, 
3405secondary=mo_operation_ceda_operation_table
3406, uselist=False
3407)})
3408
3409
3410class_mapper(CEDA_Processing).add_properties({  '_ceda_process': relationship(CEDA_Process, 
3411secondary=ceda_process_ceda_processing_table
3412, uselist=False
3413),      'review': relationship(CEDA_Review
3414, primaryjoin=ceda_review_table.c.ceda_processing_review==ceda_processing_table.c.ceda_processing_id
3415),      '_mo_processing': relationship(MO_Processing, 
3416secondary=mo_processing_ceda_processing_table
3417, uselist=False
3418)})
3419
3420
3421class_mapper(CEDA_Project).add_properties({     'observationCollection': relationship(CEDA_ObservationCollection, uselist=False
3422, primaryjoin=ceda_observationcollection_table.c.ceda_project_observationCollection==ceda_project_table.c.ceda_project_id
3423),      'projectResource': relationship(MO_OnlineResource
3424, primaryjoin=mo_onlineresource_table.c.ceda_project_projectResource==ceda_project_table.c.ceda_project_id
3425),      'review': relationship(CEDA_Review
3426, primaryjoin=ceda_review_table.c.ceda_project_review==ceda_project_table.c.ceda_project_id
3427),      '_mo_project': relationship(MO_Project, 
3428secondary=mo_project_ceda_project_table
3429, uselist=False
3430)})
3431
3432
3433class_mapper(CEDA_Instrument).add_properties({  'review': relationship(CEDA_Review
3434, primaryjoin=ceda_review_table.c.ceda_instrument_review==ceda_instrument_table.c.ceda_instrument_id
3435),      '_mo_instrument': relationship(MO_Instrument, 
3436secondary=mo_instrument_ceda_instrument_table
3437, uselist=False
3438)})
3439
3440
3441class_mapper(CEDA_Observation).add_properties({ '_mo_observation': relationship(MO_Observation, 
3442secondary=mo_observation_ceda_observation_table
3443, uselist=False
3444),      'inSupportOf': relationship(CEDA_Project, uselist=False
3445, primaryjoin=ceda_project_table.c.ceda_observation_inSupportOf==ceda_observation_table.c.ceda_observation_id
3446),      'internalReview': relationship(CEDA_Review
3447, primaryjoin=ceda_review_table.c.ceda_observation_internalReview==ceda_observation_table.c.ceda_observation_id
3448),      'keywords': relationship(MD_Keywords
3449, primaryjoin=md_keywords_table.c.ceda_observation_keywords==ceda_observation_table.c.ceda_observation_id
3450),      'procedure': relationship(CEDA_Process, uselist=False
3451, primaryjoin=ceda_process_table.c.ceda_observation_procedure==ceda_observation_table.c.ceda_observation_id
3452),      'result': relationship(CEDA_Result, uselist=False
3453, primaryjoin=ceda_result_table.c.ceda_observation_result==ceda_observation_table.c.ceda_observation_id
3454),      'citation': relationship(CEDA_Citation
3455, primaryjoin=ceda_citation_table.c.ceda_observation_citation==ceda_observation_table.c.ceda_observation_id
3456)})
3457
3458
3459class_mapper(MO_Acquisition).add_properties({   'platform': relationship(MO_Platform, uselist=False
3460, primaryjoin=mo_platform_table.c.mo_acquisition_platform==mo_acquisition_table.c.mo_acquisition_id
3461),      'realatedParty': relationship(MO_ResponsiblePartyInfo
3462, primaryjoin=mo_responsiblepartyinfo_table.c.mo_acquisition_realatedParty==mo_acquisition_table.c.mo_acquisition_id
3463),      'instrument': relationship(MO_Instrument, uselist=False
3464, primaryjoin=mo_instrument_table.c.mo_acquisition_instrument==mo_acquisition_table.c.mo_acquisition_id
3465),      'operation': relationship(MO_Operation, uselist=False
3466, primaryjoin=mo_operation_table.c.mo_acquisition_operation==mo_acquisition_table.c.mo_acquisition_id
3467),      '_mo_process': relationship(MO_Process, 
3468secondary=mo_process_mo_acquisition_table
3469, uselist=False
3470),      'documentation': relationship(CI_Citation
3471, primaryjoin=ci_citation_table.c.mo_acquisition_documentation==mo_acquisition_table.c.mo_acquisition_id
3472),      'outputDescription': relationship(MO_InputOutput, uselist=False
3473, primaryjoin=mo_inputoutput_table.c.mo_acquisition_outputDescription==mo_acquisition_table.c.mo_acquisition_id
3474),      'instrumentPlatformPair': relationship(MO_InstrumentPlatformPair
3475, primaryjoin=mo_instrumentplatformpair_table.c.mo_acquisition_instrumentPlatformPair==mo_acquisition_table.c.mo_acquisition_id
3476),      'identifier': relationship(MD_Identifier
3477, primaryjoin=md_identifier_table.c.mo_acquisition_identifier==mo_acquisition_table.c.mo_acquisition_id
3478)})
3479
3480
3481class_mapper(CEDA_Acquisition).add_properties({ 'operation': relationship(CEDA_Operation, uselist=False
3482, primaryjoin=ceda_operation_table.c.ceda_acquisition_operation==ceda_acquisition_table.c.ceda_acquisition_id
3483),      '_ceda_process': relationship(CEDA_Process, 
3484secondary=ceda_process_ceda_acquisition_table
3485, uselist=False
3486),      'review': relationship(CEDA_Review
3487, primaryjoin=ceda_review_table.c.ceda_acquisition_review==ceda_acquisition_table.c.ceda_acquisition_id
3488),      'instrument': relationship(CEDA_Instrument, uselist=False
3489, primaryjoin=ceda_instrument_table.c.ceda_acquisition_instrument==ceda_acquisition_table.c.ceda_acquisition_id
3490),      'platform': relationship(CEDA_Platform, uselist=False
3491, primaryjoin=ceda_platform_table.c.ceda_acquisition_platform==ceda_acquisition_table.c.ceda_acquisition_id
3492),      '_mo_acquisition': relationship(MO_Acquisition, 
3493secondary=mo_acquisition_ceda_acquisition_table
3494, uselist=False
3495)})
3496
3497
3498class_mapper(RS_Identifier).add_properties({    '_md_identifier': relationship(MD_Identifier, 
3499secondary=md_identifier_rs_identifier_table
3500, uselist=False
3501)})
3502
3503
3504class_mapper(CEDA_Platform).add_properties({    'review': relationship(CEDA_Review
3505, primaryjoin=ceda_review_table.c.ceda_platform_review==ceda_platform_table.c.ceda_platform_id
3506),      '_mo_platform': relationship(MO_Platform, 
3507secondary=mo_platform_ceda_platform_table
3508, uselist=False
3509)})
3510
3511
3512class_mapper(MO_Processing).add_properties({    '_mo_computation': relationship(MO_Computation, 
3513secondary=mo_computation_mo_processing_table
3514, uselist=False
3515),      'identifier': relationship(MD_Identifier
3516, primaryjoin=md_identifier_table.c.mo_processing_identifier==mo_processing_table.c.mo_processing_id
3517),      'documentation': relationship(CI_Citation
3518, primaryjoin=ci_citation_table.c.mo_processing_documentation==mo_processing_table.c.mo_processing_id
3519),      'processingInput': relationship(MO_InputOutput
3520, primaryjoin=mo_inputoutput_table.c.mo_processing_processingInput==mo_processing_table.c.mo_processing_id
3521),      'relatedParty': relationship(MO_ResponsiblePartyInfo
3522, primaryjoin=mo_responsiblepartyinfo_table.c.mo_processing_relatedParty==mo_processing_table.c.mo_processing_id
3523),      'softwareReference': relationship(CI_Citation, uselist=False
3524, primaryjoin=ci_citation_table.c.mo_processing_softwareReference==mo_processing_table.c.mo_processing_id
3525),      'processingOutput': relationship(MO_InputOutput, uselist=False
3526, primaryjoin=mo_inputoutput_table.c.mo_processing_processingOutput==mo_processing_table.c.mo_processing_id
3527)})
3528
3529metadata.create_all(engine)
3530
3531
Note: See TracBrowser for help on using the repository browser.