cdmlib-model/src/main/java/eu/etaxonomy/cdm/model/media/RightsTerm.java -text
cdmlib-model/src/main/java/eu/etaxonomy/cdm/model/media/package-info.java -text
cdmlib-model/src/main/java/eu/etaxonomy/cdm/model/molecular/DnaSample.java -text
-cdmlib-model/src/main/java/eu/etaxonomy/cdm/model/molecular/GenBankAccession.java -text
cdmlib-model/src/main/java/eu/etaxonomy/cdm/model/molecular/Locus.java -text
cdmlib-model/src/main/java/eu/etaxonomy/cdm/model/molecular/PhylogeneticTree.java -text
cdmlib-model/src/main/java/eu/etaxonomy/cdm/model/molecular/Sequence.java -text
\r
\r
EN_DASH("\u2013"), // https://de.wikipedia.org/wiki/Halbgeviertstrich\r
+ SPATIUM("\u202F"), //very short non-breaking space\r
+ EN_DASH_SPATIUM("\u202F\u2013\u202F"),\r
HYBRID ("\u00D7"), // hybrid sign\r
- SHARP_S("\u00DF")\r
+ SHARP_S("\u00DF"),\r
;\r
\r
private String value;\r
REVTYPE TINYINT
);
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.GATHERINGEVENT_MARKER_AUD;
-CREATE CACHED TABLE PUBLIC.GENBANKACCESSION(
- ID INTEGER NOT NULL,
- CREATED TIMESTAMP,
- UUID VARCHAR(36),
- UPDATED TIMESTAMP,
- ACCESSIONNUMBER VARCHAR(255),
- URI CLOB,
- CREATEDBY_ID INTEGER,
- UPDATEDBY_ID INTEGER
-);
--- 0 +/- SELECT COUNT(*) FROM PUBLIC.GENBANKACCESSION;
-CREATE CACHED TABLE PUBLIC.GENBANKACCESSION_AUD(
- ID INTEGER NOT NULL,
- REV INTEGER NOT NULL,
- REVTYPE TINYINT,
- CREATED TIMESTAMP,
- UUID VARCHAR(36),
- UPDATED TIMESTAMP,
- ACCESSIONNUMBER VARCHAR(255),
- URI CLOB,
- CREATEDBY_ID INTEGER,
- UPDATEDBY_ID INTEGER
-);
--- 0 +/- SELECT COUNT(*) FROM PUBLIC.GENBANKACCESSION_AUD;
CREATE CACHED TABLE PUBLIC.GRANTEDAUTHORITYIMPL(
ID INTEGER NOT NULL,
CREATED TIMESTAMP,
SERIESPART VARCHAR(255),
TITLE CLOB,
REFTYPE INTEGER,
- URI CLOB, VARCHAR(255),
+ URI CLOB,
VOLUME VARCHAR(255),
CREATEDBY_ID INTEGER,
UPDATEDBY_ID INTEGER,
PROTECTEDTITLECACHE BOOLEAN NOT NULL,
TITLECACHE VARCHAR(255),
BARCODE BOOLEAN NOT NULL,
+ GENBANKACCESSIONNUMBER VARCHAR(20),
+ GENBANKURI CLOB,
CITATIONMICROREFERENCE VARCHAR(255),
DATESEQUENCED TIMESTAMP,
LENGTH INTEGER,
PROTECTEDTITLECACHE BOOLEAN,
TITLECACHE VARCHAR(255),
BARCODE BOOLEAN,
+ GENBANKACCESSIONNUMBER VARCHAR(20),
+ GENBANKURI CLOB,
CITATIONMICROREFERENCE VARCHAR(255),
DATESEQUENCED TIMESTAMP,
LENGTH INTEGER,
REVTYPE TINYINT
);
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.SEQUENCE_EXTENSION_AUD;
-CREATE CACHED TABLE PUBLIC.SEQUENCE_GENBANKACCESSION(
- SEQUENCE_ID INTEGER NOT NULL,
- GENBANKACCESSION_ID INTEGER NOT NULL
-);
--- 0 +/- SELECT COUNT(*) FROM PUBLIC.SEQUENCE_GENBANKACCESSION;
-CREATE CACHED TABLE PUBLIC.SEQUENCE_GENBANKACCESSION_AUD(
- REV INTEGER NOT NULL,
- SEQUENCE_ID INTEGER NOT NULL,
- GENBANKACCESSION_ID INTEGER NOT NULL,
- REVTYPE TINYINT
-);
--- 0 +/- SELECT COUNT(*) FROM PUBLIC.SEQUENCE_GENBANKACCESSION_AUD;
CREATE CACHED TABLE PUBLIC.SEQUENCE_MARKER(
SEQUENCE_ID INTEGER NOT NULL,
MARKERS_ID INTEGER NOT NULL
ALTER TABLE PUBLIC.SEQUENCE_MEDIA_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_2CE PRIMARY KEY(REV, SEQUENCE_ID, CHROMATOGRAMS_ID);
ALTER TABLE PUBLIC.MEDIAREPRESENTATION ADD CONSTRAINT PUBLIC.CONSTRAINT_BE0 PRIMARY KEY(ID);
ALTER TABLE PUBLIC.DEFINEDTERMBASE_MEASUREMENTUNIT_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_BA2 PRIMARY KEY(REV, DEFINEDTERMBASE_ID, RECOMMENDEDMEASUREMENTUNITS_ID);
-ALTER TABLE PUBLIC.GENBANKACCESSION_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_F37 PRIMARY KEY(ID, REV);
ALTER TABLE PUBLIC.LANGUAGESTRING_MARKER_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_F36 PRIMARY KEY(REV, LANGUAGESTRING_ID, MARKERS_ID);
ALTER TABLE PUBLIC.RIGHTS_ANNOTATION_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_301 PRIMARY KEY(REV, RIGHTS_ID, ANNOTATIONS_ID);
ALTER TABLE PUBLIC.REFERENCE_RIGHTS_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_F43 PRIMARY KEY(REV, REFERENCE_ID, RIGHTS_ID);
ALTER TABLE PUBLIC.SPECIMENOROBSERVATIONBASE_MEDIA_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_D0 PRIMARY KEY(REV, SPECIMENOROBSERVATIONBASE_ID, MEDIA_ID);
ALTER TABLE PUBLIC.SEQUENCE_ORIGINALSOURCEBASE ADD CONSTRAINT PUBLIC.CONSTRAINT_726 PRIMARY KEY(SEQUENCE_ID, SOURCES_ID);
ALTER TABLE PUBLIC.STATEDATA_LANGUAGESTRING_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_D63 PRIMARY KEY(REV, STATEDATA_ID, MODIFYINGTEXT_ID, MODIFYINGTEXT_MAPKEY_ID);
-ALTER TABLE PUBLIC.SEQUENCE_GENBANKACCESSION ADD CONSTRAINT PUBLIC.CONSTRAINT_C4F PRIMARY KEY(SEQUENCE_ID, GENBANKACCESSION_ID);
ALTER TABLE PUBLIC.TERMVOCABULARY_ANNOTATION ADD CONSTRAINT PUBLIC.CONSTRAINT_C4D PRIMARY KEY(TERMVOCABULARY_ID, ANNOTATIONS_ID);
ALTER TABLE PUBLIC.SEQUENCE_EXTENSION_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_550F PRIMARY KEY(REV, SEQUENCE_ID, EXTENSIONS_ID);
ALTER TABLE PUBLIC.FEATURETREE ADD CONSTRAINT PUBLIC.CONSTRAINT_69EA PRIMARY KEY(ID);
ALTER TABLE PUBLIC.GATHERINGEVENT ADD CONSTRAINT PUBLIC.CONSTRAINT_2A PRIMARY KEY(ID);
ALTER TABLE PUBLIC.AGENTBASE_MEDIA ADD CONSTRAINT PUBLIC.CONSTRAINT_28 PRIMARY KEY(AGENTBASE_ID, MEDIA_ID);
ALTER TABLE PUBLIC.STATEDATA ADD CONSTRAINT PUBLIC.CONSTRAINT_29 PRIMARY KEY(ID);
-ALTER TABLE PUBLIC.GENBANKACCESSION ADD CONSTRAINT PUBLIC.CONSTRAINT_22 PRIMARY KEY(ID);
ALTER TABLE PUBLIC.TERMVOCABULARY_ANNOTATION_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_AF1 PRIMARY KEY(REV, TERMVOCABULARY_ID, ANNOTATIONS_ID);
ALTER TABLE PUBLIC.HOMOTYPICALGROUP_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_20 PRIMARY KEY(ID, REV);
ALTER TABLE PUBLIC.INSTITUTIONALMEMBERSHIP ADD CONSTRAINT PUBLIC.CONSTRAINT_21 PRIMARY KEY(ID);
ALTER TABLE PUBLIC.REFERENCE_MARKER ADD CONSTRAINT PUBLIC.CONSTRAINT_81E PRIMARY KEY(REFERENCE_ID, MARKERS_ID);
ALTER TABLE PUBLIC.DESCRIPTIONELEMENTBASE_ORIGINALSOURCEBASE_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_7B PRIMARY KEY(REV, DESCRIPTIONELEMENTBASE_ID, SOURCES_ID);
ALTER TABLE PUBLIC.SEQUENCE_REFERENCE ADD CONSTRAINT PUBLIC.CONSTRAINT_762 PRIMARY KEY(SEQUENCE_ID, CITATIONS_ID);
-ALTER TABLE PUBLIC.SEQUENCE_GENBANKACCESSION_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_C3C PRIMARY KEY(REV, SEQUENCE_ID, GENBANKACCESSION_ID);
ALTER TABLE PUBLIC.KEYSTATEMENT ADD CONSTRAINT PUBLIC.CONSTRAINT_7A PRIMARY KEY(ID);
ALTER TABLE PUBLIC.REPRESENTATION_MARKER_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_91 PRIMARY KEY(REV, REPRESENTATION_ID, MARKERS_ID);
ALTER TABLE PUBLIC.MEDIAKEY_SCOPE_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_40F PRIMARY KEY(REV, MEDIA_ID, SCOPERESTRICTIONS_ID);
ALTER TABLE PUBLIC.DESCRIPTIONBASE_ANNOTATION ADD CONSTRAINT PUBLIC.CONSTRAINT_63F UNIQUE(ANNOTATIONS_ID);
ALTER TABLE PUBLIC.DESCRIPTIONELEMENTBASE_MARKER ADD CONSTRAINT PUBLIC.CONSTRAINT_AE96 UNIQUE(MARKERS_ID);
ALTER TABLE PUBLIC.CLASSIFICATION_TAXONNODE ADD CONSTRAINT PUBLIC.CONSTRAINT_D7D UNIQUE(ROOTNODES_ID);
-ALTER TABLE PUBLIC.GENBANKACCESSION ADD CONSTRAINT PUBLIC.CONSTRAINT_224 UNIQUE(UUID);
ALTER TABLE PUBLIC.HYBRIDRELATIONSHIP_ANNOTATION ADD CONSTRAINT PUBLIC.CONSTRAINT_2820 UNIQUE(ANNOTATIONS_ID);
ALTER TABLE PUBLIC.ANNOTATION_ANNOTATION ADD CONSTRAINT PUBLIC.CONSTRAINT_AE UNIQUE(ANNOTATIONS_ID);
ALTER TABLE PUBLIC.SEQUENCE_REFERENCE ADD CONSTRAINT PUBLIC.CONSTRAINT_7620 UNIQUE(CITATIONS_ID);
ALTER TABLE PUBLIC.TERMVOCABULARY_EXTENSION ADD CONSTRAINT PUBLIC.CONSTRAINT_C3CBC UNIQUE(EXTENSIONS_ID);
ALTER TABLE PUBLIC.STATISTICALMEASUREMENTVALUE ADD CONSTRAINT PUBLIC.CONSTRAINT_35B UNIQUE(UUID);
ALTER TABLE PUBLIC.SPECIMENOROBSERVATIONBASE_SEQUENCE ADD CONSTRAINT PUBLIC.CONSTRAINT_BE634 UNIQUE(SEQUENCES_ID);
-ALTER TABLE PUBLIC.SEQUENCE_GENBANKACCESSION ADD CONSTRAINT PUBLIC.CONSTRAINT_C4F1 UNIQUE(GENBANKACCESSION_ID);
ALTER TABLE PUBLIC.TAXONBASE_CREDIT ADD CONSTRAINT PUBLIC.CONSTRAINT_FF44 UNIQUE(CREDITS_ID);
ALTER TABLE PUBLIC.COLLECTION_EXTENSION ADD CONSTRAINT PUBLIC.CONSTRAINT_BBE UNIQUE(EXTENSIONS_ID);
ALTER TABLE PUBLIC.TAXONNAMEBASE ADD CONSTRAINT PUBLIC.CONSTRAINT_919B UNIQUE(UUID);
ALTER TABLE PUBLIC.LANGUAGESTRING_ANNOTATION ADD CONSTRAINT PUBLIC.FK8400DFA51E403E0B FOREIGN KEY(ANNOTATIONS_ID) REFERENCES PUBLIC.ANNOTATION(ID) NOCHECK;
ALTER TABLE PUBLIC.DEFINEDTERMBASE_REPRESENTATION ADD CONSTRAINT PUBLIC.FKAAC8AFE6B31C4747 FOREIGN KEY(REPRESENTATIONS_ID) REFERENCES PUBLIC.REPRESENTATION(ID) NOCHECK;
ALTER TABLE PUBLIC.KEYSTATEMENT_LANGUAGESTRING ADD CONSTRAINT PUBLIC.FK70BB5FD8DA0C376A FOREIGN KEY(LABEL_MAPKEY_ID) REFERENCES PUBLIC.DEFINEDTERMBASE(ID) NOCHECK;
-ALTER TABLE PUBLIC.SEQUENCE_GENBANKACCESSION ADD CONSTRAINT PUBLIC.FK8F698096D57FFDD5 FOREIGN KEY(SEQUENCE_ID) REFERENCES PUBLIC.SEQUENCE(ID) NOCHECK;
ALTER TABLE PUBLIC.AGENTBASE_RIGHTS_AUD ADD CONSTRAINT PUBLIC.FK4FDFF8D134869AAE FOREIGN KEY(REV) REFERENCES PUBLIC.AUDITEVENT(REVISIONNUMBER) NOCHECK;
ALTER TABLE PUBLIC.MEDIAKEY_SCOPE ADD CONSTRAINT PUBLIC.FKBFFEE8F0546985E4 FOREIGN KEY(SCOPERESTRICTIONS_ID) REFERENCES PUBLIC.DEFINEDTERMBASE(ID) NOCHECK;
ALTER TABLE PUBLIC.TERMVOCABULARY_REPRESENTATION ADD CONSTRAINT PUBLIC.FKA408B63A258E060 FOREIGN KEY(TERMVOCABULARY_ID) REFERENCES PUBLIC.TERMVOCABULARY(ID) NOCHECK;
ALTER TABLE PUBLIC.SEQUENCE_REFERENCE ADD CONSTRAINT PUBLIC.FK6944904DD57FFDD5 FOREIGN KEY(SEQUENCE_ID) REFERENCES PUBLIC.SEQUENCE(ID) NOCHECK;
ALTER TABLE PUBLIC.PERMISSIONGROUP ADD CONSTRAINT PUBLIC.FK629941D04FF2DB2C FOREIGN KEY(CREATEDBY_ID) REFERENCES PUBLIC.USERACCOUNT(ID) NOCHECK;
ALTER TABLE PUBLIC.SPECIMENOROBSERVATIONBASE_EXTENSION_AUD ADD CONSTRAINT PUBLIC.FK7AE0176334869AAE FOREIGN KEY(REV) REFERENCES PUBLIC.AUDITEVENT(REVISIONNUMBER) NOCHECK;
-ALTER TABLE PUBLIC.GENBANKACCESSION ADD CONSTRAINT PUBLIC.FK86C1DBF8BC5DA539 FOREIGN KEY(UPDATEDBY_ID) REFERENCES PUBLIC.USERACCOUNT(ID) NOCHECK;
ALTER TABLE PUBLIC.TAXONBASE_RIGHTS ADD CONSTRAINT PUBLIC.FK65CF621BC13F7B21 FOREIGN KEY(RIGHTS_ID) REFERENCES PUBLIC.RIGHTS(ID) NOCHECK;
ALTER TABLE PUBLIC.RIGHTS ADD CONSTRAINT PUBLIC.FK91E56DF7E8D36B00 FOREIGN KEY(LANGUAGE_ID) REFERENCES PUBLIC.DEFINEDTERMBASE(ID) NOCHECK;
ALTER TABLE PUBLIC.KEYSTATEMENT ADD CONSTRAINT PUBLIC.FK7125B9F04FF2DB2C FOREIGN KEY(CREATEDBY_ID) REFERENCES PUBLIC.USERACCOUNT(ID) NOCHECK;
ALTER TABLE PUBLIC.DESCRIPTIONELEMENTBASE_STATEDATA ADD CONSTRAINT PUBLIC.FK592D6F6D15153604 FOREIGN KEY(STATES_ID) REFERENCES PUBLIC.STATEDATA(ID) NOCHECK;
ALTER TABLE PUBLIC.INDIVIDUALASSOCIATION_LANGUAGESTRING ADD CONSTRAINT PUBLIC.FKB5C75EC02BEBA58D FOREIGN KEY(DESCRIPTION_ID) REFERENCES PUBLIC.LANGUAGESTRING(ID) NOCHECK;
ALTER TABLE PUBLIC.CLASSIFICATION ADD CONSTRAINT PUBLIC.FKDB110006BC5DA539 FOREIGN KEY(UPDATEDBY_ID) REFERENCES PUBLIC.USERACCOUNT(ID) NOCHECK;
-ALTER TABLE PUBLIC.SEQUENCE_GENBANKACCESSION ADD CONSTRAINT PUBLIC.FK8F69809615C4EF35 FOREIGN KEY(GENBANKACCESSION_ID) REFERENCES PUBLIC.GENBANKACCESSION(ID) NOCHECK;
ALTER TABLE PUBLIC.DEFINEDTERMBASE_CREDIT ADD CONSTRAINT PUBLIC.FK78FF2B1232D1B9F FOREIGN KEY(CREDITS_ID) REFERENCES PUBLIC.CREDIT(ID) NOCHECK;
ALTER TABLE PUBLIC.HOMOTYPICALGROUP_MARKER ADD CONSTRAINT PUBLIC.FK97D36661BFEAE500 FOREIGN KEY(HOMOTYPICALGROUP_ID) REFERENCES PUBLIC.HOMOTYPICALGROUP(ID) NOCHECK;
ALTER TABLE PUBLIC.MEDIAKEY_TAXON ADD CONSTRAINT PUBLIC.FKC00C3966DE9A3E39 FOREIGN KEY(TAXON_ID) REFERENCES PUBLIC.TAXONBASE(ID) NOCHECK;
ALTER TABLE PUBLIC.TAXONBASE_MARKER_AUD ADD CONSTRAINT PUBLIC.FKE11D334F34869AAE FOREIGN KEY(REV) REFERENCES PUBLIC.AUDITEVENT(REVISIONNUMBER) NOCHECK;
ALTER TABLE PUBLIC.REFERENCE_ORIGINALSOURCEBASE_AUD ADD CONSTRAINT PUBLIC.FKC025854234869AAE FOREIGN KEY(REV) REFERENCES PUBLIC.AUDITEVENT(REVISIONNUMBER) NOCHECK;
ALTER TABLE PUBLIC.DESCRIPTIONELEMENTBASE_ANNOTATION_AUD ADD CONSTRAINT PUBLIC.FK2BC1DD2E34869AAE FOREIGN KEY(REV) REFERENCES PUBLIC.AUDITEVENT(REVISIONNUMBER) NOCHECK;
-ALTER TABLE PUBLIC.GENBANKACCESSION_AUD ADD CONSTRAINT PUBLIC.FK5A2F4DC934869AAE FOREIGN KEY(REV) REFERENCES PUBLIC.AUDITEVENT(REVISIONNUMBER) NOCHECK;
ALTER TABLE PUBLIC.POLYTOMOUSKEY_ANNOTATION ADD CONSTRAINT PUBLIC.FK278CF8B61E403E0B FOREIGN KEY(ANNOTATIONS_ID) REFERENCES PUBLIC.ANNOTATION(ID) NOCHECK;
ALTER TABLE PUBLIC.TERMVOCABULARY_REPRESENTATION_AUD ADD CONSTRAINT PUBLIC.FK681B370B34869AAE FOREIGN KEY(REV) REFERENCES PUBLIC.AUDITEVENT(REVISIONNUMBER) NOCHECK;
ALTER TABLE PUBLIC.USERACCOUNT_AUD ADD CONSTRAINT PUBLIC.FK6A57909334869AAE FOREIGN KEY(REV) REFERENCES PUBLIC.AUDITEVENT(REVISIONNUMBER) NOCHECK;
ALTER TABLE PUBLIC.AGENTBASE_AGENTBASE_AUD ADD CONSTRAINT PUBLIC.FKA8A87CFE34869AAE FOREIGN KEY(REV) REFERENCES PUBLIC.AUDITEVENT(REVISIONNUMBER) NOCHECK;
ALTER TABLE PUBLIC.DESCRIPTIONBASE_SPECIMENOROBSERVATIONBASE_AUD ADD CONSTRAINT PUBLIC.FKF1B33B5134869AAE FOREIGN KEY(REV) REFERENCES PUBLIC.AUDITEVENT(REVISIONNUMBER) NOCHECK;
ALTER TABLE PUBLIC.TERMVOCABULARY_ORIGINALSOURCEBASE ADD CONSTRAINT PUBLIC.FK8F2D512A258E060 FOREIGN KEY(TERMVOCABULARY_ID) REFERENCES PUBLIC.TERMVOCABULARY(ID) NOCHECK;
-ALTER TABLE PUBLIC.GENBANKACCESSION ADD CONSTRAINT PUBLIC.FK86C1DBF84FF2DB2C FOREIGN KEY(CREATEDBY_ID) REFERENCES PUBLIC.USERACCOUNT(ID) NOCHECK;
ALTER TABLE PUBLIC.DESCRIPTIONBASE ADD CONSTRAINT PUBLIC.FKFF4D58CDDE9A3E39 FOREIGN KEY(TAXON_ID) REFERENCES PUBLIC.TAXONBASE(ID) NOCHECK;
ALTER TABLE PUBLIC.NOMENCLATURALSTATUS_MARKER_AUD ADD CONSTRAINT PUBLIC.FK8619495F34869AAE FOREIGN KEY(REV) REFERENCES PUBLIC.AUDITEVENT(REVISIONNUMBER) NOCHECK;
-ALTER TABLE PUBLIC.SEQUENCE_GENBANKACCESSION_AUD ADD CONSTRAINT PUBLIC.FKC717736734869AAE FOREIGN KEY(REV) REFERENCES PUBLIC.AUDITEVENT(REVISIONNUMBER) NOCHECK;
ALTER TABLE PUBLIC.NAMERELATIONSHIP_MARKER ADD CONSTRAINT PUBLIC.FKE3E463967B4CB560 FOREIGN KEY(NAMERELATIONSHIP_ID) REFERENCES PUBLIC.NAMERELATIONSHIP(ID) NOCHECK;
ALTER TABLE PUBLIC.SPECIMENOROBSERVATIONBASE_RIGHTS_AUD ADD CONSTRAINT PUBLIC.FK4168503534869AAE FOREIGN KEY(REV) REFERENCES PUBLIC.AUDITEVENT(REVISIONNUMBER) NOCHECK;
ALTER TABLE PUBLIC.FEATURENODE_DEFINEDTERMBASE_INAPPLICABLEIF_AUD ADD CONSTRAINT PUBLIC.FKB8D7025234869AAE FOREIGN KEY(REV) REFERENCES PUBLIC.AUDITEVENT(REVISIONNUMBER) NOCHECK;
GATHERINGEVENT_DEFINEDTERMBASE_AUD*,
GATHERINGEVENT_MARKER*,
GATHERINGEVENT_MARKER_AUD*,
- GENBANKACCESSION*,
- GENBANKACCESSION_AUD*,
GRANTEDAUTHORITYIMPL*,
HIBERNATE_SEQUENCES*,
HOMOTYPICALGROUP*,
SEQUENCE_AUD*,
SEQUENCE_EXTENSION*,
SEQUENCE_EXTENSION_AUD*,
- SEQUENCE_GENBANKACCESSION*,
- SEQUENCE_GENBANKACCESSION_AUD*,
SEQUENCE_MARKER*,
SEQUENCE_MARKER_AUD*,
SEQUENCE_MEDIA*,
UPDATED CDATA #IMPLIED
TERMTYPE CDATA #IMPLIED
URI CDATA #IMPLIED
+ RANKCLASS CDATA #IMPLIED
ORDERINDEX CDATA #IMPLIED
IDINVOCABULARY CDATA #IMPLIED
ISO639_1 CDATA #IMPLIED
UPDATED CDATA #IMPLIED
TERMTYPE CDATA #IMPLIED
URI CDATA #IMPLIED
+ RANKCLASS CDATA #IMPLIED
CREATEDBY_ID CDATA #IMPLIED
UPDATEDBY_ID CDATA #IMPLIED
KINDOF_ID CDATA #IMPLIED
ABSOLUTEELEVATION CDATA #IMPLIED
ABSOLUTEELEVATIONERROR CDATA #IMPLIED
COLLECTINGMETHOD CDATA #IMPLIED
+ COLLECTINGMETHODMAX CDATA #IMPLIED
DISTANCETOGROUND CDATA #IMPLIED
+ DISTANCETOGROUNDMAX CDATA #IMPLIED
+ DISTANCETOGROUNDTEXT CDATA #IMPLIED
DISTANCETOWATERSURFACE CDATA #IMPLIED
+ DISTANCETOWATERSURFACEMAX CDATA #IMPLIED
+ DISTANCETOWATERSURFACETEXT CDATA #IMPLIED
EXACTLOCATION_ERRORRADIUS CDATA #IMPLIED
EXACTLOCATION_LATITUDE CDATA #IMPLIED
EXACTLOCATION_LONGITUDE CDATA #IMPLIED
ABSOLUTEELEVATIONERROR CDATA #IMPLIED
COLLECTINGMETHOD CDATA #IMPLIED
DISTANCETOGROUND CDATA #IMPLIED
+ DISTANCETOGROUNDMAX CDATA #IMPLIED
+ DISTANCETOGROUNDTEXT CDATA #IMPLIED
DISTANCETOWATERSURFACE CDATA #IMPLIED
+ DISTANCETOWATERSURFACEMAX CDATA #IMPLIED
+ DISTANCETOWATERSURFACETEXT CDATA #IMPLIED
EXACTLOCATION_ERRORRADIUS CDATA #IMPLIED
EXACTLOCATION_LATITUDE CDATA #IMPLIED
EXACTLOCATION_LONGITUDE CDATA #IMPLIED
REVTYPE CDATA #IMPLIED
>
-<!ELEMENT GENBANKACCESSION EMPTY>
-<!ATTLIST GENBANKACCESSION
- ID CDATA #REQUIRED
- CREATED CDATA #IMPLIED
- UUID CDATA #IMPLIED
- UPDATED CDATA #IMPLIED
- ACCESSIONNUMBER CDATA #IMPLIED
- URI CDATA #IMPLIED
- CREATEDBY_ID CDATA #IMPLIED
- UPDATEDBY_ID CDATA #IMPLIED
->
-
-<!ELEMENT GENBANKACCESSION_AUD EMPTY>
-<!ATTLIST GENBANKACCESSION_AUD
- ID CDATA #REQUIRED
- REV CDATA #REQUIRED
- REVTYPE CDATA #IMPLIED
- CREATED CDATA #IMPLIED
- UUID CDATA #IMPLIED
- UPDATED CDATA #IMPLIED
- ACCESSIONNUMBER CDATA #IMPLIED
- URI CDATA #IMPLIED
- CREATEDBY_ID CDATA #IMPLIED
- UPDATEDBY_ID CDATA #IMPLIED
->
-
<!ELEMENT GRANTEDAUTHORITYIMPL EMPTY>
<!ATTLIST GRANTEDAUTHORITYIMPL
ID CDATA #REQUIRED
PROTECTEDTITLECACHE CDATA #IMPLIED
TITLECACHE CDATA #IMPLIED
BARCODE CDATA #IMPLIED
+ GENBANKACCESSIONNUMBER CDATA #IMPLIED
+ GENBANKURI CDATA #IMPLIED
CITATIONMICROREFERENCE CDATA #IMPLIED
DATESEQUENCED CDATA #IMPLIED
LENGTH CDATA #IMPLIED
PROTECTEDTITLECACHE CDATA #IMPLIED
TITLECACHE CDATA #IMPLIED
BARCODE CDATA #IMPLIED
+ GENBANKACCESSIONNUMBER CDATA #IMPLIED
+ GENBANKURI CDATA #IMPLIED
CITATIONMICROREFERENCE CDATA #IMPLIED
DATESEQUENCED CDATA #IMPLIED
LENGTH CDATA #IMPLIED
REVTYPE CDATA #IMPLIED
>
-<!ELEMENT SEQUENCE_GENBANKACCESSION EMPTY>
-<!ATTLIST SEQUENCE_GENBANKACCESSION
- SEQUENCE_ID CDATA #REQUIRED
- GENBANKACCESSION_ID CDATA #REQUIRED
->
-
-<!ELEMENT SEQUENCE_GENBANKACCESSION_AUD EMPTY>
-<!ATTLIST SEQUENCE_GENBANKACCESSION_AUD
- REV CDATA #REQUIRED
- SEQUENCE_ID CDATA #REQUIRED
- GENBANKACCESSION_ID CDATA #REQUIRED
- REVTYPE CDATA #IMPLIED
->
-
<!ELEMENT SEQUENCE_MARKER EMPTY>
<!ATTLIST SEQUENCE_MARKER
SEQUENCE_ID CDATA #REQUIRED
<xs:element name="DnaSample" type="molecular:DnaSample"/>
- <xs:element name="GenBankAccession" type="molecular:GenBankAccession"/>
-
<xs:element name="Locus" type="molecular:Locus"/>
<xs:element name="PhylogeneticTree" type="molecular:PhylogeneticTree"/>
</xs:sequence>
</xs:complexType>
</xs:element>
- <xs:element name="GenBankAccessions" minOccurs="0">
- <xs:complexType>
- <xs:sequence>
- <xs:element ref="molecular:GenBankAccession" minOccurs="0" maxOccurs="unbounded"/>
- </xs:sequence>
- </xs:complexType>
- </xs:element>
<xs:element name="Chromatograms" minOccurs="0">
<xs:complexType>
<xs:sequence>
</xs:complexContent>
</xs:complexType>
- <xs:complexType name="GenBankAccession">
- <xs:complexContent>
- <xs:extension base="common:VersionableEntity">
- <xs:sequence>
- <xs:element name="AccessionNumber" type="xs:string" minOccurs="0"/>
- <xs:element name="URI" type="xs:string" minOccurs="0"/>
- </xs:sequence>
- </xs:extension>
- </xs:complexContent>
- </xs:complexType>
-
<xs:complexType name="PhylogeneticTree">
<xs:complexContent>
<xs:extension base="media:ReferencedMedia">
// "GatheringEvent", \r
// "GatheringEvent_Annotation", \r
// "GatheringEvent_Marker", \r
-// "GenBankAccession", \r
"HomotypicalGroup", \r
// "HomotypicalGroup_Annotation", \r
// "HomotypicalGroup_Marker", \r
// "Sequence",\r
// "Sequence_Annotation", \r
// "Sequence_Extension", \r
-// "Sequence_GenBankAccession", \r
// "Sequence_Marker", \r
// "Sequence_Media", \r
// "Sequence_OriginalSource", \r
REVTYPE TINYINT
);
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.GATHERINGEVENT_MARKER_AUD;
-CREATE CACHED TABLE PUBLIC.GENBANKACCESSION(
- ID INTEGER NOT NULL,
- CREATED TIMESTAMP,
- UUID VARCHAR(36),
- UPDATED TIMESTAMP,
- ACCESSIONNUMBER VARCHAR(255),
- URI CLOB,
- CREATEDBY_ID INTEGER,
- UPDATEDBY_ID INTEGER
-);
--- 0 +/- SELECT COUNT(*) FROM PUBLIC.GENBANKACCESSION;
-CREATE CACHED TABLE PUBLIC.GENBANKACCESSION_AUD(
- ID INTEGER NOT NULL,
- REV INTEGER NOT NULL,
- REVTYPE TINYINT,
- CREATED TIMESTAMP,
- UUID VARCHAR(36),
- UPDATED TIMESTAMP,
- ACCESSIONNUMBER VARCHAR(255),
- URI CLOB,
- CREATEDBY_ID INTEGER,
- UPDATEDBY_ID INTEGER
-);
--- 0 +/- SELECT COUNT(*) FROM PUBLIC.GENBANKACCESSION_AUD;
CREATE CACHED TABLE PUBLIC.GRANTEDAUTHORITYIMPL(
ID INTEGER NOT NULL,
CREATED TIMESTAMP,
SERIESPART VARCHAR(255),
TITLE CLOB,
REFTYPE INTEGER,
- URI CLOB, VARCHAR(255),
+ URI CLOB,
VOLUME VARCHAR(255),
CREATEDBY_ID INTEGER,
UPDATEDBY_ID INTEGER,
PROTECTEDTITLECACHE BOOLEAN NOT NULL,
TITLECACHE VARCHAR(255),
BARCODE BOOLEAN NOT NULL,
+ GENBANKACCESSIONNUMBER VARCHAR(20),
+ GENBANKURI CLOB,
CITATIONMICROREFERENCE VARCHAR(255),
DATESEQUENCED TIMESTAMP,
LENGTH INTEGER,
PROTECTEDTITLECACHE BOOLEAN,
TITLECACHE VARCHAR(255),
BARCODE BOOLEAN,
+ GENBANKACCESSIONNUMBER VARCHAR(20),
+ GENBANKURI CLOB,
CITATIONMICROREFERENCE VARCHAR(255),
DATESEQUENCED TIMESTAMP,
LENGTH INTEGER,
REVTYPE TINYINT
);
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.SEQUENCE_EXTENSION_AUD;
-CREATE CACHED TABLE PUBLIC.SEQUENCE_GENBANKACCESSION(
- SEQUENCE_ID INTEGER NOT NULL,
- GENBANKACCESSION_ID INTEGER NOT NULL
-);
--- 0 +/- SELECT COUNT(*) FROM PUBLIC.SEQUENCE_GENBANKACCESSION;
-CREATE CACHED TABLE PUBLIC.SEQUENCE_GENBANKACCESSION_AUD(
- REV INTEGER NOT NULL,
- SEQUENCE_ID INTEGER NOT NULL,
- GENBANKACCESSION_ID INTEGER NOT NULL,
- REVTYPE TINYINT
-);
--- 0 +/- SELECT COUNT(*) FROM PUBLIC.SEQUENCE_GENBANKACCESSION_AUD;
CREATE CACHED TABLE PUBLIC.SEQUENCE_MARKER(
SEQUENCE_ID INTEGER NOT NULL,
MARKERS_ID INTEGER NOT NULL
ALTER TABLE PUBLIC.SEQUENCE_MEDIA_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_2CE PRIMARY KEY(REV, SEQUENCE_ID, CHROMATOGRAMS_ID);
ALTER TABLE PUBLIC.MEDIAREPRESENTATION ADD CONSTRAINT PUBLIC.CONSTRAINT_BE0 PRIMARY KEY(ID);
ALTER TABLE PUBLIC.DEFINEDTERMBASE_MEASUREMENTUNIT_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_BA2 PRIMARY KEY(REV, DEFINEDTERMBASE_ID, RECOMMENDEDMEASUREMENTUNITS_ID);
-ALTER TABLE PUBLIC.GENBANKACCESSION_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_F37 PRIMARY KEY(ID, REV);
ALTER TABLE PUBLIC.LANGUAGESTRING_MARKER_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_F36 PRIMARY KEY(REV, LANGUAGESTRING_ID, MARKERS_ID);
ALTER TABLE PUBLIC.RIGHTS_ANNOTATION_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_301 PRIMARY KEY(REV, RIGHTS_ID, ANNOTATIONS_ID);
ALTER TABLE PUBLIC.REFERENCE_RIGHTS_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_F43 PRIMARY KEY(REV, REFERENCE_ID, RIGHTS_ID);
ALTER TABLE PUBLIC.SPECIMENOROBSERVATIONBASE_MEDIA_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_D0 PRIMARY KEY(REV, SPECIMENOROBSERVATIONBASE_ID, MEDIA_ID);
ALTER TABLE PUBLIC.SEQUENCE_ORIGINALSOURCEBASE ADD CONSTRAINT PUBLIC.CONSTRAINT_726 PRIMARY KEY(SEQUENCE_ID, SOURCES_ID);
ALTER TABLE PUBLIC.STATEDATA_LANGUAGESTRING_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_D63 PRIMARY KEY(REV, STATEDATA_ID, MODIFYINGTEXT_ID, MODIFYINGTEXT_MAPKEY_ID);
-ALTER TABLE PUBLIC.SEQUENCE_GENBANKACCESSION ADD CONSTRAINT PUBLIC.CONSTRAINT_C4F PRIMARY KEY(SEQUENCE_ID, GENBANKACCESSION_ID);
ALTER TABLE PUBLIC.TERMVOCABULARY_ANNOTATION ADD CONSTRAINT PUBLIC.CONSTRAINT_C4D PRIMARY KEY(TERMVOCABULARY_ID, ANNOTATIONS_ID);
ALTER TABLE PUBLIC.SEQUENCE_EXTENSION_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_550F PRIMARY KEY(REV, SEQUENCE_ID, EXTENSIONS_ID);
ALTER TABLE PUBLIC.FEATURETREE ADD CONSTRAINT PUBLIC.CONSTRAINT_69EA PRIMARY KEY(ID);
ALTER TABLE PUBLIC.GATHERINGEVENT ADD CONSTRAINT PUBLIC.CONSTRAINT_2A PRIMARY KEY(ID);
ALTER TABLE PUBLIC.AGENTBASE_MEDIA ADD CONSTRAINT PUBLIC.CONSTRAINT_28 PRIMARY KEY(AGENTBASE_ID, MEDIA_ID);
ALTER TABLE PUBLIC.STATEDATA ADD CONSTRAINT PUBLIC.CONSTRAINT_29 PRIMARY KEY(ID);
-ALTER TABLE PUBLIC.GENBANKACCESSION ADD CONSTRAINT PUBLIC.CONSTRAINT_22 PRIMARY KEY(ID);
ALTER TABLE PUBLIC.TERMVOCABULARY_ANNOTATION_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_AF1 PRIMARY KEY(REV, TERMVOCABULARY_ID, ANNOTATIONS_ID);
ALTER TABLE PUBLIC.HOMOTYPICALGROUP_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_20 PRIMARY KEY(ID, REV);
ALTER TABLE PUBLIC.INSTITUTIONALMEMBERSHIP ADD CONSTRAINT PUBLIC.CONSTRAINT_21 PRIMARY KEY(ID);
ALTER TABLE PUBLIC.REFERENCE_MARKER ADD CONSTRAINT PUBLIC.CONSTRAINT_81E PRIMARY KEY(REFERENCE_ID, MARKERS_ID);
ALTER TABLE PUBLIC.DESCRIPTIONELEMENTBASE_ORIGINALSOURCEBASE_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_7B PRIMARY KEY(REV, DESCRIPTIONELEMENTBASE_ID, SOURCES_ID);
ALTER TABLE PUBLIC.SEQUENCE_REFERENCE ADD CONSTRAINT PUBLIC.CONSTRAINT_762 PRIMARY KEY(SEQUENCE_ID, CITATIONS_ID);
-ALTER TABLE PUBLIC.SEQUENCE_GENBANKACCESSION_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_C3C PRIMARY KEY(REV, SEQUENCE_ID, GENBANKACCESSION_ID);
ALTER TABLE PUBLIC.KEYSTATEMENT ADD CONSTRAINT PUBLIC.CONSTRAINT_7A PRIMARY KEY(ID);
ALTER TABLE PUBLIC.REPRESENTATION_MARKER_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_91 PRIMARY KEY(REV, REPRESENTATION_ID, MARKERS_ID);
ALTER TABLE PUBLIC.MEDIAKEY_SCOPE_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_40F PRIMARY KEY(REV, MEDIA_ID, SCOPERESTRICTIONS_ID);
ALTER TABLE PUBLIC.DESCRIPTIONBASE_ANNOTATION ADD CONSTRAINT PUBLIC.CONSTRAINT_63F UNIQUE(ANNOTATIONS_ID);
ALTER TABLE PUBLIC.DESCRIPTIONELEMENTBASE_MARKER ADD CONSTRAINT PUBLIC.CONSTRAINT_AE96 UNIQUE(MARKERS_ID);
ALTER TABLE PUBLIC.CLASSIFICATION_TAXONNODE ADD CONSTRAINT PUBLIC.CONSTRAINT_D7D UNIQUE(ROOTNODES_ID);
-ALTER TABLE PUBLIC.GENBANKACCESSION ADD CONSTRAINT PUBLIC.CONSTRAINT_224 UNIQUE(UUID);
ALTER TABLE PUBLIC.HYBRIDRELATIONSHIP_ANNOTATION ADD CONSTRAINT PUBLIC.CONSTRAINT_2820 UNIQUE(ANNOTATIONS_ID);
ALTER TABLE PUBLIC.ANNOTATION_ANNOTATION ADD CONSTRAINT PUBLIC.CONSTRAINT_AE UNIQUE(ANNOTATIONS_ID);
ALTER TABLE PUBLIC.SEQUENCE_REFERENCE ADD CONSTRAINT PUBLIC.CONSTRAINT_7620 UNIQUE(CITATIONS_ID);
ALTER TABLE PUBLIC.TERMVOCABULARY_EXTENSION ADD CONSTRAINT PUBLIC.CONSTRAINT_C3CBC UNIQUE(EXTENSIONS_ID);
ALTER TABLE PUBLIC.STATISTICALMEASUREMENTVALUE ADD CONSTRAINT PUBLIC.CONSTRAINT_35B UNIQUE(UUID);
ALTER TABLE PUBLIC.SPECIMENOROBSERVATIONBASE_SEQUENCE ADD CONSTRAINT PUBLIC.CONSTRAINT_BE634 UNIQUE(SEQUENCES_ID);
-ALTER TABLE PUBLIC.SEQUENCE_GENBANKACCESSION ADD CONSTRAINT PUBLIC.CONSTRAINT_C4F1 UNIQUE(GENBANKACCESSION_ID);
ALTER TABLE PUBLIC.TAXONBASE_CREDIT ADD CONSTRAINT PUBLIC.CONSTRAINT_FF44 UNIQUE(CREDITS_ID);
ALTER TABLE PUBLIC.COLLECTION_EXTENSION ADD CONSTRAINT PUBLIC.CONSTRAINT_BBE UNIQUE(EXTENSIONS_ID);
ALTER TABLE PUBLIC.TAXONNAMEBASE ADD CONSTRAINT PUBLIC.CONSTRAINT_919B UNIQUE(UUID);
ALTER TABLE PUBLIC.LANGUAGESTRING_ANNOTATION ADD CONSTRAINT PUBLIC.FK8400DFA51E403E0B FOREIGN KEY(ANNOTATIONS_ID) REFERENCES PUBLIC.ANNOTATION(ID) NOCHECK;
ALTER TABLE PUBLIC.DEFINEDTERMBASE_REPRESENTATION ADD CONSTRAINT PUBLIC.FKAAC8AFE6B31C4747 FOREIGN KEY(REPRESENTATIONS_ID) REFERENCES PUBLIC.REPRESENTATION(ID) NOCHECK;
ALTER TABLE PUBLIC.KEYSTATEMENT_LANGUAGESTRING ADD CONSTRAINT PUBLIC.FK70BB5FD8DA0C376A FOREIGN KEY(LABEL_MAPKEY_ID) REFERENCES PUBLIC.DEFINEDTERMBASE(ID) NOCHECK;
-ALTER TABLE PUBLIC.SEQUENCE_GENBANKACCESSION ADD CONSTRAINT PUBLIC.FK8F698096D57FFDD5 FOREIGN KEY(SEQUENCE_ID) REFERENCES PUBLIC.SEQUENCE(ID) NOCHECK;
ALTER TABLE PUBLIC.AGENTBASE_RIGHTS_AUD ADD CONSTRAINT PUBLIC.FK4FDFF8D134869AAE FOREIGN KEY(REV) REFERENCES PUBLIC.AUDITEVENT(REVISIONNUMBER) NOCHECK;
ALTER TABLE PUBLIC.MEDIAKEY_SCOPE ADD CONSTRAINT PUBLIC.FKBFFEE8F0546985E4 FOREIGN KEY(SCOPERESTRICTIONS_ID) REFERENCES PUBLIC.DEFINEDTERMBASE(ID) NOCHECK;
ALTER TABLE PUBLIC.TERMVOCABULARY_REPRESENTATION ADD CONSTRAINT PUBLIC.FKA408B63A258E060 FOREIGN KEY(TERMVOCABULARY_ID) REFERENCES PUBLIC.TERMVOCABULARY(ID) NOCHECK;
ALTER TABLE PUBLIC.SEQUENCE_REFERENCE ADD CONSTRAINT PUBLIC.FK6944904DD57FFDD5 FOREIGN KEY(SEQUENCE_ID) REFERENCES PUBLIC.SEQUENCE(ID) NOCHECK;
ALTER TABLE PUBLIC.PERMISSIONGROUP ADD CONSTRAINT PUBLIC.FK629941D04FF2DB2C FOREIGN KEY(CREATEDBY_ID) REFERENCES PUBLIC.USERACCOUNT(ID) NOCHECK;
ALTER TABLE PUBLIC.SPECIMENOROBSERVATIONBASE_EXTENSION_AUD ADD CONSTRAINT PUBLIC.FK7AE0176334869AAE FOREIGN KEY(REV) REFERENCES PUBLIC.AUDITEVENT(REVISIONNUMBER) NOCHECK;
-ALTER TABLE PUBLIC.GENBANKACCESSION ADD CONSTRAINT PUBLIC.FK86C1DBF8BC5DA539 FOREIGN KEY(UPDATEDBY_ID) REFERENCES PUBLIC.USERACCOUNT(ID) NOCHECK;
ALTER TABLE PUBLIC.TAXONBASE_RIGHTS ADD CONSTRAINT PUBLIC.FK65CF621BC13F7B21 FOREIGN KEY(RIGHTS_ID) REFERENCES PUBLIC.RIGHTS(ID) NOCHECK;
ALTER TABLE PUBLIC.RIGHTS ADD CONSTRAINT PUBLIC.FK91E56DF7E8D36B00 FOREIGN KEY(LANGUAGE_ID) REFERENCES PUBLIC.DEFINEDTERMBASE(ID) NOCHECK;
ALTER TABLE PUBLIC.KEYSTATEMENT ADD CONSTRAINT PUBLIC.FK7125B9F04FF2DB2C FOREIGN KEY(CREATEDBY_ID) REFERENCES PUBLIC.USERACCOUNT(ID) NOCHECK;
ALTER TABLE PUBLIC.DESCRIPTIONELEMENTBASE_STATEDATA ADD CONSTRAINT PUBLIC.FK592D6F6D15153604 FOREIGN KEY(STATES_ID) REFERENCES PUBLIC.STATEDATA(ID) NOCHECK;
ALTER TABLE PUBLIC.INDIVIDUALASSOCIATION_LANGUAGESTRING ADD CONSTRAINT PUBLIC.FKB5C75EC02BEBA58D FOREIGN KEY(DESCRIPTION_ID) REFERENCES PUBLIC.LANGUAGESTRING(ID) NOCHECK;
ALTER TABLE PUBLIC.CLASSIFICATION ADD CONSTRAINT PUBLIC.FKDB110006BC5DA539 FOREIGN KEY(UPDATEDBY_ID) REFERENCES PUBLIC.USERACCOUNT(ID) NOCHECK;
-ALTER TABLE PUBLIC.SEQUENCE_GENBANKACCESSION ADD CONSTRAINT PUBLIC.FK8F69809615C4EF35 FOREIGN KEY(GENBANKACCESSION_ID) REFERENCES PUBLIC.GENBANKACCESSION(ID) NOCHECK;
ALTER TABLE PUBLIC.DEFINEDTERMBASE_CREDIT ADD CONSTRAINT PUBLIC.FK78FF2B1232D1B9F FOREIGN KEY(CREDITS_ID) REFERENCES PUBLIC.CREDIT(ID) NOCHECK;
ALTER TABLE PUBLIC.HOMOTYPICALGROUP_MARKER ADD CONSTRAINT PUBLIC.FK97D36661BFEAE500 FOREIGN KEY(HOMOTYPICALGROUP_ID) REFERENCES PUBLIC.HOMOTYPICALGROUP(ID) NOCHECK;
ALTER TABLE PUBLIC.MEDIAKEY_TAXON ADD CONSTRAINT PUBLIC.FKC00C3966DE9A3E39 FOREIGN KEY(TAXON_ID) REFERENCES PUBLIC.TAXONBASE(ID) NOCHECK;
ALTER TABLE PUBLIC.TAXONBASE_MARKER_AUD ADD CONSTRAINT PUBLIC.FKE11D334F34869AAE FOREIGN KEY(REV) REFERENCES PUBLIC.AUDITEVENT(REVISIONNUMBER) NOCHECK;
ALTER TABLE PUBLIC.REFERENCE_ORIGINALSOURCEBASE_AUD ADD CONSTRAINT PUBLIC.FKC025854234869AAE FOREIGN KEY(REV) REFERENCES PUBLIC.AUDITEVENT(REVISIONNUMBER) NOCHECK;
ALTER TABLE PUBLIC.DESCRIPTIONELEMENTBASE_ANNOTATION_AUD ADD CONSTRAINT PUBLIC.FK2BC1DD2E34869AAE FOREIGN KEY(REV) REFERENCES PUBLIC.AUDITEVENT(REVISIONNUMBER) NOCHECK;
-ALTER TABLE PUBLIC.GENBANKACCESSION_AUD ADD CONSTRAINT PUBLIC.FK5A2F4DC934869AAE FOREIGN KEY(REV) REFERENCES PUBLIC.AUDITEVENT(REVISIONNUMBER) NOCHECK;
ALTER TABLE PUBLIC.POLYTOMOUSKEY_ANNOTATION ADD CONSTRAINT PUBLIC.FK278CF8B61E403E0B FOREIGN KEY(ANNOTATIONS_ID) REFERENCES PUBLIC.ANNOTATION(ID) NOCHECK;
ALTER TABLE PUBLIC.TERMVOCABULARY_REPRESENTATION_AUD ADD CONSTRAINT PUBLIC.FK681B370B34869AAE FOREIGN KEY(REV) REFERENCES PUBLIC.AUDITEVENT(REVISIONNUMBER) NOCHECK;
ALTER TABLE PUBLIC.USERACCOUNT_AUD ADD CONSTRAINT PUBLIC.FK6A57909334869AAE FOREIGN KEY(REV) REFERENCES PUBLIC.AUDITEVENT(REVISIONNUMBER) NOCHECK;
ALTER TABLE PUBLIC.AGENTBASE_AGENTBASE_AUD ADD CONSTRAINT PUBLIC.FKA8A87CFE34869AAE FOREIGN KEY(REV) REFERENCES PUBLIC.AUDITEVENT(REVISIONNUMBER) NOCHECK;
ALTER TABLE PUBLIC.DESCRIPTIONBASE_SPECIMENOROBSERVATIONBASE_AUD ADD CONSTRAINT PUBLIC.FKF1B33B5134869AAE FOREIGN KEY(REV) REFERENCES PUBLIC.AUDITEVENT(REVISIONNUMBER) NOCHECK;
ALTER TABLE PUBLIC.TERMVOCABULARY_ORIGINALSOURCEBASE ADD CONSTRAINT PUBLIC.FK8F2D512A258E060 FOREIGN KEY(TERMVOCABULARY_ID) REFERENCES PUBLIC.TERMVOCABULARY(ID) NOCHECK;
-ALTER TABLE PUBLIC.GENBANKACCESSION ADD CONSTRAINT PUBLIC.FK86C1DBF84FF2DB2C FOREIGN KEY(CREATEDBY_ID) REFERENCES PUBLIC.USERACCOUNT(ID) NOCHECK;
ALTER TABLE PUBLIC.DESCRIPTIONBASE ADD CONSTRAINT PUBLIC.FKFF4D58CDDE9A3E39 FOREIGN KEY(TAXON_ID) REFERENCES PUBLIC.TAXONBASE(ID) NOCHECK;
ALTER TABLE PUBLIC.NOMENCLATURALSTATUS_MARKER_AUD ADD CONSTRAINT PUBLIC.FK8619495F34869AAE FOREIGN KEY(REV) REFERENCES PUBLIC.AUDITEVENT(REVISIONNUMBER) NOCHECK;
-ALTER TABLE PUBLIC.SEQUENCE_GENBANKACCESSION_AUD ADD CONSTRAINT PUBLIC.FKC717736734869AAE FOREIGN KEY(REV) REFERENCES PUBLIC.AUDITEVENT(REVISIONNUMBER) NOCHECK;
ALTER TABLE PUBLIC.NAMERELATIONSHIP_MARKER ADD CONSTRAINT PUBLIC.FKE3E463967B4CB560 FOREIGN KEY(NAMERELATIONSHIP_ID) REFERENCES PUBLIC.NAMERELATIONSHIP(ID) NOCHECK;
ALTER TABLE PUBLIC.SPECIMENOROBSERVATIONBASE_RIGHTS_AUD ADD CONSTRAINT PUBLIC.FK4168503534869AAE FOREIGN KEY(REV) REFERENCES PUBLIC.AUDITEVENT(REVISIONNUMBER) NOCHECK;
ALTER TABLE PUBLIC.FEATURENODE_DEFINEDTERMBASE_INAPPLICABLEIF_AUD ADD CONSTRAINT PUBLIC.FKB8D7025234869AAE FOREIGN KEY(REV) REFERENCES PUBLIC.AUDITEVENT(REVISIONNUMBER) NOCHECK;
+++ /dev/null
-/**
-* Copyright (C) 2007 EDIT
-* European Distributed Institute of Taxonomy
-* http://www.e-taxonomy.eu
-*
-* The contents of this file are subject to the Mozilla Public License Version 1.1
-* See LICENSE.TXT at the top of this package for the full license terms.
-*/
-
-package eu.etaxonomy.cdm.model.molecular;
-
-
-import java.net.URI;
-
-import javax.persistence.Entity;
-import javax.xml.bind.annotation.XmlAccessType;
-import javax.xml.bind.annotation.XmlAccessorType;
-import javax.xml.bind.annotation.XmlElement;
-import javax.xml.bind.annotation.XmlRootElement;
-import javax.xml.bind.annotation.XmlType;
-
-import org.apache.log4j.Logger;
-import org.hibernate.annotations.Type;
-import org.hibernate.envers.Audited;
-import org.hibernate.search.annotations.Analyze;
-import org.hibernate.search.annotations.Field;
-
-import eu.etaxonomy.cdm.model.common.VersionableEntity;
-
-/**
- * @author m.doering
- * @version 1.0
- * @created 08-Nov-2007 13:06:25
- */
-@XmlAccessorType(XmlAccessType.FIELD)
-@XmlType(name = "GenBankAccession", propOrder = {
- "accessionNumber",
- "uri"
-})
-@XmlRootElement(name = "GenBankAccession")
-@Entity
-@Audited
-public class GenBankAccession extends VersionableEntity {
- private static final long serialVersionUID = -8179493118062601585L;
- private static final Logger logger = Logger.getLogger(GenBankAccession.class);
-
- @XmlElement(name = "AccessionNumber")
- private String accessionNumber;
-
- @XmlElement(name = "URI")
- @Field(analyze = Analyze.NO)
- @Type(type="uriUserType")
- private URI uri;
-
-//*********************** FACTORY ****************************************************/
-
- public static GenBankAccession NewInstance(String accessionNumber){
- GenBankAccession result = new GenBankAccession();
- result.setAccessionNumber(accessionNumber);
- return result;
- }
-
-//*********************** CONSTRUCTOR ****************************************************/
-
- private GenBankAccession() {
-
- }
-
-//*********************** GETTER / SETTER ****************************************************/
-
-
- public String getAccessionNumber(){
- logger.debug("getAccessionNumber");
- return this.accessionNumber;
- }
-
- /**
- *
- * @param accessionNumber accessionNumber
- */
- public void setAccessionNumber(String accessionNumber){
- this.accessionNumber = accessionNumber;
- }
-
- public URI getUri(){
- return this.uri;
- }
-
- /**
- *
- * @param uri uri
- */
- public void setUri(URI uri){
- this.uri = uri;
- }
-
-}
\ No newline at end of file
package eu.etaxonomy.cdm.model.molecular;
+import java.net.URI;
import java.util.HashSet;
import java.util.Set;
import javax.persistence.ManyToOne;
import javax.persistence.OneToMany;
import javax.persistence.Transient;
+import javax.validation.constraints.Size;
import javax.xml.bind.annotation.XmlAccessType;
import javax.xml.bind.annotation.XmlAccessorType;
import javax.xml.bind.annotation.XmlAttribute;
import org.hibernate.annotations.Table;
import org.hibernate.annotations.Type;
import org.hibernate.envers.Audited;
+import org.hibernate.search.annotations.Analyze;
+import org.hibernate.search.annotations.Field;
import org.joda.time.DateTime;
import org.springframework.beans.factory.annotation.Configurable;
"publishedIn",
"locus",
"citations",
- "genBankAccession",
+ "genBankAccessionNumber",
+ "genBankUri",
"chromatograms"
})
@XmlRootElement(name = "Sequence")
@OneToMany(fetch = FetchType.LAZY)
private Set<Reference> citations = new HashSet<Reference>();
- @XmlElementWrapper(name = "GenBankAccessions")
- @XmlElement(name = "GenBankAccession")
- @OneToMany(fetch = FetchType.LAZY)
- @Cascade(CascadeType.SAVE_UPDATE)
- private Set<GenBankAccession> genBankAccession = new HashSet<GenBankAccession>();
+// @XmlElementWrapper(name = "GenBankAccessions")
+// @XmlElement(name = "GenBankAccession")
+// @OneToMany(fetch = FetchType.LAZY)
+// @Cascade(CascadeType.SAVE_UPDATE)
+// private Set<GenBankAccession> genBankAccession = new HashSet<GenBankAccession>();
+
+ @XmlElement(name = "GenBankAccessionNumber")
+ @Size(max=20)
+ private String genBankAccessionNumber;
+
+ @XmlElement(name = "GenBankUri")
+ @Field(analyze = Analyze.NO)
+ @Type(type="uriUserType")
+ private URI genBankUri;
@XmlElement(name = "Locus")
@XmlIDREF
this.citations.remove(citation);
}
- public Set<GenBankAccession> getGenBankAccession() {
- return genBankAccession;
+ public String getGenBankAccessionNumber() {
+ return genBankAccessionNumber;
}
- public void addGenBankAccession(GenBankAccession genBankAccession) {
- this.genBankAccession.add(genBankAccession);
+ public void setGenBankAccessionNumber(String genBankAccessionNumber) {
+ this.genBankAccessionNumber = genBankAccessionNumber;
}
-
- public void removeGenBankAccession(GenBankAccession genBankAccession) {
- this.genBankAccession.remove(genBankAccession);
+
+ public URI getGenBankUri() {
+ return genBankUri;
+ }
+
+ public void setGenBankUri(URI genBankUri) {
+ this.genBankUri = genBankUri;
}
public Set<Media> getChromatograms() {
}
- result.genBankAccession = new HashSet<GenBankAccession>();
- for (GenBankAccession genBankAcc: this.genBankAccession){
- result.genBankAccession.add((GenBankAccession)genBankAcc.clone());
- }
-
result.chromatograms = new HashSet<Media>();
for (Media chromatogram: this.chromatograms){
return null;
}
}
+
}
\ No newline at end of file
package eu.etaxonomy.cdm.model.molecular;\r
\r
-import static org.junit.Assert.assertEquals;\r
-import static org.junit.Assert.assertNotSame;\r
-import static org.junit.Assert.assertTrue;\r
+import static org.junit.Assert.*;\r
\r
+import java.net.URI;\r
import java.util.Iterator;\r
\r
import org.apache.log4j.Logger;\r
seq.setBarcode(true);\r
seq.setSequence("ATTGCCATCG");\r
\r
- GenBankAccession genBankAccession = GenBankAccession.NewInstance("12393247");\r
- seq.addGenBankAccession(genBankAccession );\r
+ seq.setGenBankAccessionNumber("HM347273");\r
+ seq.setGenBankUri(URI.create("http://www.abc.de"));\r
Media chromatogram = Media.NewInstance();\r
chromatogram.putTitle(LanguageString.NewInstance("chromatogram", Language.ENGLISH()));\r
seq.addChromatogram(chromatogram);\r
assertEquals(title, titleClone);\r
\r
\r
- \r
- assertTrue (sequenceClone.getGenBankAccession().size() == seq.getGenBankAccession().size());\r
- \r
- Iterator<GenBankAccession> genBankAccessionIteratorClone = sequenceClone.getGenBankAccession().iterator();\r
- Iterator<GenBankAccession> genBankAccessionIterator = seq.getGenBankAccession().iterator();\r
- GenBankAccession genBankAccession = (GenBankAccession)genBankAccessionIterator.next();\r
- String numberStr = genBankAccession.getAccessionNumber();\r
- GenBankAccession genBankAccessionClone = (GenBankAccession)genBankAccessionIteratorClone.next();\r
- String numberStrClone = genBankAccessionClone.getAccessionNumber(); \r
- assertEquals(numberStr, numberStrClone);\r
- assertNotSame(genBankAccession, genBankAccessionClone);\r
+ assertTrue (sequenceClone.getGenBankAccessionNumber().equals(seq.getGenBankAccessionNumber()));\r
+ assertNotNull(sequenceClone.getGenBankUri());\r
+ assertTrue (sequenceClone.getGenBankUri().equals(seq.getGenBankUri()));\r
\r
DnaSample dnaSampleClone = (DnaSample)dnaSample.clone();\r
Sequence[] seqArray = new Sequence[dnaSample.getSequences().size()];\r
//TODO update datatype->CLOB for URIs. (DefinedTerms, TermVocabulary, Reference
//Rights, MediaRepresentationPart, GenBankAccession, ) #3345
+ //TODO remove table Sequence_GenBankAccession
+ //TODO remove table GenBankAccession
+
+ //TODO add columns GenBankAccessionNumber(String) and GenBankUri (URI) to Sequence
+
+ //
return stepList;
}
<mapping class="eu.etaxonomy.cdm.model.media.RightsTerm"/>\r
<!-- Molecular Package -->\r
<mapping class="eu.etaxonomy.cdm.model.molecular.DnaSample"/>\r
- <mapping class="eu.etaxonomy.cdm.model.molecular.GenBankAccession"/>\r
<mapping class="eu.etaxonomy.cdm.model.molecular.Locus"/>\r
<mapping class="eu.etaxonomy.cdm.model.molecular.PhylogeneticTree"/>\r
<mapping class="eu.etaxonomy.cdm.model.molecular.Sequence"/>\r
import eu.etaxonomy.cdm.model.media.Rights;\r
import eu.etaxonomy.cdm.model.media.RightsTerm;\r
import eu.etaxonomy.cdm.model.molecular.DnaSample;\r
-import eu.etaxonomy.cdm.model.molecular.GenBankAccession;\r
import eu.etaxonomy.cdm.model.molecular.Locus;\r
import eu.etaxonomy.cdm.model.molecular.PhylogeneticTree;\r
import eu.etaxonomy.cdm.model.molecular.Sequence;\r
Rights.class, \r
RightsTerm.class, \r
DnaSample.class, \r
- GenBankAccession.class, \r
Locus.class, \r
PhylogeneticTree.class, \r
Sequence.class, \r
import org.unitils.spring.annotation.SpringBeanByType;\r
\r
import eu.etaxonomy.cdm.model.molecular.DnaSample;\r
-import eu.etaxonomy.cdm.model.molecular.GenBankAccession;\r
import eu.etaxonomy.cdm.model.molecular.Locus;\r
import eu.etaxonomy.cdm.model.molecular.Sequence;\r
import eu.etaxonomy.cdm.persistence.dao.occurrence.IOccurrenceDao;\r
\r
//**************** TESTS ************************************************ \r
\r
- //Test if DnaSample can be loaded and if Sequence, Locus and GenBankAccession data can \r
+ //Test if DnaSample can be loaded and if Sequence and Locus data can \r
//be lazy loaded from database\r
//#3340\r
@Test\r
- public void testLazyLoadSequenceLocusGenbankaccession() {\r
+ public void testLazyLoadSequenceLocus() {\r
createTestData();\r
DnaSample sample1 = (DnaSample)occurrenceDao.findByUuid(uuidSample1);\r
Set<Sequence> sequences = sample1.getSequences();\r
Sequence sequence = sequences.iterator().next();\r
Locus locus = sequence.getLocus();\r
Assert.assertEquals("Locus", locus.getName());\r
- Set<GenBankAccession> accessions = sequence.getGenBankAccession();\r
- GenBankAccession accession = accessions.iterator().next();\r
- Assert.assertEquals("123", accession.getAccessionNumber());\r
+// Set<GenBankAccession> accessions = sequence.getGenBankAccession();\r
+// GenBankAccession accession = accessions.iterator().next();\r
+// Assert.assertEquals("123", accession.getAccessionNumber());\r
commit();\r
}\r
\r
Locus locus = Locus.NewInstance("Locus", null);\r
sequence.setLocus(locus);\r
\r
- GenBankAccession accession = GenBankAccession.NewInstance("123");\r
- sequence.addGenBankAccession(accession);\r
+// GenBankAccession accession = GenBankAccession.NewInstance("123");\r
+// sequence.addGenBankAccession(accession);\r
\r
occurrenceDao.save(sample);\r
commitAndStartNewTransaction(new String[]{"DnaSample", "SpecimenOrObservationBase", "Locus"});\r
<class>eu.etaxonomy.cdm.model.media.RightsTerm</class>
<!-- Molecular Package -->
<class>eu.etaxonomy.cdm.model.molecular.DnaSample</class>
- <class>eu.etaxonomy.cdm.model.molecular.GenBankAccession</class>
<class>eu.etaxonomy.cdm.model.molecular.Locus</class>
<class>eu.etaxonomy.cdm.model.molecular.PhylogeneticTree</class>
<class>eu.etaxonomy.cdm.model.molecular.Sequence</class>
REVTYPE TINYINT
);
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.GATHERINGEVENT_MARKER_AUD;
-CREATE CACHED TABLE PUBLIC.GENBANKACCESSION(
- ID INTEGER NOT NULL,
- CREATED TIMESTAMP,
- UUID VARCHAR(36),
- UPDATED TIMESTAMP,
- ACCESSIONNUMBER VARCHAR(255),
- URI CLOB,
- CREATEDBY_ID INTEGER,
- UPDATEDBY_ID INTEGER
-);
--- 0 +/- SELECT COUNT(*) FROM PUBLIC.GENBANKACCESSION;
-CREATE CACHED TABLE PUBLIC.GENBANKACCESSION_AUD(
- ID INTEGER NOT NULL,
- REV INTEGER NOT NULL,
- REVTYPE TINYINT,
- CREATED TIMESTAMP,
- UUID VARCHAR(36),
- UPDATED TIMESTAMP,
- ACCESSIONNUMBER VARCHAR(255),
- URI CLOB,
- CREATEDBY_ID INTEGER,
- UPDATEDBY_ID INTEGER
-);
--- 0 +/- SELECT COUNT(*) FROM PUBLIC.GENBANKACCESSION_AUD;
CREATE CACHED TABLE PUBLIC.GRANTEDAUTHORITYIMPL(
ID INTEGER NOT NULL,
CREATED TIMESTAMP,
SERIESPART VARCHAR(255),
TITLE CLOB,
REFTYPE INTEGER,
- URI CLOB, VARCHAR(255),
+ URI CLOB,
VOLUME VARCHAR(255),
CREATEDBY_ID INTEGER,
UPDATEDBY_ID INTEGER,
PROTECTEDTITLECACHE BOOLEAN NOT NULL,
TITLECACHE VARCHAR(255),
BARCODE BOOLEAN NOT NULL,
+ GENBANKACCESSIONNUMBER VARCHAR(20),
+ GENBANKURI CLOB,
CITATIONMICROREFERENCE VARCHAR(255),
DATESEQUENCED TIMESTAMP,
LENGTH INTEGER,
PROTECTEDTITLECACHE BOOLEAN,
TITLECACHE VARCHAR(255),
BARCODE BOOLEAN,
+ GENBANKACCESSIONNUMBER VARCHAR(20),
+ GENBANKURI CLOB,
CITATIONMICROREFERENCE VARCHAR(255),
DATESEQUENCED TIMESTAMP,
LENGTH INTEGER,
REVTYPE TINYINT
);
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.SEQUENCE_EXTENSION_AUD;
-CREATE CACHED TABLE PUBLIC.SEQUENCE_GENBANKACCESSION(
- SEQUENCE_ID INTEGER NOT NULL,
- GENBANKACCESSION_ID INTEGER NOT NULL
-);
--- 0 +/- SELECT COUNT(*) FROM PUBLIC.SEQUENCE_GENBANKACCESSION;
-CREATE CACHED TABLE PUBLIC.SEQUENCE_GENBANKACCESSION_AUD(
- REV INTEGER NOT NULL,
- SEQUENCE_ID INTEGER NOT NULL,
- GENBANKACCESSION_ID INTEGER NOT NULL,
- REVTYPE TINYINT
-);
--- 0 +/- SELECT COUNT(*) FROM PUBLIC.SEQUENCE_GENBANKACCESSION_AUD;
CREATE CACHED TABLE PUBLIC.SEQUENCE_MARKER(
SEQUENCE_ID INTEGER NOT NULL,
MARKERS_ID INTEGER NOT NULL
ALTER TABLE PUBLIC.SEQUENCE_MEDIA_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_2CE PRIMARY KEY(REV, SEQUENCE_ID, CHROMATOGRAMS_ID);
ALTER TABLE PUBLIC.MEDIAREPRESENTATION ADD CONSTRAINT PUBLIC.CONSTRAINT_BE0 PRIMARY KEY(ID);
ALTER TABLE PUBLIC.DEFINEDTERMBASE_MEASUREMENTUNIT_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_BA2 PRIMARY KEY(REV, DEFINEDTERMBASE_ID, RECOMMENDEDMEASUREMENTUNITS_ID);
-ALTER TABLE PUBLIC.GENBANKACCESSION_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_F37 PRIMARY KEY(ID, REV);
ALTER TABLE PUBLIC.LANGUAGESTRING_MARKER_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_F36 PRIMARY KEY(REV, LANGUAGESTRING_ID, MARKERS_ID);
ALTER TABLE PUBLIC.RIGHTS_ANNOTATION_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_301 PRIMARY KEY(REV, RIGHTS_ID, ANNOTATIONS_ID);
ALTER TABLE PUBLIC.REFERENCE_RIGHTS_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_F43 PRIMARY KEY(REV, REFERENCE_ID, RIGHTS_ID);
ALTER TABLE PUBLIC.SPECIMENOROBSERVATIONBASE_MEDIA_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_D0 PRIMARY KEY(REV, SPECIMENOROBSERVATIONBASE_ID, MEDIA_ID);
ALTER TABLE PUBLIC.SEQUENCE_ORIGINALSOURCEBASE ADD CONSTRAINT PUBLIC.CONSTRAINT_726 PRIMARY KEY(SEQUENCE_ID, SOURCES_ID);
ALTER TABLE PUBLIC.STATEDATA_LANGUAGESTRING_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_D63 PRIMARY KEY(REV, STATEDATA_ID, MODIFYINGTEXT_ID, MODIFYINGTEXT_MAPKEY_ID);
-ALTER TABLE PUBLIC.SEQUENCE_GENBANKACCESSION ADD CONSTRAINT PUBLIC.CONSTRAINT_C4F PRIMARY KEY(SEQUENCE_ID, GENBANKACCESSION_ID);
ALTER TABLE PUBLIC.TERMVOCABULARY_ANNOTATION ADD CONSTRAINT PUBLIC.CONSTRAINT_C4D PRIMARY KEY(TERMVOCABULARY_ID, ANNOTATIONS_ID);
ALTER TABLE PUBLIC.SEQUENCE_EXTENSION_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_550F PRIMARY KEY(REV, SEQUENCE_ID, EXTENSIONS_ID);
ALTER TABLE PUBLIC.FEATURETREE ADD CONSTRAINT PUBLIC.CONSTRAINT_69EA PRIMARY KEY(ID);
ALTER TABLE PUBLIC.GATHERINGEVENT ADD CONSTRAINT PUBLIC.CONSTRAINT_2A PRIMARY KEY(ID);
ALTER TABLE PUBLIC.AGENTBASE_MEDIA ADD CONSTRAINT PUBLIC.CONSTRAINT_28 PRIMARY KEY(AGENTBASE_ID, MEDIA_ID);
ALTER TABLE PUBLIC.STATEDATA ADD CONSTRAINT PUBLIC.CONSTRAINT_29 PRIMARY KEY(ID);
-ALTER TABLE PUBLIC.GENBANKACCESSION ADD CONSTRAINT PUBLIC.CONSTRAINT_22 PRIMARY KEY(ID);
ALTER TABLE PUBLIC.TERMVOCABULARY_ANNOTATION_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_AF1 PRIMARY KEY(REV, TERMVOCABULARY_ID, ANNOTATIONS_ID);
ALTER TABLE PUBLIC.HOMOTYPICALGROUP_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_20 PRIMARY KEY(ID, REV);
ALTER TABLE PUBLIC.INSTITUTIONALMEMBERSHIP ADD CONSTRAINT PUBLIC.CONSTRAINT_21 PRIMARY KEY(ID);
ALTER TABLE PUBLIC.REFERENCE_MARKER ADD CONSTRAINT PUBLIC.CONSTRAINT_81E PRIMARY KEY(REFERENCE_ID, MARKERS_ID);
ALTER TABLE PUBLIC.DESCRIPTIONELEMENTBASE_ORIGINALSOURCEBASE_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_7B PRIMARY KEY(REV, DESCRIPTIONELEMENTBASE_ID, SOURCES_ID);
ALTER TABLE PUBLIC.SEQUENCE_REFERENCE ADD CONSTRAINT PUBLIC.CONSTRAINT_762 PRIMARY KEY(SEQUENCE_ID, CITATIONS_ID);
-ALTER TABLE PUBLIC.SEQUENCE_GENBANKACCESSION_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_C3C PRIMARY KEY(REV, SEQUENCE_ID, GENBANKACCESSION_ID);
ALTER TABLE PUBLIC.KEYSTATEMENT ADD CONSTRAINT PUBLIC.CONSTRAINT_7A PRIMARY KEY(ID);
ALTER TABLE PUBLIC.REPRESENTATION_MARKER_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_91 PRIMARY KEY(REV, REPRESENTATION_ID, MARKERS_ID);
ALTER TABLE PUBLIC.MEDIAKEY_SCOPE_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_40F PRIMARY KEY(REV, MEDIA_ID, SCOPERESTRICTIONS_ID);
ALTER TABLE PUBLIC.DESCRIPTIONBASE_ANNOTATION ADD CONSTRAINT PUBLIC.CONSTRAINT_63F UNIQUE(ANNOTATIONS_ID);
ALTER TABLE PUBLIC.DESCRIPTIONELEMENTBASE_MARKER ADD CONSTRAINT PUBLIC.CONSTRAINT_AE96 UNIQUE(MARKERS_ID);
ALTER TABLE PUBLIC.CLASSIFICATION_TAXONNODE ADD CONSTRAINT PUBLIC.CONSTRAINT_D7D UNIQUE(ROOTNODES_ID);
-ALTER TABLE PUBLIC.GENBANKACCESSION ADD CONSTRAINT PUBLIC.CONSTRAINT_224 UNIQUE(UUID);
ALTER TABLE PUBLIC.HYBRIDRELATIONSHIP_ANNOTATION ADD CONSTRAINT PUBLIC.CONSTRAINT_2820 UNIQUE(ANNOTATIONS_ID);
ALTER TABLE PUBLIC.ANNOTATION_ANNOTATION ADD CONSTRAINT PUBLIC.CONSTRAINT_AE UNIQUE(ANNOTATIONS_ID);
ALTER TABLE PUBLIC.SEQUENCE_REFERENCE ADD CONSTRAINT PUBLIC.CONSTRAINT_7620 UNIQUE(CITATIONS_ID);
ALTER TABLE PUBLIC.TERMVOCABULARY_EXTENSION ADD CONSTRAINT PUBLIC.CONSTRAINT_C3CBC UNIQUE(EXTENSIONS_ID);
ALTER TABLE PUBLIC.STATISTICALMEASUREMENTVALUE ADD CONSTRAINT PUBLIC.CONSTRAINT_35B UNIQUE(UUID);
ALTER TABLE PUBLIC.SPECIMENOROBSERVATIONBASE_SEQUENCE ADD CONSTRAINT PUBLIC.CONSTRAINT_BE634 UNIQUE(SEQUENCES_ID);
-ALTER TABLE PUBLIC.SEQUENCE_GENBANKACCESSION ADD CONSTRAINT PUBLIC.CONSTRAINT_C4F1 UNIQUE(GENBANKACCESSION_ID);
ALTER TABLE PUBLIC.TAXONBASE_CREDIT ADD CONSTRAINT PUBLIC.CONSTRAINT_FF44 UNIQUE(CREDITS_ID);
ALTER TABLE PUBLIC.COLLECTION_EXTENSION ADD CONSTRAINT PUBLIC.CONSTRAINT_BBE UNIQUE(EXTENSIONS_ID);
ALTER TABLE PUBLIC.TAXONNAMEBASE ADD CONSTRAINT PUBLIC.CONSTRAINT_919B UNIQUE(UUID);
ALTER TABLE PUBLIC.LANGUAGESTRING_ANNOTATION ADD CONSTRAINT PUBLIC.FK8400DFA51E403E0B FOREIGN KEY(ANNOTATIONS_ID) REFERENCES PUBLIC.ANNOTATION(ID) NOCHECK;
ALTER TABLE PUBLIC.DEFINEDTERMBASE_REPRESENTATION ADD CONSTRAINT PUBLIC.FKAAC8AFE6B31C4747 FOREIGN KEY(REPRESENTATIONS_ID) REFERENCES PUBLIC.REPRESENTATION(ID) NOCHECK;
ALTER TABLE PUBLIC.KEYSTATEMENT_LANGUAGESTRING ADD CONSTRAINT PUBLIC.FK70BB5FD8DA0C376A FOREIGN KEY(LABEL_MAPKEY_ID) REFERENCES PUBLIC.DEFINEDTERMBASE(ID) NOCHECK;
-ALTER TABLE PUBLIC.SEQUENCE_GENBANKACCESSION ADD CONSTRAINT PUBLIC.FK8F698096D57FFDD5 FOREIGN KEY(SEQUENCE_ID) REFERENCES PUBLIC.SEQUENCE(ID) NOCHECK;
ALTER TABLE PUBLIC.AGENTBASE_RIGHTS_AUD ADD CONSTRAINT PUBLIC.FK4FDFF8D134869AAE FOREIGN KEY(REV) REFERENCES PUBLIC.AUDITEVENT(REVISIONNUMBER) NOCHECK;
ALTER TABLE PUBLIC.MEDIAKEY_SCOPE ADD CONSTRAINT PUBLIC.FKBFFEE8F0546985E4 FOREIGN KEY(SCOPERESTRICTIONS_ID) REFERENCES PUBLIC.DEFINEDTERMBASE(ID) NOCHECK;
ALTER TABLE PUBLIC.TERMVOCABULARY_REPRESENTATION ADD CONSTRAINT PUBLIC.FKA408B63A258E060 FOREIGN KEY(TERMVOCABULARY_ID) REFERENCES PUBLIC.TERMVOCABULARY(ID) NOCHECK;
ALTER TABLE PUBLIC.SEQUENCE_REFERENCE ADD CONSTRAINT PUBLIC.FK6944904DD57FFDD5 FOREIGN KEY(SEQUENCE_ID) REFERENCES PUBLIC.SEQUENCE(ID) NOCHECK;
ALTER TABLE PUBLIC.PERMISSIONGROUP ADD CONSTRAINT PUBLIC.FK629941D04FF2DB2C FOREIGN KEY(CREATEDBY_ID) REFERENCES PUBLIC.USERACCOUNT(ID) NOCHECK;
ALTER TABLE PUBLIC.SPECIMENOROBSERVATIONBASE_EXTENSION_AUD ADD CONSTRAINT PUBLIC.FK7AE0176334869AAE FOREIGN KEY(REV) REFERENCES PUBLIC.AUDITEVENT(REVISIONNUMBER) NOCHECK;
-ALTER TABLE PUBLIC.GENBANKACCESSION ADD CONSTRAINT PUBLIC.FK86C1DBF8BC5DA539 FOREIGN KEY(UPDATEDBY_ID) REFERENCES PUBLIC.USERACCOUNT(ID) NOCHECK;
ALTER TABLE PUBLIC.TAXONBASE_RIGHTS ADD CONSTRAINT PUBLIC.FK65CF621BC13F7B21 FOREIGN KEY(RIGHTS_ID) REFERENCES PUBLIC.RIGHTS(ID) NOCHECK;
ALTER TABLE PUBLIC.RIGHTS ADD CONSTRAINT PUBLIC.FK91E56DF7E8D36B00 FOREIGN KEY(LANGUAGE_ID) REFERENCES PUBLIC.DEFINEDTERMBASE(ID) NOCHECK;
ALTER TABLE PUBLIC.KEYSTATEMENT ADD CONSTRAINT PUBLIC.FK7125B9F04FF2DB2C FOREIGN KEY(CREATEDBY_ID) REFERENCES PUBLIC.USERACCOUNT(ID) NOCHECK;
ALTER TABLE PUBLIC.DESCRIPTIONELEMENTBASE_STATEDATA ADD CONSTRAINT PUBLIC.FK592D6F6D15153604 FOREIGN KEY(STATES_ID) REFERENCES PUBLIC.STATEDATA(ID) NOCHECK;
ALTER TABLE PUBLIC.INDIVIDUALASSOCIATION_LANGUAGESTRING ADD CONSTRAINT PUBLIC.FKB5C75EC02BEBA58D FOREIGN KEY(DESCRIPTION_ID) REFERENCES PUBLIC.LANGUAGESTRING(ID) NOCHECK;
ALTER TABLE PUBLIC.CLASSIFICATION ADD CONSTRAINT PUBLIC.FKDB110006BC5DA539 FOREIGN KEY(UPDATEDBY_ID) REFERENCES PUBLIC.USERACCOUNT(ID) NOCHECK;
-ALTER TABLE PUBLIC.SEQUENCE_GENBANKACCESSION ADD CONSTRAINT PUBLIC.FK8F69809615C4EF35 FOREIGN KEY(GENBANKACCESSION_ID) REFERENCES PUBLIC.GENBANKACCESSION(ID) NOCHECK;
ALTER TABLE PUBLIC.DEFINEDTERMBASE_CREDIT ADD CONSTRAINT PUBLIC.FK78FF2B1232D1B9F FOREIGN KEY(CREDITS_ID) REFERENCES PUBLIC.CREDIT(ID) NOCHECK;
ALTER TABLE PUBLIC.HOMOTYPICALGROUP_MARKER ADD CONSTRAINT PUBLIC.FK97D36661BFEAE500 FOREIGN KEY(HOMOTYPICALGROUP_ID) REFERENCES PUBLIC.HOMOTYPICALGROUP(ID) NOCHECK;
ALTER TABLE PUBLIC.MEDIAKEY_TAXON ADD CONSTRAINT PUBLIC.FKC00C3966DE9A3E39 FOREIGN KEY(TAXON_ID) REFERENCES PUBLIC.TAXONBASE(ID) NOCHECK;
ALTER TABLE PUBLIC.TAXONBASE_MARKER_AUD ADD CONSTRAINT PUBLIC.FKE11D334F34869AAE FOREIGN KEY(REV) REFERENCES PUBLIC.AUDITEVENT(REVISIONNUMBER) NOCHECK;
ALTER TABLE PUBLIC.REFERENCE_ORIGINALSOURCEBASE_AUD ADD CONSTRAINT PUBLIC.FKC025854234869AAE FOREIGN KEY(REV) REFERENCES PUBLIC.AUDITEVENT(REVISIONNUMBER) NOCHECK;
ALTER TABLE PUBLIC.DESCRIPTIONELEMENTBASE_ANNOTATION_AUD ADD CONSTRAINT PUBLIC.FK2BC1DD2E34869AAE FOREIGN KEY(REV) REFERENCES PUBLIC.AUDITEVENT(REVISIONNUMBER) NOCHECK;
-ALTER TABLE PUBLIC.GENBANKACCESSION_AUD ADD CONSTRAINT PUBLIC.FK5A2F4DC934869AAE FOREIGN KEY(REV) REFERENCES PUBLIC.AUDITEVENT(REVISIONNUMBER) NOCHECK;
ALTER TABLE PUBLIC.POLYTOMOUSKEY_ANNOTATION ADD CONSTRAINT PUBLIC.FK278CF8B61E403E0B FOREIGN KEY(ANNOTATIONS_ID) REFERENCES PUBLIC.ANNOTATION(ID) NOCHECK;
ALTER TABLE PUBLIC.TERMVOCABULARY_REPRESENTATION_AUD ADD CONSTRAINT PUBLIC.FK681B370B34869AAE FOREIGN KEY(REV) REFERENCES PUBLIC.AUDITEVENT(REVISIONNUMBER) NOCHECK;
ALTER TABLE PUBLIC.USERACCOUNT_AUD ADD CONSTRAINT PUBLIC.FK6A57909334869AAE FOREIGN KEY(REV) REFERENCES PUBLIC.AUDITEVENT(REVISIONNUMBER) NOCHECK;
ALTER TABLE PUBLIC.AGENTBASE_AGENTBASE_AUD ADD CONSTRAINT PUBLIC.FKA8A87CFE34869AAE FOREIGN KEY(REV) REFERENCES PUBLIC.AUDITEVENT(REVISIONNUMBER) NOCHECK;
ALTER TABLE PUBLIC.DESCRIPTIONBASE_SPECIMENOROBSERVATIONBASE_AUD ADD CONSTRAINT PUBLIC.FKF1B33B5134869AAE FOREIGN KEY(REV) REFERENCES PUBLIC.AUDITEVENT(REVISIONNUMBER) NOCHECK;
ALTER TABLE PUBLIC.TERMVOCABULARY_ORIGINALSOURCEBASE ADD CONSTRAINT PUBLIC.FK8F2D512A258E060 FOREIGN KEY(TERMVOCABULARY_ID) REFERENCES PUBLIC.TERMVOCABULARY(ID) NOCHECK;
-ALTER TABLE PUBLIC.GENBANKACCESSION ADD CONSTRAINT PUBLIC.FK86C1DBF84FF2DB2C FOREIGN KEY(CREATEDBY_ID) REFERENCES PUBLIC.USERACCOUNT(ID) NOCHECK;
ALTER TABLE PUBLIC.DESCRIPTIONBASE ADD CONSTRAINT PUBLIC.FKFF4D58CDDE9A3E39 FOREIGN KEY(TAXON_ID) REFERENCES PUBLIC.TAXONBASE(ID) NOCHECK;
ALTER TABLE PUBLIC.NOMENCLATURALSTATUS_MARKER_AUD ADD CONSTRAINT PUBLIC.FK8619495F34869AAE FOREIGN KEY(REV) REFERENCES PUBLIC.AUDITEVENT(REVISIONNUMBER) NOCHECK;
-ALTER TABLE PUBLIC.SEQUENCE_GENBANKACCESSION_AUD ADD CONSTRAINT PUBLIC.FKC717736734869AAE FOREIGN KEY(REV) REFERENCES PUBLIC.AUDITEVENT(REVISIONNUMBER) NOCHECK;
ALTER TABLE PUBLIC.NAMERELATIONSHIP_MARKER ADD CONSTRAINT PUBLIC.FKE3E463967B4CB560 FOREIGN KEY(NAMERELATIONSHIP_ID) REFERENCES PUBLIC.NAMERELATIONSHIP(ID) NOCHECK;
ALTER TABLE PUBLIC.SPECIMENOROBSERVATIONBASE_RIGHTS_AUD ADD CONSTRAINT PUBLIC.FK4168503534869AAE FOREIGN KEY(REV) REFERENCES PUBLIC.AUDITEVENT(REVISIONNUMBER) NOCHECK;
ALTER TABLE PUBLIC.FEATURENODE_DEFINEDTERMBASE_INAPPLICABLEIF_AUD ADD CONSTRAINT PUBLIC.FKB8D7025234869AAE FOREIGN KEY(REV) REFERENCES PUBLIC.AUDITEVENT(REVISIONNUMBER) NOCHECK;
<GATHERINGEVENT_DEFINEDTERMBASE_AUD/>
<GATHERINGEVENT_MARKER/>
<GATHERINGEVENT_MARKER_AUD/>
- <GENBANKACCESSION/>
- <GENBANKACCESSION_AUD/>
<GRANTEDAUTHORITYIMPL/>
<HIBERNATE_SEQUENCES SEQUENCE_NAME="DefinedTermBase" NEXT_VAL="2110"/>
<HIBERNATE_SEQUENCES SEQUENCE_NAME="Representation" NEXT_VAL="2200"/>
<SEQUENCE_CREDIT_AUD/>
<SEQUENCE_EXTENSION/>
<SEQUENCE_EXTENSION_AUD/>
- <SEQUENCE_GENBANKACCESSION/>
- <SEQUENCE_GENBANKACCESSION_AUD/>
<SEQUENCE_MARKER/>
<SEQUENCE_MARKER_AUD/>
<SEQUENCE_MEDIA/>
<GATHERINGEVENT_DEFINEDTERMBASE_AUD />\r
<GATHERINGEVENT_MARKER />\r
<GATHERINGEVENT_MARKER_AUD />\r
-<GENBANKACCESSION />\r
-<GENBANKACCESSION_AUD />\r
<GRANTEDAUTHORITYIMPL />\r
<HIBERNATE_SEQUENCES />\r
<HOMOTYPICALGROUP />\r
<SEQUENCE_CREDIT_AUD/>\r
<SEQUENCE_EXTENSION/>\r
<SEQUENCE_EXTENSION_AUD/>\r
- <SEQUENCE_GENBANKACCESSION/>\r
- <SEQUENCE_GENBANKACCESSION_AUD/>\r
<SEQUENCE_MARKER/>\r
<SEQUENCE_MARKER_AUD/>\r
<SEQUENCE_MEDIA/>\r
GATHERINGEVENT_DEFINEDTERMBASE_AUD*,
GATHERINGEVENT_MARKER*,
GATHERINGEVENT_MARKER_AUD*,
- GENBANKACCESSION*,
- GENBANKACCESSION_AUD*,
GRANTEDAUTHORITYIMPL*,
HIBERNATE_SEQUENCES*,
HOMOTYPICALGROUP*,
SEQUENCE_AUD*,
SEQUENCE_EXTENSION*,
SEQUENCE_EXTENSION_AUD*,
- SEQUENCE_GENBANKACCESSION*,
- SEQUENCE_GENBANKACCESSION_AUD*,
SEQUENCE_MARKER*,
SEQUENCE_MARKER_AUD*,
SEQUENCE_MEDIA*,
REVTYPE CDATA #IMPLIED
>
-<!ELEMENT GENBANKACCESSION EMPTY>
-<!ATTLIST GENBANKACCESSION
- ID CDATA #REQUIRED
- CREATED CDATA #IMPLIED
- UUID CDATA #IMPLIED
- UPDATED CDATA #IMPLIED
- ACCESSIONNUMBER CDATA #IMPLIED
- URI CDATA #IMPLIED
- CREATEDBY_ID CDATA #IMPLIED
- UPDATEDBY_ID CDATA #IMPLIED
->
-
-<!ELEMENT GENBANKACCESSION_AUD EMPTY>
-<!ATTLIST GENBANKACCESSION_AUD
- ID CDATA #REQUIRED
- REV CDATA #REQUIRED
- REVTYPE CDATA #IMPLIED
- CREATED CDATA #IMPLIED
- UUID CDATA #IMPLIED
- UPDATED CDATA #IMPLIED
- ACCESSIONNUMBER CDATA #IMPLIED
- URI CDATA #IMPLIED
- CREATEDBY_ID CDATA #IMPLIED
- UPDATEDBY_ID CDATA #IMPLIED
->
-
<!ELEMENT GRANTEDAUTHORITYIMPL EMPTY>
<!ATTLIST GRANTEDAUTHORITYIMPL
ID CDATA #REQUIRED
PROTECTEDTITLECACHE CDATA #IMPLIED
TITLECACHE CDATA #IMPLIED
BARCODE CDATA #IMPLIED
+ GENBANKACCESSIONNUMBER CDATA #IMPLIED
+ GENBANKURI CDATA #IMPLIED
CITATIONMICROREFERENCE CDATA #IMPLIED
DATESEQUENCED CDATA #IMPLIED
LENGTH CDATA #IMPLIED
PROTECTEDTITLECACHE CDATA #IMPLIED
TITLECACHE CDATA #IMPLIED
BARCODE CDATA #IMPLIED
+ GENBANKACCESSIONNUMBER CDATA #IMPLIED
+ GENBANKURI CDATA #IMPLIED
CITATIONMICROREFERENCE CDATA #IMPLIED
DATESEQUENCED CDATA #IMPLIED
LENGTH CDATA #IMPLIED
REVTYPE CDATA #IMPLIED
>
-<!ELEMENT SEQUENCE_GENBANKACCESSION EMPTY>
-<!ATTLIST SEQUENCE_GENBANKACCESSION
- SEQUENCE_ID CDATA #REQUIRED
- GENBANKACCESSION_ID CDATA #REQUIRED
->
-
-<!ELEMENT SEQUENCE_GENBANKACCESSION_AUD EMPTY>
-<!ATTLIST SEQUENCE_GENBANKACCESSION_AUD
- REV CDATA #REQUIRED
- SEQUENCE_ID CDATA #REQUIRED
- GENBANKACCESSION_ID CDATA #REQUIRED
- REVTYPE CDATA #IMPLIED
->
-
<!ELEMENT SEQUENCE_MARKER EMPTY>
<!ATTLIST SEQUENCE_MARKER
SEQUENCE_ID CDATA #REQUIRED
<value>MediaRepresentation.parts</value>\r
\r
<value>Sequence.locus</value>\r
- <value>Sequence.genBankAccession</value>\r
+ <value>Sequence.genBankAccessionNumber</value>\r
+ <value>Sequence.genBankUri</value>\r
\r
<value>Annotation.annotationType</value>\r
<value>Marker.markerType</value>\r
}else{\r
String minStr = min == null? null : String.valueOf(min);\r
String maxStr = max == null? null : String.valueOf(max);\r
- String result = CdmUtils.concat(" " + UTF8.EN_DASH + " ", minStr, maxStr);\r
+ String result = CdmUtils.concat(UTF8.EN_DASH_SPATIUM.toString(), minStr, maxStr);\r
return result;\r
}\r
}\r
specimenFacade.setAbsoluteElevationRange(30, 36);\r
Assert.assertEquals("", Integer.valueOf(36),specimenFacade.getAbsoluteElevationMaximum());\r
Assert.assertEquals("", Integer.valueOf(30),specimenFacade.getAbsoluteElevation());\r
- Assert.assertEquals("", "30 " + UTF8.EN_DASH + " 36",specimenFacade.absoluteElevationToString());\r
+ Assert.assertEquals("", "30" + UTF8.EN_DASH_SPATIUM + "36",specimenFacade.absoluteElevationToString());\r
Assert.assertEquals("", null,specimenFacade.getAbsoluteElevationText());\r
\r
specimenFacade.setAbsoluteElevationRange(30, 35);\r
- Assert.assertEquals("Odd range should not throw an exception anymore", String.format("30 %s 35", UTF8.EN_DASH),specimenFacade.absoluteElevationToString());\r
+ Assert.assertEquals("Odd range should not throw an exception anymore", String.format("30%s35", UTF8.EN_DASH_SPATIUM),specimenFacade.absoluteElevationToString());\r
\r
specimenFacade.setAbsoluteElevationRange(41, null);\r
Assert.assertEquals("", null,specimenFacade.getAbsoluteElevationMaximum());\r
REVTYPE TINYINT
);
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.GATHERINGEVENT_MARKER_AUD;
-CREATE CACHED TABLE PUBLIC.GENBANKACCESSION(
- ID INTEGER NOT NULL,
- CREATED TIMESTAMP,
- UUID VARCHAR(36),
- UPDATED TIMESTAMP,
- ACCESSIONNUMBER VARCHAR(255),
- URI CLOB,
- CREATEDBY_ID INTEGER,
- UPDATEDBY_ID INTEGER
-);
--- 0 +/- SELECT COUNT(*) FROM PUBLIC.GENBANKACCESSION;
-CREATE CACHED TABLE PUBLIC.GENBANKACCESSION_AUD(
- ID INTEGER NOT NULL,
- REV INTEGER NOT NULL,
- REVTYPE TINYINT,
- CREATED TIMESTAMP,
- UUID VARCHAR(36),
- UPDATED TIMESTAMP,
- ACCESSIONNUMBER VARCHAR(255),
- URI CLOB,
- CREATEDBY_ID INTEGER,
- UPDATEDBY_ID INTEGER
-);
--- 0 +/- SELECT COUNT(*) FROM PUBLIC.GENBANKACCESSION_AUD;
CREATE CACHED TABLE PUBLIC.GRANTEDAUTHORITYIMPL(
ID INTEGER NOT NULL,
CREATED TIMESTAMP,
SERIESPART VARCHAR(255),
TITLE CLOB,
REFTYPE INTEGER,
- URI CLOB, VARCHAR(255),
+ URI CLOB,
VOLUME VARCHAR(255),
CREATEDBY_ID INTEGER,
UPDATEDBY_ID INTEGER,
PROTECTEDTITLECACHE BOOLEAN NOT NULL,
TITLECACHE VARCHAR(255),
BARCODE BOOLEAN NOT NULL,
+ GENBANKACCESSIONNUMBER VARCHAR(20),
+ GENBANKURI CLOB,
CITATIONMICROREFERENCE VARCHAR(255),
DATESEQUENCED TIMESTAMP,
LENGTH INTEGER,
PROTECTEDTITLECACHE BOOLEAN,
TITLECACHE VARCHAR(255),
BARCODE BOOLEAN,
+ GENBANKACCESSIONNUMBER VARCHAR(20),
+ GENBANKURI CLOB,
CITATIONMICROREFERENCE VARCHAR(255),
DATESEQUENCED TIMESTAMP,
LENGTH INTEGER,
REVTYPE TINYINT
);
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.SEQUENCE_EXTENSION_AUD;
-CREATE CACHED TABLE PUBLIC.SEQUENCE_GENBANKACCESSION(
- SEQUENCE_ID INTEGER NOT NULL,
- GENBANKACCESSION_ID INTEGER NOT NULL
-);
--- 0 +/- SELECT COUNT(*) FROM PUBLIC.SEQUENCE_GENBANKACCESSION;
-CREATE CACHED TABLE PUBLIC.SEQUENCE_GENBANKACCESSION_AUD(
- REV INTEGER NOT NULL,
- SEQUENCE_ID INTEGER NOT NULL,
- GENBANKACCESSION_ID INTEGER NOT NULL,
- REVTYPE TINYINT
-);
--- 0 +/- SELECT COUNT(*) FROM PUBLIC.SEQUENCE_GENBANKACCESSION_AUD;
CREATE CACHED TABLE PUBLIC.SEQUENCE_MARKER(
SEQUENCE_ID INTEGER NOT NULL,
MARKERS_ID INTEGER NOT NULL
ALTER TABLE PUBLIC.SEQUENCE_MEDIA_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_2CE PRIMARY KEY(REV, SEQUENCE_ID, CHROMATOGRAMS_ID);
ALTER TABLE PUBLIC.MEDIAREPRESENTATION ADD CONSTRAINT PUBLIC.CONSTRAINT_BE0 PRIMARY KEY(ID);
ALTER TABLE PUBLIC.DEFINEDTERMBASE_MEASUREMENTUNIT_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_BA2 PRIMARY KEY(REV, DEFINEDTERMBASE_ID, RECOMMENDEDMEASUREMENTUNITS_ID);
-ALTER TABLE PUBLIC.GENBANKACCESSION_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_F37 PRIMARY KEY(ID, REV);
ALTER TABLE PUBLIC.LANGUAGESTRING_MARKER_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_F36 PRIMARY KEY(REV, LANGUAGESTRING_ID, MARKERS_ID);
ALTER TABLE PUBLIC.RIGHTS_ANNOTATION_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_301 PRIMARY KEY(REV, RIGHTS_ID, ANNOTATIONS_ID);
ALTER TABLE PUBLIC.REFERENCE_RIGHTS_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_F43 PRIMARY KEY(REV, REFERENCE_ID, RIGHTS_ID);
ALTER TABLE PUBLIC.SPECIMENOROBSERVATIONBASE_MEDIA_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_D0 PRIMARY KEY(REV, SPECIMENOROBSERVATIONBASE_ID, MEDIA_ID);
ALTER TABLE PUBLIC.SEQUENCE_ORIGINALSOURCEBASE ADD CONSTRAINT PUBLIC.CONSTRAINT_726 PRIMARY KEY(SEQUENCE_ID, SOURCES_ID);
ALTER TABLE PUBLIC.STATEDATA_LANGUAGESTRING_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_D63 PRIMARY KEY(REV, STATEDATA_ID, MODIFYINGTEXT_ID, MODIFYINGTEXT_MAPKEY_ID);
-ALTER TABLE PUBLIC.SEQUENCE_GENBANKACCESSION ADD CONSTRAINT PUBLIC.CONSTRAINT_C4F PRIMARY KEY(SEQUENCE_ID, GENBANKACCESSION_ID);
ALTER TABLE PUBLIC.TERMVOCABULARY_ANNOTATION ADD CONSTRAINT PUBLIC.CONSTRAINT_C4D PRIMARY KEY(TERMVOCABULARY_ID, ANNOTATIONS_ID);
ALTER TABLE PUBLIC.SEQUENCE_EXTENSION_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_550F PRIMARY KEY(REV, SEQUENCE_ID, EXTENSIONS_ID);
ALTER TABLE PUBLIC.FEATURETREE ADD CONSTRAINT PUBLIC.CONSTRAINT_69EA PRIMARY KEY(ID);
ALTER TABLE PUBLIC.GATHERINGEVENT ADD CONSTRAINT PUBLIC.CONSTRAINT_2A PRIMARY KEY(ID);
ALTER TABLE PUBLIC.AGENTBASE_MEDIA ADD CONSTRAINT PUBLIC.CONSTRAINT_28 PRIMARY KEY(AGENTBASE_ID, MEDIA_ID);
ALTER TABLE PUBLIC.STATEDATA ADD CONSTRAINT PUBLIC.CONSTRAINT_29 PRIMARY KEY(ID);
-ALTER TABLE PUBLIC.GENBANKACCESSION ADD CONSTRAINT PUBLIC.CONSTRAINT_22 PRIMARY KEY(ID);
ALTER TABLE PUBLIC.TERMVOCABULARY_ANNOTATION_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_AF1 PRIMARY KEY(REV, TERMVOCABULARY_ID, ANNOTATIONS_ID);
ALTER TABLE PUBLIC.HOMOTYPICALGROUP_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_20 PRIMARY KEY(ID, REV);
ALTER TABLE PUBLIC.INSTITUTIONALMEMBERSHIP ADD CONSTRAINT PUBLIC.CONSTRAINT_21 PRIMARY KEY(ID);
ALTER TABLE PUBLIC.REFERENCE_MARKER ADD CONSTRAINT PUBLIC.CONSTRAINT_81E PRIMARY KEY(REFERENCE_ID, MARKERS_ID);
ALTER TABLE PUBLIC.DESCRIPTIONELEMENTBASE_ORIGINALSOURCEBASE_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_7B PRIMARY KEY(REV, DESCRIPTIONELEMENTBASE_ID, SOURCES_ID);
ALTER TABLE PUBLIC.SEQUENCE_REFERENCE ADD CONSTRAINT PUBLIC.CONSTRAINT_762 PRIMARY KEY(SEQUENCE_ID, CITATIONS_ID);
-ALTER TABLE PUBLIC.SEQUENCE_GENBANKACCESSION_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_C3C PRIMARY KEY(REV, SEQUENCE_ID, GENBANKACCESSION_ID);
ALTER TABLE PUBLIC.KEYSTATEMENT ADD CONSTRAINT PUBLIC.CONSTRAINT_7A PRIMARY KEY(ID);
ALTER TABLE PUBLIC.REPRESENTATION_MARKER_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_91 PRIMARY KEY(REV, REPRESENTATION_ID, MARKERS_ID);
ALTER TABLE PUBLIC.MEDIAKEY_SCOPE_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_40F PRIMARY KEY(REV, MEDIA_ID, SCOPERESTRICTIONS_ID);
ALTER TABLE PUBLIC.DESCRIPTIONBASE_ANNOTATION ADD CONSTRAINT PUBLIC.CONSTRAINT_63F UNIQUE(ANNOTATIONS_ID);
ALTER TABLE PUBLIC.DESCRIPTIONELEMENTBASE_MARKER ADD CONSTRAINT PUBLIC.CONSTRAINT_AE96 UNIQUE(MARKERS_ID);
ALTER TABLE PUBLIC.CLASSIFICATION_TAXONNODE ADD CONSTRAINT PUBLIC.CONSTRAINT_D7D UNIQUE(ROOTNODES_ID);
-ALTER TABLE PUBLIC.GENBANKACCESSION ADD CONSTRAINT PUBLIC.CONSTRAINT_224 UNIQUE(UUID);
ALTER TABLE PUBLIC.HYBRIDRELATIONSHIP_ANNOTATION ADD CONSTRAINT PUBLIC.CONSTRAINT_2820 UNIQUE(ANNOTATIONS_ID);
ALTER TABLE PUBLIC.ANNOTATION_ANNOTATION ADD CONSTRAINT PUBLIC.CONSTRAINT_AE UNIQUE(ANNOTATIONS_ID);
ALTER TABLE PUBLIC.SEQUENCE_REFERENCE ADD CONSTRAINT PUBLIC.CONSTRAINT_7620 UNIQUE(CITATIONS_ID);
ALTER TABLE PUBLIC.TERMVOCABULARY_EXTENSION ADD CONSTRAINT PUBLIC.CONSTRAINT_C3CBC UNIQUE(EXTENSIONS_ID);
ALTER TABLE PUBLIC.STATISTICALMEASUREMENTVALUE ADD CONSTRAINT PUBLIC.CONSTRAINT_35B UNIQUE(UUID);
ALTER TABLE PUBLIC.SPECIMENOROBSERVATIONBASE_SEQUENCE ADD CONSTRAINT PUBLIC.CONSTRAINT_BE634 UNIQUE(SEQUENCES_ID);
-ALTER TABLE PUBLIC.SEQUENCE_GENBANKACCESSION ADD CONSTRAINT PUBLIC.CONSTRAINT_C4F1 UNIQUE(GENBANKACCESSION_ID);
ALTER TABLE PUBLIC.TAXONBASE_CREDIT ADD CONSTRAINT PUBLIC.CONSTRAINT_FF44 UNIQUE(CREDITS_ID);
ALTER TABLE PUBLIC.COLLECTION_EXTENSION ADD CONSTRAINT PUBLIC.CONSTRAINT_BBE UNIQUE(EXTENSIONS_ID);
ALTER TABLE PUBLIC.TAXONNAMEBASE ADD CONSTRAINT PUBLIC.CONSTRAINT_919B UNIQUE(UUID);
ALTER TABLE PUBLIC.LANGUAGESTRING_ANNOTATION ADD CONSTRAINT PUBLIC.FK8400DFA51E403E0B FOREIGN KEY(ANNOTATIONS_ID) REFERENCES PUBLIC.ANNOTATION(ID) NOCHECK;
ALTER TABLE PUBLIC.DEFINEDTERMBASE_REPRESENTATION ADD CONSTRAINT PUBLIC.FKAAC8AFE6B31C4747 FOREIGN KEY(REPRESENTATIONS_ID) REFERENCES PUBLIC.REPRESENTATION(ID) NOCHECK;
ALTER TABLE PUBLIC.KEYSTATEMENT_LANGUAGESTRING ADD CONSTRAINT PUBLIC.FK70BB5FD8DA0C376A FOREIGN KEY(LABEL_MAPKEY_ID) REFERENCES PUBLIC.DEFINEDTERMBASE(ID) NOCHECK;
-ALTER TABLE PUBLIC.SEQUENCE_GENBANKACCESSION ADD CONSTRAINT PUBLIC.FK8F698096D57FFDD5 FOREIGN KEY(SEQUENCE_ID) REFERENCES PUBLIC.SEQUENCE(ID) NOCHECK;
ALTER TABLE PUBLIC.AGENTBASE_RIGHTS_AUD ADD CONSTRAINT PUBLIC.FK4FDFF8D134869AAE FOREIGN KEY(REV) REFERENCES PUBLIC.AUDITEVENT(REVISIONNUMBER) NOCHECK;
ALTER TABLE PUBLIC.MEDIAKEY_SCOPE ADD CONSTRAINT PUBLIC.FKBFFEE8F0546985E4 FOREIGN KEY(SCOPERESTRICTIONS_ID) REFERENCES PUBLIC.DEFINEDTERMBASE(ID) NOCHECK;
ALTER TABLE PUBLIC.TERMVOCABULARY_REPRESENTATION ADD CONSTRAINT PUBLIC.FKA408B63A258E060 FOREIGN KEY(TERMVOCABULARY_ID) REFERENCES PUBLIC.TERMVOCABULARY(ID) NOCHECK;
ALTER TABLE PUBLIC.SEQUENCE_REFERENCE ADD CONSTRAINT PUBLIC.FK6944904DD57FFDD5 FOREIGN KEY(SEQUENCE_ID) REFERENCES PUBLIC.SEQUENCE(ID) NOCHECK;
ALTER TABLE PUBLIC.PERMISSIONGROUP ADD CONSTRAINT PUBLIC.FK629941D04FF2DB2C FOREIGN KEY(CREATEDBY_ID) REFERENCES PUBLIC.USERACCOUNT(ID) NOCHECK;
ALTER TABLE PUBLIC.SPECIMENOROBSERVATIONBASE_EXTENSION_AUD ADD CONSTRAINT PUBLIC.FK7AE0176334869AAE FOREIGN KEY(REV) REFERENCES PUBLIC.AUDITEVENT(REVISIONNUMBER) NOCHECK;
-ALTER TABLE PUBLIC.GENBANKACCESSION ADD CONSTRAINT PUBLIC.FK86C1DBF8BC5DA539 FOREIGN KEY(UPDATEDBY_ID) REFERENCES PUBLIC.USERACCOUNT(ID) NOCHECK;
ALTER TABLE PUBLIC.TAXONBASE_RIGHTS ADD CONSTRAINT PUBLIC.FK65CF621BC13F7B21 FOREIGN KEY(RIGHTS_ID) REFERENCES PUBLIC.RIGHTS(ID) NOCHECK;
ALTER TABLE PUBLIC.RIGHTS ADD CONSTRAINT PUBLIC.FK91E56DF7E8D36B00 FOREIGN KEY(LANGUAGE_ID) REFERENCES PUBLIC.DEFINEDTERMBASE(ID) NOCHECK;
ALTER TABLE PUBLIC.KEYSTATEMENT ADD CONSTRAINT PUBLIC.FK7125B9F04FF2DB2C FOREIGN KEY(CREATEDBY_ID) REFERENCES PUBLIC.USERACCOUNT(ID) NOCHECK;
ALTER TABLE PUBLIC.DESCRIPTIONELEMENTBASE_STATEDATA ADD CONSTRAINT PUBLIC.FK592D6F6D15153604 FOREIGN KEY(STATES_ID) REFERENCES PUBLIC.STATEDATA(ID) NOCHECK;
ALTER TABLE PUBLIC.INDIVIDUALASSOCIATION_LANGUAGESTRING ADD CONSTRAINT PUBLIC.FKB5C75EC02BEBA58D FOREIGN KEY(DESCRIPTION_ID) REFERENCES PUBLIC.LANGUAGESTRING(ID) NOCHECK;
ALTER TABLE PUBLIC.CLASSIFICATION ADD CONSTRAINT PUBLIC.FKDB110006BC5DA539 FOREIGN KEY(UPDATEDBY_ID) REFERENCES PUBLIC.USERACCOUNT(ID) NOCHECK;
-ALTER TABLE PUBLIC.SEQUENCE_GENBANKACCESSION ADD CONSTRAINT PUBLIC.FK8F69809615C4EF35 FOREIGN KEY(GENBANKACCESSION_ID) REFERENCES PUBLIC.GENBANKACCESSION(ID) NOCHECK;
ALTER TABLE PUBLIC.DEFINEDTERMBASE_CREDIT ADD CONSTRAINT PUBLIC.FK78FF2B1232D1B9F FOREIGN KEY(CREDITS_ID) REFERENCES PUBLIC.CREDIT(ID) NOCHECK;
ALTER TABLE PUBLIC.HOMOTYPICALGROUP_MARKER ADD CONSTRAINT PUBLIC.FK97D36661BFEAE500 FOREIGN KEY(HOMOTYPICALGROUP_ID) REFERENCES PUBLIC.HOMOTYPICALGROUP(ID) NOCHECK;
ALTER TABLE PUBLIC.MEDIAKEY_TAXON ADD CONSTRAINT PUBLIC.FKC00C3966DE9A3E39 FOREIGN KEY(TAXON_ID) REFERENCES PUBLIC.TAXONBASE(ID) NOCHECK;
ALTER TABLE PUBLIC.TAXONBASE_MARKER_AUD ADD CONSTRAINT PUBLIC.FKE11D334F34869AAE FOREIGN KEY(REV) REFERENCES PUBLIC.AUDITEVENT(REVISIONNUMBER) NOCHECK;
ALTER TABLE PUBLIC.REFERENCE_ORIGINALSOURCEBASE_AUD ADD CONSTRAINT PUBLIC.FKC025854234869AAE FOREIGN KEY(REV) REFERENCES PUBLIC.AUDITEVENT(REVISIONNUMBER) NOCHECK;
ALTER TABLE PUBLIC.DESCRIPTIONELEMENTBASE_ANNOTATION_AUD ADD CONSTRAINT PUBLIC.FK2BC1DD2E34869AAE FOREIGN KEY(REV) REFERENCES PUBLIC.AUDITEVENT(REVISIONNUMBER) NOCHECK;
-ALTER TABLE PUBLIC.GENBANKACCESSION_AUD ADD CONSTRAINT PUBLIC.FK5A2F4DC934869AAE FOREIGN KEY(REV) REFERENCES PUBLIC.AUDITEVENT(REVISIONNUMBER) NOCHECK;
ALTER TABLE PUBLIC.POLYTOMOUSKEY_ANNOTATION ADD CONSTRAINT PUBLIC.FK278CF8B61E403E0B FOREIGN KEY(ANNOTATIONS_ID) REFERENCES PUBLIC.ANNOTATION(ID) NOCHECK;
ALTER TABLE PUBLIC.TERMVOCABULARY_REPRESENTATION_AUD ADD CONSTRAINT PUBLIC.FK681B370B34869AAE FOREIGN KEY(REV) REFERENCES PUBLIC.AUDITEVENT(REVISIONNUMBER) NOCHECK;
ALTER TABLE PUBLIC.USERACCOUNT_AUD ADD CONSTRAINT PUBLIC.FK6A57909334869AAE FOREIGN KEY(REV) REFERENCES PUBLIC.AUDITEVENT(REVISIONNUMBER) NOCHECK;
ALTER TABLE PUBLIC.AGENTBASE_AGENTBASE_AUD ADD CONSTRAINT PUBLIC.FKA8A87CFE34869AAE FOREIGN KEY(REV) REFERENCES PUBLIC.AUDITEVENT(REVISIONNUMBER) NOCHECK;
ALTER TABLE PUBLIC.DESCRIPTIONBASE_SPECIMENOROBSERVATIONBASE_AUD ADD CONSTRAINT PUBLIC.FKF1B33B5134869AAE FOREIGN KEY(REV) REFERENCES PUBLIC.AUDITEVENT(REVISIONNUMBER) NOCHECK;
ALTER TABLE PUBLIC.TERMVOCABULARY_ORIGINALSOURCEBASE ADD CONSTRAINT PUBLIC.FK8F2D512A258E060 FOREIGN KEY(TERMVOCABULARY_ID) REFERENCES PUBLIC.TERMVOCABULARY(ID) NOCHECK;
-ALTER TABLE PUBLIC.GENBANKACCESSION ADD CONSTRAINT PUBLIC.FK86C1DBF84FF2DB2C FOREIGN KEY(CREATEDBY_ID) REFERENCES PUBLIC.USERACCOUNT(ID) NOCHECK;
ALTER TABLE PUBLIC.DESCRIPTIONBASE ADD CONSTRAINT PUBLIC.FKFF4D58CDDE9A3E39 FOREIGN KEY(TAXON_ID) REFERENCES PUBLIC.TAXONBASE(ID) NOCHECK;
ALTER TABLE PUBLIC.NOMENCLATURALSTATUS_MARKER_AUD ADD CONSTRAINT PUBLIC.FK8619495F34869AAE FOREIGN KEY(REV) REFERENCES PUBLIC.AUDITEVENT(REVISIONNUMBER) NOCHECK;
-ALTER TABLE PUBLIC.SEQUENCE_GENBANKACCESSION_AUD ADD CONSTRAINT PUBLIC.FKC717736734869AAE FOREIGN KEY(REV) REFERENCES PUBLIC.AUDITEVENT(REVISIONNUMBER) NOCHECK;
ALTER TABLE PUBLIC.NAMERELATIONSHIP_MARKER ADD CONSTRAINT PUBLIC.FKE3E463967B4CB560 FOREIGN KEY(NAMERELATIONSHIP_ID) REFERENCES PUBLIC.NAMERELATIONSHIP(ID) NOCHECK;
ALTER TABLE PUBLIC.SPECIMENOROBSERVATIONBASE_RIGHTS_AUD ADD CONSTRAINT PUBLIC.FK4168503534869AAE FOREIGN KEY(REV) REFERENCES PUBLIC.AUDITEVENT(REVISIONNUMBER) NOCHECK;
ALTER TABLE PUBLIC.FEATURENODE_DEFINEDTERMBASE_INAPPLICABLEIF_AUD ADD CONSTRAINT PUBLIC.FKB8D7025234869AAE FOREIGN KEY(REV) REFERENCES PUBLIC.AUDITEVENT(REVISIONNUMBER) NOCHECK;