| 421 | extend_existing=False,) |
| 422 | |
| 423 | |
| 424 | |
| 425 | |
| 426 | |
| 427 | |
| 428 | |
| 429 | |
| 430 | |
| 431 | |
| 432 | |
| 433 | |
| 434 | md_medium_table = Table('md_medium', metadata, |
| 435 | Column('id', Integer, Sequence('md_medium_id_seq'), primary_key=True), |
| 436 | Column('md_digitaltransferoptions_offline_id', Integer, ForeignKey('md_digitaltransferoptions.id')), |
| 437 | Column('mediumNote', TEXT , nullable=True), |
| 438 | Column('densityUnits', TEXT , nullable=True), |
| 439 | Column('volumes', Integer , nullable=True), |
| 440 | Column('density', ARRAY(NUMERIC) , nullable=True), |
| 441 | Column('mediumFormat', MD_MediumFormatCode.db_type() , nullable=True), |
| 442 | Column('name', MD_MediumNameCode.db_type() , nullable=True), |
| 443 | extend_existing=False,) |
| 444 | |
| 445 | |
| 446 | |
| 447 | |
| 448 | |
| 449 | |
| 450 | |
| 451 | |
| 452 | |
| 453 | |
| 454 | |
| 455 | |
| 456 | tm_object_table = Table('tm_object', metadata, |
| 457 | Column('id', Integer, Sequence('tm_object_id_seq'), primary_key=True), |
| 458 | Column('om_observation_phenomenontime_id', Integer, ForeignKey('om_observation.id')), |
| 459 | Column('tm_complex__tm_object_id', Integer, ForeignKey('tm_complex.id')), |
| 460 | Column('mo_observationcollection_phenomenontime', Integer, ForeignKey('mo_observationcollection.id')), |
| 461 | Column('mo_operation_operationtime_id', Integer, ForeignKey('mo_operation.id')), |
| 462 | Column('tm_primitive__tm_object_id', Integer, ForeignKey('tm_primitive.id')), |
| 463 | extend_existing=False,) |
| 464 | |
| 465 | |
| 466 | |
| 467 | |
| 468 | |
| 469 | |
| 470 | |
| 471 | |
| 472 | |
| 473 | |
| 474 | |
| 475 | |
| 476 | cv_gridcoordinate_table = Table('cv_gridcoordinate', metadata, |
| 477 | Column('id', Integer, Sequence('cv_gridcoordinate_id_seq'), primary_key=True), |
| 478 | Column('cv_gridenvelope_low_id', Integer, ForeignKey('cv_gridenvelope.id')), |
| 479 | Column('cv_gridpoint_gridcoord_id', Integer, ForeignKey('cv_gridpoint.id')), |
| 480 | Column('cv_gridenvelope_high_id', Integer, ForeignKey('cv_gridenvelope.id')), |
| 481 | Column('coordValues', ARRAY(Integer) , nullable=False), |
| 482 | extend_existing=False,) |
| 483 | |
| 484 | |
| 485 | |
| 486 | |
| 487 | |
| 488 | |
| 489 | |
| 490 | |
| 491 | |
| 492 | |
| 493 | |
| 494 | |
| 495 | unlimitedinteger_table = Table('unlimitedinteger', metadata, |
| 496 | Column('id', Integer, Sequence('unlimitedinteger_id_seq'), primary_key=True), |
| 497 | Column('multiplicityrange_upper_id', Integer, ForeignKey('multiplicityrange.id')), |
| 498 | Column('value', Integer , nullable=True), |
| 499 | Column('isInfinite', BOOLEAN , nullable=False), |
| 500 | extend_existing=False,) |
| 501 | |
| 502 | |
| 503 | |
| 504 | |
| 505 | |
| 506 | |
| 507 | |
| 508 | |
| 509 | |
| 510 | |
| 511 | |
| 512 | |
| 513 | md_constraints_table = Table('md_constraints', metadata, |
| 514 | Column('id', Integer, Sequence('md_constraints_id_seq'), primary_key=True), |
| 515 | Column('mo_observation_permission_id', Integer, ForeignKey('mo_observation.id')), |
| 516 | Column('md_metadata_metadataconstraints', Integer, ForeignKey('md_metadata.id')), |
| 517 | Column('md_identification_resourceconstraints', Integer, ForeignKey('md_identification.id')), |
| 518 | Column('useLimitation', ARRAY(TEXT) , nullable=True), |
| 519 | extend_existing=False,) |
| 520 | |
| 521 | |
| 522 | |
| 523 | |
| 524 | |
| 525 | |
| 526 | |
| 527 | |
| 528 | |
| 529 | |
| 530 | |
| 531 | |
| 532 | dq_result_table = Table('dq_result', metadata, |
| 533 | Column('id', Integer, Sequence('dq_result_id_seq'), primary_key=True), |
| 534 | Column('dq_element_result', Integer, ForeignKey('dq_element.id')), |
| 535 | extend_existing=False,) |
| 536 | |
| 537 | |
| 538 | |
| 539 | |
| 540 | |
| 541 | |
| 542 | |
| 543 | |
| 544 | |
| 545 | |
| 546 | |
| 547 | |
| 548 | md_browsegraphic_table = Table('md_browsegraphic', metadata, |
| 549 | Column('id', Integer, Sequence('md_browsegraphic_id_seq'), primary_key=True), |
| 550 | Column('md_identification_graphicoverview', Integer, ForeignKey('md_identification.id')), |
| 551 | Column('fileType', TEXT , nullable=True), |
| 552 | Column('fileName', TEXT , nullable=False), |
| 553 | Column('fileDescription', TEXT , nullable=True), |
| 554 | extend_existing=False,) |
| 555 | |
| 556 | |
| 557 | |
| 558 | |
| 559 | |
| 560 | |
| 561 | |
| 562 | |
| 563 | |
| 564 | |
| 565 | |
| 566 | |
| 567 | md_contentinformation_table = Table('md_contentinformation', metadata, |
| 568 | Column('id', Integer, Sequence('md_contentinformation_id_seq'), primary_key=True), |
| 569 | Column('md_metadata_contentinfo', Integer, ForeignKey('md_metadata.id')), |
| 570 | extend_existing=False,) |
| 571 | |
| 572 | |
| 573 | |
| 574 | |
| 575 | |
| 576 | |
| 577 | |
| 578 | |
| 579 | |
| 580 | |
| 581 | |
| 582 | |
| 583 | tm_duration_table = Table('tm_duration', metadata, |
| 584 | Column('id', Integer, Sequence('tm_duration_id_seq'), primary_key=True), |
| 585 | Column('tm_periodduration__tm_duration_id', Integer, ForeignKey('tm_periodduration.id')), |
| 586 | extend_existing=False,) |
| 587 | |
| 588 | |
| 589 | |
| 590 | |
| 591 | |
| 592 | |
| 593 | |
| 594 | |
| 595 | |
| 596 | |
| 597 | |
| 598 | |
| 599 | any_table = Table('any', metadata, |
| 600 | Column('id', Integer, Sequence('any_id_seq'), primary_key=True), |
| 601 | Column('namedvalue_value_id', Integer, ForeignKey('namedvalue.id')), |
| 602 | Column('om_observation_result_id', Integer, ForeignKey('om_observation.id')), |
358 | | clocktime_table = Table('clocktime', metadata, |
359 | | Column('id', Integer, Sequence('clocktime_id_seq'), primary_key=True), |
360 | | Column('datetime__clocktime_id', Integer, ForeignKey('datetime.id')), |
361 | | Column('timeZone', TEXT , nullable=True), |
362 | | Column('second', TEXT , nullable=True), |
363 | | Column('minute', TEXT , nullable=True), |
364 | | Column('hour', TEXT , nullable=False), |
365 | | extend_existing=False,) |
366 | | |
367 | | |
368 | | |
369 | | |
370 | | |
371 | | |
372 | | |
373 | | |
374 | | |
375 | | |
376 | | |
377 | | |
378 | | md_contentinformation_table = Table('md_contentinformation', metadata, |
379 | | Column('id', Integer, Sequence('md_contentinformation_id_seq'), primary_key=True), |
380 | | Column('md_metadata_contentinfo', Integer, ForeignKey('md_metadata.id')), |
381 | | extend_existing=False,) |
382 | | |
383 | | |
384 | | |
385 | | |
386 | | |
387 | | |
388 | | |
389 | | |
390 | | |
391 | | |
392 | | |
393 | | |
394 | | ci_telephone_table = Table('ci_telephone', metadata, |
395 | | Column('id', Integer, Sequence('ci_telephone_id_seq'), primary_key=True), |
396 | | Column('ci_contact_phone_id', Integer, ForeignKey('ci_contact.id')), |
397 | | Column('facsimile', ARRAY(TEXT) , nullable=True), |
398 | | Column('voice', ARRAY(TEXT) , nullable=True), |
399 | | extend_existing=False,) |
400 | | |
401 | | |
402 | | |
403 | | |
404 | | |
405 | | |
406 | | |
407 | | |
408 | | |
409 | | |
410 | | |
411 | | |
412 | | tm_object_table = Table('tm_object', metadata, |
413 | | Column('id', Integer, Sequence('tm_object_id_seq'), primary_key=True), |
414 | | Column('mo_observationcollection_phenomenontime', Integer, ForeignKey('mo_observationcollection.id')), |
415 | | Column('om_observation_phenomenontime_id', Integer, ForeignKey('om_observation.id')), |
416 | | Column('mo_operation_operationtime_id', Integer, ForeignKey('mo_operation.id')), |
417 | | Column('tm_complex__tm_object_id', Integer, ForeignKey('tm_complex.id')), |
418 | | Column('tm_primitive__tm_object_id', Integer, ForeignKey('tm_primitive.id')), |
419 | | extend_existing=False,) |
420 | | |
421 | | |
422 | | |
423 | | |
424 | | |
425 | | |
426 | | |
427 | | |
428 | | |
429 | | |
430 | | |
431 | | |
432 | | dq_result_table = Table('dq_result', metadata, |
433 | | Column('id', Integer, Sequence('dq_result_id_seq'), primary_key=True), |
434 | | Column('dq_element_result', Integer, ForeignKey('dq_element.id')), |
435 | | extend_existing=False,) |
436 | | |
437 | | |
438 | | |
439 | | |
440 | | |
441 | | |
442 | | |
443 | | |
444 | | |
445 | | |
446 | | |
447 | | |
448 | | ci_address_table = Table('ci_address', metadata, |
449 | | Column('id', Integer, Sequence('ci_address_id_seq'), primary_key=True), |
450 | | Column('ci_contact_address_id', Integer, ForeignKey('ci_contact.id')), |
451 | | Column('postalCode', TEXT , nullable=True), |
452 | | Column('electronicMailAddress', ARRAY(TEXT) , nullable=True), |
453 | | Column('country', TEXT , nullable=True), |
454 | | Column('city', TEXT , nullable=True), |
455 | | Column('deliveryPoint', ARRAY(TEXT) , nullable=True), |
456 | | Column('administrativeArea', TEXT , nullable=True), |
457 | | extend_existing=False,) |
458 | | |
459 | | |
460 | | |
461 | | |
462 | | |
463 | | |
464 | | |
465 | | |
466 | | |
467 | | |
468 | | |
469 | | |
470 | | md_constraints_table = Table('md_constraints', metadata, |
471 | | Column('id', Integer, Sequence('md_constraints_id_seq'), primary_key=True), |
472 | | Column('mo_observation_permission_id', Integer, ForeignKey('mo_observation.id')), |
473 | | Column('md_identification_resourceconstraints', Integer, ForeignKey('md_identification.id')), |
474 | | Column('md_metadata_metadataconstraints', Integer, ForeignKey('md_metadata.id')), |
475 | | Column('useLimitation', ARRAY(TEXT) , nullable=True), |
476 | | extend_existing=False,) |
477 | | |
478 | | |
479 | | |
480 | | |
481 | | |
482 | | |
483 | | |
484 | | |
485 | | |
486 | | |
487 | | |
488 | | |
489 | | any_table = Table('any', metadata, |
490 | | Column('id', Integer, Sequence('any_id_seq'), primary_key=True), |
491 | | Column('namedvalue_value_id', Integer, ForeignKey('namedvalue.id')), |
492 | | Column('om_observation_result_id', Integer, ForeignKey('om_observation.id')), |
493 | | extend_existing=False,) |
494 | | |
495 | | |
496 | | |
497 | | |
498 | | |
499 | | |
500 | | |
501 | | |
502 | | |
503 | | |
504 | | |
505 | | |
506 | | tm_duration_table = Table('tm_duration', metadata, |
507 | | Column('id', Integer, Sequence('tm_duration_id_seq'), primary_key=True), |
508 | | Column('tm_periodduration__tm_duration_id', Integer, ForeignKey('tm_periodduration.id')), |
509 | | extend_existing=False,) |
510 | | |
511 | | |
512 | | |
513 | | |
514 | | |
515 | | |
516 | | |
517 | | |
518 | | |
519 | | |
520 | | |
521 | | |
522 | | md_browsegraphic_table = Table('md_browsegraphic', metadata, |
523 | | Column('id', Integer, Sequence('md_browsegraphic_id_seq'), primary_key=True), |
524 | | Column('md_identification_graphicoverview', Integer, ForeignKey('md_identification.id')), |
525 | | Column('fileType', TEXT , nullable=True), |
526 | | Column('fileName', TEXT , nullable=False), |
527 | | Column('fileDescription', TEXT , nullable=True), |
528 | | extend_existing=False,) |
529 | | |
530 | | |
531 | | |
532 | | |
533 | | |
534 | | |
535 | | |
536 | | |
537 | | |
538 | | |
539 | | |
540 | | |
541 | | url_table = Table('url', metadata, |
542 | | Column('id', Integer, Sequence('url_id_seq'), primary_key=True), |
543 | | Column('ci_onlineresource_linkage_id', Integer, ForeignKey('ci_onlineresource.id')), |
544 | | extend_existing=False,) |
545 | | |
546 | | |
547 | | |
548 | | |
549 | | |
550 | | |
551 | | |
552 | | |
553 | | |
554 | | |
555 | | |
556 | | |
557 | | unlimitedinteger_table = Table('unlimitedinteger', metadata, |
558 | | Column('id', Integer, Sequence('unlimitedinteger_id_seq'), primary_key=True), |
559 | | Column('multiplicityrange_upper_id', Integer, ForeignKey('multiplicityrange.id')), |
560 | | Column('value', Integer , nullable=True), |
561 | | Column('isInfinite', BOOLEAN , nullable=False), |
562 | | extend_existing=False,) |
563 | | |
564 | | |
565 | | |
566 | | |
567 | | |
568 | | |
569 | | |
570 | | |
571 | | |
572 | | |
573 | | |
574 | | |
575 | | ex_geographicextent_table = Table('ex_geographicextent', metadata, |
576 | | Column('id', Integer, Sequence('ex_geographicextent_id_seq'), primary_key=True), |
577 | | Column('mo_observation_geographicextent', Integer, ForeignKey('mo_observation.id')), |
578 | | Column('ex_geographicdescription__ex_geographicextent_id', Integer, ForeignKey('ex_geographicdescription.id')), |
579 | | Column('ex_extent_geographicelement', Integer, ForeignKey('ex_extent.id')), |
580 | | Column('mo_observationcollection_geographicextent', Integer, ForeignKey('mo_observationcollection.id')), |
581 | | Column('extentTypeCode', BOOLEAN , nullable=True), |
582 | | extend_existing=False,) |
583 | | |
584 | | |
585 | | |
586 | | |
587 | | |
588 | | |
589 | | |
590 | | |
591 | | |
592 | | |
593 | | |
594 | | |
595 | | gf_constraint_table = Table('gf_constraint', metadata, |
596 | | Column('id', Integer, Sequence('gf_constraint_id_seq'), primary_key=True), |
597 | | Column('gf_propertytype_constrainedby', Integer, ForeignKey('gf_propertytype.id')), |
598 | | Column('gf_featuretype_constrainedby', Integer, ForeignKey('gf_featuretype.id')), |
599 | | Column('description', TEXT , nullable=False), |
600 | | extend_existing=False,) |
601 | | |
602 | | |
603 | | |
604 | | |
605 | | |
606 | | |
607 | | |
608 | | |
609 | | |
610 | | |
611 | | |
612 | | |
613 | | cv_gridcoordinate_table = Table('cv_gridcoordinate', metadata, |
614 | | Column('id', Integer, Sequence('cv_gridcoordinate_id_seq'), primary_key=True), |
615 | | Column('cv_gridenvelope_low_id', Integer, ForeignKey('cv_gridenvelope.id')), |
616 | | Column('cv_gridenvelope_high_id', Integer, ForeignKey('cv_gridenvelope.id')), |
617 | | Column('cv_gridpoint_gridcoord_id', Integer, ForeignKey('cv_gridpoint.id')), |
618 | | Column('coordValues', ARRAY(Integer) , nullable=False), |
619 | | extend_existing=False,) |
620 | | |
621 | | |
622 | | |
623 | | |
624 | | |
625 | | |
626 | | |
627 | | |
628 | | |
629 | | |
630 | | |
631 | | |
632 | | tm_complex_table = Table('tm_complex', metadata, |
633 | | Column('id', Integer, Sequence('tm_complex_id_seq'), primary_key=True), |
634 | | Column('tm_topologicalcomplex__tm_complex_id', Integer, ForeignKey('tm_topologicalcomplex.id')), |
635 | | extend_existing=False,) |
636 | | |
637 | | |
638 | | |
639 | | |
640 | | |
641 | | |
642 | | |
643 | | |
644 | | |
645 | | |
646 | | |
647 | | |
648 | | tm_periodduration_table = Table('tm_periodduration', metadata, |
649 | | Column('id', Integer, Sequence('tm_periodduration_id_seq'), primary_key=True), |
650 | | Column('md_maintenanceinformation_userdefinedmaintenancefrequency_id', Integer, ForeignKey('md_maintenanceinformation.id')), |
651 | | Column('days', TEXT , nullable=True), |
652 | | Column('designator', TEXT , nullable=False), |
653 | | Column('hours', TEXT , nullable=True), |
654 | | Column('seconds', TEXT , nullable=True), |
655 | | Column('months', TEXT , nullable=True), |
656 | | Column('timeIndicator', TEXT , nullable=True), |
657 | | Column('years', TEXT , nullable=True), |
658 | | Column('minutes', TEXT , nullable=True), |
659 | | extend_existing=False,) |
660 | | |
661 | | |
662 | | |
663 | | |
664 | | |
665 | | |
666 | | |
667 | | |
668 | | |
669 | | |
670 | | |
671 | | |
672 | | date_table = Table('date', metadata, |
673 | | Column('id', Integer, Sequence('date_id_seq'), primary_key=True), |
674 | | Column('tm_position_date8601_id', Integer, ForeignKey('tm_position.id')), |
675 | | Column('md_metadata_datestamp_id', Integer, ForeignKey('md_metadata.id')), |
676 | | Column('datetime__date_id', Integer, ForeignKey('datetime.id')), |
677 | | Column('ci_date_date_id', Integer, ForeignKey('ci_date.id')), |
678 | | Column('md_maintenanceinformation_dateofnextupdate_id', Integer, ForeignKey('md_maintenanceinformation.id')), |
679 | | Column('cd_datum_realizationepoch_id', Integer, ForeignKey('cd_datum.id')), |
680 | | Column('ci_citation_editiondate_id', Integer, ForeignKey('ci_citation.id')), |
681 | | Column('year', TEXT , nullable=True), |
682 | | Column('century', TEXT , nullable=False), |
683 | | Column('month', TEXT , nullable=True), |
684 | | Column('day', TEXT , nullable=True), |
685 | | extend_existing=False,) |
686 | | |
687 | | |
688 | | |
689 | | |
690 | | |
691 | | |
692 | | |
693 | | |
694 | | |
695 | | |
696 | | |
697 | | |
698 | | tm_primitive_table = Table('tm_primitive', metadata, |
699 | | Column('id', Integer, Sequence('tm_primitive_id_seq'), primary_key=True), |
700 | | Column('tm_geometricprimitive__tm_primitive_id', Integer, ForeignKey('tm_geometricprimitive.id')), |
701 | | Column('ex_temporalextent_extent_id', Integer, ForeignKey('ex_temporalextent.id')), |
702 | | Column('tm_topologicalprimitive__tm_primitive_id', Integer, ForeignKey('tm_topologicalprimitive.id')), |
703 | | extend_existing=False,) |
704 | | |
705 | | |
706 | | |
707 | | |
708 | | |
709 | | |
710 | | |
711 | | |
712 | | |
713 | | |
714 | | |
715 | | |
716 | | ci_onlineresource_table = Table('ci_onlineresource', metadata, |
717 | | Column('id', Integer, Sequence('ci_onlineresource_id_seq'), primary_key=True), |
718 | | Column('md_metadataextensioninformation_extensiononlineresource_id', Integer, ForeignKey('md_metadataextensioninformation.id')), |
719 | | Column('ci_contact_onlineresource_id', Integer, ForeignKey('ci_contact.id')), |
720 | | Column('mo_onlineresource__ci_onlineresource_id', Integer, ForeignKey('mo_onlineresource.id')), |
721 | | Column('md_digitaltransferoptions_online', Integer, ForeignKey('md_digitaltransferoptions.id')), |
722 | | Column('mo_observationcollection_additionalmetadata', Integer, ForeignKey('mo_observationcollection.id')), |
723 | | Column('description', TEXT , nullable=True), |
724 | | Column('name', TEXT , nullable=True), |
725 | | Column('protocol', TEXT , nullable=True), |
726 | | Column('function', CI_OnLineFunctionCode.db_type() , nullable=True), |
727 | | Column('applicationProfile', TEXT , nullable=True), |
728 | | extend_existing=False,) |
729 | | |
730 | | |
731 | | |
732 | | |
733 | | |
734 | | |
735 | | |
736 | | |
737 | | |
738 | | |
739 | | |
740 | | |
| 850 | datetime_table = Table('datetime', metadata, |
| 851 | Column('id', Integer, Sequence('datetime_id_seq'), primary_key=True), |
| 852 | Column('md_standardorderprocess_plannedavailabledatetime_id', Integer, ForeignKey('md_standardorderprocess.id')), |
| 853 | Column('ceda_notes_date_id', Integer, ForeignKey('ceda_notes.id')), |
| 854 | Column('li_processstep_datetime_id', Integer, ForeignKey('li_processstep.id')), |
| 855 | Column('md_usage_usagedatetime_id', Integer, ForeignKey('md_usage.id')), |
| 856 | Column('tm_position_datetime8601_id', Integer, ForeignKey('tm_position.id')), |
| 857 | Column('dq_element_datetime', Integer, ForeignKey('dq_element.id')), |
| 858 | extend_existing=False,) |
| 859 | |
| 860 | |
| 861 | |
| 862 | |
| 863 | |
| 864 | |
| 865 | |
| 866 | |
| 867 | |
| 868 | |
| 869 | |
| 870 | |
| 871 | ci_date_table = Table('ci_date', metadata, |
| 872 | Column('id', Integer, Sequence('ci_date_id_seq'), primary_key=True), |
| 873 | Column('ci_citation_date', Integer, ForeignKey('ci_citation.id')), |
| 874 | Column('dateType', CI_DateTypeCode.db_type() , nullable=False), |
| 875 | extend_existing=False,) |
| 876 | |
| 877 | |
| 878 | |
| 879 | |
| 880 | |
| 881 | |
| 882 | |
| 883 | |
| 884 | |
| 885 | |
| 886 | |
| 887 | |
| 888 | ci_party_table = Table('ci_party', metadata, |
| 889 | Column('id', Integer, Sequence('ci_party_id_seq'), primary_key=True), |
| 890 | Column('ci_organisation__ci_party_id', Integer, ForeignKey('ci_organisation.id')), |
| 891 | Column('ci_individual__ci_party_id', Integer, ForeignKey('ci_individual.id')), |
| 892 | Column('ci_responsibility_party', Integer, ForeignKey('ci_responsibility.id')), |
| 893 | Column('name', TEXT , nullable=True), |
| 894 | extend_existing=False,) |
| 895 | |
| 896 | |
| 897 | |
| 898 | |
| 899 | |
| 900 | |
| 901 | |
| 902 | |
| 903 | |
| 904 | |
| 905 | |
| 906 | |
| 907 | ex_temporalextent_table = Table('ex_temporalextent', metadata, |
| 908 | Column('id', Integer, Sequence('ex_temporalextent_id_seq'), primary_key=True), |
| 909 | Column('ex_extent_temporalelement', Integer, ForeignKey('ex_extent.id')), |
| 910 | extend_existing=False,) |
| 911 | |
| 912 | |
| 913 | |
| 914 | |
| 915 | |
| 916 | |
| 917 | |
| 918 | |
| 919 | |
| 920 | |
| 921 | |
| 922 | |
| 923 | ci_responsibleparty_table = Table('ci_responsibleparty', metadata, |
| 924 | Column('id', Integer, Sequence('ci_responsibleparty_id_seq'), primary_key=True), |
| 925 | Column('md_extendedelementinformation_source', Integer, ForeignKey('md_extendedelementinformation.id')), |
| 926 | Column('md_metadata_contact', Integer, ForeignKey('md_metadata.id')), |
| 927 | Column('md_identification_pointofcontact', Integer, ForeignKey('md_identification.id')), |
| 928 | Column('li_processstep_processor', Integer, ForeignKey('li_processstep.id')), |
| 929 | Column('md_usage_usercontactinfo', Integer, ForeignKey('md_usage.id')), |
| 930 | Column('md_maintenanceinformation_contact', Integer, ForeignKey('md_maintenanceinformation.id')), |
| 931 | Column('ci_citation_citedresponsibleparty', Integer, ForeignKey('ci_citation.id')), |
| 932 | Column('md_distributor_distributorcontact_id', Integer, ForeignKey('md_distributor.id')), |
| 933 | Column('positionName', TEXT , nullable=True), |
| 934 | Column('organisationName', TEXT , nullable=True), |
| 935 | Column('role', CI_RoleCode.db_type() , nullable=False), |
| 936 | Column('individualName', TEXT , nullable=True), |
| 937 | extend_existing=False,) |
| 938 | |
| 939 | |
| 940 | |
| 941 | |
| 942 | |
| 943 | |
| 944 | |
| 945 | |
| 946 | |
| 947 | |
| 948 | |
| 949 | |
| 950 | md_extendedelementinformation_table = Table('md_extendedelementinformation', metadata, |
| 951 | Column('id', Integer, Sequence('md_extendedelementinformation_id_seq'), primary_key=True), |
| 952 | Column('md_metadataextensioninformation_extendedelementinformation', Integer, ForeignKey('md_metadataextensioninformation.id')), |
| 953 | Column('rule', TEXT , nullable=False), |
| 954 | Column('dataType', MD_DatatypeCode.db_type() , nullable=False), |
| 955 | Column('rationale', ARRAY(TEXT) , nullable=True), |
| 956 | Column('maximumOccurrence', TEXT , nullable=True), |
| 957 | Column('parentEntity', ARRAY(TEXT) , nullable=False), |
| 958 | Column('obligation', MD_ObligationCode.db_type() , nullable=True), |
| 959 | Column('domainCode', Integer , nullable=True), |
| 960 | Column('shortName', TEXT , nullable=True), |
| 961 | Column('domainValue', TEXT , nullable=True), |
| 962 | Column('definition', TEXT , nullable=False), |
| 963 | Column('name', TEXT , nullable=False), |
| 964 | Column('condition', TEXT , nullable=True), |
| 965 | extend_existing=False,) |
| 966 | |
| 967 | |
| 968 | |
| 969 | |
| 970 | |
| 971 | |
| 972 | |
| 973 | |
| 974 | |
| 975 | |
| 976 | |
| 977 | |
| 978 | ci_individual_table = Table('ci_individual', metadata, |
| 979 | Column('id', Integer, Sequence('ci_individual_id_seq'), primary_key=True), |
| 980 | Column('ci_organisation_individual', Integer, ForeignKey('ci_organisation.id')), |
| 981 | Column('positionName', TEXT , nullable=True), |
| 982 | extend_existing=False,) |
| 983 | |
| 984 | |
| 985 | |
| 986 | |
| 987 | |
| 988 | |
| 989 | |
| 990 | |
| 991 | |
| 992 | |
| 993 | |
| 994 | |
| 995 | md_metadataextensioninformation_table = Table('md_metadataextensioninformation', metadata, |
| 996 | Column('id', Integer, Sequence('md_metadataextensioninformation_id_seq'), primary_key=True), |
| 997 | Column('md_metadata_metadataextensioninfo', Integer, ForeignKey('md_metadata.id')), |
| 998 | extend_existing=False,) |
| 999 | |
| 1000 | |
| 1001 | |
| 1002 | |
| 1003 | |
| 1004 | |
| 1005 | |
| 1006 | |
| 1007 | |
| 1008 | |
| 1009 | |
| 1010 | |
982 | | md_extendedelementinformation_table = Table('md_extendedelementinformation', metadata, |
983 | | Column('id', Integer, Sequence('md_extendedelementinformation_id_seq'), primary_key=True), |
984 | | Column('md_metadataextensioninformation_extendedelementinformation', Integer, ForeignKey('md_metadataextensioninformation.id')), |
985 | | Column('maximumOccurrence', TEXT , nullable=True), |
986 | | Column('domainCode', Integer , nullable=True), |
987 | | Column('parentEntity', ARRAY(TEXT) , nullable=False), |
988 | | Column('domainValue', TEXT , nullable=True), |
989 | | Column('dataType', MD_DatatypeCode.db_type() , nullable=False), |
990 | | Column('condition', TEXT , nullable=True), |
991 | | Column('definition', TEXT , nullable=False), |
992 | | Column('obligation', MD_ObligationCode.db_type() , nullable=True), |
993 | | Column('name', TEXT , nullable=False), |
994 | | Column('shortName', TEXT , nullable=True), |
995 | | Column('rule', TEXT , nullable=False), |
996 | | Column('rationale', ARRAY(TEXT) , nullable=True), |
997 | | extend_existing=False,) |
998 | | |
999 | | |
1000 | | |
1001 | | |
1002 | | |
1003 | | |
1004 | | |
1005 | | |
1006 | | |
1007 | | |
1008 | | |
1009 | | |
1010 | | md_metadataextensioninformation_table = Table('md_metadataextensioninformation', metadata, |
1011 | | Column('id', Integer, Sequence('md_metadataextensioninformation_id_seq'), primary_key=True), |
1012 | | Column('md_metadata_metadataextensioninfo', Integer, ForeignKey('md_metadata.id')), |
1013 | | extend_existing=False,) |
1014 | | |
1015 | | |
1016 | | |
1017 | | |
1018 | | |
1019 | | |
1020 | | |
1021 | | |
1022 | | |
1023 | | |
1024 | | |
1025 | | |
1026 | | ci_citation_table = Table('ci_citation', metadata, |
1027 | | Column('id', Integer, Sequence('ci_citation_id_seq'), primary_key=True), |
1028 | | Column('mo_platform_documentation', Integer, ForeignKey('mo_platform.id')), |
1029 | | Column('cc_formula_formulacitation_id', Integer, ForeignKey('cc_formula.id')), |
1030 | | Column('md_keywords_thesaurusname_id', Integer, ForeignKey('md_keywords.id')), |
1031 | | Column('mo_processing_documentation', Integer, ForeignKey('mo_processing.id')), |
1032 | | Column('md_identification_citation_id', Integer, ForeignKey('md_identification.id')), |
1033 | | Column('li_source_sourcecitation_id', Integer, ForeignKey('li_source.id')), |
1034 | | Column('mo_compositeprocess_documentation', Integer, ForeignKey('mo_compositeprocess.id')), |
1035 | | Column('mo_project_documentation', Integer, ForeignKey('mo_project.id')), |
1036 | | Column('mo_operation_documentation', Integer, ForeignKey('mo_operation.id')), |
1037 | | Column('mo_acquisition_documentation', Integer, ForeignKey('mo_acquisition.id')), |
1038 | | Column('mo_instrument_documentation', Integer, ForeignKey('mo_instrument.id')), |
1039 | | Column('mo_processing_softwarereference_id', Integer, ForeignKey('mo_processing.id')), |
1040 | | Column('md_identifier_authority_id', Integer, ForeignKey('md_identifier.id', use_alter=True, name='fk_md_identifier_authority')), |
1041 | | Column('mo_project_dmp_id', Integer, ForeignKey('mo_project.id')), |
1042 | | Column('mo_observation_documentation', Integer, ForeignKey('mo_observation.id')), |
1043 | | Column('le_algorithm_citation_id', Integer, ForeignKey('le_algorithm.id')), |
1044 | | Column('md_applicationschemainformation_name_id', Integer, ForeignKey('md_applicationschemainformation.id')), |
1045 | | Column('md_aggregateinformation_aggregatedatasetname_id', Integer, ForeignKey('md_aggregateinformation.id')), |
1046 | | Column('md_portrayalcataloguereference_portrayalcataloguecitation', Integer, ForeignKey('md_portrayalcataloguereference.id')), |
1047 | | Column('dq_element_evaluationprocedure_id', Integer, ForeignKey('dq_element.id')), |
1048 | | Column('ISSN', TEXT , nullable=True), |
1049 | | Column('edition', TEXT , nullable=True), |
1050 | | Column('presentationForm', CI_PresentationFormCode.db_type() , nullable=True), |
1051 | | Column('collectiveTitle', TEXT , nullable=True), |
1052 | | Column('alternateTitle', ARRAY(TEXT) , nullable=True), |
1053 | | Column('otherCitationDetails', TEXT , nullable=True), |
1054 | | Column('title', TEXT , nullable=False), |
1055 | | Column('ISBN', TEXT , nullable=True), |
1056 | | extend_existing=False,) |
1057 | | |
1058 | | |
1059 | | |
1060 | | |
1061 | | |
1062 | | |
1063 | | |
1064 | | |
1065 | | |
1066 | | |
1067 | | |
1068 | | |
1069 | | cv_footprint_table = Table('cv_footprint', metadata, |
1070 | | Column('id', Integer, Sequence('cv_footprint_id_seq'), primary_key=True), |
1071 | | Column('cv_gridpoint_footprint', Integer, ForeignKey('cv_gridpoint.id', use_alter=True, name='fk_cv_gridpoint_footprint')), |
| 1064 | schema_table = Table('schema', metadata, |
| 1065 | Column('id', Integer, Sequence('schema_id_seq'), primary_key=True), |
| 1066 | Column('type_schema', Integer, ForeignKey('type.id', use_alter=True, name='fk_type_schema')), |
| 1067 | Column('isGlobal', BOOLEAN , nullable=False), |
| 1068 | extend_existing=False,) |
| 1069 | |
| 1070 | |
| 1071 | |
| 1072 | |
| 1073 | |
| 1074 | |
| 1075 | |
| 1076 | |
| 1077 | |
| 1078 | |
| 1079 | |
| 1080 | |
| 1081 | cc_singleoperation_table = Table('cc_singleoperation', metadata, |
| 1082 | Column('id', Integer, Sequence('cc_singleoperation_id_seq'), primary_key=True), |
| 1083 | Column('cc_generalparametervalue_coordoperation', Integer, ForeignKey('cc_generalparametervalue.id', use_alter=True, name='fk_cc_generalparametervalue_coordoperation')), |
| 1084 | Column('cc_conversion__cc_singleoperation_id', Integer, ForeignKey('cc_conversion.id')), |
| 1085 | Column('cc_operationmethod_coordoperation', Integer, ForeignKey('cc_operationmethod.id', use_alter=True, name='fk_cc_operationmethod_coordoperation')), |
| 1086 | extend_existing=False,) |
| 1087 | |
| 1088 | |
| 1089 | |
| 1090 | |
| 1091 | |
| 1092 | |
| 1093 | |
| 1094 | |
| 1095 | |
| 1096 | |
| 1097 | |
| 1098 | |
| 1099 | cs_verticalcs_table = Table('cs_verticalcs', metadata, |
| 1100 | Column('id', Integer, Sequence('cs_verticalcs_id_seq'), primary_key=True), |
| 1101 | Column('sc_verticalcrs_coordinatesystem_id', Integer, ForeignKey('sc_verticalcrs.id', use_alter=True, name='fk_sc_verticalcrs_coordinatesystem')), |
| 1102 | extend_existing=False,) |
| 1103 | |
| 1104 | |
| 1105 | |
| 1106 | |
| 1107 | |
| 1108 | |
| 1109 | |
| 1110 | |
| 1111 | |
| 1112 | |
| 1113 | |
| 1114 | |
| 1115 | li_processstep_table = Table('li_processstep', metadata, |
| 1116 | Column('id', Integer, Sequence('li_processstep_id_seq'), primary_key=True), |
| 1117 | Column('li_lineage_processstep', Integer, ForeignKey('li_lineage.id')), |
| 1118 | Column('li_source_sourcestep', Integer, ForeignKey('li_source.id', use_alter=True, name='fk_li_source_sourcestep')), |
| 1119 | Column('rationale', TEXT , nullable=True), |
| 1120 | Column('description', TEXT , nullable=False), |
| 1121 | extend_existing=False,) |
| 1122 | |
| 1123 | |
| 1124 | |
| 1125 | |
| 1126 | |
| 1127 | |
| 1128 | |
| 1129 | |
| 1130 | |
| 1131 | |
| 1132 | |
| 1133 | |
| 1134 | gfi_feature_table = Table('gfi_feature', metadata, |
| 1135 | Column('id', Integer, Sequence('gfi_feature_id_seq'), primary_key=True), |
| 1136 | Column('om_observation_featureofinterest_id', Integer, ForeignKey('om_observation.id', use_alter=True, name='fk_om_observation_featureofinterest')), |
| 1137 | extend_existing=False,) |
| 1138 | |
| 1139 | |
| 1140 | |
| 1141 | |
| 1142 | |
| 1143 | |
| 1144 | |
| 1145 | |
| 1146 | |
| 1147 | |
| 1148 | |
| 1149 | |
| 1150 | cc_generalparametervalue_table = Table('cc_generalparametervalue', metadata, |
| 1151 | Column('id', Integer, Sequence('cc_generalparametervalue_id_seq'), primary_key=True), |
| 1152 | Column('cc_parametervaluegroup__cc_generalparametervalue_id', Integer, ForeignKey('cc_parametervaluegroup.id')), |
| 1153 | Column('cc_singleoperation_parametervalue', Integer, ForeignKey('cc_singleoperation.id', use_alter=True, name='fk_cc_singleoperation_parametervalue')), |
| 1154 | Column('cc_parametervaluegroup_parametervalue', Integer, ForeignKey('cc_parametervaluegroup.id', use_alter=True, name='fk_cc_parametervaluegroup_parametervalue')), |
| 1155 | Column('cc_generaloperationparameter_value', Integer, ForeignKey('cc_generaloperationparameter.id', use_alter=True, name='fk_cc_generaloperationparameter_value')), |
| 1156 | extend_existing=False,) |
| 1157 | |
| 1158 | |
| 1159 | |
| 1160 | |
| 1161 | |
| 1162 | |
| 1163 | |
| 1164 | |
| 1165 | |
| 1166 | |
| 1167 | |
| 1168 | |
| 1169 | ds_aggregate_table = Table('ds_aggregate', metadata, |
| 1170 | Column('id', Integer, Sequence('ds_aggregate_id_seq'), primary_key=True), |
| 1171 | Column('ds_dataset_partof', Integer, ForeignKey('ds_dataset.id', use_alter=True, name='fk_ds_dataset_partof')), |
| 1172 | Column('md_metadata_series', Integer, ForeignKey('md_metadata.id', use_alter=True, name='fk_md_metadata_series')), |
| 1173 | extend_existing=False,) |
| 1174 | |
| 1175 | |
| 1176 | |
| 1177 | |
| 1178 | |
| 1179 | |
| 1180 | |
| 1181 | |
| 1182 | |
| 1183 | |
| 1184 | |
| 1185 | |
| 1186 | md_representativefraction_table = Table('md_representativefraction', metadata, |
| 1187 | Column('id', Integer, Sequence('md_representativefraction_id_seq'), primary_key=True), |
| 1188 | Column('li_source_scaledenominator_id', Integer, ForeignKey('li_source.id')), |
| 1189 | Column('denominator', Integer , nullable=False), |
| 1190 | extend_existing=False,) |
| 1191 | |
| 1192 | |
| 1193 | |
| 1194 | |
| 1195 | |
| 1196 | |
| 1197 | |
| 1198 | |
| 1199 | |
| 1200 | |
| 1201 | |
| 1202 | |
| 1203 | rs_referencesystem_table = Table('rs_referencesystem', metadata, |
| 1204 | Column('id', Integer, Sequence('rs_referencesystem_id_seq'), primary_key=True), |
| 1205 | Column('tm_referencesystem__rs_referencesystem_id', Integer, ForeignKey('tm_referencesystem.id')), |
| 1206 | Column('sc_crs__rs_referencesystem_id', Integer, ForeignKey('sc_crs.id')), |
1102 | | md_distributor_table = Table('md_distributor', metadata, |
1103 | | Column('id', Integer, Sequence('md_distributor_id_seq'), primary_key=True), |
1104 | | Column('md_format_formatdistributor', Integer, ForeignKey('md_format.id', use_alter=True, name='fk_md_format_formatdistributor')), |
1105 | | Column('md_distribution_distributor', Integer, ForeignKey('md_distribution.id')), |
1106 | | extend_existing=False,) |
1107 | | |
1108 | | |
1109 | | |
1110 | | |
1111 | | |
1112 | | |
1113 | | |
1114 | | |
1115 | | |
1116 | | |
1117 | | |
1118 | | |
1119 | | ds_aggregate_table = Table('ds_aggregate', metadata, |
1120 | | Column('id', Integer, Sequence('ds_aggregate_id_seq'), primary_key=True), |
1121 | | Column('ds_dataset_partof', Integer, ForeignKey('ds_dataset.id', use_alter=True, name='fk_ds_dataset_partof')), |
1122 | | Column('md_metadata_series', Integer, ForeignKey('md_metadata.id', use_alter=True, name='fk_md_metadata_series')), |
| 1237 | md_format_table = Table('md_format', metadata, |
| 1238 | Column('id', Integer, Sequence('md_format_id_seq'), primary_key=True), |
| 1239 | Column('md_distribution_distributionformat', Integer, ForeignKey('md_distribution.id')), |
| 1240 | Column('md_identification_resourceformat', Integer, ForeignKey('md_identification.id')), |
| 1241 | Column('md_distributor_distributorformat', Integer, ForeignKey('md_distributor.id', use_alter=True, name='fk_md_distributor_distributorformat')), |
| 1242 | Column('amendmentNumber', TEXT , nullable=True), |
| 1243 | Column('fileDecompressionTechnique', TEXT , nullable=True), |
| 1244 | Column('name', TEXT , nullable=False), |
| 1245 | Column('version', TEXT , nullable=False), |
| 1246 | Column('specification', TEXT , nullable=True), |
| 1247 | extend_existing=False,) |
| 1248 | |
| 1249 | |
| 1250 | |
| 1251 | |
| 1252 | |
| 1253 | |
| 1254 | |
| 1255 | |
| 1256 | |
| 1257 | |
| 1258 | |
| 1259 | |
| 1260 | ci_responsibility_table = Table('ci_responsibility', metadata, |
| 1261 | Column('id', Integer, Sequence('ci_responsibility_id_seq'), primary_key=True), |
| 1262 | Column('mo_responsiblepartyinfo__ci_responsibility_id', Integer, ForeignKey('mo_responsiblepartyinfo.id')), |
| 1263 | extend_existing=False,) |
| 1264 | |
| 1265 | |
| 1266 | |
| 1267 | |
| 1268 | |
| 1269 | |
| 1270 | |
| 1271 | |
| 1272 | |
| 1273 | |
| 1274 | |
| 1275 | |
| 1276 | scopedname_table = Table('scopedname', metadata, |
| 1277 | Column('id', Integer, Sequence('scopedname_id_seq'), primary_key=True), |
| 1278 | Column('mo_onlineresource_servicefunction_id', Integer, ForeignKey('mo_onlineresource.id')), |
| 1279 | Column('mo_instrument_type_id', Integer, ForeignKey('mo_instrument.id')), |
| 1280 | extend_existing=False,) |
| 1281 | |
| 1282 | |
| 1283 | |
| 1284 | |
| 1285 | |
| 1286 | |
| 1287 | |
| 1288 | |
| 1289 | |
| 1290 | |
| 1291 | |
| 1292 | |
| 1293 | ceda_result_table = Table('ceda_result', metadata, |
| 1294 | Column('id', Integer, Sequence('ceda_result_id_seq'), primary_key=True), |
| 1295 | Column('numberOfFiles', Integer , nullable=True), |
| 1296 | Column('volume', Integer , nullable=True), |
| 1297 | Column('internalPath', TEXT , nullable=False), |
| 1298 | Column('curationCategory', CEDA_CurationValue.db_type() , nullable=False), |
| 1299 | extend_existing=False,) |
| 1300 | |
| 1301 | |
| 1302 | |
| 1303 | |
| 1304 | |
| 1305 | |
| 1306 | |
| 1307 | |
| 1308 | |
| 1309 | |
| 1310 | |
| 1311 | |
| 1312 | le_nominalresolution_table = Table('le_nominalresolution', metadata, |
| 1313 | Column('id', Integer, Sequence('le_nominalresolution_id_seq'), primary_key=True), |
| 1314 | Column('le_source_resolution_id', Integer, ForeignKey('le_source.id')), |
| 1315 | extend_existing=False,) |
| 1316 | |
| 1317 | |
| 1318 | |
| 1319 | |
| 1320 | |
| 1321 | |
| 1322 | |
| 1323 | |
| 1324 | |
| 1325 | |
| 1326 | |
| 1327 | |
| 1328 | ceda_acquisition_table = Table('ceda_acquisition', metadata, |
| 1329 | Column('id', Integer, Sequence('ceda_acquisition_id_seq'), primary_key=True), |
| 1330 | extend_existing=False,) |
| 1331 | |
| 1332 | |
| 1333 | |
| 1334 | |
| 1335 | |
| 1336 | |
| 1337 | |
| 1338 | |
| 1339 | |
| 1340 | |
| 1341 | |
| 1342 | |
| 1343 | cv_footprint_table = Table('cv_footprint', metadata, |
| 1344 | Column('id', Integer, Sequence('cv_footprint_id_seq'), primary_key=True), |
| 1345 | Column('cv_gridpoint_footprint', Integer, ForeignKey('cv_gridpoint.id', use_alter=True, name='fk_cv_gridpoint_footprint')), |
| 1346 | extend_existing=False,) |
| 1347 | |
| 1348 | |
| 1349 | |
| 1350 | |
| 1351 | |
| 1352 | |
| 1353 | |
| 1354 | |
| 1355 | |
| 1356 | |
| 1357 | |
| 1358 | |
| 1359 | md_maintenanceinformation_table = Table('md_maintenanceinformation', metadata, |
| 1360 | Column('id', Integer, Sequence('md_maintenanceinformation_id_seq'), primary_key=True), |
| 1361 | Column('md_identification_resourcemaintenance', Integer, ForeignKey('md_identification.id', use_alter=True, name='fk_md_identification_resourcemaintenance')), |
| 1362 | Column('md_metadata_metadatamaintenance_id', Integer, ForeignKey('md_metadata.id', use_alter=True, name='fk_md_metadata_metadatamaintenance')), |
| 1363 | Column('maintenanceAndUpdateFrequency', MD_MaintenanceFrequencyCode.db_type() , nullable=False), |
| 1364 | Column('maintenanceNote', ARRAY(TEXT) , nullable=True), |
| 1365 | Column('updateScope', MD_ScopeCode.db_type() , nullable=True), |
| 1366 | extend_existing=False,) |
| 1367 | |
| 1368 | |
| 1369 | |
| 1370 | |
| 1371 | |
| 1372 | |
| 1373 | |
| 1374 | |
| 1375 | |
| 1376 | |
| 1377 | |
| 1378 | |
| 1379 | md_portrayalcataloguereference_table = Table('md_portrayalcataloguereference', metadata, |
| 1380 | Column('id', Integer, Sequence('md_portrayalcataloguereference_id_seq'), primary_key=True), |
| 1381 | Column('md_metadata_portrayalcatalogueinfo', Integer, ForeignKey('md_metadata.id')), |
| 1382 | extend_existing=False,) |
| 1383 | |
| 1384 | |
| 1385 | |
| 1386 | |
| 1387 | |
| 1388 | |
| 1389 | |
| 1390 | |
| 1391 | |
| 1392 | |
| 1393 | |
| 1394 | |
| 1395 | md_aggregateinformation_table = Table('md_aggregateinformation', metadata, |
| 1396 | Column('id', Integer, Sequence('md_aggregateinformation_id_seq'), primary_key=True), |
| 1397 | Column('md_identification_aggregationinfo', Integer, ForeignKey('md_identification.id')), |
| 1398 | Column('initiativeType', DS_InitiativeTypeCode.db_type() , nullable=True), |
| 1399 | Column('associationType', DS_AssociationTypeCode.db_type() , nullable=False), |
| 1400 | extend_existing=False,) |
| 1401 | |
| 1402 | |
| 1403 | |
| 1404 | |
| 1405 | |
| 1406 | |
| 1407 | |
| 1408 | |
| 1409 | |
| 1410 | |
| 1411 | |
| 1412 | |
| 1413 | cc_formula_table = Table('cc_formula', metadata, |
| 1414 | Column('id', Integer, Sequence('cc_formula_id_seq'), primary_key=True), |
| 1415 | Column('cc_operationmethod_formulareference_id', Integer, ForeignKey('cc_operationmethod.id')), |
| 1416 | Column('formula', TEXT , nullable=False), |
| 1417 | extend_existing=False,) |
| 1418 | |
| 1419 | |
| 1420 | |
| 1421 | |
| 1422 | |
| 1423 | |
| 1424 | |
| 1425 | |
| 1426 | |
| 1427 | |
| 1428 | |
| 1429 | |
| 1430 | cs_coordinatesystemaxis_table = Table('cs_coordinatesystemaxis', metadata, |
| 1431 | Column('id', Integer, Sequence('cs_coordinatesystemaxis_id_seq'), primary_key=True), |
| 1432 | Column('cs_coordinatesystem_axis', Integer, ForeignKey('cs_coordinatesystem.id', use_alter=True, name='fk_cs_coordinatesystem_axis')), |
| 1433 | Column('minimumValue', NUMERIC , nullable=True), |
| 1434 | Column('maximumValue', NUMERIC , nullable=True), |
| 1435 | Column('axisAbbrev', TEXT , nullable=False), |
| 1436 | Column('axisDirection', CS_AxisDirection.db_type() , nullable=False), |
| 1437 | Column('rangeMeaning', CS_RangeMeaning.db_type() , nullable=True), |
| 1438 | extend_existing=False,) |
| 1439 | |
| 1440 | |
| 1441 | |
| 1442 | |
| 1443 | |
| 1444 | |
| 1445 | |
| 1446 | |
| 1447 | |
| 1448 | |
| 1449 | |
| 1450 | |
| 1451 | gf_operation_table = Table('gf_operation', metadata, |
| 1452 | Column('id', Integer, Sequence('gf_operation_id_seq'), primary_key=True), |
| 1453 | Column('gf_associationtype_thegf_operation', Integer, ForeignKey('gf_associationtype.id', use_alter=True, name='fk_gf_associationtype_thegf_operation')), |
| 1454 | Column('signature', TEXT , nullable=False), |
| 1455 | extend_existing=False,) |
| 1456 | |
| 1457 | |
| 1458 | |
| 1459 | |
| 1460 | |
| 1461 | |
| 1462 | |
| 1463 | |
| 1464 | |
| 1465 | |
| 1466 | |
| 1467 | |
| 1468 | cc_generaloperationparameter_table = Table('cc_generaloperationparameter', metadata, |
| 1469 | Column('id', Integer, Sequence('cc_generaloperationparameter_id_seq'), primary_key=True), |
| 1470 | Column('cc_generalparametervalue_parameter_id', Integer, ForeignKey('cc_generalparametervalue.id', use_alter=True, name='fk_cc_generalparametervalue_parameter')), |
| 1471 | Column('cc_operationparametergroup__cc_generaloperationparameter_id', Integer, ForeignKey('cc_operationparametergroup.id')), |
| 1472 | Column('cc_operationparametergroup_parameter', Integer, ForeignKey('cc_operationparametergroup.id', use_alter=True, name='fk_cc_operationparametergroup_parameter')), |
| 1473 | Column('minimumOccurs', Integer , nullable=True), |
| 1474 | extend_existing=False,) |
| 1475 | |
| 1476 | |
| 1477 | |
| 1478 | |
| 1479 | |
| 1480 | |
| 1481 | |
| 1482 | |
| 1483 | |
| 1484 | |
| 1485 | |
| 1486 | |
| 1487 | tm_temporalposition_table = Table('tm_temporalposition', metadata, |
| 1488 | Column('id', Integer, Sequence('tm_temporalposition_id_seq'), primary_key=True), |
| 1489 | Column('tm_referencesystem_position', Integer, ForeignKey('tm_referencesystem.id', use_alter=True, name='fk_tm_referencesystem_position')), |
| 1490 | Column('tm_position_anyother_id', Integer, ForeignKey('tm_position.id')), |
| 1491 | Column('indeterminatePosition', TM_IndeterminateValue.db_type() , nullable=True), |
| 1492 | extend_existing=False,) |
| 1493 | |
| 1494 | |
| 1495 | |
| 1496 | |
| 1497 | |
| 1498 | |
| 1499 | |
| 1500 | |
| 1501 | |
| 1502 | |
| 1503 | |
| 1504 | |
| 1505 | om_observation_table = Table('om_observation', metadata, |
| 1506 | Column('id', Integer, Sequence('om_observation_id_seq'), primary_key=True), |
| 1507 | Column('mo_observation__om_observation_id', Integer, ForeignKey('mo_observation.id')), |
| 1508 | Column('om_process_generatedobservation', Integer, ForeignKey('om_process.id', use_alter=True, name='fk_om_process_generatedobservation')), |
| 1509 | Column('gfi_feature_propertyvalueprovider', Integer, ForeignKey('gfi_feature.id', use_alter=True, name='fk_gfi_feature_propertyvalueprovider')), |
| 1510 | extend_existing=False,) |
| 1511 | |
| 1512 | |
| 1513 | |
| 1514 | |
| 1515 | |
| 1516 | |
| 1517 | |
| 1518 | |
| 1519 | |
| 1520 | |
| 1521 | |
| 1522 | |
| 1523 | tm_edge_table = Table('tm_edge', metadata, |
| 1524 | Column('id', Integer, Sequence('tm_edge_id_seq'), primary_key=True), |
| 1525 | Column('tm_node_nextedge', Integer, ForeignKey('tm_node.id', use_alter=True, name='fk_tm_node_nextedge')), |
| 1526 | Column('tm_node_previousedge', Integer, ForeignKey('tm_node.id', use_alter=True, name='fk_tm_node_previousedge')), |
| 1527 | Column('tm_period_topology_id', Integer, ForeignKey('tm_period.id', use_alter=True, name='fk_tm_period_topology')), |
| 1528 | extend_existing=False,) |
| 1529 | |
| 1530 | |
| 1531 | |
| 1532 | |
| 1533 | |
| 1534 | |
| 1535 | |
| 1536 | |
| 1537 | |
| 1538 | |
| 1539 | |
| 1540 | |
| 1541 | mo_observation_table = Table('mo_observation', metadata, |
| 1542 | Column('id', Integer, Sequence('mo_observation_id_seq'), primary_key=True), |
| 1543 | Column('mo_observationcollection_member', Integer, ForeignKey('mo_observationcollection.id', use_alter=True, name='fk_mo_observationcollection_member')), |
| 1544 | Column('ceda_observation__mo_observation_id', Integer, ForeignKey('ceda_observation.id')), |
| 1545 | Column('status', MD_ProgressCode.db_type() , nullable=True), |
| 1546 | Column('description', TEXT , nullable=True), |
| 1547 | Column('publicationState', MO_PublicationStateValue.db_type() , nullable=True), |
| 1548 | Column('resultAccumulation', MD_MaintenanceFrequencyCode.db_type() , nullable=True), |
| 1549 | Column('resolution', TEXT , nullable=True), |
| 1550 | extend_existing=False,) |
| 1551 | |
| 1552 | |
| 1553 | |
| 1554 | |
| 1555 | |
| 1556 | |
| 1557 | |
| 1558 | |
| 1559 | |
| 1560 | |
| 1561 | |
| 1562 | |
| 1563 | localname_table = Table('localname', metadata, |
| 1564 | Column('id', Integer, Sequence('localname_id_seq'), primary_key=True), |
| 1565 | Column('schema_schemaname_id', Integer, ForeignKey('schema.id')), |
| 1566 | Column('typename__localname_id', Integer, ForeignKey('typename.id')), |
| 1567 | Column('gf_propertytype_membername_id', Integer, ForeignKey('gf_propertytype.id')), |
| 1568 | Column('gf_featuretype_typename_id', Integer, ForeignKey('gf_featuretype.id')), |
| 1569 | extend_existing=False,) |
| 1570 | |
| 1571 | |
| 1572 | |
| 1573 | |
| 1574 | |
| 1575 | |
| 1576 | |
| 1577 | |
| 1578 | |
| 1579 | |
| 1580 | |
| 1581 | |
| 1582 | gm_complex_table = Table('gm_complex', metadata, |
| 1583 | Column('id', Integer, Sequence('gm_complex_id_seq'), primary_key=True), |
| 1584 | Column('gm_primitive_complex', Integer, ForeignKey('gm_primitive.id', use_alter=True, name='fk_gm_primitive_complex')), |
| 1585 | Column('tp_complex_geometry_id', Integer, ForeignKey('tp_complex.id', use_alter=True, name='fk_tp_complex_geometry')), |
| 1586 | Column('gm_composite__gm_complex_id', Integer, ForeignKey('gm_composite.id')), |
| 1587 | extend_existing=False,) |
| 1588 | |
| 1589 | |
| 1590 | |
| 1591 | |
| 1592 | |
| 1593 | |
| 1594 | |
| 1595 | |
| 1596 | |
| 1597 | |
| 1598 | |
| 1599 | |
| 1600 | cv_gridcell_table = Table('cv_gridcell', metadata, |
| 1601 | Column('id', Integer, Sequence('cv_gridcell_id_seq'), primary_key=True), |
| 1602 | Column('cv_grid_cell', Integer, ForeignKey('cv_grid.id', use_alter=True, name='fk_cv_grid_cell')), |
| 1603 | Column('cv_gridpoint_cell', Integer, ForeignKey('cv_gridpoint.id', use_alter=True, name='fk_cv_gridpoint_cell')), |
| 1604 | extend_existing=False,) |
| 1605 | |
| 1606 | |
| 1607 | |
| 1608 | |
| 1609 | |
| 1610 | |
| 1611 | |
| 1612 | |
| 1613 | |
| 1614 | |
| 1615 | |
| 1616 | |
| 1617 | gm_orientableprimitive_table = Table('gm_orientableprimitive', metadata, |
| 1618 | Column('id', Integer, Sequence('gm_orientableprimitive_id_seq'), primary_key=True), |
| 1619 | Column('gm_primitive_proxy_id', Integer, ForeignKey('gm_primitive.id', use_alter=True, name='fk_gm_primitive_proxy')), |
| 1620 | Column('orientation', Sign.db_type() , nullable=False), |
| 1621 | extend_existing=False,) |
| 1622 | |
| 1623 | |
| 1624 | |
| 1625 | |
| 1626 | |
| 1627 | |
| 1628 | |
| 1629 | |
| 1630 | |
| 1631 | |
| 1632 | |
| 1633 | |
| 1634 | li_lineage_table = Table('li_lineage', metadata, |
| 1635 | Column('id', Integer, Sequence('li_lineage_id_seq'), primary_key=True), |
| 1636 | Column('dq_dataquality_lineage_id', Integer, ForeignKey('dq_dataquality.id')), |
| 1637 | Column('statement', TEXT , nullable=True), |
| 1638 | extend_existing=False,) |
| 1639 | |
| 1640 | |
| 1641 | |
| 1642 | |
| 1643 | |
| 1644 | |
| 1645 | |
| 1646 | |
| 1647 | |
| 1648 | |
| 1649 | |
| 1650 | |
| 1651 | cv_coverage_table = Table('cv_coverage', metadata, |
| 1652 | Column('id', Integer, Sequence('cv_coverage_id_seq'), primary_key=True), |
| 1653 | Column('cv_domainobject_collection_id', Integer, ForeignKey('cv_domainobject.id', use_alter=True, name='fk_cv_domainobject_collection')), |
| 1654 | Column('cv_attributevalues_collection_id', Integer, ForeignKey('cv_attributevalues.id', use_alter=True, name='fk_cv_attributevalues_collection')), |
| 1655 | Column('commonPointRule', CV_CommonPointRule.db_type() , nullable=False), |
| 1656 | extend_existing=False,) |
| 1657 | |
| 1658 | |
| 1659 | |
| 1660 | |
| 1661 | |
| 1662 | |
| 1663 | |
| 1664 | |
| 1665 | |
| 1666 | |
| 1667 | |
| 1668 | |
| 1669 | dq_scope_table = Table('dq_scope', metadata, |
| 1670 | Column('id', Integer, Sequence('dq_scope_id_seq'), primary_key=True), |
| 1671 | Column('dq_dataquality_scope_id', Integer, ForeignKey('dq_dataquality.id', use_alter=True, name='fk_dq_dataquality_scope')), |
| 1672 | Column('level', MD_ScopeCode.db_type() , nullable=False), |
| 1673 | extend_existing=False,) |
| 1674 | |
| 1675 | |
| 1676 | |
| 1677 | |
| 1678 | |
| 1679 | |
| 1680 | |
| 1681 | |
| 1682 | |
| 1683 | |
| 1684 | |
| 1685 | |
| 1686 | gm_composite_table = Table('gm_composite', metadata, |
| 1687 | Column('id', Integer, Sequence('gm_composite_id_seq'), primary_key=True), |
| 1688 | Column('gm_compositepoint__gm_composite_id', Integer, ForeignKey('gm_compositepoint.id')), |
| 1689 | Column('gm_primitive_composite', Integer, ForeignKey('gm_primitive.id', use_alter=True, name='fk_gm_primitive_composite')), |
| 1690 | extend_existing=False,) |
| 1691 | |
| 1692 | |
| 1693 | |
| 1694 | |
| 1695 | |
| 1696 | |
| 1697 | |
| 1698 | |
| 1699 | |
| 1700 | |
| 1701 | |
| 1702 | |
| 1703 | mo_platform_table = Table('mo_platform', metadata, |
| 1704 | Column('id', Integer, Sequence('mo_platform_id_seq'), primary_key=True), |
| 1705 | Column('mo_operation_platform', Integer, ForeignKey('mo_operation.id')), |
| 1706 | Column('mo_instrumentplatformpair_platform_id', Integer, ForeignKey('mo_instrumentplatformpair.id')), |
| 1707 | Column('ceda_platform__mo_platform_id', Integer, ForeignKey('ceda_platform.id')), |
| 1708 | Column('mo_acquisition_platform', Integer, ForeignKey('mo_acquisition.id')), |
| 1709 | Column('description', TEXT , nullable=True), |
| 1710 | Column('type', MO_PlatformTypeValue.db_type() , nullable=True), |
| 1711 | extend_existing=False,) |
| 1712 | |
| 1713 | |
| 1714 | |
| 1715 | |
| 1716 | |
| 1717 | |
| 1718 | |
| 1719 | |
| 1720 | |
| 1721 | |
| 1722 | |
| 1723 | |
| 1724 | mo_inputoutput_table = Table('mo_inputoutput', metadata, |
| 1725 | Column('id', Integer, Sequence('mo_inputoutput_id_seq'), primary_key=True), |
| 1726 | Column('mo_acquisition_outputdescription_id', Integer, ForeignKey('mo_acquisition.id')), |
| 1727 | Column('mo_processing_processingoutput_id', Integer, ForeignKey('mo_processing.id')), |
| 1728 | Column('mo_processing_processinginput', Integer, ForeignKey('mo_processing.id')), |
1151 | | gm_point_table = Table('gm_point', metadata, |
1152 | | Column('id', Integer, Sequence('gm_point_id_seq'), primary_key=True), |
1153 | | Column('cv_gridpoint_groundpoint', Integer, ForeignKey('cv_gridpoint.id', use_alter=True, name='fk_cv_gridpoint_groundpoint')), |
1154 | | Column('gm_compositepoint__gm_point_id', Integer, ForeignKey('gm_compositepoint.id')), |
1155 | | Column('gm_compositepoint_generator_id', Integer, ForeignKey('gm_compositepoint.id', use_alter=True, name='fk_gm_compositepoint_generator')), |
1156 | | extend_existing=False,) |
1157 | | |
1158 | | |
1159 | | |
1160 | | |
1161 | | |
1162 | | |
1163 | | |
1164 | | |
1165 | | |
1166 | | |
1167 | | |
1168 | | |
1169 | | gm_complex_table = Table('gm_complex', metadata, |
1170 | | Column('id', Integer, Sequence('gm_complex_id_seq'), primary_key=True), |
1171 | | Column('gm_composite__gm_complex_id', Integer, ForeignKey('gm_composite.id')), |
1172 | | Column('tp_complex_geometry_id', Integer, ForeignKey('tp_complex.id', use_alter=True, name='fk_tp_complex_geometry')), |
1173 | | Column('gm_primitive_complex', Integer, ForeignKey('gm_primitive.id', use_alter=True, name='fk_gm_primitive_complex')), |
| 1757 | mo_instrument_table = Table('mo_instrument', metadata, |
| 1758 | Column('id', Integer, Sequence('mo_instrument_id_seq'), primary_key=True), |
| 1759 | Column('ceda_instrument__mo_instrument_id', Integer, ForeignKey('ceda_instrument.id')), |
| 1760 | Column('mo_instrumentplatformpair_instrument_id', Integer, ForeignKey('mo_instrumentplatformpair.id')), |
| 1761 | Column('mo_acquisition_instrument', Integer, ForeignKey('mo_acquisition.id')), |
| 1762 | Column('description', TEXT , nullable=True), |
| 1763 | extend_existing=False,) |
| 1764 | |
| 1765 | |
| 1766 | |
| 1767 | |
| 1768 | |
| 1769 | |
| 1770 | |
| 1771 | |
| 1772 | |
| 1773 | |
| 1774 | |
| 1775 | |
| 1776 | ceda_observation_table = Table('ceda_observation', metadata, |
| 1777 | Column('id', Integer, Sequence('ceda_observation_id_seq'), primary_key=True), |
| 1778 | Column('dataLineage', TEXT , nullable=False), |
| 1779 | extend_existing=False,) |
| 1780 | |
| 1781 | |
| 1782 | |
| 1783 | |
| 1784 | |
| 1785 | |
| 1786 | |
| 1787 | |
| 1788 | |
| 1789 | |
| 1790 | |
| 1791 | |
| 1792 | ex_extent_table = Table('ex_extent', metadata, |
| 1793 | Column('id', Integer, Sequence('ex_extent_id_seq'), primary_key=True), |
| 1794 | Column('rs_referencesystem_domainofvalidity_id', Integer, ForeignKey('rs_referencesystem.id', use_alter=True, name='fk_rs_referencesystem_domainofvalidity')), |
| 1795 | Column('cc_coordinateoperation_domainofvalidity_id', Integer, ForeignKey('cc_coordinateoperation.id', use_alter=True, name='fk_cc_coordinateoperation_domainofvalidity')), |
| 1796 | Column('dq_scope_extent_id', Integer, ForeignKey('dq_scope.id')), |
| 1797 | Column('cd_datum_domainofvalidity_id', Integer, ForeignKey('cd_datum.id', use_alter=True, name='fk_cd_datum_domainofvalidity')), |
| 1798 | Column('ci_responsiblepartyinfo_extent', Integer, ForeignKey('ci_responsiblepartyinfo.id')), |
| 1799 | Column('cv_coverage_domainextent', Integer, ForeignKey('cv_coverage.id', use_alter=True, name='fk_cv_coverage_domainextent')), |
| 1800 | Column('li_source_sourceextent', Integer, ForeignKey('li_source.id')), |
| 1801 | Column('tm_referencesystem_domainofvalidity', Integer, ForeignKey('tm_referencesystem.id')), |
| 1802 | Column('description', TEXT , nullable=True), |
| 1803 | extend_existing=False,) |
| 1804 | |
| 1805 | |
| 1806 | |
| 1807 | |
| 1808 | |
| 1809 | |
| 1810 | |
| 1811 | |
| 1812 | |
| 1813 | |
| 1814 | |
| 1815 | |
| 1816 | mo_observationcollection_table = Table('mo_observationcollection', metadata, |
| 1817 | Column('id', Integer, Sequence('mo_observationcollection_id_seq'), primary_key=True), |
| 1818 | Column('mo_project_observationcollection', Integer, ForeignKey('mo_project.id')), |
| 1819 | Column('ceda_observationcollection__mo_observationcollection_id', Integer, ForeignKey('ceda_observationcollection.id')), |
| 1820 | Column('description', TEXT , nullable=True), |
| 1821 | Column('publicationState', MO_PublicationStateValue.db_type() , nullable=True), |
| 1822 | extend_existing=False,) |
| 1823 | |
| 1824 | |
| 1825 | |
| 1826 | |
| 1827 | |
| 1828 | |
| 1829 | |
| 1830 | |
| 1831 | |
| 1832 | |
| 1833 | |
| 1834 | |
| 1835 | mo_acquisition_table = Table('mo_acquisition', metadata, |
| 1836 | Column('id', Integer, Sequence('mo_acquisition_id_seq'), primary_key=True), |
| 1837 | Column('ceda_acquisition__mo_acquisition_id', Integer, ForeignKey('ceda_acquisition.id')), |
| 1838 | Column('mo_compositeprocess_acquisitioncomponent', Integer, ForeignKey('mo_compositeprocess.id')), |
| 1839 | Column('description', TEXT , nullable=True), |
| 1840 | extend_existing=False,) |
| 1841 | |
| 1842 | |
| 1843 | |
| 1844 | |
| 1845 | |
| 1846 | |
| 1847 | |
| 1848 | |
| 1849 | |
| 1850 | |
| 1851 | |
| 1852 | |
| 1853 | tm_instant_table = Table('tm_instant', metadata, |
| 1854 | Column('id', Integer, Sequence('tm_instant_id_seq'), primary_key=True), |
| 1855 | Column('tm_period_begin_id', Integer, ForeignKey('tm_period.id', use_alter=True, name='fk_tm_period_begin')), |
| 1856 | Column('tm_period_end_id', Integer, ForeignKey('tm_period.id', use_alter=True, name='fk_tm_period_end')), |
| 1857 | Column('om_observation_resulttime_id', Integer, ForeignKey('om_observation.id')), |
| 1858 | Column('tm_node_geometry_id', Integer, ForeignKey('tm_node.id', use_alter=True, name='fk_tm_node_geometry')), |
| 1859 | extend_existing=False,) |
| 1860 | |
| 1861 | |
| 1862 | |
| 1863 | |
| 1864 | |
| 1865 | |
| 1866 | |
| 1867 | |
| 1868 | |
| 1869 | |
| 1870 | |
| 1871 | |
| 1872 | md_metadata_table = Table('md_metadata', metadata, |
| 1873 | Column('id', Integer, Sequence('md_metadata_id_seq'), primary_key=True), |
| 1874 | Column('gf_attributetype_featureattributemetadata', Integer, ForeignKey('gf_attributetype.id', use_alter=True, name='fk_gf_attributetype_featureattributemetadata')), |
| 1875 | Column('ds_aggregate_seriesmetadata', Integer, ForeignKey('ds_aggregate.id', use_alter=True, name='fk_ds_aggregate_seriesmetadata')), |
| 1876 | Column('gf_featuretype_featuretypemetadata', Integer, ForeignKey('gf_featuretype.id', use_alter=True, name='fk_gf_featuretype_featuretypemetadata')), |
| 1877 | Column('mo_observationcollection_isometadata', Integer, ForeignKey('mo_observationcollection.id')), |
| 1878 | Column('om_observation_metadata_id', Integer, ForeignKey('om_observation.id')), |
| 1879 | Column('cl_dataset_has', Integer, ForeignKey('cl_dataset.id', use_alter=True, name='fk_cl_dataset_has')), |
| 1880 | Column('ds_dataset_has', Integer, ForeignKey('ds_dataset.id', use_alter=True, name='fk_ds_dataset_has')), |
| 1881 | Column('gf_propertytype_propertytypemetadata', Integer, ForeignKey('gf_propertytype.id', use_alter=True, name='fk_gf_propertytype_propertytypemetadata')), |
| 1882 | Column('characterSet', MD_CharacterSetCode.db_type() , nullable=True), |
| 1883 | Column('fileIdentifier', TEXT , nullable=True), |
| 1884 | Column('hierarchyLevelName', ARRAY(TEXT) , nullable=True), |
| 1885 | Column('dataSet', TEXT , nullable=True), |
| 1886 | Column('metadataStandardVersion', TEXT , nullable=True), |
| 1887 | Column('parentIdentifier', TEXT , nullable=True), |
| 1888 | Column('metadataStandardName', TEXT , nullable=True), |
| 1889 | Column('hierarchyLevel', MD_ScopeCode.db_type() , nullable=True), |
| 1890 | Column('language', TEXT , nullable=True), |
| 1891 | extend_existing=False,) |
| 1892 | |
| 1893 | |
| 1894 | |
| 1895 | |
| 1896 | |
| 1897 | |
| 1898 | |
| 1899 | |
| 1900 | |
| 1901 | |
| 1902 | |
| 1903 | |
| 1904 | gf_inheritancerelation_table = Table('gf_inheritancerelation', metadata, |
| 1905 | Column('id', Integer, Sequence('gf_inheritancerelation_id_seq'), primary_key=True), |
| 1906 | Column('gf_featuretype_thegf_inheritancerelation', Integer, ForeignKey('gf_featuretype.id', use_alter=True, name='fk_gf_featuretype_thegf_inheritancerelation')), |
| 1907 | Column('description', TEXT , nullable=False), |
| 1908 | Column('uniqueInstance', BOOLEAN , nullable=False), |
| 1909 | Column('name', TEXT , nullable=False), |
| 1910 | extend_existing=False,) |
| 1911 | |
| 1912 | |
| 1913 | |
| 1914 | |
| 1915 | |
| 1916 | |
| 1917 | |
| 1918 | |
| 1919 | |
| 1920 | |
| 1921 | |
| 1922 | |
| 1923 | ex_verticalextent_table = Table('ex_verticalextent', metadata, |
| 1924 | Column('id', Integer, Sequence('ex_verticalextent_id_seq'), primary_key=True), |
| 1925 | Column('ex_extent_verticalelement', Integer, ForeignKey('ex_extent.id', use_alter=True, name='fk_ex_extent_verticalelement')), |
| 1926 | Column('mo_observationcollection_verticalextent', Integer, ForeignKey('mo_observationcollection.id')), |
| 1927 | Column('mo_observation_verticalextent', Integer, ForeignKey('mo_observation.id')), |
| 1928 | Column('minimumValue', NUMERIC , nullable=False), |
| 1929 | Column('maximumValue', NUMERIC , nullable=False), |
| 1930 | extend_existing=False,) |
| 1931 | |
| 1932 | |
| 1933 | |
| 1934 | |
| 1935 | |
| 1936 | |
| 1937 | |
| 1938 | |
| 1939 | |
| 1940 | |
| 1941 | |
| 1942 | |
| 1943 | tm_referencesystem_table = Table('tm_referencesystem', metadata, |
| 1944 | Column('id', Integer, Sequence('tm_referencesystem_id_seq'), primary_key=True), |
| 1945 | Column('tm_temporalposition_frame_id', Integer, ForeignKey('tm_temporalposition.id', use_alter=True, name='fk_tm_temporalposition_frame')), |
| 1946 | extend_existing=False,) |
| 1947 | |
| 1948 | |
| 1949 | |
| 1950 | |
| 1951 | |
| 1952 | |
| 1953 | |
| 1954 | |
| 1955 | |
| 1956 | |
| 1957 | |
| 1958 | |
| 1959 | ceda_review_table = Table('ceda_review', metadata, |
| 1960 | Column('id', Integer, Sequence('ceda_review_id_seq'), primary_key=True), |
| 1961 | Column('ceda_operation_review', Integer, ForeignKey('ceda_operation.id')), |
| 1962 | Column('ceda_processing_review', Integer, ForeignKey('ceda_processing.id')), |
| 1963 | Column('ceda_project_review', Integer, ForeignKey('ceda_project.id')), |
| 1964 | Column('ceda_platform_review', Integer, ForeignKey('ceda_platform.id')), |
| 1965 | Column('ceda_observation_internalreview', Integer, ForeignKey('ceda_observation.id')), |
| 1966 | Column('ceda_observationcollection_review', Integer, ForeignKey('ceda_observationcollection.id')), |
| 1967 | Column('ceda_instrument_review', Integer, ForeignKey('ceda_instrument.id')), |
| 1968 | Column('ceda_acquisition_review', Integer, ForeignKey('ceda_acquisition.id')), |
| 1969 | Column('ceda_compositeprocess_review', Integer, ForeignKey('ceda_compositeprocess.id')), |
| 1970 | Column('reviewStatus', CEDA_ReviewStatusValue.db_type() , nullable=False), |
| 1971 | Column('reviewFrequency', CEDA_ReviewFrequencyValue.db_type() , nullable=False), |
| 1972 | extend_existing=False,) |
| 1973 | |
| 1974 | |
| 1975 | |
| 1976 | |
| 1977 | |
| 1978 | |
| 1979 | |
| 1980 | |
| 1981 | |
| 1982 | |
| 1983 | |
| 1984 | |
| 1985 | sc_generalderivedcrs_table = Table('sc_generalderivedcrs', metadata, |
| 1986 | Column('id', Integer, Sequence('sc_generalderivedcrs_id_seq'), primary_key=True), |
| 1987 | Column('sc_derivedcrs__sc_generalderivedcrs_id', Integer, ForeignKey('sc_derivedcrs.id')), |
| 1988 | Column('cc_conversion_referencesystem', Integer, ForeignKey('cc_conversion.id', use_alter=True, name='fk_cc_conversion_referencesystem')), |
| 1989 | extend_existing=False,) |
| 1990 | |
| 1991 | |
| 1992 | |
| 1993 | |
| 1994 | |
| 1995 | |
| 1996 | |
| 1997 | |
| 1998 | |
| 1999 | |
| 2000 | |
| 2001 | |
| 2002 | tm_topologicalprimitive_table = Table('tm_topologicalprimitive', metadata, |
| 2003 | Column('id', Integer, Sequence('tm_topologicalprimitive_id_seq'), primary_key=True), |
| 2004 | Column('tm_node__tm_topologicalprimitive_id', Integer, ForeignKey('tm_node.id')), |
| 2005 | Column('tm_edge__tm_topologicalprimitive_id', Integer, ForeignKey('tm_edge.id')), |
| 2006 | Column('tm_topologicalcomplex_primitive', Integer, ForeignKey('tm_topologicalcomplex.id', use_alter=True, name='fk_tm_topologicalcomplex_primitive')), |
| 2007 | extend_existing=False,) |
| 2008 | |
| 2009 | |
| 2010 | |
| 2011 | |
| 2012 | |
| 2013 | |
| 2014 | |
| 2015 | |
| 2016 | |
| 2017 | |
| 2018 | |
| 2019 | |
| 2020 | dq_element_table = Table('dq_element', metadata, |
| 2021 | Column('id', Integer, Sequence('dq_element_id_seq'), primary_key=True), |
| 2022 | Column('dq_dataquality_report', Integer, ForeignKey('dq_dataquality.id')), |
| 2023 | Column('dq_positionalaccuracy__dq_element_id', Integer, ForeignKey('dq_positionalaccuracy.id')), |
| 2024 | Column('om_observation_resultquality', Integer, ForeignKey('om_observation.id')), |
| 2025 | Column('measureDescription', TEXT , nullable=True), |
| 2026 | Column('nameOfMeasure', ARRAY(TEXT) , nullable=True), |
| 2027 | Column('evaluationMethodDescription', TEXT , nullable=True), |
| 2028 | Column('evaluationMethodType', DQ_EvaluationMethodTypeCode.db_type() , nullable=True), |
| 2029 | extend_existing=False,) |
| 2030 | |
| 2031 | |
| 2032 | |
| 2033 | |
| 2034 | |
| 2035 | |
| 2036 | |
| 2037 | |
| 2038 | |
| 2039 | |
| 2040 | |
| 2041 | |
| 2042 | uomscale_table = Table('uomscale', metadata, |
| 2043 | Column('id', Integer, Sequence('uomscale_id_seq'), primary_key=True), |
| 2044 | Column('scale_uom_id', Integer, ForeignKey('scale.id')), |
| 2045 | extend_existing=False,) |
| 2046 | |
| 2047 | |
| 2048 | |
| 2049 | |
| 2050 | |
| 2051 | |
| 2052 | |
| 2053 | |
| 2054 | |
| 2055 | |
| 2056 | |
| 2057 | |
| 2058 | tp_primitive_table = Table('tp_primitive', metadata, |
| 2059 | Column('id', Integer, Sequence('tp_primitive_id_seq'), primary_key=True), |
| 2060 | Column('tp_directedtopo__tp_primitive_id', Integer, ForeignKey('tp_directedtopo.id')), |
| 2061 | Column('tp_directedtopo_topo_id', Integer, ForeignKey('tp_directedtopo.id', use_alter=True, name='fk_tp_directedtopo_topo')), |
| 2062 | Column('gm_primitive_topology', Integer, ForeignKey('gm_primitive.id', use_alter=True, name='fk_gm_primitive_topology')), |
| 2063 | Column('tp_complex_element', Integer, ForeignKey('tp_complex.id', use_alter=True, name='fk_tp_complex_element')), |
| 2064 | extend_existing=False,) |
| 2065 | |
| 2066 | |
| 2067 | |
| 2068 | |
| 2069 | |
| 2070 | |
| 2071 | |
| 2072 | |
| 2073 | |
| 2074 | |
| 2075 | |
| 2076 | |
| 2077 | ci_citation_table = Table('ci_citation', metadata, |
| 2078 | Column('id', Integer, Sequence('ci_citation_id_seq'), primary_key=True), |
| 2079 | Column('dq_element_evaluationprocedure_id', Integer, ForeignKey('dq_element.id')), |
| 2080 | Column('li_source_sourcecitation_id', Integer, ForeignKey('li_source.id')), |
| 2081 | Column('mo_project_dmp_id', Integer, ForeignKey('mo_project.id')), |
| 2082 | Column('md_aggregateinformation_aggregatedatasetname_id', Integer, ForeignKey('md_aggregateinformation.id')), |
| 2083 | Column('mo_instrument_documentation', Integer, ForeignKey('mo_instrument.id')), |
| 2084 | Column('mo_processing_softwarereference_id', Integer, ForeignKey('mo_processing.id')), |
| 2085 | Column('md_portrayalcataloguereference_portrayalcataloguecitation', Integer, ForeignKey('md_portrayalcataloguereference.id')), |
| 2086 | Column('md_identifier_authority_id', Integer, ForeignKey('md_identifier.id', use_alter=True, name='fk_md_identifier_authority')), |
| 2087 | Column('md_identification_citation_id', Integer, ForeignKey('md_identification.id')), |
| 2088 | Column('cc_formula_formulacitation_id', Integer, ForeignKey('cc_formula.id')), |
| 2089 | Column('mo_compositeprocess_documentation', Integer, ForeignKey('mo_compositeprocess.id')), |
| 2090 | Column('md_keywords_thesaurusname_id', Integer, ForeignKey('md_keywords.id')), |
| 2091 | Column('mo_observation_documentation', Integer, ForeignKey('mo_observation.id')), |
| 2092 | Column('md_applicationschemainformation_name_id', Integer, ForeignKey('md_applicationschemainformation.id')), |
| 2093 | Column('mo_project_documentation', Integer, ForeignKey('mo_project.id')), |
| 2094 | Column('mo_acquisition_documentation', Integer, ForeignKey('mo_acquisition.id')), |
| 2095 | Column('mo_platform_documentation', Integer, ForeignKey('mo_platform.id')), |
| 2096 | Column('mo_operation_documentation', Integer, ForeignKey('mo_operation.id')), |
| 2097 | Column('le_algorithm_citation_id', Integer, ForeignKey('le_algorithm.id')), |
| 2098 | Column('mo_processing_documentation', Integer, ForeignKey('mo_processing.id')), |
| 2099 | Column('alternateTitle', ARRAY(TEXT) , nullable=True), |
| 2100 | Column('ISBN', TEXT , nullable=True), |
| 2101 | Column('presentationForm', CI_PresentationFormCode.db_type() , nullable=True), |
| 2102 | Column('collectiveTitle', TEXT , nullable=True), |
| 2103 | Column('ISSN', TEXT , nullable=True), |
| 2104 | Column('title', TEXT , nullable=False), |
| 2105 | Column('edition', TEXT , nullable=True), |
| 2106 | Column('otherCitationDetails', TEXT , nullable=True), |
| 2107 | extend_existing=False,) |
| 2108 | |
| 2109 | |
| 2110 | |
| 2111 | |
| 2112 | |
| 2113 | |
| 2114 | |
| 2115 | |
| 2116 | |
| 2117 | |
| 2118 | |
| 2119 | |
| 2120 | tm_node_table = Table('tm_node', metadata, |
| 2121 | Column('id', Integer, Sequence('tm_node_id_seq'), primary_key=True), |
| 2122 | Column('tm_instant_topology_id', Integer, ForeignKey('tm_instant.id', use_alter=True, name='fk_tm_instant_topology')), |
| 2123 | Column('tm_edge_start_id', Integer, ForeignKey('tm_edge.id', use_alter=True, name='fk_tm_edge_start')), |
| 2124 | Column('tm_edge_end_id', Integer, ForeignKey('tm_edge.id', use_alter=True, name='fk_tm_edge_end')), |
| 2125 | extend_existing=False,) |
| 2126 | |
| 2127 | |
| 2128 | |
| 2129 | |
| 2130 | |
| 2131 | |
| 2132 | |
| 2133 | |
| 2134 | |
| 2135 | |
| 2136 | |
| 2137 | |
| 2138 | le_source_table = Table('le_source', metadata, |
| 2139 | Column('id', Integer, Sequence('le_source_id_seq'), primary_key=True), |
| 2140 | Column('mo_inputoutput_description_id', Integer, ForeignKey('mo_inputoutput.id')), |
| 2141 | extend_existing=False,) |
| 2142 | |
| 2143 | |
| 2144 | |
| 2145 | |
| 2146 | |
| 2147 | |
| 2148 | |
| 2149 | |
| 2150 | |
| 2151 | |
| 2152 | |
| 2153 | |
| 2154 | dq_positionalaccuracy_table = Table('dq_positionalaccuracy', metadata, |
| 2155 | Column('id', Integer, Sequence('dq_positionalaccuracy_id_seq'), primary_key=True), |
| 2156 | Column('cc_coordinateoperation_coordinateoperationaccuracy', Integer, ForeignKey('cc_coordinateoperation.id')), |
| 2157 | extend_existing=False,) |
| 2158 | |
| 2159 | |
| 2160 | |
| 2161 | |
| 2162 | |
| 2163 | |
| 2164 | |
| 2165 | |
| 2166 | |
| 2167 | |
| 2168 | |
| 2169 | |
| 2170 | sc_singlecrs_table = Table('sc_singlecrs', metadata, |
| 2171 | Column('id', Integer, Sequence('sc_singlecrs_id_seq'), primary_key=True), |
| 2172 | Column('sc_verticalcrs__sc_singlecrs_id', Integer, ForeignKey('sc_verticalcrs.id')), |
| 2173 | Column('sc_generalderivedcrs__sc_singlecrs_id', Integer, ForeignKey('sc_generalderivedcrs.id')), |
| 2174 | Column('cd_datum_referencesystem', Integer, ForeignKey('cd_datum.id', use_alter=True, name='fk_cd_datum_referencesystem')), |
| 2175 | Column('cs_coordinatesystem_referencesystem', Integer, ForeignKey('cs_coordinatesystem.id', use_alter=True, name='fk_cs_coordinatesystem_referencesystem')), |
| 2176 | Column('sc_derivedcrs_basecrs_id', Integer, ForeignKey('sc_derivedcrs.id', use_alter=True, name='fk_sc_derivedcrs_basecrs')), |
| 2177 | Column('sc_compoundcrs_componentreferencesystem', Integer, ForeignKey('sc_compoundcrs.id', use_alter=True, name='fk_sc_compoundcrs_componentreferencesystem')), |
| 2178 | extend_existing=False,) |
| 2179 | |
| 2180 | |
| 2181 | |
| 2182 | |
| 2183 | |
| 2184 | |
| 2185 | |
| 2186 | |
| 2187 | |
| 2188 | |
| 2189 | |
| 2190 | |
| 2191 | mo_computation_table = Table('mo_computation', metadata, |
| 2192 | Column('id', Integer, Sequence('mo_computation_id_seq'), primary_key=True), |
| 2193 | Column('mo_processing__mo_computation_id', Integer, ForeignKey('mo_processing.id')), |
| 2194 | Column('mo_compositeprocess_computationcomponent', Integer, ForeignKey('mo_compositeprocess.id')), |
| 2195 | extend_existing=False,) |
| 2196 | |
| 2197 | |
| 2198 | |
| 2199 | |
| 2200 | |
| 2201 | |
| 2202 | |
| 2203 | |
| 2204 | |
| 2205 | |
| 2206 | |
| 2207 | |
| 2208 | cv_attributevalues_table = Table('cv_attributevalues', metadata, |
| 2209 | Column('id', Integer, Sequence('cv_attributevalues_id_seq'), primary_key=True), |
| 2210 | Column('cv_coverage_rangeelement', Integer, ForeignKey('cv_coverage.id', use_alter=True, name='fk_cv_coverage_rangeelement')), |
| 2211 | extend_existing=False,) |
| 2212 | |
| 2213 | |
| 2214 | |
| 2215 | |
| 2216 | |
| 2217 | |
| 2218 | |
| 2219 | |
| 2220 | |
| 2221 | |
| 2222 | |
| 2223 | |
| 2224 | md_keywords_table = Table('md_keywords', metadata, |
| 2225 | Column('id', Integer, Sequence('md_keywords_id_seq'), primary_key=True), |
| 2226 | Column('mo_project_keywords', Integer, ForeignKey('mo_project.id')), |
| 2227 | Column('ceda_observation_keywords', Integer, ForeignKey('ceda_observation.id')), |
| 2228 | Column('md_identification_descriptivekeywords', Integer, ForeignKey('md_identification.id')), |
| 2229 | Column('keyword', ARRAY(TEXT) , nullable=False), |
| 2230 | Column('type', MD_KeywordTypeCode.db_type() , nullable=True), |
| 2231 | extend_existing=False,) |
| 2232 | |
| 2233 | |
| 2234 | |
| 2235 | |
| 2236 | |
| 2237 | |
| 2238 | |
| 2239 | |
| 2240 | |
| 2241 | |
| 2242 | |
| 2243 | |
| 2244 | sc_verticalcrs_table = Table('sc_verticalcrs', metadata, |
| 2245 | Column('id', Integer, Sequence('sc_verticalcrs_id_seq'), primary_key=True), |
| 2246 | Column('ex_verticalextent_verticalcrs_id', Integer, ForeignKey('ex_verticalextent.id')), |
| 2247 | Column('cs_verticalcs_referencesystem', Integer, ForeignKey('cs_verticalcs.id', use_alter=True, name='fk_cs_verticalcs_referencesystem')), |
| 2248 | Column('cd_verticaldatum_referencesystem', Integer, ForeignKey('cd_verticaldatum.id', use_alter=True, name='fk_cd_verticaldatum_referencesystem')), |
1239 | | ceda_processing_table = Table('ceda_processing', metadata, |
1240 | | Column('id', Integer, Sequence('ceda_processing_id_seq'), primary_key=True), |
1241 | | extend_existing=False,) |
1242 | | |
1243 | | |
1244 | | |
1245 | | |
1246 | | |
1247 | | |
1248 | | |
1249 | | |
1250 | | |
1251 | | |
1252 | | |
1253 | | |
1254 | | sc_crs_table = Table('sc_crs', metadata, |
1255 | | Column('id', Integer, Sequence('sc_crs_id_seq'), primary_key=True), |
1256 | | Column('directposition_crs_id', Integer, ForeignKey('directposition.id', use_alter=True, name='fk_directposition_crs')), |
1257 | | Column('cc_coordinateoperation_sourcecrs_id', Integer, ForeignKey('cc_coordinateoperation.id', use_alter=True, name='fk_cc_coordinateoperation_sourcecrs')), |
1258 | | Column('ex_verticalextent_verticalcrs_id', Integer, ForeignKey('ex_verticalextent.id', use_alter=True, name='fk_ex_verticalextent_verticalcrs')), |
1259 | | Column('gm_object_crs_id', Integer, ForeignKey('gm_object.id', use_alter=True, name='fk_gm_object_crs')), |
1260 | | Column('sc_singlecrs__sc_crs_id', Integer, ForeignKey('sc_singlecrs.id')), |
1261 | | Column('cv_coverage_crs_id', Integer, ForeignKey('cv_coverage.id')), |
1262 | | Column('sc_compoundcrs__sc_crs_id', Integer, ForeignKey('sc_compoundcrs.id')), |
1263 | | Column('cc_coordinateoperation_targetcrs_id', Integer, ForeignKey('cc_coordinateoperation.id', use_alter=True, name='fk_cc_coordinateoperation_targetcrs')), |
1264 | | Column('cv_referenceablegrid_crs', Integer, ForeignKey('cv_referenceablegrid.id', use_alter=True, name='fk_cv_referenceablegrid_crs')), |
1265 | | Column('scope', ARRAY(TEXT) , nullable=False), |
1266 | | extend_existing=False,) |
1267 | | |
1268 | | |
1269 | | |
1270 | | |
1271 | | |
1272 | | |
1273 | | |
1274 | | |
1275 | | |
1276 | | |
1277 | | |
1278 | | |
1279 | | length_table = Table('length', metadata, |
1280 | | Column('id', Integer, Sequence('length_id_seq'), primary_key=True), |
1281 | | Column('distance__length_id', Integer, ForeignKey('distance.id')), |
1282 | | extend_existing=False,) |
1283 | | |
1284 | | |
1285 | | |
1286 | | |
1287 | | |
1288 | | |
1289 | | |
1290 | | |
1291 | | |
1292 | | |
1293 | | |
1294 | | |
1295 | | sc_singlecrs_table = Table('sc_singlecrs', metadata, |
1296 | | Column('id', Integer, Sequence('sc_singlecrs_id_seq'), primary_key=True), |
1297 | | Column('cd_datum_referencesystem', Integer, ForeignKey('cd_datum.id', use_alter=True, name='fk_cd_datum_referencesystem')), |
1298 | | Column('cs_coordinatesystem_referencesystem', Integer, ForeignKey('cs_coordinatesystem.id', use_alter=True, name='fk_cs_coordinatesystem_referencesystem')), |
1299 | | Column('sc_verticalcrs__sc_singlecrs_id', Integer, ForeignKey('sc_verticalcrs.id')), |
1300 | | Column('sc_derivedcrs_basecrs_id', Integer, ForeignKey('sc_derivedcrs.id', use_alter=True, name='fk_sc_derivedcrs_basecrs')), |
1301 | | Column('sc_compoundcrs_componentreferencesystem', Integer, ForeignKey('sc_compoundcrs.id', use_alter=True, name='fk_sc_compoundcrs_componentreferencesystem')), |
1302 | | Column('sc_generalderivedcrs__sc_singlecrs_id', Integer, ForeignKey('sc_generalderivedcrs.id')), |
1303 | | extend_existing=False,) |
1304 | | |
1305 | | |
1306 | | |
1307 | | |
1308 | | |
1309 | | |
1310 | | |
1311 | | |
1312 | | |
1313 | | |
1314 | | |
1315 | | |
1316 | | mo_acquisition_table = Table('mo_acquisition', metadata, |
1317 | | Column('id', Integer, Sequence('mo_acquisition_id_seq'), primary_key=True), |
1318 | | Column('mo_compositeprocess_acquisitioncomponent', Integer, ForeignKey('mo_compositeprocess.id')), |
1319 | | Column('ceda_acquisition__mo_acquisition_id', Integer, ForeignKey('ceda_acquisition.id')), |
1320 | | Column('description', TEXT , nullable=True), |
| 2295 | cd_verticaldatum_table = Table('cd_verticaldatum', metadata, |
| 2296 | Column('id', Integer, Sequence('cd_verticaldatum_id_seq'), primary_key=True), |
| 2297 | Column('sc_verticalcrs_datum_id', Integer, ForeignKey('sc_verticalcrs.id', use_alter=True, name='fk_sc_verticalcrs_datum')), |
| 2298 | extend_existing=False,) |
| 2299 | |
| 2300 | |
| 2301 | |
| 2302 | |
| 2303 | |
| 2304 | |
| 2305 | |
| 2306 | |
| 2307 | |
| 2308 | |
| 2309 | |
| 2310 | |
| 2311 | ci_responsiblepartyinfo_table = Table('ci_responsiblepartyinfo', metadata, |
| 2312 | Column('id', Integer, Sequence('ci_responsiblepartyinfo_id_seq'), primary_key=True), |
| 2313 | Column('ci_responsibility__ci_responsiblepartyinfo_id', Integer, ForeignKey('ci_responsibility.id')), |
| 2314 | Column('role', CI_RoleCode.db_type() , nullable=False), |
| 2315 | extend_existing=False,) |
| 2316 | |
| 2317 | |
| 2318 | |
| 2319 | |
| 2320 | |
| 2321 | |
| 2322 | |
| 2323 | |
| 2324 | |
| 2325 | |
| 2326 | |
| 2327 | |
| 2328 | distance_table = Table('distance', metadata, |
| 2329 | Column('id', Integer, Sequence('distance_id_seq'), primary_key=True), |
| 2330 | Column('le_nominalresolution_groundresolution_id', Integer, ForeignKey('le_nominalresolution.id')), |
| 2331 | Column('le_nominalresolution_scanningresolution_id', Integer, ForeignKey('le_nominalresolution.id')), |
| 2332 | extend_existing=False,) |
| 2333 | |
| 2334 | |
| 2335 | |
| 2336 | |
| 2337 | |
| 2338 | |
| 2339 | |
| 2340 | |
| 2341 | |
| 2342 | |
| 2343 | |
| 2344 | |
| 2345 | cl_dataset_table = Table('cl_dataset', metadata, |
| 2346 | Column('id', Integer, Sequence('cl_dataset_id_seq'), primary_key=True), |
| 2347 | Column('md_metadata_describes', Integer, ForeignKey('md_metadata.id', use_alter=True, name='fk_md_metadata_describes')), |
1435 | | uomlength_table = Table('uomlength', metadata, |
1436 | | Column('id', Integer, Sequence('uomlength_id_seq'), primary_key=True), |
1437 | | Column('scale_sourceunits_id', Integer, ForeignKey('scale.id')), |
1438 | | Column('scale_targetunits_id', Integer, ForeignKey('scale.id')), |
1439 | | Column('length_uom_id', Integer, ForeignKey('length.id')), |
1440 | | extend_existing=False,) |
1441 | | |
1442 | | |
1443 | | |
1444 | | |
1445 | | |
1446 | | |
1447 | | |
1448 | | |
1449 | | |
1450 | | |
1451 | | |
1452 | | |
1453 | | cd_datum_table = Table('cd_datum', metadata, |
1454 | | Column('id', Integer, Sequence('cd_datum_id_seq'), primary_key=True), |
1455 | | Column('sc_singlecrs_datum_id', Integer, ForeignKey('sc_singlecrs.id', use_alter=True, name='fk_sc_singlecrs_datum')), |
1456 | | Column('cd_verticaldatum__cd_datum_id', Integer, ForeignKey('cd_verticaldatum.id')), |
1457 | | Column('anchorDefinition', TEXT , nullable=True), |
1458 | | Column('scope', ARRAY(TEXT) , nullable=False), |
1459 | | extend_existing=False,) |
1460 | | |
1461 | | |
1462 | | |
1463 | | |
1464 | | |
1465 | | |
1466 | | |
1467 | | |
1468 | | |
1469 | | |
1470 | | |
1471 | | |
1472 | | cv_gridcell_table = Table('cv_gridcell', metadata, |
1473 | | Column('id', Integer, Sequence('cv_gridcell_id_seq'), primary_key=True), |
1474 | | Column('cv_gridpoint_cell', Integer, ForeignKey('cv_gridpoint.id', use_alter=True, name='fk_cv_gridpoint_cell')), |
1475 | | Column('cv_grid_cell', Integer, ForeignKey('cv_grid.id', use_alter=True, name='fk_cv_grid_cell')), |
1476 | | extend_existing=False,) |
1477 | | |
1478 | | |
1479 | | |
1480 | | |
1481 | | |
1482 | | |
1483 | | |
1484 | | |
1485 | | |
1486 | | |
1487 | | |
1488 | | |
1489 | | mo_computation_table = Table('mo_computation', metadata, |
1490 | | Column('id', Integer, Sequence('mo_computation_id_seq'), primary_key=True), |
1491 | | Column('mo_processing__mo_computation_id', Integer, ForeignKey('mo_processing.id')), |
1492 | | Column('mo_compositeprocess_computationcomponent', Integer, ForeignKey('mo_compositeprocess.id')), |
| 2489 | ceda_platform_table = Table('ceda_platform', metadata, |
| 2490 | Column('id', Integer, Sequence('ceda_platform_id_seq'), primary_key=True), |
| 2491 | extend_existing=False,) |
| 2492 | |
| 2493 | |
| 2494 | |
| 2495 | |
| 2496 | |
| 2497 | |
| 2498 | |
| 2499 | |
| 2500 | |
| 2501 | |
| 2502 | |
| 2503 | |
| 2504 | io_identifiedobjectbase_table = Table('io_identifiedobjectbase', metadata, |
| 2505 | Column('id', Integer, Sequence('io_identifiedobjectbase_id_seq'), primary_key=True), |
| 2506 | Column('sc_crs__io_identifiedobjectbase_id', Integer, ForeignKey('sc_crs.id')), |
| 2507 | Column('io_identifiedobject__io_identifiedobjectbase_id', Integer, ForeignKey('io_identifiedobject.id')), |
| 2508 | Column('remarks', TEXT , nullable=True), |
| 2509 | extend_existing=False,) |
| 2510 | |
| 2511 | |
| 2512 | |
| 2513 | |
| 2514 | |
| 2515 | |
| 2516 | |
| 2517 | |
| 2518 | |
| 2519 | |
| 2520 | |
| 2521 | |
| 2522 | namespace_table = Table('namespace', metadata, |
| 2523 | Column('id', Integer, Sequence('namespace_id_seq'), primary_key=True), |
| 2524 | Column('genericname_scope_id', Integer, ForeignKey('genericname.id', use_alter=True, name='fk_genericname_scope')), |
| 2525 | Column('schema__namespace_id', Integer, ForeignKey('schema.id')), |
| 2526 | Column('isGlobal', BOOLEAN , nullable=False), |
| 2527 | extend_existing=False,) |
| 2528 | |
| 2529 | |
| 2530 | |
| 2531 | |
| 2532 | |
| 2533 | |
| 2534 | |
| 2535 | |
| 2536 | |
| 2537 | |
| 2538 | |
| 2539 | |
| 2540 | cc_operationparametergroup_table = Table('cc_operationparametergroup', metadata, |
| 2541 | Column('id', Integer, Sequence('cc_operationparametergroup_id_seq'), primary_key=True), |
| 2542 | Column('cc_generaloperationparameter_group', Integer, ForeignKey('cc_generaloperationparameter.id', use_alter=True, name='fk_cc_generaloperationparameter_group')), |
| 2543 | Column('cc_parametervaluegroup_group_id', Integer, ForeignKey('cc_parametervaluegroup.id', use_alter=True, name='fk_cc_parametervaluegroup_group')), |
| 2544 | Column('maximumOccurs', Integer , nullable=True), |
| 2545 | extend_existing=False,) |
| 2546 | |
| 2547 | |
| 2548 | |
| 2549 | |
| 2550 | |
| 2551 | |
| 2552 | |
| 2553 | |
| 2554 | |
| 2555 | |
| 2556 | |
| 2557 | |
| 2558 | cv_domainobject_table = Table('cv_domainobject', metadata, |
| 2559 | Column('id', Integer, Sequence('cv_domainobject_id_seq'), primary_key=True), |
| 2560 | Column('cv_gridpoint__cv_domainobject_id', Integer, ForeignKey('cv_gridpoint.id')), |
| 2561 | Column('cv_coverage_domainelement', Integer, ForeignKey('cv_coverage.id', use_alter=True, name='fk_cv_coverage_domainelement')), |
| 2562 | extend_existing=False,) |
| 2563 | |
| 2564 | |
| 2565 | |
| 2566 | |
| 2567 | |
| 2568 | |
| 2569 | |
| 2570 | |
| 2571 | |
| 2572 | |
| 2573 | |
| 2574 | |
| 2575 | gm_point_table = Table('gm_point', metadata, |
| 2576 | Column('id', Integer, Sequence('gm_point_id_seq'), primary_key=True), |
| 2577 | Column('gm_compositepoint_generator_id', Integer, ForeignKey('gm_compositepoint.id', use_alter=True, name='fk_gm_compositepoint_generator')), |
| 2578 | Column('gm_compositepoint__gm_point_id', Integer, ForeignKey('gm_compositepoint.id')), |
| 2579 | Column('cv_gridpoint_groundpoint', Integer, ForeignKey('cv_gridpoint.id', use_alter=True, name='fk_cv_gridpoint_groundpoint')), |
| 2580 | extend_existing=False,) |
| 2581 | |
| 2582 | |
| 2583 | |
| 2584 | |
| 2585 | |
| 2586 | |
| 2587 | |
| 2588 | |
| 2589 | |
| 2590 | |
| 2591 | |
| 2592 | |
| 2593 | om_process_table = Table('om_process', metadata, |
| 2594 | Column('id', Integer, Sequence('om_process_id_seq'), primary_key=True), |
| 2595 | Column('mo_process__om_process_id', Integer, ForeignKey('mo_process.id')), |
| 2596 | Column('om_observation_procedure_id', Integer, ForeignKey('om_observation.id', use_alter=True, name='fk_om_observation_procedure')), |
| 2597 | extend_existing=False,) |
| 2598 | |
| 2599 | |
| 2600 | |
| 2601 | |
| 2602 | |
| 2603 | |
| 2604 | |
| 2605 | |
| 2606 | |
| 2607 | |
| 2608 | |
| 2609 | |
| 2610 | dq_dataquality_table = Table('dq_dataquality', metadata, |
| 2611 | Column('id', Integer, Sequence('dq_dataquality_id_seq'), primary_key=True), |
| 2612 | Column('md_metadata_dataqualityinfo', Integer, ForeignKey('md_metadata.id')), |
| 2613 | extend_existing=False,) |
| 2614 | |
| 2615 | |
| 2616 | |
| 2617 | |
| 2618 | |
| 2619 | |
| 2620 | |
| 2621 | |
| 2622 | |
| 2623 | |
| 2624 | |
| 2625 | |
| 2626 | mo_project_table = Table('mo_project', metadata, |
| 2627 | Column('id', Integer, Sequence('mo_project_id_seq'), primary_key=True), |
| 2628 | Column('mo_observation_insupportof_id', Integer, ForeignKey('mo_observation.id', use_alter=True, name='fk_mo_observation_insupportof')), |
| 2629 | Column('ceda_project__mo_project_id', Integer, ForeignKey('ceda_project.id')), |
| 2630 | Column('status', MD_ProgressCode.db_type() , nullable=True), |
| 2631 | Column('description', TEXT , nullable=True), |
| 2632 | Column('publicationState', MO_PublicationStateValue.db_type() , nullable=True), |
| 2633 | Column('abstract', TEXT , nullable=True), |
| 2634 | extend_existing=False,) |
| 2635 | |
| 2636 | |
| 2637 | |
| 2638 | |
| 2639 | |
| 2640 | |
| 2641 | |
| 2642 | |
| 2643 | |
| 2644 | |
| 2645 | |
| 2646 | |
| 2647 | cc_passthroughoperation_table = Table('cc_passthroughoperation', metadata, |
| 2648 | Column('id', Integer, Sequence('cc_passthroughoperation_id_seq'), primary_key=True), |
| 2649 | Column('cc_coordinateoperation_passthruoperation', Integer, ForeignKey('cc_coordinateoperation.id', use_alter=True, name='fk_cc_coordinateoperation_passthruoperation')), |
| 2650 | Column('modifiedCoordinate', ARRAY(Integer) , nullable=False), |
| 2651 | extend_existing=False,) |
| 2652 | |
| 2653 | |
| 2654 | |
| 2655 | |
| 2656 | |
| 2657 | |
| 2658 | |
| 2659 | |
| 2660 | |
| 2661 | |
| 2662 | |
| 2663 | |
| 2664 | mo_responsiblepartyinfo_table = Table('mo_responsiblepartyinfo', metadata, |
| 2665 | Column('id', Integer, Sequence('mo_responsiblepartyinfo_id_seq'), primary_key=True), |
| 2666 | Column('mo_compositeprocess_relatedparty', Integer, ForeignKey('mo_compositeprocess.id')), |
| 2667 | Column('mo_processing_relatedparty', Integer, ForeignKey('mo_processing.id')), |
| 2668 | Column('mo_instrument_realatedparty', Integer, ForeignKey('mo_instrument.id')), |
| 2669 | Column('mo_acquisition_realatedparty', Integer, ForeignKey('mo_acquisition.id')), |
| 2670 | Column('mo_operation_relatedpartyinfo', Integer, ForeignKey('mo_operation.id')), |
| 2671 | Column('mo_observation_relatedparty', Integer, ForeignKey('mo_observation.id')), |
| 2672 | Column('mo_organization_relatedparty', Integer, ForeignKey('mo_organization.id')), |
| 2673 | Column('mo_platform_relatedparty', Integer, ForeignKey('mo_platform.id')), |
| 2674 | Column('ceda_review_reviewer_id', Integer, ForeignKey('ceda_review.id')), |
| 2675 | Column('ceda_observationcollection_cedaofficer_id', Integer, ForeignKey('ceda_observationcollection.id')), |
| 2676 | Column('mo_project_relatedparty', Integer, ForeignKey('mo_project.id')), |
| 2677 | Column('ceda_notes_commentator_id', Integer, ForeignKey('ceda_notes.id')), |
1561 | | Column('recordtype_membertype_id', Integer, ForeignKey('recordtype.id')), |
1562 | | extend_existing=False,) |
1563 | | |
1564 | | |
1565 | | |
1566 | | |
1567 | | |
1568 | | |
1569 | | |
1570 | | |
1571 | | |
1572 | | |
1573 | | |
1574 | | |
1575 | | ceda_acquisition_table = Table('ceda_acquisition', metadata, |
1576 | | Column('id', Integer, Sequence('ceda_acquisition_id_seq'), primary_key=True), |
| 2770 | Column('schema_description_id', Integer, ForeignKey('schema.id', use_alter=True, name='fk_schema_description')), |
| 2771 | extend_existing=False,) |
| 2772 | |
| 2773 | |
| 2774 | |
| 2775 | |
| 2776 | |
| 2777 | |
| 2778 | |
| 2779 | |
| 2780 | |
| 2781 | |
| 2782 | |
| 2783 | |
| 2784 | io_identifiedobject_table = Table('io_identifiedobject', metadata, |
| 2785 | Column('id', Integer, Sequence('io_identifiedobject_id_seq'), primary_key=True), |
| 2786 | Column('cd_datum__io_identifiedobject_id', Integer, ForeignKey('cd_datum.id')), |
| 2787 | Column('cc_operationmethod__io_identifiedobject_id', Integer, ForeignKey('cc_operationmethod.id')), |
| 2788 | Column('cs_coordinatesystemaxis__io_identifiedobject_id', Integer, ForeignKey('cs_coordinatesystemaxis.id')), |
| 2789 | Column('cs_coordinatesystem__io_identifiedobject_id', Integer, ForeignKey('cs_coordinatesystem.id')), |
| 2790 | Column('cc_coordinateoperation__io_identifiedobject_id', Integer, ForeignKey('cc_coordinateoperation.id')), |
| 2791 | Column('cc_generaloperationparameter__io_identifiedobject_id', Integer, ForeignKey('cc_generaloperationparameter.id')), |
| 2792 | extend_existing=False,) |
| 2793 | |
| 2794 | |
| 2795 | |
| 2796 | |
| 2797 | |
| 2798 | |
| 2799 | |
| 2800 | |
| 2801 | |
| 2802 | |
| 2803 | |
| 2804 | |
| 2805 | record_table = Table('record', metadata, |
| 2806 | Column('id', Integer, Sequence('record_id_seq'), primary_key=True), |
| 2807 | Column('cv_attributevalues_values_id', Integer, ForeignKey('cv_attributevalues.id')), |
| 2808 | Column('recordtype_record', Integer, ForeignKey('recordtype.id', use_alter=True, name='fk_recordtype_record')), |
| 2809 | extend_existing=False,) |
| 2810 | |
| 2811 | |
| 2812 | |
| 2813 | |
| 2814 | |
| 2815 | |
| 2816 | |
| 2817 | |
| 2818 | |
| 2819 | |
| 2820 | |
| 2821 | |
| 2822 | rs_identifier_table = Table('rs_identifier', metadata, |
| 2823 | Column('id', Integer, Sequence('rs_identifier_id_seq'), primary_key=True), |
| 2824 | Column('md_referencesystem_referencesystemidentifier_id', Integer, ForeignKey('md_referencesystem.id')), |
| 2825 | Column('tm_referencesystem_name_id', Integer, ForeignKey('tm_referencesystem.id')), |
| 2826 | Column('io_identifiedobjectbase_identifier', Integer, ForeignKey('io_identifiedobjectbase.id')), |
| 2827 | Column('rs_referencesystem_name_id', Integer, ForeignKey('rs_referencesystem.id')), |
| 2828 | Column('io_identifiedobject_name_id', Integer, ForeignKey('io_identifiedobject.id')), |
| 2829 | Column('version', TEXT , nullable=True), |
| 2830 | Column('codeSpace', TEXT , nullable=True), |
| 2831 | extend_existing=False,) |
| 2832 | |
| 2833 | |
| 2834 | |
| 2835 | |
| 2836 | |
| 2837 | |
| 2838 | |
| 2839 | |
| 2840 | |
| 2841 | |
| 2842 | |
| 2843 | |
| 2844 | cc_concatenatedoperation_table = Table('cc_concatenatedoperation', metadata, |
| 2845 | Column('id', Integer, Sequence('cc_concatenatedoperation_id_seq'), primary_key=True), |
| 2846 | Column('cc_coordinateoperation_concatoperation', Integer, ForeignKey('cc_coordinateoperation.id', use_alter=True, name='fk_cc_coordinateoperation_concatoperation')), |
| 2847 | extend_existing=False,) |
| 2848 | |
| 2849 | |
| 2850 | |
| 2851 | |
| 2852 | |
| 2853 | |
| 2854 | |
| 2855 | |
| 2856 | |
| 2857 | |
| 2858 | |
| 2859 | |
| 2860 | mo_location_table = Table('mo_location', metadata, |
| 2861 | Column('id', Integer, Sequence('mo_location_id_seq'), primary_key=True), |
| 2862 | Column('mo_operation_location_id', Integer, ForeignKey('mo_operation.id')), |
| 2863 | Column('mo_platform_location_id', Integer, ForeignKey('mo_platform.id')), |
| 2864 | extend_existing=False,) |
| 2865 | |
| 2866 | |
| 2867 | |
| 2868 | |
| 2869 | |
| 2870 | |
| 2871 | |
| 2872 | |
| 2873 | |
| 2874 | |
| 2875 | |
| 2876 | |
| 2877 | md_distribution_table = Table('md_distribution', metadata, |
| 2878 | Column('id', Integer, Sequence('md_distribution_id_seq'), primary_key=True), |
| 2879 | Column('md_metadata_distributioninfo_id', Integer, ForeignKey('md_metadata.id')), |
| 2880 | extend_existing=False,) |
| 2881 | |
| 2882 | |
| 2883 | |
| 2884 | |
| 2885 | |
| 2886 | |
| 2887 | |
| 2888 | |
| 2889 | |
| 2890 | |
| 2891 | |
| 2892 | |
| 2893 | tm_topologicalcomplex_table = Table('tm_topologicalcomplex', metadata, |
| 2894 | Column('id', Integer, Sequence('tm_topologicalcomplex_id_seq'), primary_key=True), |
| 2895 | Column('tm_topologicalprimitive_complex_id', Integer, ForeignKey('tm_topologicalprimitive.id', use_alter=True, name='fk_tm_topologicalprimitive_complex')), |
| 2896 | extend_existing=False,) |
| 2897 | |
| 2898 | |
| 2899 | |
| 2900 | |
| 2901 | |
| 2902 | |
| 2903 | |
| 2904 | |
| 2905 | |
| 2906 | |
| 2907 | |
| 2908 | |
| 2909 | ceda_processing_table = Table('ceda_processing', metadata, |
| 2910 | Column('id', Integer, Sequence('ceda_processing_id_seq'), primary_key=True), |
1590 | | mo_observation_table = Table('mo_observation', metadata, |
1591 | | Column('id', Integer, Sequence('mo_observation_id_seq'), primary_key=True), |
1592 | | Column('ceda_observation__mo_observation_id', Integer, ForeignKey('ceda_observation.id')), |
1593 | | Column('mo_observationcollection_member', Integer, ForeignKey('mo_observationcollection.id', use_alter=True, name='fk_mo_observationcollection_member')), |
1594 | | Column('resolution', TEXT , nullable=True), |
1595 | | Column('description', TEXT , nullable=True), |
1596 | | Column('status', MD_ProgressCode.db_type() , nullable=True), |
1597 | | Column('publicationState', MO_PublicationStateValue.db_type() , nullable=True), |
1598 | | Column('resultAccumulation', MD_MaintenanceFrequencyCode.db_type() , nullable=True), |
1599 | | extend_existing=False,) |
1600 | | |
1601 | | |
1602 | | |
1603 | | |
1604 | | |
1605 | | |
1606 | | |
1607 | | |
1608 | | |
1609 | | |
1610 | | |
1611 | | |
1612 | | li_lineage_table = Table('li_lineage', metadata, |
1613 | | Column('id', Integer, Sequence('li_lineage_id_seq'), primary_key=True), |
1614 | | Column('dq_dataquality_lineage_id', Integer, ForeignKey('dq_dataquality.id')), |
1615 | | Column('statement', TEXT , nullable=True), |
1616 | | extend_existing=False,) |
1617 | | |
1618 | | |
1619 | | |
1620 | | |
1621 | | |
1622 | | |
1623 | | |
1624 | | |
1625 | | |
1626 | | |
1627 | | |
1628 | | |
1629 | | gm_orientableprimitive_table = Table('gm_orientableprimitive', metadata, |
1630 | | Column('id', Integer, Sequence('gm_orientableprimitive_id_seq'), primary_key=True), |
1631 | | Column('gm_primitive_proxy_id', Integer, ForeignKey('gm_primitive.id', use_alter=True, name='fk_gm_primitive_proxy')), |
| 2924 | ceda_operation_table = Table('ceda_operation', metadata, |
| 2925 | Column('id', Integer, Sequence('ceda_operation_id_seq'), primary_key=True), |
| 2926 | extend_existing=False,) |
| 2927 | |
| 2928 | |
| 2929 | |
| 2930 | |
| 2931 | |
| 2932 | |
| 2933 | |
| 2934 | |
| 2935 | |
| 2936 | |
| 2937 | |
| 2938 | |
| 2939 | cd_datum_table = Table('cd_datum', metadata, |
| 2940 | Column('id', Integer, Sequence('cd_datum_id_seq'), primary_key=True), |
| 2941 | Column('cd_verticaldatum__cd_datum_id', Integer, ForeignKey('cd_verticaldatum.id')), |
| 2942 | Column('sc_singlecrs_datum_id', Integer, ForeignKey('sc_singlecrs.id', use_alter=True, name='fk_sc_singlecrs_datum')), |
| 2943 | Column('scope', ARRAY(TEXT) , nullable=False), |
| 2944 | Column('anchorDefinition', TEXT , nullable=True), |
| 2945 | extend_existing=False,) |
| 2946 | |
| 2947 | |
| 2948 | |
| 2949 | |
| 2950 | |
| 2951 | |
| 2952 | |
| 2953 | |
| 2954 | |
| 2955 | |
| 2956 | |
| 2957 | |
| 2958 | tp_expression_table = Table('tp_expression', metadata, |
| 2959 | Column('id', Integer, Sequence('tp_expression_id_seq'), primary_key=True), |
| 2960 | Column('tp_expressionterm_expression_id', Integer, ForeignKey('tp_expressionterm.id', use_alter=True, name='fk_tp_expressionterm_expression')), |
| 2961 | extend_existing=False,) |
| 2962 | |
| 2963 | |
| 2964 | |
| 2965 | |
| 2966 | |
| 2967 | |
| 2968 | |
| 2969 | |
| 2970 | |
| 2971 | |
| 2972 | |
| 2973 | |
| 2974 | sc_crs_table = Table('sc_crs', metadata, |
| 2975 | Column('id', Integer, Sequence('sc_crs_id_seq'), primary_key=True), |
| 2976 | Column('sc_singlecrs__sc_crs_id', Integer, ForeignKey('sc_singlecrs.id')), |
| 2977 | Column('ex_verticalextent_verticalcrs_id', Integer, ForeignKey('ex_verticalextent.id', use_alter=True, name='fk_ex_verticalextent_verticalcrs')), |
| 2978 | Column('cv_referenceablegrid_crs', Integer, ForeignKey('cv_referenceablegrid.id', use_alter=True, name='fk_cv_referenceablegrid_crs')), |
| 2979 | Column('directposition_crs_id', Integer, ForeignKey('directposition.id', use_alter=True, name='fk_directposition_crs')), |
| 2980 | Column('cc_coordinateoperation_targetcrs_id', Integer, ForeignKey('cc_coordinateoperation.id', use_alter=True, name='fk_cc_coordinateoperation_targetcrs')), |
| 2981 | Column('cv_coverage_crs_id', Integer, ForeignKey('cv_coverage.id')), |
| 2982 | Column('gm_object_crs_id', Integer, ForeignKey('gm_object.id', use_alter=True, name='fk_gm_object_crs')), |
| 2983 | Column('cc_coordinateoperation_sourcecrs_id', Integer, ForeignKey('cc_coordinateoperation.id', use_alter=True, name='fk_cc_coordinateoperation_sourcecrs')), |
| 2984 | Column('sc_compoundcrs__sc_crs_id', Integer, ForeignKey('sc_compoundcrs.id')), |
| 2985 | Column('scope', ARRAY(TEXT) , nullable=False), |
| 2986 | extend_existing=False,) |
| 2987 | |
| 2988 | |
| 2989 | |
| 2990 | |
| 2991 | |
| 2992 | |
| 2993 | |
| 2994 | |
| 2995 | |
| 2996 | |
| 2997 | |
| 2998 | |
| 2999 | mo_onlineresource_table = Table('mo_onlineresource', metadata, |
| 3000 | Column('id', Integer, Sequence('mo_onlineresource_id_seq'), primary_key=True), |
| 3001 | Column('mo_result_sample', Integer, ForeignKey('mo_result.id')), |
| 3002 | Column('ceda_project_projectresource', Integer, ForeignKey('ceda_project.id')), |
| 3003 | Column('mo_result_source', Integer, ForeignKey('mo_result.id')), |
| 3004 | extend_existing=False,) |
| 3005 | |
| 3006 | |
| 3007 | |
| 3008 | |
| 3009 | |
| 3010 | |
| 3011 | |
| 3012 | |
| 3013 | |
| 3014 | |
| 3015 | |
| 3016 | |
| 3017 | tp_directedtopo_table = Table('tp_directedtopo', metadata, |
| 3018 | Column('id', Integer, Sequence('tp_directedtopo_id_seq'), primary_key=True), |
| 3019 | Column('tp_primitive_proxy_id', Integer, ForeignKey('tp_primitive.id', use_alter=True, name='fk_tp_primitive_proxy')), |
| 3020 | Column('tp_expressionterm_variable_id', Integer, ForeignKey('tp_expressionterm.id', use_alter=True, name='fk_tp_expressionterm_variable')), |
1646 | | ex_extent_table = Table('ex_extent', metadata, |
1647 | | Column('id', Integer, Sequence('ex_extent_id_seq'), primary_key=True), |
1648 | | Column('cv_coverage_domainextent', Integer, ForeignKey('cv_coverage.id', use_alter=True, name='fk_cv_coverage_domainextent')), |
1649 | | Column('li_source_sourceextent', Integer, ForeignKey('li_source.id')), |
1650 | | Column('dq_scope_extent_id', Integer, ForeignKey('dq_scope.id')), |
1651 | | Column('cd_datum_domainofvalidity_id', Integer, ForeignKey('cd_datum.id', use_alter=True, name='fk_cd_datum_domainofvalidity')), |
1652 | | Column('rs_referencesystem_domainofvalidity_id', Integer, ForeignKey('rs_referencesystem.id', use_alter=True, name='fk_rs_referencesystem_domainofvalidity')), |
1653 | | Column('cc_coordinateoperation_domainofvalidity_id', Integer, ForeignKey('cc_coordinateoperation.id', use_alter=True, name='fk_cc_coordinateoperation_domainofvalidity')), |
1654 | | Column('tm_referencesystem_domainofvalidity', Integer, ForeignKey('tm_referencesystem.id')), |
1655 | | Column('ci_responsiblepartyinfo_extent', Integer, ForeignKey('ci_responsiblepartyinfo.id')), |
1656 | | Column('description', TEXT , nullable=True), |
1657 | | extend_existing=False,) |
1658 | | |
1659 | | |
1660 | | |
1661 | | |
1662 | | |
1663 | | |
1664 | | |
1665 | | |
1666 | | |
1667 | | |
1668 | | |
1669 | | |
1670 | | cv_attributevalues_table = Table('cv_attributevalues', metadata, |
1671 | | Column('id', Integer, Sequence('cv_attributevalues_id_seq'), primary_key=True), |
1672 | | Column('cv_coverage_rangeelement', Integer, ForeignKey('cv_coverage.id', use_alter=True, name='fk_cv_coverage_rangeelement')), |
| 3035 | cv_gridpoint_table = Table('cv_gridpoint', metadata, |
| 3036 | Column('id', Integer, Sequence('cv_gridpoint_id_seq'), primary_key=True), |
| 3037 | Column('cv_footprint_center', Integer, ForeignKey('cv_footprint.id', use_alter=True, name='fk_cv_footprint_center')), |
| 3038 | Column('cv_gridcell_corner', Integer, ForeignKey('cv_gridcell.id', use_alter=True, name='fk_cv_gridcell_corner')), |
| 3039 | Column('cv_grid_intersection', Integer, ForeignKey('cv_grid.id', use_alter=True, name='fk_cv_grid_intersection')), |
| 3040 | Column('gm_point_gridpoint', Integer, ForeignKey('gm_point.id', use_alter=True, name='fk_gm_point_gridpoint')), |
| 3041 | extend_existing=False,) |
| 3042 | |
| 3043 | |
| 3044 | |
| 3045 | |
| 3046 | |
| 3047 | |
| 3048 | |
| 3049 | |
| 3050 | |
| 3051 | |
| 3052 | |
| 3053 | |
| 3054 | gf_propertytype_table = Table('gf_propertytype', metadata, |
| 3055 | Column('id', Integer, Sequence('gf_propertytype_id_seq'), primary_key=True), |
| 3056 | Column('gf_associationrole__gf_propertytype_id', Integer, ForeignKey('gf_associationrole.id')), |
| 3057 | Column('gf_attributetype__gf_propertytype_id', Integer, ForeignKey('gf_attributetype.id')), |
| 3058 | Column('gf_featuretype_carrierofcharacteristics', Integer, ForeignKey('gf_featuretype.id', use_alter=True, name='fk_gf_featuretype_carrierofcharacteristics')), |
| 3059 | Column('om_observation_observedproperty_id', Integer, ForeignKey('om_observation.id')), |
| 3060 | Column('md_metadata_propertytype', Integer, ForeignKey('md_metadata.id', use_alter=True, name='fk_md_metadata_propertytype')), |
| 3061 | Column('gf_operation__gf_propertytype_id', Integer, ForeignKey('gf_operation.id')), |
| 3062 | Column('definition', TEXT , nullable=False), |
| 3063 | extend_existing=False,) |
| 3064 | |
| 3065 | |
| 3066 | |
| 3067 | |
| 3068 | |
| 3069 | |
| 3070 | |
| 3071 | |
| 3072 | |
| 3073 | |
| 3074 | |
| 3075 | |
| 3076 | gm_object_table = Table('gm_object', metadata, |
| 3077 | Column('id', Integer, Sequence('gm_object_id_seq'), primary_key=True), |
| 3078 | Column('gm_complex__gm_object_id', Integer, ForeignKey('gm_complex.id')), |
| 3079 | Column('cv_domainobject_spatialelement', Integer, ForeignKey('cv_domainobject.id', use_alter=True, name='fk_cv_domainobject_spatialelement')), |
| 3080 | Column('sc_crs_object', Integer, ForeignKey('sc_crs.id', use_alter=True, name='fk_sc_crs_object')), |
| 3081 | Column('mo_location_geometrylocation_id', Integer, ForeignKey('mo_location.id')), |
| 3082 | Column('cv_footprint_geometry_id', Integer, ForeignKey('cv_footprint.id', use_alter=True, name='fk_cv_footprint_geometry')), |
| 3083 | Column('gm_primitive__gm_object_id', Integer, ForeignKey('gm_primitive.id')), |
| 3084 | extend_existing=False,) |
| 3085 | |
| 3086 | |
| 3087 | |
| 3088 | |
| 3089 | |
| 3090 | |
| 3091 | |
| 3092 | |
| 3093 | |
| 3094 | |
| 3095 | |
| 3096 | |
| 3097 | tm_period_table = Table('tm_period', metadata, |
| 3098 | Column('id', Integer, Sequence('tm_period_id_seq'), primary_key=True), |
| 3099 | Column('tm_instant_begunby', Integer, ForeignKey('tm_instant.id', use_alter=True, name='fk_tm_instant_begunby')), |
| 3100 | Column('tm_edge_geometry_id', Integer, ForeignKey('tm_edge.id', use_alter=True, name='fk_tm_edge_geometry')), |
| 3101 | Column('om_observation_validtime_id', Integer, ForeignKey('om_observation.id')), |
| 3102 | Column('tm_instant_endedby', Integer, ForeignKey('tm_instant.id', use_alter=True, name='fk_tm_instant_endedby')), |
| 3103 | extend_existing=False,) |
| 3104 | |
| 3105 | |
| 3106 | |
| 3107 | |
| 3108 | |
| 3109 | |
| 3110 | |
| 3111 | |
| 3112 | |
| 3113 | |
| 3114 | |
| 3115 | |
| 3116 | mo_instrumentplatformpair_table = Table('mo_instrumentplatformpair', metadata, |
| 3117 | Column('id', Integer, Sequence('mo_instrumentplatformpair_id_seq'), primary_key=True), |
| 3118 | Column('mo_acquisition_instrumentplatformpair', Integer, ForeignKey('mo_acquisition.id')), |
| 3119 | extend_existing=False,) |
| 3120 | |
| 3121 | |
| 3122 | |
| 3123 | |
| 3124 | |
| 3125 | |
| 3126 | |
| 3127 | |
| 3128 | |
| 3129 | |
| 3130 | |
| 3131 | |
| 3132 | mo_result_table = Table('mo_result', metadata, |
| 3133 | Column('id', Integer, Sequence('mo_result_id_seq'), primary_key=True), |
| 3134 | Column('mo_observation_result_id', Integer, ForeignKey('mo_observation.id')), |
| 3135 | Column('ceda_result__mo_result_id', Integer, ForeignKey('ceda_result.id')), |
| 3136 | extend_existing=False,) |
| 3137 | |
| 3138 | |
| 3139 | |
| 3140 | |
| 3141 | |
| 3142 | |
| 3143 | |
| 3144 | |
| 3145 | |
| 3146 | |
| 3147 | |
| 3148 | |
| 3149 | ceda_instrument_table = Table('ceda_instrument', metadata, |
| 3150 | Column('id', Integer, Sequence('ceda_instrument_id_seq'), primary_key=True), |
| 3151 | extend_existing=False,) |
| 3152 | |
| 3153 | |
| 3154 | |
| 3155 | |
| 3156 | |
| 3157 | |
| 3158 | |
| 3159 | |
| 3160 | |
| 3161 | |
| 3162 | |
| 3163 | |
| 3164 | md_applicationschemainformation_table = Table('md_applicationschemainformation', metadata, |
| 3165 | Column('id', Integer, Sequence('md_applicationschemainformation_id_seq'), primary_key=True), |
| 3166 | Column('md_metadata_applicationschemainfo', Integer, ForeignKey('md_metadata.id')), |
| 3167 | Column('constraintLanguage', TEXT , nullable=False), |
| 3168 | Column('schemaLanguage', TEXT , nullable=False), |
| 3169 | Column('schemaAscii', TEXT , nullable=True), |
| 3170 | Column('softwareDevelopmentFileFormat', TEXT , nullable=True), |
| 3171 | extend_existing=False,) |
| 3172 | |
| 3173 | |
| 3174 | |
| 3175 | |
| 3176 | |
| 3177 | |
| 3178 | |
| 3179 | |
| 3180 | |
| 3181 | |
| 3182 | |
| 3183 | |
| 3184 | mo_organization_table = Table('mo_organization', metadata, |
| 3185 | Column('id', Integer, Sequence('mo_organization_id_seq'), primary_key=True), |
| 3186 | Column('description', TEXT , nullable=True), |
| 3187 | extend_existing=False,) |
| 3188 | |
| 3189 | |
| 3190 | |
| 3191 | |
| 3192 | |
| 3193 | |
| 3194 | |
| 3195 | |
| 3196 | |
| 3197 | |
| 3198 | |
| 3199 | |
| 3200 | unitofmeasure_table = Table('unitofmeasure', metadata, |
| 3201 | Column('id', Integer, Sequence('unitofmeasure_id_seq'), primary_key=True), |
| 3202 | Column('cs_coordinatesystemaxis_axisunitid_id', Integer, ForeignKey('cs_coordinatesystemaxis.id')), |
| 3203 | Column('uomlength__unitofmeasure_id', Integer, ForeignKey('uomlength.id')), |
| 3204 | Column('uomscale__unitofmeasure_id', Integer, ForeignKey('uomscale.id')), |
| 3205 | Column('measure_uom_id', Integer, ForeignKey('measure.id', use_alter=True, name='fk_measure_uom')), |
| 3206 | Column('nameStandardUnit', TEXT , nullable=True), |
| 3207 | Column('uomSymbol', TEXT , nullable=False), |
| 3208 | Column('scaleToStandardUnit', NUMERIC , nullable=True), |
| 3209 | Column('measureType', MeasureType.db_type() , nullable=False), |
| 3210 | Column('uomName', TEXT , nullable=False), |
| 3211 | Column('formula', TEXT , nullable=True), |
| 3212 | Column('offsetToStandardUnit', NUMERIC , nullable=True), |
| 3213 | extend_existing=False,) |
| 3214 | |
| 3215 | |
| 3216 | |
| 3217 | |
| 3218 | |
| 3219 | |
| 3220 | |
| 3221 | |
| 3222 | |
| 3223 | |
| 3224 | |
| 3225 | |
| 3226 | cc_parametervaluegroup_table = Table('cc_parametervaluegroup', metadata, |
| 3227 | Column('id', Integer, Sequence('cc_parametervaluegroup_id_seq'), primary_key=True), |
| 3228 | Column('cc_operationparametergroup_value', Integer, ForeignKey('cc_operationparametergroup.id', use_alter=True, name='fk_cc_operationparametergroup_value')), |
| 3229 | Column('cc_generalparametervalue_group_id', Integer, ForeignKey('cc_generalparametervalue.id', use_alter=True, name='fk_cc_generalparametervalue_group')), |
| 3230 | extend_existing=False,) |
| 3231 | |
| 3232 | |
| 3233 | |
| 3234 | |
| 3235 | |
| 3236 | |
| 3237 | |
| 3238 | |
| 3239 | |
| 3240 | |
| 3241 | |
| 3242 | |
| 3243 | directposition_table = Table('directposition', metadata, |
| 3244 | Column('id', Integer, Sequence('directposition_id_seq'), primary_key=True), |
| 3245 | Column('gm_point_position_id', Integer, ForeignKey('gm_point.id', use_alter=True, name='fk_gm_point_position')), |
| 3246 | Column('sc_crs_directposition', Integer, ForeignKey('sc_crs.id', use_alter=True, name='fk_sc_crs_directposition')), |
| 3247 | Column('dimension', Integer , nullable=False), |
| 3248 | Column('coordinate', ARRAY(NUMERIC) , nullable=False), |
| 3249 | extend_existing=False,) |
| 3250 | |
| 3251 | |
| 3252 | |
| 3253 | |
| 3254 | |
| 3255 | |
| 3256 | |
| 3257 | |
| 3258 | |
| 3259 | |
| 3260 | |
| 3261 | |
| 3262 | ceda_notes_table = Table('ceda_notes', metadata, |
| 3263 | Column('id', Integer, Sequence('ceda_notes_id_seq'), primary_key=True), |
| 3264 | Column('ceda_review_notes', Integer, ForeignKey('ceda_review.id')), |
| 3265 | Column('comments', TEXT , nullable=False), |
| 3266 | extend_existing=False,) |
| 3267 | |
| 3268 | |
| 3269 | |
| 3270 | |
| 3271 | |
| 3272 | |
| 3273 | |
| 3274 | |
| 3275 | |
| 3276 | |
| 3277 | |
| 3278 | |
| 3279 | cc_conversion_table = Table('cc_conversion', metadata, |
| 3280 | Column('id', Integer, Sequence('cc_conversion_id_seq'), primary_key=True), |
| 3281 | Column('sc_generalderivedcrs_conversion_id', Integer, ForeignKey('sc_generalderivedcrs.id', use_alter=True, name='fk_sc_generalderivedcrs_conversion')), |
| 3282 | Column('operationVersion', TEXT , nullable=True), |
| 3283 | extend_existing=False,) |
| 3284 | |
| 3285 | |
| 3286 | |
| 3287 | |
| 3288 | |
| 3289 | |
| 3290 | |
| 3291 | |
| 3292 | |
| 3293 | |
| 3294 | |
| 3295 | |
| 3296 | scale_table = Table('scale', metadata, |
| 3297 | Column('id', Integer, Sequence('scale_id_seq'), primary_key=True), |
| 3298 | Column('md_representativefraction_equivalentscale', Integer, ForeignKey('md_representativefraction.id')), |
| 3299 | extend_existing=False,) |
| 3300 | |
| 3301 | |
| 3302 | |
| 3303 | |
| 3304 | |
| 3305 | |
| 3306 | |
| 3307 | |
| 3308 | |
| 3309 | |
| 3310 | |
| 3311 | |
| 3312 | ceda_observationcollection_table = Table('ceda_observationcollection', metadata, |
| 3313 | Column('id', Integer, Sequence('ceda_observationcollection_id_seq'), primary_key=True), |
| 3314 | extend_existing=False,) |
| 3315 | |
| 3316 | |
| 3317 | |
| 3318 | |
| 3319 | |
| 3320 | |
| 3321 | |
| 3322 | |
| 3323 | |
| 3324 | |
| 3325 | |
| 3326 | |
| 3327 | length_table = Table('length', metadata, |
| 3328 | Column('id', Integer, Sequence('length_id_seq'), primary_key=True), |
| 3329 | Column('distance__length_id', Integer, ForeignKey('distance.id')), |
| 3330 | extend_existing=False,) |
| 3331 | |
| 3332 | |
| 3333 | |
| 3334 | |
| 3335 | |
| 3336 | |
| 3337 | |
| 3338 | |
| 3339 | |
| 3340 | |
| 3341 | |
| 3342 | |
| 3343 | mo_process_table = Table('mo_process', metadata, |
| 3344 | Column('id', Integer, Sequence('mo_process_id_seq'), primary_key=True), |
| 3345 | Column('mo_compositeprocess__mo_process_id', Integer, ForeignKey('mo_compositeprocess.id')), |
| 3346 | Column('ceda_process__mo_process_id', Integer, ForeignKey('ceda_process.id')), |
| 3347 | Column('mo_computation__mo_process_id', Integer, ForeignKey('mo_computation.id')), |
| 3348 | Column('mo_acquisition__mo_process_id', Integer, ForeignKey('mo_acquisition.id')), |
| 3349 | extend_existing=False,) |
| 3350 | |
| 3351 | |
| 3352 | |
| 3353 | |
| 3354 | |
| 3355 | |
| 3356 | |
| 3357 | |
| 3358 | |
| 3359 | |
| 3360 | |
| 3361 | |
| 3362 | recordtype_table = Table('recordtype', metadata, |
| 3363 | Column('id', Integer, Sequence('recordtype_id_seq'), primary_key=True), |
| 3364 | Column('cv_coverage_rangetype_id', Integer, ForeignKey('cv_coverage.id')), |
| 3365 | Column('record_recordtype_id', Integer, ForeignKey('record.id', use_alter=True, name='fk_record_recordtype')), |
1736 | | mo_responsiblepartyinfo_table = Table('mo_responsiblepartyinfo', metadata, |
1737 | | Column('id', Integer, Sequence('mo_responsiblepartyinfo_id_seq'), primary_key=True), |
1738 | | Column('mo_instrument_realatedparty', Integer, ForeignKey('mo_instrument.id')), |
1739 | | Column('ceda_notes_commentator_id', Integer, ForeignKey('ceda_notes.id')), |
1740 | | Column('mo_operation_relatedpartyinfo', Integer, ForeignKey('mo_operation.id')), |
1741 | | Column('mo_processing_relatedparty', Integer, ForeignKey('mo_processing.id')), |
1742 | | Column('mo_acquisition_realatedparty', Integer, ForeignKey('mo_acquisition.id')), |
1743 | | Column('mo_project_relatedparty', Integer, ForeignKey('mo_project.id')), |
1744 | | Column('mo_observation_relatedparty', Integer, ForeignKey('mo_observation.id')), |
1745 | | Column('ceda_observationcollection_cedaofficer_id', Integer, ForeignKey('ceda_observationcollection.id')), |
1746 | | Column('mo_platform_relatedparty', Integer, ForeignKey('mo_platform.id')), |
1747 | | Column('mo_compositeprocess_relatedparty', Integer, ForeignKey('mo_compositeprocess.id')), |
1748 | | Column('ceda_review_reviewer_id', Integer, ForeignKey('ceda_review.id')), |
1749 | | Column('role', MO_RoleValue.db_type() , nullable=False), |
1750 | | extend_existing=False,) |
1751 | | |
1752 | | |
1753 | | |
1754 | | |
1755 | | |
1756 | | |
1757 | | |
1758 | | |
1759 | | |
1760 | | |
1761 | | |
1762 | | |
1763 | | gf_propertytype_table = Table('gf_propertytype', metadata, |
1764 | | Column('id', Integer, Sequence('gf_propertytype_id_seq'), primary_key=True), |
1765 | | Column('md_metadata_propertytype', Integer, ForeignKey('md_metadata.id', use_alter=True, name='fk_md_metadata_propertytype')), |
1766 | | Column('gf_attributetype__gf_propertytype_id', Integer, ForeignKey('gf_attributetype.id')), |
1767 | | Column('gf_associationrole__gf_propertytype_id', Integer, ForeignKey('gf_associationrole.id')), |
1768 | | Column('gf_operation__gf_propertytype_id', Integer, ForeignKey('gf_operation.id')), |
1769 | | Column('om_observation_observedproperty_id', Integer, ForeignKey('om_observation.id')), |
1770 | | Column('gf_featuretype_carrierofcharacteristics', Integer, ForeignKey('gf_featuretype.id', use_alter=True, name='fk_gf_featuretype_carrierofcharacteristics')), |
1771 | | Column('definition', TEXT , nullable=False), |
1772 | | extend_existing=False,) |
1773 | | |
1774 | | |
1775 | | |
1776 | | |
1777 | | |
1778 | | |
1779 | | |
1780 | | |
1781 | | |
1782 | | |
1783 | | |
1784 | | |
1785 | | gf_operation_table = Table('gf_operation', metadata, |
1786 | | Column('id', Integer, Sequence('gf_operation_id_seq'), primary_key=True), |
1787 | | Column('gf_associationtype_thegf_operation', Integer, ForeignKey('gf_associationtype.id', use_alter=True, name='fk_gf_associationtype_thegf_operation')), |
1788 | | Column('signature', TEXT , nullable=False), |
1789 | | extend_existing=False,) |
1790 | | |
1791 | | |
1792 | | |
1793 | | |
1794 | | |
1795 | | |
1796 | | |
1797 | | |
1798 | | |
1799 | | |
1800 | | |
1801 | | |
1802 | | cv_domainobject_table = Table('cv_domainobject', metadata, |
1803 | | Column('id', Integer, Sequence('cv_domainobject_id_seq'), primary_key=True), |
1804 | | Column('cv_gridpoint__cv_domainobject_id', Integer, ForeignKey('cv_gridpoint.id')), |
1805 | | Column('cv_coverage_domainelement', Integer, ForeignKey('cv_coverage.id', use_alter=True, name='fk_cv_coverage_domainelement')), |
| 3448 | uomlength_table = Table('uomlength', metadata, |
| 3449 | Column('id', Integer, Sequence('uomlength_id_seq'), primary_key=True), |
| 3450 | Column('length_uom_id', Integer, ForeignKey('length.id')), |
| 3451 | Column('scale_sourceunits_id', Integer, ForeignKey('scale.id')), |
| 3452 | Column('scale_targetunits_id', Integer, ForeignKey('scale.id')), |
| 3453 | extend_existing=False,) |
| 3454 | |
| 3455 | |
| 3456 | |
| 3457 | |
| 3458 | |
| 3459 | |
| 3460 | |
| 3461 | |
| 3462 | |
| 3463 | |
| 3464 | |
| 3465 | |
| 3466 | md_scopedescription_table = Table('md_scopedescription', metadata, |
| 3467 | Column('id', Integer, Sequence('md_scopedescription_id_seq'), primary_key=True), |
| 3468 | Column('dq_scope_leveldescription', Integer, ForeignKey('dq_scope.id', use_alter=True, name='fk_dq_scope_leveldescription')), |
| 3469 | Column('md_maintenanceinformation_updatescopedescription', Integer, ForeignKey('md_maintenanceinformation.id', use_alter=True, name='fk_md_maintenanceinformation_updatescopedescription')), |
| 3470 | Column('dataset', TEXT , nullable=False), |
| 3471 | Column('other', TEXT , nullable=False), |
| 3472 | extend_existing=False,) |
| 3473 | |
| 3474 | |
| 3475 | |
| 3476 | |
| 3477 | |
| 3478 | |
| 3479 | |
| 3480 | |
| 3481 | |
| 3482 | |
| 3483 | |
| 3484 | |
| 3485 | tp_expressionterm_table = Table('tp_expressionterm', metadata, |
| 3486 | Column('id', Integer, Sequence('tp_expressionterm_id_seq'), primary_key=True), |
| 3487 | Column('tp_expression_term', Integer, ForeignKey('tp_expression.id', use_alter=True, name='fk_tp_expression_term')), |
| 3488 | Column('tp_directedtopo_term', Integer, ForeignKey('tp_directedtopo.id', use_alter=True, name='fk_tp_directedtopo_term')), |
| 3489 | Column('coefficient', Integer , nullable=False), |
| 3490 | extend_existing=False,) |
| 3491 | |
| 3492 | |
| 3493 | |
| 3494 | |
| 3495 | |
| 3496 | |
| 3497 | |
| 3498 | |
| 3499 | |
| 3500 | |
| 3501 | |
| 3502 | |
| 3503 | cc_coordinateoperation_table = Table('cc_coordinateoperation', metadata, |
| 3504 | Column('id', Integer, Sequence('cc_coordinateoperation_id_seq'), primary_key=True), |
| 3505 | Column('cc_passthroughoperation_coordoperation_id', Integer, ForeignKey('cc_passthroughoperation.id', use_alter=True, name='fk_cc_passthroughoperation_coordoperation')), |
| 3506 | Column('sc_crs_coordoperationfrom', Integer, ForeignKey('sc_crs.id', use_alter=True, name='fk_sc_crs_coordoperationfrom')), |
| 3507 | Column('cc_singleoperation__cc_coordinateoperation_id', Integer, ForeignKey('cc_singleoperation.id')), |
| 3508 | Column('cc_concatenatedoperation__cc_coordinateoperation_id', Integer, ForeignKey('cc_concatenatedoperation.id')), |
| 3509 | Column('cc_concatenatedoperation_coordoperation', Integer, ForeignKey('cc_concatenatedoperation.id', use_alter=True, name='fk_cc_concatenatedoperation_coordoperation')), |
| 3510 | Column('cc_passthroughoperation__cc_coordinateoperation_id', Integer, ForeignKey('cc_passthroughoperation.id')), |
| 3511 | Column('sc_crs_coordoperationto', Integer, ForeignKey('sc_crs.id', use_alter=True, name='fk_sc_crs_coordoperationto')), |
| 3512 | Column('operationVersion', TEXT , nullable=True), |
| 3513 | Column('scope', ARRAY(TEXT) , nullable=False), |
| 3514 | extend_existing=False,) |
| 3515 | |
| 3516 | |
| 3517 | |
| 3518 | |
| 3519 | |
| 3520 | |
| 3521 | |
| 3522 | |
| 3523 | |
| 3524 | |
| 3525 | |
| 3526 | |
| 3527 | gf_associationtype_table = Table('gf_associationtype', metadata, |
| 3528 | Column('id', Integer, Sequence('gf_associationtype_id_seq'), primary_key=True), |
| 3529 | Column('gf_featuretype_linkbetween', Integer, ForeignKey('gf_featuretype.id', use_alter=True, name='fk_gf_featuretype_linkbetween')), |
| 3530 | Column('gf_operation_dependson', Integer, ForeignKey('gf_operation.id', use_alter=True, name='fk_gf_operation_dependson')), |
1837 | | md_format_table = Table('md_format', metadata, |
1838 | | Column('id', Integer, Sequence('md_format_id_seq'), primary_key=True), |
1839 | | Column('md_identification_resourceformat', Integer, ForeignKey('md_identification.id')), |
1840 | | Column('md_distributor_distributorformat', Integer, ForeignKey('md_distributor.id', use_alter=True, name='fk_md_distributor_distributorformat')), |
1841 | | Column('md_distribution_distributionformat', Integer, ForeignKey('md_distribution.id')), |
1842 | | Column('amendmentNumber', TEXT , nullable=True), |
1843 | | Column('version', TEXT , nullable=False), |
1844 | | Column('specification', TEXT , nullable=True), |
1845 | | Column('fileDecompressionTechnique', TEXT , nullable=True), |
1846 | | Column('name', TEXT , nullable=False), |
1847 | | extend_existing=False,) |
1848 | | |
1849 | | |
1850 | | |
1851 | | |
1852 | | |
1853 | | |
1854 | | |
1855 | | |
1856 | | |
1857 | | |
1858 | | |
1859 | | |
1860 | | ci_responsiblepartyinfo_table = Table('ci_responsiblepartyinfo', metadata, |
1861 | | Column('id', Integer, Sequence('ci_responsiblepartyinfo_id_seq'), primary_key=True), |
1862 | | Column('ci_responsibility__ci_responsiblepartyinfo_id', Integer, ForeignKey('ci_responsibility.id')), |
1863 | | Column('role', CI_RoleCode.db_type() , nullable=False), |
1864 | | extend_existing=False,) |
1865 | | |
1866 | | |
1867 | | |
1868 | | |
1869 | | |
1870 | | |
1871 | | |
1872 | | |
1873 | | |
1874 | | |
1875 | | |
1876 | | |
1877 | | md_metadata_table = Table('md_metadata', metadata, |
1878 | | Column('id', Integer, Sequence('md_metadata_id_seq'), primary_key=True), |
1879 | | Column('cl_dataset_has', Integer, ForeignKey('cl_dataset.id', use_alter=True, name='fk_cl_dataset_has')), |
1880 | | Column('gf_featuretype_featuretypemetadata', Integer, ForeignKey('gf_featuretype.id', use_alter=True, name='fk_gf_featuretype_featuretypemetadata')), |
1881 | | Column('ds_dataset_has', Integer, ForeignKey('ds_dataset.id', use_alter=True, name='fk_ds_dataset_has')), |
1882 | | Column('mo_observationcollection_isometadata', Integer, ForeignKey('mo_observationcollection.id')), |
1883 | | Column('om_observation_metadata_id', Integer, ForeignKey('om_observation.id')), |
1884 | | Column('ds_aggregate_seriesmetadata', Integer, ForeignKey('ds_aggregate.id', use_alter=True, name='fk_ds_aggregate_seriesmetadata')), |
1885 | | Column('gf_propertytype_propertytypemetadata', Integer, ForeignKey('gf_propertytype.id', use_alter=True, name='fk_gf_propertytype_propertytypemetadata')), |
1886 | | Column('gf_attributetype_featureattributemetadata', Integer, ForeignKey('gf_attributetype.id', use_alter=True, name='fk_gf_attributetype_featureattributemetadata')), |
1887 | | Column('dataSet', TEXT , nullable=True), |
1888 | | Column('metadataStandardVersion', TEXT , nullable=True), |
1889 | | Column('hierarchyLevel', MD_ScopeCode.db_type() , nullable=True), |
1890 | | Column('language', TEXT , nullable=True), |
1891 | | Column('characterSet', MD_CharacterSetCode.db_type() , nullable=True), |
1892 | | Column('metadataStandardName', TEXT , nullable=True), |
1893 | | Column('fileIdentifier', TEXT , nullable=True), |
1894 | | Column('hierarchyLevelName', ARRAY(TEXT) , nullable=True), |
1895 | | Column('parentIdentifier', TEXT , nullable=True), |
1896 | | extend_existing=False,) |
1897 | | |
1898 | | |
1899 | | |
1900 | | |
1901 | | |
1902 | | |
1903 | | |
1904 | | |
1905 | | |
1906 | | |
1907 | | |
1908 | | |
1909 | | le_nominalresolution_table = Table('le_nominalresolution', metadata, |
1910 | | Column('id', Integer, Sequence('le_nominalresolution_id_seq'), primary_key=True), |
1911 | | Column('le_source_resolution_id', Integer, ForeignKey('le_source.id')), |
1912 | | extend_existing=False,) |
1913 | | |
1914 | | |
1915 | | |
1916 | | |
1917 | | |
1918 | | |
1919 | | |
1920 | | |
1921 | | |
1922 | | |
1923 | | |
1924 | | |
1925 | | ceda_platform_table = Table('ceda_platform', metadata, |
1926 | | Column('id', Integer, Sequence('ceda_platform_id_seq'), primary_key=True), |
1927 | | extend_existing=False,) |
1928 | | |
1929 | | |
1930 | | |
1931 | | |
1932 | | |
1933 | | |
1934 | | |
1935 | | |
1936 | | |
1937 | | |
1938 | | |
1939 | | |
1940 | | cc_conversion_table = Table('cc_conversion', metadata, |
1941 | | Column('id', Integer, Sequence('cc_conversion_id_seq'), primary_key=True), |
1942 | | Column('sc_generalderivedcrs_conversion_id', Integer, ForeignKey('sc_generalderivedcrs.id', use_alter=True, name='fk_sc_generalderivedcrs_conversion')), |
1943 | | Column('operationVersion', TEXT , nullable=True), |
1944 | | extend_existing=False,) |
1945 | | |
1946 | | |
1947 | | |
1948 | | |
1949 | | |
1950 | | |
1951 | | |
1952 | | |
1953 | | |
1954 | | |
1955 | | |
1956 | | |
1957 | | dq_scope_table = Table('dq_scope', metadata, |
1958 | | Column('id', Integer, Sequence('dq_scope_id_seq'), primary_key=True), |
1959 | | Column('dq_dataquality_scope_id', Integer, ForeignKey('dq_dataquality.id', use_alter=True, name='fk_dq_dataquality_scope')), |
1960 | | Column('level', MD_ScopeCode.db_type() , nullable=False), |
1961 | | extend_existing=False,) |
1962 | | |
1963 | | |
1964 | | |
1965 | | |
1966 | | |
1967 | | |
1968 | | |
1969 | | |
1970 | | |
1971 | | |
1972 | | |
1973 | | |
1974 | | md_distribution_table = Table('md_distribution', metadata, |
1975 | | Column('id', Integer, Sequence('md_distribution_id_seq'), primary_key=True), |
1976 | | Column('md_metadata_distributioninfo_id', Integer, ForeignKey('md_metadata.id')), |
1977 | | extend_existing=False,) |
1978 | | |
1979 | | |
1980 | | |
1981 | | |
1982 | | |
1983 | | |
1984 | | |
1985 | | |
1986 | | |
1987 | | |
1988 | | |
1989 | | |
1990 | | gm_composite_table = Table('gm_composite', metadata, |
1991 | | Column('id', Integer, Sequence('gm_composite_id_seq'), primary_key=True), |
1992 | | Column('gm_primitive_composite', Integer, ForeignKey('gm_primitive.id', use_alter=True, name='fk_gm_primitive_composite')), |
1993 | | Column('gm_compositepoint__gm_composite_id', Integer, ForeignKey('gm_compositepoint.id')), |
1994 | | extend_existing=False,) |
1995 | | |
1996 | | |
1997 | | |
1998 | | |
1999 | | |
2000 | | |
2001 | | |
2002 | | |
2003 | | |
2004 | | |
2005 | | |
2006 | | |
2007 | | mo_onlineresource_table = Table('mo_onlineresource', metadata, |
2008 | | Column('id', Integer, Sequence('mo_onlineresource_id_seq'), primary_key=True), |
2009 | | Column('mo_result_sample', Integer, ForeignKey('mo_result.id')), |
2010 | | Column('mo_result_source', Integer, ForeignKey('mo_result.id')), |
2011 | | Column('ceda_project_projectresource', Integer, ForeignKey('ceda_project.id')), |
| 3562 | gf_featuretype_table = Table('gf_featuretype', metadata, |
| 3563 | Column('id', Integer, Sequence('gf_featuretype_id_seq'), primary_key=True), |
| 3564 | Column('gf_inheritancerelation_subtype_id', Integer, ForeignKey('gf_inheritancerelation.id', use_alter=True, name='fk_gf_inheritancerelation_subtype')), |
| 3565 | Column('gf_propertytype_thegf_featuretype_id', Integer, ForeignKey('gf_propertytype.id', use_alter=True, name='fk_gf_propertytype_thegf_featuretype')), |
| 3566 | Column('gf_associationtype_includes', Integer, ForeignKey('gf_associationtype.id', use_alter=True, name='fk_gf_associationtype_includes')), |
| 3567 | Column('md_metadata_featuretype', Integer, ForeignKey('md_metadata.id', use_alter=True, name='fk_md_metadata_featuretype')), |
| 3568 | Column('gf_inheritancerelation_supertype_id', Integer, ForeignKey('gf_inheritancerelation.id', use_alter=True, name='fk_gf_inheritancerelation_supertype')), |
| 3569 | Column('gf_associationtype__gf_featuretype_id', Integer, ForeignKey('gf_associationtype.id')), |
| 3570 | Column('md_scopedescription_featureinstances', Integer, ForeignKey('md_scopedescription.id', use_alter=True, name='fk_md_scopedescription_featureinstances')), |
| 3571 | Column('md_scopedescription_features', Integer, ForeignKey('md_scopedescription.id', use_alter=True, name='fk_md_scopedescription_features')), |
| 3572 | Column('isAbstract', BOOLEAN , nullable=False), |
| 3573 | Column('definition', TEXT , nullable=False), |
2029 | | Column('namespace_name', Integer, ForeignKey('namespace.id', use_alter=True, name='fk_namespace_name')), |
2030 | | Column('mo_inputoutput_name_id', Integer, ForeignKey('mo_inputoutput.id')), |
2031 | | Column('io_identifiedobjectbase_alias', Integer, ForeignKey('io_identifiedobjectbase.id')), |
2032 | | Column('localname__genericname_id', Integer, ForeignKey('localname.id')), |
2033 | | extend_existing=False,) |
2034 | | |
2035 | | |
2036 | | |
2037 | | |
2038 | | |
2039 | | |
2040 | | |
2041 | | |
2042 | | |
2043 | | |
2044 | | |
2045 | | |
2046 | | ceda_project_table = Table('ceda_project', metadata, |
2047 | | Column('id', Integer, Sequence('ceda_project_id_seq'), primary_key=True), |
2048 | | extend_existing=False,) |
2049 | | |
2050 | | |
2051 | | |
2052 | | |
2053 | | |
2054 | | |
2055 | | |
2056 | | |
2057 | | |
2058 | | |
2059 | | |
2060 | | |
2061 | | cc_coordinateoperation_table = Table('cc_coordinateoperation', metadata, |
2062 | | Column('id', Integer, Sequence('cc_coordinateoperation_id_seq'), primary_key=True), |
2063 | | Column('cc_singleoperation__cc_coordinateoperation_id', Integer, ForeignKey('cc_singleoperation.id')), |
2064 | | Column('cc_concatenatedoperation__cc_coordinateoperation_id', Integer, ForeignKey('cc_concatenatedoperation.id')), |
2065 | | Column('cc_concatenatedoperation_coordoperation', Integer, ForeignKey('cc_concatenatedoperation.id', use_alter=True, name='fk_cc_concatenatedoperation_coordoperation')), |
2066 | | Column('sc_crs_coordoperationfrom', Integer, ForeignKey('sc_crs.id', use_alter=True, name='fk_sc_crs_coordoperationfrom')), |
2067 | | Column('cc_passthroughoperation__cc_coordinateoperation_id', Integer, ForeignKey('cc_passthroughoperation.id')), |
2068 | | Column('cc_passthroughoperation_coordoperation_id', Integer, ForeignKey('cc_passthroughoperation.id', use_alter=True, name='fk_cc_passthroughoperation_coordoperation')), |
2069 | | Column('sc_crs_coordoperationto', Integer, ForeignKey('sc_crs.id', use_alter=True, name='fk_sc_crs_coordoperationto')), |
2070 | | Column('operationVersion', TEXT , nullable=True), |
2071 | | Column('scope', ARRAY(TEXT) , nullable=False), |
2072 | | extend_existing=False,) |
2073 | | |
2074 | | |
2075 | | |
2076 | | |
2077 | | |
2078 | | |
2079 | | |
2080 | | |
2081 | | |
2082 | | |
2083 | | |
2084 | | |
2085 | | mo_project_table = Table('mo_project', metadata, |
2086 | | Column('id', Integer, Sequence('mo_project_id_seq'), primary_key=True), |
2087 | | Column('mo_observation_insupportof_id', Integer, ForeignKey('mo_observation.id', use_alter=True, name='fk_mo_observation_insupportof')), |
2088 | | Column('ceda_project__mo_project_id', Integer, ForeignKey('ceda_project.id')), |
2089 | | Column('abstract', TEXT , nullable=True), |
2090 | | Column('description', TEXT , nullable=True), |
2091 | | Column('status', MD_ProgressCode.db_type() , nullable=True), |
2092 | | Column('publicationState', MO_PublicationStateValue.db_type() , nullable=True), |
2093 | | extend_existing=False,) |
2094 | | |
2095 | | |
2096 | | |
2097 | | |
2098 | | |
2099 | | |
2100 | | |
2101 | | |
2102 | | |
2103 | | |
2104 | | |
2105 | | |
2106 | | tp_primitive_table = Table('tp_primitive', metadata, |
2107 | | Column('id', Integer, Sequence('tp_primitive_id_seq'), primary_key=True), |
2108 | | Column('tp_complex_element', Integer, ForeignKey('tp_complex.id', use_alter=True, name='fk_tp_complex_element')), |
2109 | | Column('tp_directedtopo__tp_primitive_id', Integer, ForeignKey('tp_directedtopo.id')), |
2110 | | Column('gm_primitive_topology', Integer, ForeignKey('gm_primitive.id', use_alter=True, name='fk_gm_primitive_topology')), |
2111 | | Column('tp_directedtopo_topo_id', Integer, ForeignKey('tp_directedtopo.id', use_alter=True, name='fk_tp_directedtopo_topo')), |
2112 | | extend_existing=False,) |
2113 | | |
2114 | | |
2115 | | |
2116 | | |
2117 | | |
2118 | | |
2119 | | |
2120 | | |
2121 | | |
2122 | | |
2123 | | |
2124 | | |
2125 | | gf_inheritancerelation_table = Table('gf_inheritancerelation', metadata, |
2126 | | Column('id', Integer, Sequence('gf_inheritancerelation_id_seq'), primary_key=True), |
2127 | | Column('gf_featuretype_thegf_inheritancerelation', Integer, ForeignKey('gf_featuretype.id', use_alter=True, name='fk_gf_featuretype_thegf_inheritancerelation')), |
2128 | | Column('description', TEXT , nullable=False), |
2129 | | Column('uniqueInstance', BOOLEAN , nullable=False), |
2130 | | Column('name', TEXT , nullable=False), |
2131 | | extend_existing=False,) |
2132 | | |
2133 | | |
2134 | | |
2135 | | |
2136 | | |
2137 | | |
2138 | | |
2139 | | |
2140 | | |
2141 | | |
2142 | | |
2143 | | |
2144 | | tm_edge_table = Table('tm_edge', metadata, |
2145 | | Column('id', Integer, Sequence('tm_edge_id_seq'), primary_key=True), |
2146 | | Column('tm_period_topology_id', Integer, ForeignKey('tm_period.id', use_alter=True, name='fk_tm_period_topology')), |
2147 | | Column('tm_node_nextedge', Integer, ForeignKey('tm_node.id', use_alter=True, name='fk_tm_node_nextedge')), |
2148 | | Column('tm_node_previousedge', Integer, ForeignKey('tm_node.id', use_alter=True, name='fk_tm_node_previousedge')), |
2149 | | extend_existing=False,) |
2150 | | |
2151 | | |
2152 | | |
2153 | | |
2154 | | |
2155 | | |
2156 | | |
2157 | | |
2158 | | |
2159 | | |
2160 | | |
2161 | | |
2162 | | namespace_table = Table('namespace', metadata, |
2163 | | Column('id', Integer, Sequence('namespace_id_seq'), primary_key=True), |
2164 | | Column('schema__namespace_id', Integer, ForeignKey('schema.id')), |
2165 | | Column('genericname_scope_id', Integer, ForeignKey('genericname.id', use_alter=True, name='fk_genericname_scope')), |
2166 | | Column('isGlobal', BOOLEAN , nullable=False), |
2167 | | extend_existing=False,) |
2168 | | |
2169 | | |
2170 | | |
2171 | | |
2172 | | |
2173 | | |
2174 | | |
2175 | | |
2176 | | |
2177 | | |
2178 | | |
2179 | | |
2180 | | rs_identifier_table = Table('rs_identifier', metadata, |
2181 | | Column('id', Integer, Sequence('rs_identifier_id_seq'), primary_key=True), |
2182 | | Column('io_identifiedobjectbase_identifier', Integer, ForeignKey('io_identifiedobjectbase.id')), |
2183 | | Column('io_identifiedobject_name_id', Integer, ForeignKey('io_identifiedobject.id')), |
2184 | | Column('tm_referencesystem_name_id', Integer, ForeignKey('tm_referencesystem.id')), |
2185 | | Column('md_referencesystem_referencesystemidentifier_id', Integer, ForeignKey('md_referencesystem.id')), |
2186 | | Column('rs_referencesystem_name_id', Integer, ForeignKey('rs_referencesystem.id')), |
2187 | | Column('version', TEXT , nullable=True), |
2188 | | Column('codeSpace', TEXT , nullable=True), |
2189 | | extend_existing=False,) |
2190 | | |
2191 | | |
2192 | | |
2193 | | |
2194 | | |
2195 | | |
2196 | | |
2197 | | |
2198 | | |
2199 | | |
2200 | | |
2201 | | |
2202 | | tp_complex_table = Table('tp_complex', metadata, |
2203 | | Column('id', Integer, Sequence('tp_complex_id_seq'), primary_key=True), |
2204 | | Column('tp_primitive_complex', Integer, ForeignKey('tp_primitive.id', use_alter=True, name='fk_tp_primitive_complex')), |
2205 | | Column('tp_primitive_maximalcomplex_id', Integer, ForeignKey('tp_primitive.id', use_alter=True, name='fk_tp_primitive_maximalcomplex')), |
2206 | | Column('gm_complex_topology_id', Integer, ForeignKey('gm_complex.id', use_alter=True, name='fk_gm_complex_topology')), |
2207 | | extend_existing=False,) |
2208 | | |
2209 | | |
2210 | | |
2211 | | |
2212 | | |
2213 | | |
2214 | | |
2215 | | |
2216 | | |
2217 | | |
2218 | | |
2219 | | |
2220 | | md_aggregateinformation_table = Table('md_aggregateinformation', metadata, |
2221 | | Column('id', Integer, Sequence('md_aggregateinformation_id_seq'), primary_key=True), |
2222 | | Column('md_identification_aggregationinfo', Integer, ForeignKey('md_identification.id')), |
2223 | | Column('associationType', DS_AssociationTypeCode.db_type() , nullable=False), |
2224 | | Column('initiativeType', DS_InitiativeTypeCode.db_type() , nullable=True), |
2225 | | extend_existing=False,) |
2226 | | |
2227 | | |
2228 | | |
2229 | | |
2230 | | |
2231 | | |
2232 | | |
2233 | | |
2234 | | |
2235 | | |
2236 | | |
2237 | | |
2238 | | distance_table = Table('distance', metadata, |
2239 | | Column('id', Integer, Sequence('distance_id_seq'), primary_key=True), |
2240 | | Column('le_nominalresolution_groundresolution_id', Integer, ForeignKey('le_nominalresolution.id')), |
2241 | | Column('le_nominalresolution_scanningresolution_id', Integer, ForeignKey('le_nominalresolution.id')), |
2242 | | extend_existing=False,) |
2243 | | |
2244 | | |
2245 | | |
2246 | | |
2247 | | |
2248 | | |
2249 | | |
2250 | | |
2251 | | |
2252 | | |
2253 | | |
2254 | | |
2255 | | om_observation_table = Table('om_observation', metadata, |
2256 | | Column('id', Integer, Sequence('om_observation_id_seq'), primary_key=True), |
2257 | | Column('gfi_feature_propertyvalueprovider', Integer, ForeignKey('gfi_feature.id', use_alter=True, name='fk_gfi_feature_propertyvalueprovider')), |
2258 | | Column('mo_observation__om_observation_id', Integer, ForeignKey('mo_observation.id')), |
2259 | | Column('om_process_generatedobservation', Integer, ForeignKey('om_process.id', use_alter=True, name='fk_om_process_generatedobservation')), |
2260 | | extend_existing=False,) |
2261 | | |
2262 | | |
2263 | | |
2264 | | |
2265 | | |
2266 | | |
2267 | | |
2268 | | |
2269 | | |
2270 | | |
2271 | | |
2272 | | |
2273 | | md_keywords_table = Table('md_keywords', metadata, |
2274 | | Column('id', Integer, Sequence('md_keywords_id_seq'), primary_key=True), |
2275 | | Column('ceda_observation_keywords', Integer, ForeignKey('ceda_observation.id')), |
2276 | | Column('md_identification_descriptivekeywords', Integer, ForeignKey('md_identification.id')), |
2277 | | Column('mo_project_keywords', Integer, ForeignKey('mo_project.id')), |
2278 | | Column('keyword', ARRAY(TEXT) , nullable=False), |
2279 | | Column('type', MD_KeywordTypeCode.db_type() , nullable=True), |
2280 | | extend_existing=False,) |
2281 | | |
2282 | | |
2283 | | |
2284 | | |
2285 | | |
2286 | | |
2287 | | |
2288 | | |
2289 | | |
2290 | | |
2291 | | |
2292 | | |
2293 | | gm_object_table = Table('gm_object', metadata, |
2294 | | Column('id', Integer, Sequence('gm_object_id_seq'), primary_key=True), |
2295 | | Column('cv_domainobject_spatialelement', Integer, ForeignKey('cv_domainobject.id', use_alter=True, name='fk_cv_domainobject_spatialelement')), |
2296 | | Column('gm_primitive__gm_object_id', Integer, ForeignKey('gm_primitive.id')), |
2297 | | Column('cv_footprint_geometry_id', Integer, ForeignKey('cv_footprint.id', use_alter=True, name='fk_cv_footprint_geometry')), |
2298 | | Column('mo_location_geometrylocation_id', Integer, ForeignKey('mo_location.id')), |
2299 | | Column('gm_complex__gm_object_id', Integer, ForeignKey('gm_complex.id')), |
2300 | | Column('sc_crs_object', Integer, ForeignKey('sc_crs.id', use_alter=True, name='fk_sc_crs_object')), |
2301 | | extend_existing=False,) |
2302 | | |
2303 | | |
2304 | | |
2305 | | |
2306 | | |
2307 | | |
2308 | | |
2309 | | |
2310 | | |
2311 | | |
2312 | | |
2313 | | |
2314 | | mo_observationcollection_table = Table('mo_observationcollection', metadata, |
2315 | | Column('id', Integer, Sequence('mo_observationcollection_id_seq'), primary_key=True), |
2316 | | Column('ceda_observationcollection__mo_observationcollection_id', Integer, ForeignKey('ceda_observationcollection.id')), |
2317 | | Column('mo_project_observationcollection', Integer, ForeignKey('mo_project.id')), |
2318 | | Column('description', TEXT , nullable=True), |
2319 | | Column('publicationState', MO_PublicationStateValue.db_type() , nullable=True), |
2320 | | extend_existing=False,) |
2321 | | |
2322 | | |
2323 | | |
2324 | | |
2325 | | |
2326 | | |
2327 | | |
2328 | | |
2329 | | |
2330 | | |
2331 | | |
2332 | | |
2333 | | cc_parametervaluegroup_table = Table('cc_parametervaluegroup', metadata, |
2334 | | Column('id', Integer, Sequence('cc_parametervaluegroup_id_seq'), primary_key=True), |
2335 | | Column('cc_operationparametergroup_value', Integer, ForeignKey('cc_operationparametergroup.id', use_alter=True, name='fk_cc_operationparametergroup_value')), |
2336 | | Column('cc_generalparametervalue_group_id', Integer, ForeignKey('cc_generalparametervalue.id', use_alter=True, name='fk_cc_generalparametervalue_group')), |
2337 | | extend_existing=False,) |
2338 | | |
2339 | | |
2340 | | |
2341 | | |
2342 | | |
2343 | | |
2344 | | |
2345 | | |
2346 | | |
2347 | | |
2348 | | |
2349 | | |
2350 | | directposition_table = Table('directposition', metadata, |
2351 | | Column('id', Integer, Sequence('directposition_id_seq'), primary_key=True), |
2352 | | Column('sc_crs_directposition', Integer, ForeignKey('sc_crs.id', use_alter=True, name='fk_sc_crs_directposition')), |
2353 | | Column('gm_point_position_id', Integer, ForeignKey('gm_point.id', use_alter=True, name='fk_gm_point_position')), |
2354 | | Column('dimension', Integer , nullable=False), |
2355 | | Column('coordinate', ARRAY(NUMERIC) , nullable=False), |
2356 | | extend_existing=False,) |
2357 | | |
2358 | | |
2359 | | |
2360 | | |
2361 | | |
2362 | | |
2363 | | |
2364 | | |
2365 | | |
2366 | | |
2367 | | |
2368 | | |
2369 | | md_portrayalcataloguereference_table = Table('md_portrayalcataloguereference', metadata, |
2370 | | Column('id', Integer, Sequence('md_portrayalcataloguereference_id_seq'), primary_key=True), |
2371 | | Column('md_metadata_portrayalcatalogueinfo', Integer, ForeignKey('md_metadata.id')), |
2372 | | extend_existing=False,) |
2373 | | |
2374 | | |
2375 | | |
2376 | | |
2377 | | |
2378 | | |
2379 | | |
2380 | | |
2381 | | |
2382 | | |
2383 | | |
2384 | | |
2385 | | cv_grid_table = Table('cv_grid', metadata, |
2386 | | Column('id', Integer, Sequence('cv_grid_id_seq'), primary_key=True), |
2387 | | Column('cv_referenceablegrid__cv_grid_id', Integer, ForeignKey('cv_referenceablegrid.id')), |
2388 | | Column('cv_gridpoint_framework_id', Integer, ForeignKey('cv_gridpoint.id', use_alter=True, name='fk_cv_gridpoint_framework')), |
2389 | | Column('cv_gridcell_framework_id', Integer, ForeignKey('cv_gridcell.id', use_alter=True, name='fk_cv_gridcell_framework')), |
2390 | | Column('dimension', Integer , nullable=False), |
2391 | | Column('axisNames', ARRAY(TEXT) , nullable=False), |
2392 | | extend_existing=False,) |
2393 | | |
2394 | | |
2395 | | |
2396 | | |
2397 | | |
2398 | | |
2399 | | |
2400 | | |
2401 | | |
2402 | | |
2403 | | |
2404 | | |
2405 | | schema_table = Table('schema', metadata, |
2406 | | Column('id', Integer, Sequence('schema_id_seq'), primary_key=True), |
2407 | | Column('type_schema', Integer, ForeignKey('type.id', use_alter=True, name='fk_type_schema')), |
2408 | | Column('isGlobal', BOOLEAN , nullable=False), |
2409 | | extend_existing=False,) |
2410 | | |
2411 | | |
2412 | | |
2413 | | |
2414 | | |
2415 | | |
2416 | | |
2417 | | |
2418 | | |
2419 | | |
2420 | | |
2421 | | |
2422 | | dq_positionalaccuracy_table = Table('dq_positionalaccuracy', metadata, |
2423 | | Column('id', Integer, Sequence('dq_positionalaccuracy_id_seq'), primary_key=True), |
2424 | | Column('cc_coordinateoperation_coordinateoperationaccuracy', Integer, ForeignKey('cc_coordinateoperation.id')), |
| 3595 | extend_existing=False,) |
| 3596 | |
| 3597 | |
| 3598 | |
| 3599 | |
| 3600 | |
| 3601 | |
| 3602 | |
| 3603 | |
| 3604 | |
| 3605 | |
| 3606 | |
| 3607 | |
| 3608 | sc_compoundcrs_table = Table('sc_compoundcrs', metadata, |
| 3609 | Column('id', Integer, Sequence('sc_compoundcrs_id_seq'), primary_key=True), |
| 3610 | Column('sc_singlecrs_compoundcrs', Integer, ForeignKey('sc_singlecrs.id', use_alter=True, name='fk_sc_singlecrs_compoundcrs')), |
2457 | | unitofmeasure_table = Table('unitofmeasure', metadata, |
2458 | | Column('id', Integer, Sequence('unitofmeasure_id_seq'), primary_key=True), |
2459 | | Column('uomscale__unitofmeasure_id', Integer, ForeignKey('uomscale.id')), |
2460 | | Column('cs_coordinatesystemaxis_axisunitid_id', Integer, ForeignKey('cs_coordinatesystemaxis.id')), |
2461 | | Column('measure_uom_id', Integer, ForeignKey('measure.id', use_alter=True, name='fk_measure_uom')), |
2462 | | Column('uomlength__unitofmeasure_id', Integer, ForeignKey('uomlength.id')), |
2463 | | Column('measureType', MeasureType.db_type() , nullable=False), |
2464 | | Column('offsetToStandardUnit', NUMERIC , nullable=True), |
2465 | | Column('uomName', TEXT , nullable=False), |
2466 | | Column('formula', TEXT , nullable=True), |
2467 | | Column('scaleToStandardUnit', NUMERIC , nullable=True), |
2468 | | Column('uomSymbol', TEXT , nullable=False), |
2469 | | Column('nameStandardUnit', TEXT , nullable=True), |
2470 | | extend_existing=False,) |
2471 | | |
2472 | | |
2473 | | |
2474 | | |
2475 | | |
2476 | | |
2477 | | |
2478 | | |
2479 | | |
2480 | | |
2481 | | |
2482 | | |
2483 | | cv_gridpoint_table = Table('cv_gridpoint', metadata, |
2484 | | Column('id', Integer, Sequence('cv_gridpoint_id_seq'), primary_key=True), |
2485 | | Column('cv_footprint_center', Integer, ForeignKey('cv_footprint.id', use_alter=True, name='fk_cv_footprint_center')), |
2486 | | Column('cv_grid_intersection', Integer, ForeignKey('cv_grid.id', use_alter=True, name='fk_cv_grid_intersection')), |
2487 | | Column('cv_gridcell_corner', Integer, ForeignKey('cv_gridcell.id', use_alter=True, name='fk_cv_gridcell_corner')), |
2488 | | Column('gm_point_gridpoint', Integer, ForeignKey('gm_point.id', use_alter=True, name='fk_gm_point_gridpoint')), |
2489 | | extend_existing=False,) |
2490 | | |
2491 | | |
2492 | | |
2493 | | |
2494 | | |
2495 | | |
2496 | | |
2497 | | |
2498 | | |
2499 | | |
2500 | | |
2501 | | |
2502 | | cd_verticaldatum_table = Table('cd_verticaldatum', metadata, |
2503 | | Column('id', Integer, Sequence('cd_verticaldatum_id_seq'), primary_key=True), |
2504 | | Column('sc_verticalcrs_datum_id', Integer, ForeignKey('sc_verticalcrs.id', use_alter=True, name='fk_sc_verticalcrs_datum')), |
2505 | | extend_existing=False,) |
2506 | | |
2507 | | |
2508 | | |
2509 | | |
2510 | | |
2511 | | |
2512 | | |
2513 | | |
2514 | | |
2515 | | |
2516 | | |
2517 | | |
2518 | | mo_result_table = Table('mo_result', metadata, |
2519 | | Column('id', Integer, Sequence('mo_result_id_seq'), primary_key=True), |
2520 | | Column('ceda_result__mo_result_id', Integer, ForeignKey('ceda_result.id')), |
2521 | | Column('mo_observation_result_id', Integer, ForeignKey('mo_observation.id')), |
2522 | | extend_existing=False,) |
2523 | | |
2524 | | |
2525 | | |
2526 | | |
2527 | | |
2528 | | |
2529 | | |
2530 | | |
2531 | | |
2532 | | |
2533 | | |
2534 | | |
2535 | | ceda_instrument_table = Table('ceda_instrument', metadata, |
2536 | | Column('id', Integer, Sequence('ceda_instrument_id_seq'), primary_key=True), |
2537 | | extend_existing=False,) |
2538 | | |
2539 | | |
2540 | | |
2541 | | |
2542 | | |
2543 | | |
2544 | | |
2545 | | |
2546 | | |
2547 | | |
2548 | | |
2549 | | |
2550 | | cc_formula_table = Table('cc_formula', metadata, |
2551 | | Column('id', Integer, Sequence('cc_formula_id_seq'), primary_key=True), |
2552 | | Column('cc_operationmethod_formulareference_id', Integer, ForeignKey('cc_operationmethod.id')), |
2553 | | Column('formula', TEXT , nullable=False), |
2554 | | extend_existing=False,) |
2555 | | |
2556 | | |
2557 | | |
2558 | | |
2559 | | |
2560 | | |
2561 | | |
2562 | | |
2563 | | |
2564 | | |
2565 | | |
2566 | | |
2567 | | scale_table = Table('scale', metadata, |
2568 | | Column('id', Integer, Sequence('scale_id_seq'), primary_key=True), |
2569 | | Column('md_representativefraction_equivalentscale', Integer, ForeignKey('md_representativefraction.id')), |
2570 | | extend_existing=False,) |
2571 | | |
2572 | | |
2573 | | |
2574 | | |
2575 | | |
2576 | | |
2577 | | |
2578 | | |
2579 | | |
2580 | | |
2581 | | |
2582 | | |
2583 | | cc_generaloperationparameter_table = Table('cc_generaloperationparameter', metadata, |
2584 | | Column('id', Integer, Sequence('cc_generaloperationparameter_id_seq'), primary_key=True), |
2585 | | Column('cc_operationparametergroup__cc_generaloperationparameter_id', Integer, ForeignKey('cc_operationparametergroup.id')), |
2586 | | Column('cc_operationparametergroup_parameter', Integer, ForeignKey('cc_operationparametergroup.id', use_alter=True, name='fk_cc_operationparametergroup_parameter')), |
2587 | | Column('cc_generalparametervalue_parameter_id', Integer, ForeignKey('cc_generalparametervalue.id', use_alter=True, name='fk_cc_generalparametervalue_parameter')), |
2588 | | Column('minimumOccurs', Integer , nullable=True), |
2589 | | extend_existing=False,) |
2590 | | |
2591 | | |
2592 | | |
2593 | | |
2594 | | |
2595 | | |
2596 | | |
2597 | | |
2598 | | |
2599 | | |
2600 | | |
2601 | | |
2602 | | mo_operation_table = Table('mo_operation', metadata, |
2603 | | Column('id', Integer, Sequence('mo_operation_id_seq'), primary_key=True), |
2604 | | Column('ceda_operation__mo_operation_id', Integer, ForeignKey('ceda_operation.id')), |
2605 | | Column('mo_acquisition_operation', Integer, ForeignKey('mo_acquisition.id')), |
2606 | | Column('description', TEXT , nullable=True), |
| 3643 | md_identification_table = Table('md_identification', metadata, |
| 3644 | Column('id', Integer, Sequence('md_identification_id_seq'), primary_key=True), |
| 3645 | Column('md_metadata_identificationinfo', Integer, ForeignKey('md_metadata.id')), |
2608 | | extend_existing=False,) |
2609 | | |
2610 | | |
2611 | | |
2612 | | |
2613 | | |
2614 | | |
2615 | | |
2616 | | |
2617 | | |
2618 | | |
2619 | | |
2620 | | |
2621 | | tm_position_table = Table('tm_position', metadata, |
2622 | | Column('id', Integer, Sequence('tm_position_id_seq'), primary_key=True), |
2623 | | Column('tm_instant_position_id', Integer, ForeignKey('tm_instant.id')), |
2624 | | extend_existing=False,) |
2625 | | |
2626 | | |
2627 | | |
2628 | | |
2629 | | |
2630 | | |
2631 | | |
2632 | | |
2633 | | |
2634 | | |
2635 | | |
2636 | | |
2637 | | dq_element_table = Table('dq_element', metadata, |
2638 | | Column('id', Integer, Sequence('dq_element_id_seq'), primary_key=True), |
2639 | | Column('dq_dataquality_report', Integer, ForeignKey('dq_dataquality.id')), |
2640 | | Column('dq_positionalaccuracy__dq_element_id', Integer, ForeignKey('dq_positionalaccuracy.id')), |
2641 | | Column('om_observation_resultquality', Integer, ForeignKey('om_observation.id')), |
2642 | | Column('evaluationMethodType', DQ_EvaluationMethodTypeCode.db_type() , nullable=True), |
2643 | | Column('measureDescription', TEXT , nullable=True), |
2644 | | Column('evaluationMethodDescription', TEXT , nullable=True), |
2645 | | Column('nameOfMeasure', ARRAY(TEXT) , nullable=True), |
2646 | | extend_existing=False,) |
2647 | | |
2648 | | |
2649 | | |
2650 | | |
2651 | | |
2652 | | |
2653 | | |
2654 | | |
2655 | | |
2656 | | |
2657 | | |
2658 | | |
2659 | | dq_dataquality_table = Table('dq_dataquality', metadata, |
2660 | | Column('id', Integer, Sequence('dq_dataquality_id_seq'), primary_key=True), |
2661 | | Column('md_metadata_dataqualityinfo', Integer, ForeignKey('md_metadata.id', use_alter=True, name='fk_md_metadata_dataqualityinfo')), |
2662 | | extend_existing=False,) |
2663 | | |
2664 | | |
2665 | | |
2666 | | |
2667 | | |
2668 | | |
2669 | | |
2670 | | |
2671 | | |
2672 | | |
2673 | | |
2674 | | |
2675 | | tm_topologicalcomplex_table = Table('tm_topologicalcomplex', metadata, |
2676 | | Column('id', Integer, Sequence('tm_topologicalcomplex_id_seq'), primary_key=True), |
2677 | | Column('tm_topologicalprimitive_complex_id', Integer, ForeignKey('tm_topologicalprimitive.id', use_alter=True, name='fk_tm_topologicalprimitive_complex')), |
2678 | | extend_existing=False,) |
2679 | | |
2680 | | |
2681 | | |
2682 | | |
2683 | | |
2684 | | |
2685 | | |
2686 | | |
2687 | | |
2688 | | |
2689 | | |
2690 | | |
2691 | | tm_topologicalprimitive_table = Table('tm_topologicalprimitive', metadata, |
2692 | | Column('id', Integer, Sequence('tm_topologicalprimitive_id_seq'), primary_key=True), |
2693 | | Column('tm_topologicalcomplex_primitive', Integer, ForeignKey('tm_topologicalcomplex.id', use_alter=True, name='fk_tm_topologicalcomplex_primitive')), |
2694 | | Column('tm_node__tm_topologicalprimitive_id', Integer, ForeignKey('tm_node.id')), |
2695 | | Column('tm_edge__tm_topologicalprimitive_id', Integer, ForeignKey('tm_edge.id')), |
2696 | | extend_existing=False,) |
2697 | | |
2698 | | |
2699 | | |
2700 | | |
2701 | | |
2702 | | |
2703 | | |
2704 | | |
2705 | | |
2706 | | |
2707 | | |
2708 | | |
2709 | | scopedname_table = Table('scopedname', metadata, |
2710 | | Column('id', Integer, Sequence('scopedname_id_seq'), primary_key=True), |
2711 | | Column('mo_onlineresource_servicefunction_id', Integer, ForeignKey('mo_onlineresource.id')), |
2712 | | Column('mo_instrument_type_id', Integer, ForeignKey('mo_instrument.id')), |
2713 | | extend_existing=False,) |
2714 | | |
2715 | | |
2716 | | |
2717 | | |
2718 | | |
2719 | | |
2720 | | |
2721 | | |
2722 | | |
2723 | | |
2724 | | |
2725 | | |
2726 | | gm_primitive_table = Table('gm_primitive', metadata, |
2727 | | Column('id', Integer, Sequence('gm_primitive_id_seq'), primary_key=True), |
2728 | | Column('gm_complex_element', Integer, ForeignKey('gm_complex.id', use_alter=True, name='fk_gm_complex_element')), |
2729 | | Column('gm_composite_generator', Integer, ForeignKey('gm_composite.id', use_alter=True, name='fk_gm_composite_generator')), |
2730 | | Column('tp_primitive_geometry_id', Integer, ForeignKey('tp_primitive.id', use_alter=True, name='fk_tp_primitive_geometry')), |
2731 | | Column('gm_point__gm_primitive_id', Integer, ForeignKey('gm_point.id')), |
2732 | | Column('gm_orientableprimitive__gm_primitive_id', Integer, ForeignKey('gm_orientableprimitive.id')), |
2733 | | Column('gm_orientableprimitive_primitive_id', Integer, ForeignKey('gm_orientableprimitive.id', use_alter=True, name='fk_gm_orientableprimitive_primitive')), |
2734 | | extend_existing=False,) |
2735 | | |
2736 | | |
2737 | | |
2738 | | |
2739 | | |
2740 | | |
2741 | | |
2742 | | |
2743 | | |
2744 | | |
2745 | | |
2746 | | |
2747 | | ceda_notes_table = Table('ceda_notes', metadata, |
2748 | | Column('id', Integer, Sequence('ceda_notes_id_seq'), primary_key=True), |
2749 | | Column('ceda_review_notes', Integer, ForeignKey('ceda_review.id')), |
2750 | | Column('comments', TEXT , nullable=False), |
2751 | | extend_existing=False,) |
2752 | | |
2753 | | |
2754 | | |
2755 | | |
2756 | | |
2757 | | |
2758 | | |
2759 | | |
2760 | | |
2761 | | |
2762 | | |
2763 | | |
2764 | | md_referencesystem_table = Table('md_referencesystem', metadata, |
2765 | | Column('id', Integer, Sequence('md_referencesystem_id_seq'), primary_key=True), |
2766 | | Column('li_source_sourcereferencesystem_id', Integer, ForeignKey('li_source.id')), |
2767 | | Column('md_metadata_referencesysteminfo', Integer, ForeignKey('md_metadata.id')), |
2768 | | extend_existing=False,) |
2769 | | |
2770 | | |
2771 | | |
2772 | | |
2773 | | |
2774 | | |
2775 | | |
2776 | | |
2777 | | |
2778 | | |
2779 | | |
2780 | | |
2781 | | cl_dataset_table = Table('cl_dataset', metadata, |
2782 | | Column('id', Integer, Sequence('cl_dataset_id_seq'), primary_key=True), |
2783 | | Column('md_metadata_describes', Integer, ForeignKey('md_metadata.id', use_alter=True, name='fk_md_metadata_describes')), |
2784 | | extend_existing=False,) |
2785 | | |
2786 | | |
2787 | | |
2788 | | |
2789 | | |
2790 | | |
2791 | | |
2792 | | |
2793 | | |
2794 | | |
2795 | | |
2796 | | |
2797 | | tp_directedtopo_table = Table('tp_directedtopo', metadata, |
2798 | | Column('id', Integer, Sequence('tp_directedtopo_id_seq'), primary_key=True), |
2799 | | Column('tp_primitive_proxy_id', Integer, ForeignKey('tp_primitive.id', use_alter=True, name='fk_tp_primitive_proxy')), |
2800 | | Column('tp_expressionterm_variable_id', Integer, ForeignKey('tp_expressionterm.id', use_alter=True, name='fk_tp_expressionterm_variable')), |
2801 | | Column('orientation', Sign.db_type() , nullable=False), |
2802 | | extend_existing=False,) |
2803 | | |
2804 | | |
2805 | | |
2806 | | |
2807 | | |
2808 | | |
2809 | | |
2810 | | |
2811 | | |
2812 | | |
2813 | | |
2814 | | |
2815 | | tm_period_table = Table('tm_period', metadata, |
2816 | | Column('id', Integer, Sequence('tm_period_id_seq'), primary_key=True), |
2817 | | Column('om_observation_validtime_id', Integer, ForeignKey('om_observation.id')), |
2818 | | Column('tm_instant_begunby', Integer, ForeignKey('tm_instant.id', use_alter=True, name='fk_tm_instant_begunby')), |
2819 | | Column('tm_instant_endedby', Integer, ForeignKey('tm_instant.id', use_alter=True, name='fk_tm_instant_endedby')), |
2820 | | Column('tm_edge_geometry_id', Integer, ForeignKey('tm_edge.id', use_alter=True, name='fk_tm_edge_geometry')), |
2821 | | extend_existing=False,) |
2822 | | |
2823 | | |
2824 | | |
2825 | | |
2826 | | |
2827 | | |
2828 | | |
2829 | | |
2830 | | |
2831 | | |
2832 | | |
2833 | | |
2834 | | mo_platform_table = Table('mo_platform', metadata, |
2835 | | Column('id', Integer, Sequence('mo_platform_id_seq'), primary_key=True), |
2836 | | Column('mo_acquisition_platform', Integer, ForeignKey('mo_acquisition.id')), |
2837 | | Column('mo_operation_platform', Integer, ForeignKey('mo_operation.id')), |
2838 | | Column('ceda_platform__mo_platform_id', Integer, ForeignKey('ceda_platform.id')), |
2839 | | Column('mo_instrumentplatformpair_platform_id', Integer, ForeignKey('mo_instrumentplatformpair.id')), |
2840 | | Column('type', MO_PlatformTypeValue.db_type() , nullable=True), |
2841 | | Column('description', TEXT , nullable=True), |
2842 | | extend_existing=False,) |
2843 | | |
2844 | | |
2845 | | |
2846 | | |
2847 | | |
2848 | | |
2849 | | |
2850 | | |
2851 | | |
2852 | | |
2853 | | |
2854 | | |
2855 | | om_process_table = Table('om_process', metadata, |
2856 | | Column('id', Integer, Sequence('om_process_id_seq'), primary_key=True), |
2857 | | Column('om_observation_procedure_id', Integer, ForeignKey('om_observation.id', use_alter=True, name='fk_om_observation_procedure')), |
2858 | | Column('mo_process__om_process_id', Integer, ForeignKey('mo_process.id')), |
2859 | | extend_existing=False,) |
2860 | | |
2861 | | |
2862 | | |
2863 | | |
2864 | | |
2865 | | |
2866 | | |
2867 | | |
2868 | | |
2869 | | |
2870 | | |
2871 | | |
2872 | | cv_coverage_table = Table('cv_coverage', metadata, |
2873 | | Column('id', Integer, Sequence('cv_coverage_id_seq'), primary_key=True), |
2874 | | Column('cv_attributevalues_collection_id', Integer, ForeignKey('cv_attributevalues.id', use_alter=True, name='fk_cv_attributevalues_collection')), |
2875 | | Column('cv_domainobject_collection_id', Integer, ForeignKey('cv_domainobject.id', use_alter=True, name='fk_cv_domainobject_collection')), |
2876 | | Column('commonPointRule', CV_CommonPointRule.db_type() , nullable=False), |
2877 | | extend_existing=False,) |
2878 | | |
2879 | | |
2880 | | |
2881 | | |
2882 | | |
2883 | | |
2884 | | |
2885 | | |
2886 | | |
2887 | | |
2888 | | |
2889 | | |
2890 | | cs_coordinatesystem_table = Table('cs_coordinatesystem', metadata, |
2891 | | Column('id', Integer, Sequence('cs_coordinatesystem_id_seq'), primary_key=True), |
2892 | | Column('cs_coordinatesystemaxis_coordinatesystem', Integer, ForeignKey('cs_coordinatesystemaxis.id', use_alter=True, name='fk_cs_coordinatesystemaxis_coordinatesystem')), |
2893 | | Column('cs_verticalcs__cs_coordinatesystem_id', Integer, ForeignKey('cs_verticalcs.id')), |
2894 | | Column('sc_singlecrs_coordinatesystem_id', Integer, ForeignKey('sc_singlecrs.id', use_alter=True, name='fk_sc_singlecrs_coordinatesystem')), |
2895 | | extend_existing=False,) |
2896 | | |
2897 | | |
2898 | | |
2899 | | |
2900 | | |
2901 | | |
2902 | | |
2903 | | |
2904 | | |
2905 | | |
2906 | | |
2907 | | |
2908 | | md_scopedescription_table = Table('md_scopedescription', metadata, |
2909 | | Column('id', Integer, Sequence('md_scopedescription_id_seq'), primary_key=True), |
2910 | | Column('md_maintenanceinformation_updatescopedescription', Integer, ForeignKey('md_maintenanceinformation.id', use_alter=True, name='fk_md_maintenanceinformation_updatescopedescription')), |
2911 | | Column('dq_scope_leveldescription', Integer, ForeignKey('dq_scope.id', use_alter=True, name='fk_dq_scope_leveldescription')), |
2912 | | Column('other', TEXT , nullable=False), |
2913 | | Column('dataset', TEXT , nullable=False), |
2914 | | extend_existing=False,) |
2915 | | |
2916 | | |
2917 | | |
2918 | | |
2919 | | |
2920 | | |
2921 | | |
2922 | | |
2923 | | |
2924 | | |
2925 | | |
2926 | | |
2927 | | md_applicationschemainformation_table = Table('md_applicationschemainformation', metadata, |
2928 | | Column('id', Integer, Sequence('md_applicationschemainformation_id_seq'), primary_key=True), |
2929 | | Column('md_metadata_applicationschemainfo', Integer, ForeignKey('md_metadata.id')), |
2930 | | Column('schemaAscii', TEXT , nullable=True), |
2931 | | Column('softwareDevelopmentFileFormat', TEXT , nullable=True), |
2932 | | Column('schemaLanguage', TEXT , nullable=False), |
2933 | | Column('constraintLanguage', TEXT , nullable=False), |
2934 | | extend_existing=False,) |
2935 | | |
2936 | | |
2937 | | |
2938 | | |
2939 | | |
2940 | | |
2941 | | |
2942 | | |
2943 | | |
2944 | | |
2945 | | |
2946 | | |
2947 | | mo_instrument_table = Table('mo_instrument', metadata, |
2948 | | Column('id', Integer, Sequence('mo_instrument_id_seq'), primary_key=True), |
2949 | | Column('mo_instrumentplatformpair_instrument_id', Integer, ForeignKey('mo_instrumentplatformpair.id')), |
2950 | | Column('mo_acquisition_instrument', Integer, ForeignKey('mo_acquisition.id')), |
2951 | | Column('ceda_instrument__mo_instrument_id', Integer, ForeignKey('ceda_instrument.id')), |
2952 | | Column('description', TEXT , nullable=True), |
2953 | | extend_existing=False,) |
2954 | | |
2955 | | |
2956 | | |
2957 | | |
2958 | | |
2959 | | |
2960 | | |
2961 | | |
2962 | | |
2963 | | |
2964 | | |
2965 | | |
2966 | | sc_verticalcrs_table = Table('sc_verticalcrs', metadata, |
2967 | | Column('id', Integer, Sequence('sc_verticalcrs_id_seq'), primary_key=True), |
2968 | | Column('cs_verticalcs_referencesystem', Integer, ForeignKey('cs_verticalcs.id', use_alter=True, name='fk_cs_verticalcs_referencesystem')), |
2969 | | Column('ex_verticalextent_verticalcrs_id', Integer, ForeignKey('ex_verticalextent.id', use_alter=True, name='fk_ex_verticalextent_verticalcrs')), |
2970 | | Column('cd_verticaldatum_referencesystem', Integer, ForeignKey('cd_verticaldatum.id', use_alter=True, name='fk_cd_verticaldatum_referencesystem')), |
2971 | | extend_existing=False,) |
2972 | | |
2973 | | |
2974 | | |
2975 | | |
2976 | | |
2977 | | |
2978 | | |
2979 | | |
2980 | | |
2981 | | |
2982 | | |
2983 | | |
2984 | | tm_temporalposition_table = Table('tm_temporalposition', metadata, |
2985 | | Column('id', Integer, Sequence('tm_temporalposition_id_seq'), primary_key=True), |
2986 | | Column('tm_position_anyother_id', Integer, ForeignKey('tm_position.id')), |
2987 | | Column('tm_referencesystem_position', Integer, ForeignKey('tm_referencesystem.id', use_alter=True, name='fk_tm_referencesystem_position')), |
2988 | | Column('indeterminatePosition', TM_IndeterminateValue.db_type() , nullable=True), |
2989 | | extend_existing=False,) |
2990 | | |
2991 | | |
2992 | | |
2993 | | |
2994 | | |
2995 | | |
2996 | | |
2997 | | |
2998 | | |
2999 | | |
3000 | | |
3001 | | |
3002 | | io_identifiedobject_table = Table('io_identifiedobject', metadata, |
3003 | | Column('id', Integer, Sequence('io_identifiedobject_id_seq'), primary_key=True), |
3004 | | Column('cs_coordinatesystemaxis__io_identifiedobject_id', Integer, ForeignKey('cs_coordinatesystemaxis.id')), |
3005 | | Column('cc_generaloperationparameter__io_identifiedobject_id', Integer, ForeignKey('cc_generaloperationparameter.id')), |
3006 | | Column('cd_datum__io_identifiedobject_id', Integer, ForeignKey('cd_datum.id')), |
3007 | | Column('cc_operationmethod__io_identifiedobject_id', Integer, ForeignKey('cc_operationmethod.id')), |
3008 | | Column('cc_coordinateoperation__io_identifiedobject_id', Integer, ForeignKey('cc_coordinateoperation.id')), |
3009 | | Column('cs_coordinatesystem__io_identifiedobject_id', Integer, ForeignKey('cs_coordinatesystem.id')), |
3010 | | extend_existing=False,) |
3011 | | |
3012 | | |
3013 | | |
3014 | | |
3015 | | |
3016 | | |
3017 | | |
3018 | | |
3019 | | |
3020 | | |
3021 | | |
3022 | | |
3023 | | uomscale_table = Table('uomscale', metadata, |
3024 | | Column('id', Integer, Sequence('uomscale_id_seq'), primary_key=True), |
3025 | | Column('scale_uom_id', Integer, ForeignKey('scale.id')), |
| 3647 | Column('abstract', TEXT , nullable=False), |
| 3648 | Column('purpose', TEXT , nullable=True), |
| 3649 | Column('credit', ARRAY(TEXT) , nullable=True), |
| 3650 | extend_existing=False,) |
| 3651 | |
| 3652 | |
| 3653 | |
| 3654 | |
| 3655 | |
| 3656 | |
| 3657 | |
| 3658 | |
| 3659 | |
| 3660 | |
| 3661 | |
| 3662 | |
| 3663 | namedvalue_table = Table('namedvalue', metadata, |
| 3664 | Column('id', Integer, Sequence('namedvalue_id_seq'), primary_key=True), |
| 3665 | Column('om_observation_parameter', Integer, ForeignKey('om_observation.id')), |
| 3666 | extend_existing=False,) |
| 3667 | |
| 3668 | |
| 3669 | |
| 3670 | |
| 3671 | |
| 3672 | |
| 3673 | |
| 3674 | |
| 3675 | |
| 3676 | |
| 3677 | |
| 3678 | |
| 3679 | ex_geographicdescription_table = Table('ex_geographicdescription', metadata, |
| 3680 | Column('id', Integer, Sequence('ex_geographicdescription_id_seq'), primary_key=True), |
| 3681 | Column('mo_location_namelocation_id', Integer, ForeignKey('mo_location.id')), |
| 3682 | extend_existing=False,) |
| 3683 | |
| 3684 | |
| 3685 | |
| 3686 | |
| 3687 | |
| 3688 | |
| 3689 | |
| 3690 | |
| 3691 | |
| 3692 | |
| 3693 | |
| 3694 | |
| 3695 | gm_compositepoint_table = Table('gm_compositepoint', metadata, |
| 3696 | Column('id', Integer, Sequence('gm_compositepoint_id_seq'), primary_key=True), |
| 3697 | Column('gm_point_composite', Integer, ForeignKey('gm_point.id', use_alter=True, name='fk_gm_point_composite')), |
| 3698 | extend_existing=False,) |
| 3699 | |
| 3700 | |
| 3701 | |
| 3702 | |
| 3703 | |
| 3704 | |
| 3705 | |
| 3706 | |
| 3707 | |
| 3708 | |
| 3709 | |
| 3710 | |
| 3711 | gf_attributetype_table = Table('gf_attributetype', metadata, |
| 3712 | Column('id', Integer, Sequence('gf_attributetype_id_seq'), primary_key=True), |
| 3713 | Column('md_scopedescription_attributeinstances', Integer, ForeignKey('md_scopedescription.id', use_alter=True, name='fk_md_scopedescription_attributeinstances')), |
| 3714 | Column('gf_operation_affectsvaluesof', Integer, ForeignKey('gf_operation.id', use_alter=True, name='fk_gf_operation_affectsvaluesof')), |
| 3715 | Column('md_scopedescription_attributes', Integer, ForeignKey('md_scopedescription.id', use_alter=True, name='fk_md_scopedescription_attributes')), |
| 3716 | Column('gf_operation_observesvaluesof', Integer, ForeignKey('gf_operation.id', use_alter=True, name='fk_gf_operation_observesvaluesof')), |
| 3717 | Column('md_metadata_featureattribute', Integer, ForeignKey('md_metadata.id', use_alter=True, name='fk_md_metadata_featureattribute')), |
| 3718 | Column('gf_operation_triggeredbyvaluesof', Integer, ForeignKey('gf_operation.id', use_alter=True, name='fk_gf_operation_triggeredbyvaluesof')), |
| 3719 | Column('valueDomain', TEXT , nullable=False), |
3056 | | mo_location_table = Table('mo_location', metadata, |
3057 | | Column('id', Integer, Sequence('mo_location_id_seq'), primary_key=True), |
3058 | | Column('mo_operation_location_id', Integer, ForeignKey('mo_operation.id')), |
3059 | | Column('mo_platform_location_id', Integer, ForeignKey('mo_platform.id')), |
3060 | | extend_existing=False,) |
3061 | | |
3062 | | |
3063 | | |
3064 | | |
3065 | | |
3066 | | |
3067 | | |
3068 | | |
3069 | | |
3070 | | |
3071 | | |
3072 | | |
3073 | | tp_expression_table = Table('tp_expression', metadata, |
3074 | | Column('id', Integer, Sequence('tp_expression_id_seq'), primary_key=True), |
3075 | | Column('tp_expressionterm_expression_id', Integer, ForeignKey('tp_expressionterm.id', use_alter=True, name='fk_tp_expressionterm_expression')), |
3076 | | extend_existing=False,) |
3077 | | |
3078 | | |
3079 | | |
3080 | | |
3081 | | |
3082 | | |
3083 | | |
3084 | | |
3085 | | |
3086 | | |
3087 | | |
3088 | | |
3089 | | cs_verticalcs_table = Table('cs_verticalcs', metadata, |
3090 | | Column('id', Integer, Sequence('cs_verticalcs_id_seq'), primary_key=True), |
3091 | | Column('sc_verticalcrs_coordinatesystem_id', Integer, ForeignKey('sc_verticalcrs.id', use_alter=True, name='fk_sc_verticalcrs_coordinatesystem')), |
3092 | | extend_existing=False,) |
3093 | | |
3094 | | |
3095 | | |
3096 | | |
3097 | | |
3098 | | |
3099 | | |
3100 | | |
3101 | | |
3102 | | |
3103 | | |
3104 | | |
3105 | | recordtype_table = Table('recordtype', metadata, |
3106 | | Column('id', Integer, Sequence('recordtype_id_seq'), primary_key=True), |
3107 | | Column('record_recordtype_id', Integer, ForeignKey('record.id', use_alter=True, name='fk_record_recordtype')), |
3108 | | Column('cv_coverage_rangetype_id', Integer, ForeignKey('cv_coverage.id')), |
3109 | | extend_existing=False,) |
3110 | | |
3111 | | |
3112 | | |
3113 | | |
3114 | | |
3115 | | |
3116 | | |
3117 | | |
3118 | | |
3119 | | |
3120 | | |
3121 | | |
3122 | | cc_concatenatedoperation_table = Table('cc_concatenatedoperation', metadata, |
3123 | | Column('id', Integer, Sequence('cc_concatenatedoperation_id_seq'), primary_key=True), |
3124 | | Column('cc_coordinateoperation_concatoperation', Integer, ForeignKey('cc_coordinateoperation.id', use_alter=True, name='fk_cc_coordinateoperation_concatoperation')), |
3125 | | extend_existing=False,) |
3126 | | |
3127 | | |
3128 | | |
3129 | | |
3130 | | |
3131 | | |
3132 | | |
3133 | | |
3134 | | |
3135 | | |
3136 | | |
3137 | | |
3138 | | rs_referencesystem_table = Table('rs_referencesystem', metadata, |
3139 | | Column('id', Integer, Sequence('rs_referencesystem_id_seq'), primary_key=True), |
3140 | | Column('sc_crs__rs_referencesystem_id', Integer, ForeignKey('sc_crs.id')), |
3141 | | Column('tm_referencesystem__rs_referencesystem_id', Integer, ForeignKey('tm_referencesystem.id')), |
3142 | | extend_existing=False,) |
3143 | | |
3144 | | |
3145 | | |
3146 | | |
3147 | | |
3148 | | |
3149 | | |
3150 | | |
3151 | | |
3152 | | |
3153 | | |
3154 | | |
3155 | | mo_instrumentplatformpair_table = Table('mo_instrumentplatformpair', metadata, |
3156 | | Column('id', Integer, Sequence('mo_instrumentplatformpair_id_seq'), primary_key=True), |
3157 | | Column('mo_acquisition_instrumentplatformpair', Integer, ForeignKey('mo_acquisition.id')), |
3158 | | extend_existing=False,) |
3159 | | |
3160 | | |
3161 | | |
3162 | | |
3163 | | |
3164 | | |
3165 | | |
3166 | | |
3167 | | |
3168 | | |
3169 | | |
3170 | | |
3171 | | tm_instant_table = Table('tm_instant', metadata, |
3172 | | Column('id', Integer, Sequence('tm_instant_id_seq'), primary_key=True), |
3173 | | Column('tm_period_end_id', Integer, ForeignKey('tm_period.id', use_alter=True, name='fk_tm_period_end')), |
3174 | | Column('om_observation_resulttime_id', Integer, ForeignKey('om_observation.id')), |
3175 | | Column('tm_period_begin_id', Integer, ForeignKey('tm_period.id', use_alter=True, name='fk_tm_period_begin')), |
3176 | | Column('tm_node_geometry_id', Integer, ForeignKey('tm_node.id', use_alter=True, name='fk_tm_node_geometry')), |
3177 | | extend_existing=False,) |
3178 | | |
3179 | | |
3180 | | |
3181 | | |
3182 | | |
3183 | | |
3184 | | |
3185 | | |
3186 | | |
3187 | | |
3188 | | |
3189 | | |
3190 | | cc_singleoperation_table = Table('cc_singleoperation', metadata, |
3191 | | Column('id', Integer, Sequence('cc_singleoperation_id_seq'), primary_key=True), |
3192 | | Column('cc_conversion__cc_singleoperation_id', Integer, ForeignKey('cc_conversion.id')), |
3193 | | Column('cc_generalparametervalue_coordoperation', Integer, ForeignKey('cc_generalparametervalue.id', use_alter=True, name='fk_cc_generalparametervalue_coordoperation')), |
3194 | | Column('cc_operationmethod_coordoperation', Integer, ForeignKey('cc_operationmethod.id', use_alter=True, name='fk_cc_operationmethod_coordoperation')), |
3195 | | extend_existing=False,) |
3196 | | |
3197 | | |
3198 | | |
3199 | | |
3200 | | |
3201 | | |
3202 | | |
3203 | | |
3204 | | |
3205 | | |
3206 | | |
3207 | | |
3208 | | tm_referencesystem_table = Table('tm_referencesystem', metadata, |
3209 | | Column('id', Integer, Sequence('tm_referencesystem_id_seq'), primary_key=True), |
3210 | | Column('tm_temporalposition_frame_id', Integer, ForeignKey('tm_temporalposition.id', use_alter=True, name='fk_tm_temporalposition_frame')), |
3211 | | extend_existing=False,) |
3212 | | |
3213 | | |
3214 | | |
3215 | | |
3216 | | |
3217 | | |
3218 | | |
3219 | | |
3220 | | |
3221 | | |
3222 | | |
3223 | | |
3224 | | measure_table = Table('measure', metadata, |
3225 | | Column('id', Integer, Sequence('measure_id_seq'), primary_key=True), |
3226 | | Column('scale__measure_id', Integer, ForeignKey('scale.id')), |
3227 | | Column('time__measure_id', Integer, ForeignKey('time.id')), |
3228 | | Column('unitofmeasure_measure', Integer, ForeignKey('unitofmeasure.id', use_alter=True, name='fk_unitofmeasure_measure')), |
3229 | | Column('length__measure_id', Integer, ForeignKey('length.id')), |
3230 | | Column('value', NUMERIC , nullable=False), |
3231 | | extend_existing=False,) |
3232 | | |
3233 | | |
3234 | | |
3235 | | |
3236 | | |
3237 | | |
3238 | | |
3239 | | |
3240 | | |
3241 | | |
3242 | | |
3243 | | |
3244 | | gf_featuretype_table = Table('gf_featuretype', metadata, |
3245 | | Column('id', Integer, Sequence('gf_featuretype_id_seq'), primary_key=True), |
3246 | | Column('gf_inheritancerelation_subtype_id', Integer, ForeignKey('gf_inheritancerelation.id', use_alter=True, name='fk_gf_inheritancerelation_subtype')), |
3247 | | Column('md_metadata_featuretype', Integer, ForeignKey('md_metadata.id', use_alter=True, name='fk_md_metadata_featuretype')), |
3248 | | Column('gf_associationtype_includes', Integer, ForeignKey('gf_associationtype.id', use_alter=True, name='fk_gf_associationtype_includes')), |
3249 | | Column('md_scopedescription_featureinstances', Integer, ForeignKey('md_scopedescription.id', use_alter=True, name='fk_md_scopedescription_featureinstances')), |
3250 | | Column('md_scopedescription_features', Integer, ForeignKey('md_scopedescription.id', use_alter=True, name='fk_md_scopedescription_features')), |
3251 | | Column('gf_associationtype__gf_featuretype_id', Integer, ForeignKey('gf_associationtype.id')), |
3252 | | Column('gf_inheritancerelation_supertype_id', Integer, ForeignKey('gf_inheritancerelation.id', use_alter=True, name='fk_gf_inheritancerelation_supertype')), |
3253 | | Column('gf_propertytype_thegf_featuretype_id', Integer, ForeignKey('gf_propertytype.id', use_alter=True, name='fk_gf_propertytype_thegf_featuretype')), |
3254 | | Column('isAbstract', BOOLEAN , nullable=False), |
3255 | | Column('definition', TEXT , nullable=False), |
3256 | | extend_existing=False,) |
3257 | | |
3258 | | |
3259 | | |
3260 | | |
3261 | | |
3262 | | |
3263 | | |
3264 | | |
3265 | | |
3266 | | |
3267 | | |
3268 | | |
3269 | | cc_operationparametergroup_table = Table('cc_operationparametergroup', metadata, |
3270 | | Column('id', Integer, Sequence('cc_operationparametergroup_id_seq'), primary_key=True), |
3271 | | Column('cc_parametervaluegroup_group_id', Integer, ForeignKey('cc_parametervaluegroup.id', use_alter=True, name='fk_cc_parametervaluegroup_group')), |
3272 | | Column('cc_generaloperationparameter_group', Integer, ForeignKey('cc_generaloperationparameter.id', use_alter=True, name='fk_cc_generaloperationparameter_group')), |
3273 | | Column('maximumOccurs', Integer , nullable=True), |
3274 | | extend_existing=False,) |
3275 | | |
3276 | | |
3277 | | |
3278 | | |
3279 | | |
3280 | | |
3281 | | |
3282 | | |
3283 | | |
3284 | | |
3285 | | |
3286 | | |
3287 | | ceda_review_table = Table('ceda_review', metadata, |
3288 | | Column('id', Integer, Sequence('ceda_review_id_seq'), primary_key=True), |
3289 | | Column('ceda_instrument_review', Integer, ForeignKey('ceda_instrument.id')), |
3290 | | Column('ceda_acquisition_review', Integer, ForeignKey('ceda_acquisition.id')), |
3291 | | Column('ceda_compositeprocess_review', Integer, ForeignKey('ceda_compositeprocess.id')), |
3292 | | Column('ceda_operation_review', Integer, ForeignKey('ceda_operation.id')), |
3293 | | Column('ceda_observationcollection_review', Integer, ForeignKey('ceda_observationcollection.id')), |
3294 | | Column('ceda_project_review', Integer, ForeignKey('ceda_project.id')), |
3295 | | Column('ceda_processing_review', Integer, ForeignKey('ceda_processing.id')), |
3296 | | Column('ceda_observation_internalreview', Integer, ForeignKey('ceda_observation.id')), |
3297 | | Column('ceda_platform_review', Integer, ForeignKey('ceda_platform.id')), |
3298 | | Column('reviewStatus', CEDA_ReviewStatusValue.db_type() , nullable=False), |
3299 | | Column('reviewFrequency', CEDA_ReviewFrequencyValue.db_type() , nullable=False), |
3300 | | extend_existing=False,) |
| 3750 | tm_position_table = Table('tm_position', metadata, |
| 3751 | Column('id', Integer, Sequence('tm_position_id_seq'), primary_key=True), |
| 3752 | Column('tm_instant_position_id', Integer, ForeignKey('tm_instant.id')), |
| 3753 | extend_existing=False,) |
| 3754 | |
| 3755 | |
| 3756 | |
| 3757 | |
| 3758 | |
| 3759 | |
| 3760 | |
| 3761 | |
| 3762 | |
| 3763 | |
| 3764 | |
| 3765 | |
| 3766 | ceda_project_table = Table('ceda_project', metadata, |
| 3767 | Column('id', Integer, Sequence('ceda_project_id_seq'), primary_key=True), |
| 3768 | extend_existing=False,) |
3319 | | |
3320 | | |
3321 | | |
3322 | | |
3323 | | |
3324 | | |
3325 | | |
3326 | | |
3327 | | |
3328 | | |
3329 | | li_processstep_table = Table('li_processstep', metadata, |
3330 | | Column('id', Integer, Sequence('li_processstep_id_seq'), primary_key=True), |
3331 | | Column('li_lineage_processstep', Integer, ForeignKey('li_lineage.id')), |
3332 | | Column('li_source_sourcestep', Integer, ForeignKey('li_source.id', use_alter=True, name='fk_li_source_sourcestep')), |
3333 | | Column('description', TEXT , nullable=False), |
3334 | | Column('rationale', TEXT , nullable=True), |
3335 | | extend_existing=False,) |
3336 | | |
3337 | | |
3338 | | |
3339 | | |
3340 | | |
3341 | | |
3342 | | |
3343 | | |
3344 | | |
3345 | | |
3346 | | |
3347 | | |
3348 | | md_representativefraction_table = Table('md_representativefraction', metadata, |
3349 | | Column('id', Integer, Sequence('md_representativefraction_id_seq'), primary_key=True), |
3350 | | Column('li_source_scaledenominator_id', Integer, ForeignKey('li_source.id')), |
3351 | | Column('denominator', Integer , nullable=False), |
3352 | | extend_existing=False,) |
3353 | | |
3354 | | |
3355 | | |
3356 | | |
3357 | | |
3358 | | |
3359 | | |
3360 | | |
3361 | | |
3362 | | |
3363 | | |
3364 | | |
3365 | | gf_attributetype_table = Table('gf_attributetype', metadata, |
3366 | | Column('id', Integer, Sequence('gf_attributetype_id_seq'), primary_key=True), |
3367 | | Column('md_scopedescription_attributes', Integer, ForeignKey('md_scopedescription.id', use_alter=True, name='fk_md_scopedescription_attributes')), |
3368 | | Column('md_metadata_featureattribute', Integer, ForeignKey('md_metadata.id', use_alter=True, name='fk_md_metadata_featureattribute')), |
3369 | | Column('gf_operation_affectsvaluesof', Integer, ForeignKey('gf_operation.id', use_alter=True, name='fk_gf_operation_affectsvaluesof')), |
3370 | | Column('gf_operation_observesvaluesof', Integer, ForeignKey('gf_operation.id', use_alter=True, name='fk_gf_operation_observesvaluesof')), |
3371 | | Column('gf_operation_triggeredbyvaluesof', Integer, ForeignKey('gf_operation.id', use_alter=True, name='fk_gf_operation_triggeredbyvaluesof')), |
3372 | | Column('md_scopedescription_attributeinstances', Integer, ForeignKey('md_scopedescription.id', use_alter=True, name='fk_md_scopedescription_attributeinstances')), |
3373 | | Column('valueDomain', TEXT , nullable=False), |
3374 | | extend_existing=False,) |
3375 | | |
3376 | | |
3377 | | |
3378 | | |
3379 | | |
3380 | | |
3381 | | |
3382 | | |
3383 | | |
3384 | | |
3385 | | |
3386 | | |
3387 | | tp_expressionterm_table = Table('tp_expressionterm', metadata, |
3388 | | Column('id', Integer, Sequence('tp_expressionterm_id_seq'), primary_key=True), |
3389 | | Column('tp_expression_term', Integer, ForeignKey('tp_expression.id', use_alter=True, name='fk_tp_expression_term')), |
3390 | | Column('tp_directedtopo_term', Integer, ForeignKey('tp_directedtopo.id', use_alter=True, name='fk_tp_directedtopo_term')), |
3391 | | Column('coefficient', Integer , nullable=False), |
3392 | | extend_existing=False,) |
3393 | | |
3394 | | |
3395 | | |
3396 | | |
3397 | | |
3398 | | |
3399 | | |
3400 | | |
3401 | | |
3402 | | |
3403 | | |
3404 | | |
3405 | | gm_compositepoint_table = Table('gm_compositepoint', metadata, |
3406 | | Column('id', Integer, Sequence('gm_compositepoint_id_seq'), primary_key=True), |
3407 | | Column('gm_point_composite', Integer, ForeignKey('gm_point.id', use_alter=True, name='fk_gm_point_composite')), |
3408 | | extend_existing=False,) |
3409 | | |
3410 | | |
3411 | | |
3412 | | |
3413 | | |
3414 | | |
3415 | | |
3416 | | |
3417 | | |
3418 | | |
3419 | | |
3420 | | |
3421 | | io_identifiedobjectbase_table = Table('io_identifiedobjectbase', metadata, |
3422 | | Column('id', Integer, Sequence('io_identifiedobjectbase_id_seq'), primary_key=True), |
3423 | | Column('io_identifiedobject__io_identifiedobjectbase_id', Integer, ForeignKey('io_identifiedobject.id')), |
3424 | | Column('sc_crs__io_identifiedobjectbase_id', Integer, ForeignKey('sc_crs.id')), |
3425 | | Column('remarks', TEXT , nullable=True), |
3426 | | extend_existing=False,) |
3427 | | |
3428 | | |
3429 | | |
3430 | | |
3431 | | |
3432 | | |
3433 | | |
3434 | | |
3435 | | |
3436 | | |
3437 | | |
3438 | | |
3439 | | cs_coordinatesystemaxis_table = Table('cs_coordinatesystemaxis', metadata, |
3440 | | Column('id', Integer, Sequence('cs_coordinatesystemaxis_id_seq'), primary_key=True), |
3441 | | Column('cs_coordinatesystem_axis', Integer, ForeignKey('cs_coordinatesystem.id', use_alter=True, name='fk_cs_coordinatesystem_axis')), |
3442 | | Column('axisDirection', CS_AxisDirection.db_type() , nullable=False), |
3443 | | Column('axisAbbrev', TEXT , nullable=False), |
3444 | | Column('minimumValue', NUMERIC , nullable=True), |
3445 | | Column('maximumValue', NUMERIC , nullable=True), |
3446 | | Column('rangeMeaning', CS_RangeMeaning.db_type() , nullable=True), |
3447 | | extend_existing=False,) |
3448 | | |
3449 | | |
3450 | | |
3451 | | |
3452 | | |
3453 | | |
3454 | | |
3455 | | |
3456 | | |
3457 | | |
3458 | | |
3459 | | |
3460 | | tm_node_table = Table('tm_node', metadata, |
3461 | | Column('id', Integer, Sequence('tm_node_id_seq'), primary_key=True), |
3462 | | Column('tm_instant_topology_id', Integer, ForeignKey('tm_instant.id', use_alter=True, name='fk_tm_instant_topology')), |
3463 | | Column('tm_edge_start_id', Integer, ForeignKey('tm_edge.id', use_alter=True, name='fk_tm_edge_start')), |
3464 | | Column('tm_edge_end_id', Integer, ForeignKey('tm_edge.id', use_alter=True, name='fk_tm_edge_end')), |
3465 | | extend_existing=False,) |
3466 | | |
3467 | | |
3468 | | |
3469 | | |
3470 | | |
3471 | | |
3472 | | |
3473 | | |
3474 | | |
3475 | | |
3476 | | |
3477 | | |
3478 | | mo_inputoutput_table = Table('mo_inputoutput', metadata, |
3479 | | Column('id', Integer, Sequence('mo_inputoutput_id_seq'), primary_key=True), |
3480 | | Column('mo_acquisition_outputdescription_id', Integer, ForeignKey('mo_acquisition.id')), |
3481 | | Column('mo_processing_processinginput', Integer, ForeignKey('mo_processing.id')), |
3482 | | Column('mo_processing_processingoutput_id', Integer, ForeignKey('mo_processing.id')), |
3483 | | extend_existing=False,) |
3484 | | |
3485 | | |
3486 | | |
3487 | | |
3488 | | |
3489 | | |
3490 | | |
3491 | | |
3492 | | |
3493 | | |
3494 | | |
3495 | | |
3496 | | ceda_operation_table = Table('ceda_operation', metadata, |
3497 | | Column('id', Integer, Sequence('ceda_operation_id_seq'), primary_key=True), |
3498 | | extend_existing=False,) |
3499 | | |
3500 | | |
3501 | | |
3502 | | |
3503 | | |
3504 | | |
3505 | | |
3506 | | |
3507 | | |
3508 | | |
3509 | | |
3510 | | |
3511 | | ci_responsibility_table = Table('ci_responsibility', metadata, |
3512 | | Column('id', Integer, Sequence('ci_responsibility_id_seq'), primary_key=True), |
3513 | | Column('mo_responsiblepartyinfo__ci_responsibility_id', Integer, ForeignKey('mo_responsiblepartyinfo.id')), |
3514 | | extend_existing=False,) |
3515 | | |
3516 | | |
3517 | | |
3518 | | |
3519 | | |
3520 | | |
3521 | | |
3522 | | |
3523 | | |
3524 | | |
3525 | | |
3526 | | |
3527 | | gf_associationtype_table = Table('gf_associationtype', metadata, |
3528 | | Column('id', Integer, Sequence('gf_associationtype_id_seq'), primary_key=True), |
3529 | | Column('gf_featuretype_linkbetween', Integer, ForeignKey('gf_featuretype.id', use_alter=True, name='fk_gf_featuretype_linkbetween')), |
3530 | | Column('gf_operation_dependson', Integer, ForeignKey('gf_operation.id', use_alter=True, name='fk_gf_operation_dependson')), |
3531 | | extend_existing=False,) |
3532 | | |
3533 | | |
3534 | | |
3535 | | |
3536 | | |
3537 | | |
3538 | | |
3539 | | |
3540 | | |
3541 | | |
3542 | | |
3543 | | |
3544 | | gfi_feature_table = Table('gfi_feature', metadata, |
3545 | | Column('id', Integer, Sequence('gfi_feature_id_seq'), primary_key=True), |
3546 | | Column('om_observation_featureofinterest_id', Integer, ForeignKey('om_observation.id', use_alter=True, name='fk_om_observation_featureofinterest')), |
3547 | | extend_existing=False,) |
3548 | | |
3549 | | |
3550 | | |
3551 | | |
3552 | | |
3553 | | |
3554 | | |
3555 | | |
3556 | | |
3557 | | |
3558 | | |
3559 | | |
3560 | | ceda_observationcollection_table = Table('ceda_observationcollection', metadata, |
3561 | | Column('id', Integer, Sequence('ceda_observationcollection_id_seq'), primary_key=True), |
3562 | | extend_existing=False,) |
3563 | | |
3564 | | |
3565 | | |
3566 | | |
3567 | | |
3568 | | |
3569 | | |
3570 | | |
3571 | | |
3572 | | |
3573 | | |
3574 | | |
3575 | | sc_generalderivedcrs_table = Table('sc_generalderivedcrs', metadata, |
3576 | | Column('id', Integer, Sequence('sc_generalderivedcrs_id_seq'), primary_key=True), |
3577 | | Column('sc_derivedcrs__sc_generalderivedcrs_id', Integer, ForeignKey('sc_derivedcrs.id')), |
3578 | | |