source: mauRepo/MolesManager/trunk/src/MolesManager/static/admin/joinInheritedSqlTables.py @ 8014

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