titleCache varchar(255),
createdby_id integer,
updatedby_id integer,
- code varchar(255),
- name varchar(255),
- ispartof_id integer,
nomenclaturaltitle varchar(255),
firstname varchar(255),
lastname varchar(255),
prefix varchar(255),
suffix varchar(255),
protectednomenclaturaltitlecache bit,
+ code varchar(255),
+ name varchar(255),
+ ispartof_id integer,
primary key (id, REV)
);
create table AgentBase_AgentBase (
AgentBase_id integer not null,
- teammembers_id integer not null
+ teammembers_id integer not null,
+ sortIndex integer not null,
+ primary key (AgentBase_id, sortIndex)
);
create table AgentBase_AgentBase_AUD (
REV integer not null,
AgentBase_id integer not null,
teammembers_id integer not null,
+ sortIndex integer not null,
revtype tinyint,
- primary key (REV, AgentBase_id, teammembers_id)
+ primary key (REV, AgentBase_id, teammembers_id, sortIndex)
);
create table AgentBase_Annotation (
primary key (REV, AgentBase_id, annotations_id)
);
+ create table AgentBase_Credit (
+ AgentBase_id integer not null,
+ credits_id integer not null,
+ sortIndex integer not null,
+ primary key (AgentBase_id, sortIndex),
+ unique (credits_id)
+ );
+
+ create table AgentBase_Credit_AUD (
+ REV integer not null,
+ AgentBase_id integer not null,
+ credits_id integer not null,
+ sortIndex integer not null,
+ revtype tinyint,
+ primary key (REV, AgentBase_id, credits_id, sortIndex)
+ );
+
create table AgentBase_DefinedTermBase (
AgentBase_id integer not null,
types_id integer not null,
primary key (REV, Collection_id, annotations_id)
);
+ create table Collection_Credit (
+ Collection_id integer not null,
+ credits_id integer not null,
+ sortIndex integer not null,
+ primary key (Collection_id, sortIndex),
+ unique (credits_id)
+ );
+
+ create table Collection_Credit_AUD (
+ REV integer not null,
+ Collection_id integer not null,
+ credits_id integer not null,
+ sortIndex integer not null,
+ revtype tinyint,
+ primary key (REV, Collection_id, credits_id, sortIndex)
+ );
+
create table Collection_Extension (
Collection_id integer not null,
extensions_id integer not null,
primary key (REV, Collection_id, rights_id)
);
+ create table Credit (
+ id integer not null,
+ created timestamp,
+ uuid varchar(255),
+ updated timestamp,
+ text longvarchar,
+ abbreviatedtext varchar(255),
+ createdby_id integer,
+ updatedby_id integer,
+ language_id integer,
+ agent_id integer,
+ primary key (id)
+ );
+
+ create table Credit_AUD (
+ id integer not null,
+ REV integer not null,
+ revtype tinyint,
+ created timestamp,
+ uuid varchar(255),
+ updated timestamp,
+ text longvarchar,
+ abbreviatedtext varchar(255),
+ createdby_id integer,
+ updatedby_id integer,
+ language_id integer,
+ agent_id integer,
+ primary key (id, REV)
+ );
+
+ create table Credit_Annotation (
+ Credit_id integer not null,
+ annotations_id integer not null,
+ primary key (Credit_id, annotations_id),
+ unique (annotations_id)
+ );
+
+ create table Credit_Annotation_AUD (
+ REV integer not null,
+ Credit_id integer not null,
+ annotations_id integer not null,
+ revtype tinyint,
+ primary key (REV, Credit_id, annotations_id)
+ );
+
+ create table Credit_Marker (
+ Credit_id integer not null,
+ markers_id integer not null,
+ primary key (Credit_id, markers_id),
+ unique (markers_id)
+ );
+
+ create table Credit_Marker_AUD (
+ REV integer not null,
+ Credit_id integer not null,
+ markers_id integer not null,
+ revtype tinyint,
+ primary key (REV, Credit_id, markers_id)
+ );
+
create table DefinedTermBase (
DTYPE varchar(31) not null,
id integer not null,
transitive bit,
defaultcolor varchar(255),
supportscategoricaldata bit,
- supportscommontaxonname bit,
+ supportscommontaxonname bit,
supportsdistribution bit,
supportsindividualassociation bit,
supportsquantitativedata bit,
partof_id integer,
vocabulary_id integer,
orderindex integer,
+ symmetric bit,
+ transitive bit,
pointapproximation_errorradius integer,
pointapproximation_latitude double,
pointapproximation_longitude double,
pointapproximation_referencesystem_id integer,
shape_id integer,
type_id integer,
+ iso3166_a2 varchar(2),
+ iso639_1 varchar(2),
+ iso639_2 varchar(3),
supportscategoricaldata bit,
- supportscommontaxonname bit,
+ supportscommontaxonname bit,
supportsdistribution bit,
supportsindividualassociation bit,
supportsquantitativedata bit,
supportstaxoninteraction bit,
supportstextdata bit,
- iso639_1 varchar(2),
- iso639_2 varchar(3),
- symmetric bit,
- transitive bit,
defaultcolor varchar(255),
- iso3166_a2 varchar(2),
primary key (id, REV)
);
titleCache varchar(255),
createdby_id integer,
updatedby_id integer,
- taxonName_fk integer,
taxon_fk integer,
+ taxonName_fk integer,
primary key (id, REV)
);
primary key (REV, DescriptionBase_id, annotations_id)
);
+ create table DescriptionBase_Credit (
+ DescriptionBase_id integer not null,
+ credits_id integer not null,
+ sortIndex integer not null,
+ primary key (DescriptionBase_id, sortIndex),
+ unique (credits_id)
+ );
+
+ create table DescriptionBase_Credit_AUD (
+ REV integer not null,
+ DescriptionBase_id integer not null,
+ credits_id integer not null,
+ sortIndex integer not null,
+ revtype tinyint,
+ primary key (REV, DescriptionBase_id, credits_id, sortIndex)
+ );
+
create table DescriptionBase_Extension (
DescriptionBase_id integer not null,
extensions_id integer not null,
citation_id integer,
feature_id integer,
indescription_id integer,
+ format_id integer,
area_id integer,
status_id integer,
+ orderrelevant bit,
unit_id integer,
name varchar(255),
language_id integer,
taxon2_id integer,
associatedspecimenorobservation_id integer,
- format_id integer,
- orderrelevant bit,
primary key (id, REV)
);
createdby_id integer,
updatedby_id integer,
representation_id integer,
+ duration integer,
height integer,
width integer,
- duration integer,
primary key (id, REV)
);
primary key (REV, person_fk, keyword_fk)
);
+ create table PublicationBase_Publisher_AUD (
+ REV integer not null,
+ referenceBase_id integer not null,
+ id integer not null,
+ sortIndex integer not null,
+ revtype tinyint,
+ primary key (REV, referenceBase_id, id, sortIndex)
+ );
create table Publisher (
id integer not null,
created timestamp,
uuid varchar(255),
- publishername varchar(255),
place varchar(255),
- referencebase_id integer not null,
- sortindex integer not null,
+ publishername varchar(255),
createdby_id integer,
+ referenceBase_id integer,
+ sortIndex integer,
primary key (id)
);
revtype tinyint,
created timestamp,
uuid varchar(255),
- publishername varchar(255),
place varchar(255),
- referencebase_id integer not null,
- sortindex integer not null,
+ publishername varchar(255),
createdby_id integer,
primary key (id, REV)
);
uri varchar(255),
datepublished_end varchar(255),
datepublished_start varchar(255),
- title varchar(255),
+ title longvarchar,
pages varchar(255),
series varchar(255),
volume varchar(255),
reporttype varchar(255),
school varchar(255),
year varchar(255),
- placepublished varchar(255),
seriespart varchar(255),
isbn varchar(255),
issn varchar(255),
createdby_id integer,
updatedby_id integer,
authorteam_id integer,
+ datepublished_end varchar(255),
+ datepublished_start varchar(255),
+ title longvarchar,
+ school_id integer,
+ pages varchar(255),
+ series varchar(255),
+ institution_id integer,
+ volume varchar(255),
+ injournal_id integer,
+ inproceedings_id integer,
+ editor varchar(255),
+ seriespart varchar(255),
+ inseries_id integer,
+ edition varchar(255),
+ isbn varchar(255),
+ organization varchar(255),
address varchar(255),
annote varchar(255),
booktitle varchar(255),
chapter varchar(255),
- edition varchar(255),
- editor varchar(255),
eprint varchar(255),
howpublished varchar(255),
institution varchar(255),
month varchar(255),
note varchar(255),
number varchar(255),
- organization varchar(255),
- pages varchar(255),
publisher varchar(255),
reporttype varchar(255),
school varchar(255),
- series varchar(255),
- title varchar(255),
- volume varchar(255),
year varchar(255),
crossref_id integer,
type_id integer,
- datepublished_end varchar(255),
- datepublished_start varchar(255),
- inbook_id integer,
- inproceedings_id integer,
- placepublished varchar(255),
- institution_id integer,
- seriespart varchar(255),
- inseries_id integer,
- isbn varchar(255),
- school_id integer,
issn varchar(255),
- injournal_id integer,
+ inbook_id integer,
primary key (id, REV)
);
primary key (REV, ReferenceBase_id, annotations_id)
);
+ create table ReferenceBase_Credit (
+ ReferenceBase_id integer not null,
+ credits_id integer not null,
+ sortIndex integer not null,
+ primary key (ReferenceBase_id, sortIndex),
+ unique (credits_id)
+ );
+
+ create table ReferenceBase_Credit_AUD (
+ REV integer not null,
+ ReferenceBase_id integer not null,
+ credits_id integer not null,
+ sortIndex integer not null,
+ revtype tinyint,
+ primary key (REV, ReferenceBase_id, credits_id, sortIndex)
+ );
+
create table ReferenceBase_Extension (
ReferenceBase_id integer not null,
extensions_id integer not null,
primary key (REV, Sequence_id, annotations_id)
);
+ create table Sequence_Credit (
+ Sequence_id integer not null,
+ credits_id integer not null,
+ sortIndex integer not null,
+ primary key (Sequence_id, sortIndex),
+ unique (credits_id)
+ );
+
+ create table Sequence_Credit_AUD (
+ REV integer not null,
+ Sequence_id integer not null,
+ credits_id integer not null,
+ sortIndex integer not null,
+ revtype tinyint,
+ primary key (REV, Sequence_id, credits_id, sortIndex)
+ );
+
create table Sequence_Extension (
Sequence_id integer not null,
extensions_id integer not null,
primary key (REV, SpecimenOrObservationBase_id, annotations_id)
);
+ create table SpecimenOrObservationBase_Credit (
+ SpecimenOrObservationBase_id integer not null,
+ credits_id integer not null,
+ sortIndex integer not null,
+ primary key (SpecimenOrObservationBase_id, sortIndex),
+ unique (credits_id)
+ );
+
+ create table SpecimenOrObservationBase_Credit_AUD (
+ REV integer not null,
+ SpecimenOrObservationBase_id integer not null,
+ credits_id integer not null,
+ sortIndex integer not null,
+ revtype tinyint,
+ primary key (REV, SpecimenOrObservationBase_id, credits_id, sortIndex)
+ );
+
create table SpecimenOrObservationBase_DerivationEvent (
originals_id integer not null,
derivationevents_id integer not null,
lsid_namespace varchar(255),
lsid_object varchar(255),
lsid_revision varchar(255),
- taxonstatusunknown bit not null,
- protectedtitlecache bit not null,
+ protectedtitlecache bit not null,
titleCache varchar(255),
doubtful bit not null,
+ taxonstatusunknown bit,
taxonomicchildrencount integer,
createdby_id integer,
updatedby_id integer,
lsid_namespace varchar(255),
lsid_object varchar(255),
lsid_revision varchar(255),
- taxonstatusunknown bit not null,
- protectedtitlecache bit,
+ protectedtitlecache bit,
titleCache varchar(255),
doubtful bit,
createdby_id integer,
updatedby_id integer,
taxonName_fk integer,
sec_id integer,
+ taxonstatusunknown bit,
taxonomicchildrencount integer,
taxonomicparentcache_id integer,
primary key (id, REV)
primary key (REV, TaxonBase_id, annotations_id)
);
+ create table TaxonBase_Credit (
+ TaxonBase_id integer not null,
+ credits_id integer not null,
+ sortIndex integer not null,
+ primary key (TaxonBase_id, sortIndex),
+ unique (credits_id)
+ );
+
+ create table TaxonBase_Credit_AUD (
+ REV integer not null,
+ TaxonBase_id integer not null,
+ credits_id integer not null,
+ sortIndex integer not null,
+ revtype tinyint,
+ primary key (REV, TaxonBase_id, credits_id, sortIndex)
+ );
+
create table TaxonBase_Extension (
TaxonBase_id integer not null,
extensions_id integer not null,
combinationauthorteam_id integer,
exbasionymauthorteam_id integer,
excombinationauthorteam_id integer,
- nameapprobation varchar(255),
- subgenusauthorship varchar(255),
+ breed varchar(255),
+ originalpublicationyear integer,
+ publicationyear integer,
anamorphic bit,
binomhybrid bit,
hybridformula bit,
monomhybrid bit,
trinomhybrid bit,
- breed varchar(255),
- originalpublicationyear integer,
- publicationyear integer,
cultivarname varchar(255),
+ nameapprobation varchar(255),
+ subgenusauthorship varchar(255),
primary key (id, REV)
);
primary key (REV, TaxonNameBase_id, annotations_id)
);
+ create table TaxonNameBase_Credit (
+ TaxonNameBase_id integer not null,
+ credits_id integer not null,
+ sortIndex integer not null,
+ primary key (TaxonNameBase_id, sortIndex),
+ unique (credits_id)
+ );
+
+ create table TaxonNameBase_Credit_AUD (
+ REV integer not null,
+ TaxonNameBase_id integer not null,
+ credits_id integer not null,
+ sortIndex integer not null,
+ revtype tinyint,
+ primary key (REV, TaxonNameBase_id, credits_id, sortIndex)
+ );
+
create table TaxonNameBase_Extension (
TaxonNameBase_id integer not null,
extensions_id integer not null,
primary key (REV, TaxonNameBase_id, typedesignations_id)
);
+ create table TaxonNode (
+ id integer not null,
+ created timestamp,
+ uuid varchar(255),
+ updated timestamp,
+ countchildren integer not null,
+ microreferenceforparentchildrelation varchar(255),
+ createdby_id integer,
+ updatedby_id integer,
+ parent_id integer,
+ referenceforparentchildrelation_id integer,
+ synonymtobeused_id integer,
+ taxon_id integer,
+ taxonomicview_id integer,
+ primary key (id)
+ );
+
+ create table TaxonNode_AUD (
+ id integer not null,
+ REV integer not null,
+ revtype tinyint,
+ created timestamp,
+ uuid varchar(255),
+ updated timestamp,
+ countchildren integer,
+ microreferenceforparentchildrelation varchar(255),
+ createdby_id integer,
+ updatedby_id integer,
+ parent_id integer,
+ referenceforparentchildrelation_id integer,
+ synonymtobeused_id integer,
+ taxon_id integer,
+ taxonomicview_id integer,
+ primary key (id, REV)
+ );
+
+ create table TaxonNode_Annotation (
+ TaxonNode_id integer not null,
+ annotations_id integer not null,
+ primary key (TaxonNode_id, annotations_id),
+ unique (annotations_id)
+ );
+
+ create table TaxonNode_Annotation_AUD (
+ REV integer not null,
+ TaxonNode_id integer not null,
+ annotations_id integer not null,
+ revtype tinyint,
+ primary key (REV, TaxonNode_id, annotations_id)
+ );
+
+ create table TaxonNode_Marker (
+ TaxonNode_id integer not null,
+ markers_id integer not null,
+ primary key (TaxonNode_id, markers_id),
+ unique (markers_id)
+ );
+
+ create table TaxonNode_Marker_AUD (
+ REV integer not null,
+ TaxonNode_id integer not null,
+ markers_id integer not null,
+ revtype tinyint,
+ primary key (REV, TaxonNode_id, markers_id)
+ );
+
create table TaxonRelationship (
id integer not null,
created timestamp,
primary key (REV, TaxonRelationship_id, markers_id)
);
- create table TermVocabulary (
- DTYPE varchar(31) not null,
+ create table TaxonomicView (
id integer not null,
created timestamp,
uuid varchar(255),
updated timestamp,
- uri varchar(255),
- termsourceuri varchar(255),
- createdby_id integer,
- updatedby_id integer,
- primary key (id)
- );
-
+ lsid_authority varchar(255),
+ lsid_lsid varchar(255),
+ lsid_namespace varchar(255),
+ lsid_object varchar(255),
+ lsid_revision varchar(255),
+ protectedtitlecache bit not null,
+ titleCache varchar(255),
+ microreference varchar(255),
+ createdby_id integer,
+ updatedby_id integer,
+ name_id integer,
+ reference_id integer,
+ primary key (id)
+ );
+
+ create table TaxonomicView_AUD (
+ id integer not null,
+ REV integer not null,
+ revtype tinyint,
+ created timestamp,
+ uuid varchar(255),
+ updated timestamp,
+ lsid_authority varchar(255),
+ lsid_lsid varchar(255),
+ lsid_namespace varchar(255),
+ lsid_object varchar(255),
+ lsid_revision varchar(255),
+ protectedtitlecache bit,
+ titleCache varchar(255),
+ microreference varchar(255),
+ createdby_id integer,
+ updatedby_id integer,
+ name_id integer,
+ reference_id integer,
+ primary key (id, REV)
+ );
+
+ create table TaxonomicView_Annotation (
+ TaxonomicView_id integer not null,
+ annotations_id integer not null,
+ primary key (TaxonomicView_id, annotations_id),
+ unique (annotations_id)
+ );
+
+ create table TaxonomicView_Annotation_AUD (
+ REV integer not null,
+ TaxonomicView_id integer not null,
+ annotations_id integer not null,
+ revtype tinyint,
+ primary key (REV, TaxonomicView_id, annotations_id)
+ );
+
+ create table TaxonomicView_Credit (
+ TaxonomicView_id integer not null,
+ credits_id integer not null,
+ sortIndex integer not null,
+ primary key (TaxonomicView_id, sortIndex),
+ unique (credits_id)
+ );
+
+ create table TaxonomicView_Credit_AUD (
+ REV integer not null,
+ TaxonomicView_id integer not null,
+ credits_id integer not null,
+ sortIndex integer not null,
+ revtype tinyint,
+ primary key (REV, TaxonomicView_id, credits_id, sortIndex)
+ );
+
+ create table TaxonomicView_Extension (
+ TaxonomicView_id integer not null,
+ extensions_id integer not null,
+ primary key (TaxonomicView_id, extensions_id),
+ unique (extensions_id)
+ );
+
+ create table TaxonomicView_Extension_AUD (
+ REV integer not null,
+ TaxonomicView_id integer not null,
+ extensions_id integer not null,
+ revtype tinyint,
+ primary key (REV, TaxonomicView_id, extensions_id)
+ );
+
+ create table TaxonomicView_Marker (
+ TaxonomicView_id integer not null,
+ markers_id integer not null,
+ primary key (TaxonomicView_id, markers_id),
+ unique (markers_id)
+ );
+
+ create table TaxonomicView_Marker_AUD (
+ REV integer not null,
+ TaxonomicView_id integer not null,
+ markers_id integer not null,
+ revtype tinyint,
+ primary key (REV, TaxonomicView_id, markers_id)
+ );
+
+ create table TaxonomicView_OriginalSource (
+ TaxonomicView_id integer not null,
+ sources_id integer not null,
+ primary key (TaxonomicView_id, sources_id),
+ unique (sources_id)
+ );
+
+ create table TaxonomicView_OriginalSource_AUD (
+ REV integer not null,
+ TaxonomicView_id integer not null,
+ sources_id integer not null,
+ revtype tinyint,
+ primary key (REV, TaxonomicView_id, sources_id)
+ );
+
+ create table TaxonomicView_Rights (
+ TaxonomicView_id integer not null,
+ rights_id integer not null,
+ primary key (TaxonomicView_id, rights_id),
+ unique (rights_id)
+ );
+
+ create table TaxonomicView_Rights_AUD (
+ REV integer not null,
+ TaxonomicView_id integer not null,
+ rights_id integer not null,
+ revtype tinyint,
+ primary key (REV, TaxonomicView_id, rights_id)
+ );
+
+ create table TaxonomicView_TaxonNode (
+ TaxonomicView_id integer not null,
+ rootnodes_id integer not null,
+ primary key (TaxonomicView_id, rootnodes_id),
+ unique (rootnodes_id)
+ );
+
+ create table TaxonomicView_TaxonNode_AUD (
+ REV integer not null,
+ TaxonomicView_id integer not null,
+ rootnodes_id integer not null,
+ revtype tinyint,
+ primary key (REV, TaxonomicView_id, rootnodes_id)
+ );
+
+ create table TermVocabulary (
+ DTYPE varchar(31) not null,
+ id integer not null,
+ created timestamp,
+ uuid varchar(255),
+ updated timestamp,
+ uri varchar(255),
+ termsourceuri varchar(255),
+ createdby_id integer,
+ updatedby_id integer,
+ primary key (id)
+ );
+
create table TermVocabulary_AUD (
DTYPE varchar(31) not null,
id integer not null,
foreign key (REV)
references AuditEvent;
+ alter table AgentBase_Credit
+ add constraint FK2636742286EFC5D4
+ foreign key (AgentBase_id)
+ references AgentBase;
+
+ alter table AgentBase_Credit
+ add constraint FK2636742232D1B9F
+ foreign key (credits_id)
+ references Credit;
+
+ alter table AgentBase_Credit_AUD
+ add constraint FK7FE7C0F334869AAE
+ foreign key (REV)
+ references AuditEvent;
+
alter table AgentBase_DefinedTermBase
add constraint FK6665C77D9A161BED
foreign key (types_id)
foreign key (REV)
references AuditEvent;
+ alter table Collection_Credit
+ add constraint FKE0A317BAEB62BE9A
+ foreign key (Collection_id)
+ references Collection;
+
+ alter table Collection_Credit
+ add constraint FKE0A317BA32D1B9F
+ foreign key (credits_id)
+ references Credit;
+
+ alter table Collection_Credit_AUD
+ add constraint FK25A8D88B34869AAE
+ foreign key (REV)
+ references AuditEvent;
+
alter table Collection_Extension
add constraint FKF68FEBDE927DE9DF
foreign key (extensions_id)
foreign key (REV)
references AuditEvent;
+ alter table Credit
+ add constraint FK78CA9719F7976FC5
+ foreign key (agent_id)
+ references AgentBase;
+
+ alter table Credit
+ add constraint FK78CA97194FF2DB2C
+ foreign key (createdby_id)
+ references User;
+
+ alter table Credit
+ add constraint FK78CA9719BC5DA539
+ foreign key (updatedby_id)
+ references User;
+
+ alter table Credit
+ add constraint FK78CA9719E8D36B00
+ foreign key (language_id)
+ references DefinedTermBase;
+
+ alter table Credit_AUD
+ add constraint FK5533906A34869AAE
+ foreign key (REV)
+ references AuditEvent;
+
+ alter table Credit_Annotation
+ add constraint FKE8DA4C354CF694E0
+ foreign key (Credit_id)
+ references Credit;
+
+ alter table Credit_Annotation
+ add constraint FKE8DA4C351E403E0B
+ foreign key (annotations_id)
+ references Annotation;
+
+ alter table Credit_Annotation_AUD
+ add constraint FK1DEB578634869AAE
+ foreign key (REV)
+ references AuditEvent;
+
+ alter table Credit_Marker
+ add constraint FK10CC68404CF694E0
+ foreign key (Credit_id)
+ references Credit;
+
+ alter table Credit_Marker
+ add constraint FK10CC6840777265A1
+ foreign key (markers_id)
+ references Marker;
+
+ alter table Credit_Marker_AUD
+ add constraint FK880A761134869AAE
+ foreign key (REV)
+ references AuditEvent;
+
alter table DefinedTermBase
add constraint FK2E340A6636C6F6F6
foreign key (pointapproximation_referencesystem_id)
foreign key (REV)
references AuditEvent;
+ alter table DescriptionBase_Credit
+ add constraint FK510B2ACBF1DDBFAB
+ foreign key (DescriptionBase_id)
+ references DescriptionBase;
+
+ alter table DescriptionBase_Credit
+ add constraint FK510B2ACB32D1B9F
+ foreign key (credits_id)
+ references Credit;
+
+ alter table DescriptionBase_Credit_AUD
+ add constraint FK2EBEFB1C34869AAE
+ foreign key (REV)
+ references AuditEvent;
+
alter table DescriptionBase_Extension
add constraint FKD5D2B32DF1DDBFAB
foreign key (DescriptionBase_id)
foreign key (REV)
references AuditEvent;
+ alter table PublicationBase_Publisher_AUD
+ add constraint FK5B9D3EB34869AAE
+ foreign key (REV)
+ references AuditEvent;
+
+ alter table Publisher
+ add constraint FKCDB7C1DC4FF2DB2C
+ foreign key (createdby_id)
+ references User;
+
+ alter table Publisher
+ add constraint FKCDB7C1DC5DEF25BB
+ foreign key (referenceBase_id)
+ references ReferenceBase;
+
+ alter table Publisher_AUD
+ add constraint FKC637A1AD34869AAE
+ foreign key (REV)
+ references AuditEvent;
+
create index ReferenceBaseTitleCacheIndex on ReferenceBase (titleCache);
alter table ReferenceBase
foreign key (REV)
references AuditEvent;
+ alter table ReferenceBase_Credit
+ add constraint FK5861201CF443DB5A
+ foreign key (ReferenceBase_id)
+ references ReferenceBase;
+
+ alter table ReferenceBase_Credit
+ add constraint FK5861201C32D1B9F
+ foreign key (credits_id)
+ references Credit;
+
+ alter table ReferenceBase_Credit_AUD
+ add constraint FK487DFED34869AAE
+ foreign key (REV)
+ references AuditEvent;
+
alter table ReferenceBase_Extension
add constraint FK81E1703C927DE9DF
foreign key (extensions_id)
foreign key (REV)
references AuditEvent;
+ alter table Sequence_Credit
+ add constraint FK2CFBC93732D1B9F
+ foreign key (credits_id)
+ references Credit;
+
+ alter table Sequence_Credit
+ add constraint FK2CFBC937D57FFDD5
+ foreign key (Sequence_id)
+ references Sequence;
+
+ alter table Sequence_Credit_AUD
+ add constraint FK4B22838834869AAE
+ foreign key (REV)
+ references AuditEvent;
+
alter table Sequence_Extension
add constraint FK7BE66D41927DE9DF
foreign key (extensions_id)
foreign key (REV)
references AuditEvent;
+ alter table SpecimenOrObservationBase_Credit
+ add constraint FK7E3A1D863B8A5ABA
+ foreign key (SpecimenOrObservationBase_id)
+ references SpecimenOrObservationBase;
+
+ alter table SpecimenOrObservationBase_Credit
+ add constraint FK7E3A1D8632D1B9F
+ foreign key (credits_id)
+ references Credit;
+
+ alter table SpecimenOrObservationBase_Credit_AUD
+ add constraint FK7170185734869AAE
+ foreign key (REV)
+ references AuditEvent;
+
alter table SpecimenOrObservationBase_DerivationEvent
add constraint FK20132036BD59A1AD
foreign key (derivationevents_id)
foreign key (REV)
references AuditEvent;
+ alter table TaxonBase_Credit
+ add constraint FK4CB48B3D32D1B9F
+ foreign key (credits_id)
+ references Credit;
+
+ alter table TaxonBase_Credit
+ add constraint FK4CB48B3D9C9D39
+ foreign key (TaxonBase_id)
+ references TaxonBase;
+
+ alter table TaxonBase_Credit_AUD
+ add constraint FK7CFED28E34869AAE
+ foreign key (REV)
+ references AuditEvent;
+
alter table TaxonBase_Extension
add constraint FKF961257B927DE9DF
foreign key (extensions_id)
foreign key (REV)
references AuditEvent;
+ alter table TaxonNameBase_Credit
+ add constraint FK29BCD8B232D1B9F
+ foreign key (credits_id)
+ references Credit;
+
+ alter table TaxonNameBase_Credit
+ add constraint FK29BCD8B28C85CF94
+ foreign key (TaxonNameBase_id)
+ references TaxonNameBase;
+
+ alter table TaxonNameBase_Credit_AUD
+ add constraint FKD9895D8334869AAE
+ foreign key (REV)
+ references AuditEvent;
+
alter table TaxonNameBase_Extension
add constraint FKC28EE7E6927DE9DF
foreign key (extensions_id)
foreign key (REV)
references AuditEvent;
+ alter table TaxonNode
+ add constraint FK924F5BCC4FF2DB2C
+ foreign key (createdby_id)
+ references User;
+
+ alter table TaxonNode
+ add constraint FK924F5BCCDE9A3E39
+ foreign key (taxon_id)
+ references TaxonBase;
+
+ alter table TaxonNode
+ add constraint FK924F5BCCCC05993E
+ foreign key (synonymtobeused_id)
+ references TaxonBase;
+
+ alter table TaxonNode
+ add constraint FK924F5BCCD019B239
+ foreign key (taxonomicview_id)
+ references TaxonomicView;
+
+ alter table TaxonNode
+ add constraint FK924F5BCC215EDF26
+ foreign key (referenceforparentchildrelation_id)
+ references ReferenceBase;
+
+ alter table TaxonNode
+ add constraint FK924F5BCC39DB2DFB
+ foreign key (parent_id)
+ references TaxonNode;
+
+ alter table TaxonNode
+ add constraint FK924F5BCCBC5DA539
+ foreign key (updatedby_id)
+ references User;
+
+ alter table TaxonNode_AUD
+ add constraint FKE090C39D34869AAE
+ foreign key (REV)
+ references AuditEvent;
+
+ alter table TaxonNode_Annotation
+ add constraint FKD8A9A9A2927D8399
+ foreign key (TaxonNode_id)
+ references TaxonNode;
+
+ alter table TaxonNode_Annotation
+ add constraint FKD8A9A9A21E403E0B
+ foreign key (annotations_id)
+ references Annotation;
+
+ alter table TaxonNode_Annotation_AUD
+ add constraint FKB2C4367334869AAE
+ foreign key (REV)
+ references AuditEvent;
+
+ alter table TaxonNode_Marker
+ add constraint FK395842D777265A1
+ foreign key (markers_id)
+ references Marker;
+
+ alter table TaxonNode_Marker
+ add constraint FK395842D927D8399
+ foreign key (TaxonNode_id)
+ references TaxonNode;
+
+ alter table TaxonNode_Marker_AUD
+ add constraint FK77D9D37E34869AAE
+ foreign key (REV)
+ references AuditEvent;
+
alter table TaxonRelationship
add constraint FK7482BA02E71EF6CE
foreign key (relatedfrom_id)
foreign key (REV)
references AuditEvent;
+ alter table TaxonomicView
+ add constraint FKE333A2E7765B124B
+ foreign key (reference_id)
+ references ReferenceBase;
+
+ alter table TaxonomicView
+ add constraint FKE333A2E74FF2DB2C
+ foreign key (createdby_id)
+ references User;
+
+ alter table TaxonomicView
+ add constraint FKE333A2E777E2F09E
+ foreign key (name_id)
+ references LanguageString;
+
+ alter table TaxonomicView
+ add constraint FKE333A2E7BC5DA539
+ foreign key (updatedby_id)
+ references User;
+
+ alter table TaxonomicView_AUD
+ add constraint FK976053834869AAE
+ foreign key (REV)
+ references AuditEvent;
+
+ alter table TaxonomicView_Annotation
+ add constraint FKE5DF73A7D019B239
+ foreign key (TaxonomicView_id)
+ references TaxonomicView;
+
+ alter table TaxonomicView_Annotation
+ add constraint FKE5DF73A71E403E0B
+ foreign key (annotations_id)
+ references Annotation;
+
+ alter table TaxonomicView_Annotation_AUD
+ add constraint FK3C4B75F834869AAE
+ foreign key (REV)
+ references AuditEvent;
+
+ alter table TaxonomicView_Credit
+ add constraint FK23C2F71D019B239
+ foreign key (TaxonomicView_id)
+ references TaxonomicView;
+
+ alter table TaxonomicView_Credit
+ add constraint FK23C2F7132D1B9F
+ foreign key (credits_id)
+ references Credit;
+
+ alter table TaxonomicView_Credit_AUD
+ add constraint FK20F13CC234869AAE
+ foreign key (REV)
+ references AuditEvent;
+
+ alter table TaxonomicView_Extension
+ add constraint FKCD1EA4C7927DE9DF
+ foreign key (extensions_id)
+ references Extension;
+
+ alter table TaxonomicView_Extension
+ add constraint FKCD1EA4C7D019B239
+ foreign key (TaxonomicView_id)
+ references TaxonomicView;
+
+ alter table TaxonomicView_Extension_AUD
+ add constraint FK204D171834869AAE
+ foreign key (REV)
+ references AuditEvent;
+
+ alter table TaxonomicView_Marker
+ add constraint FK126318B2D019B239
+ foreign key (TaxonomicView_id)
+ references TaxonomicView;
+
+ alter table TaxonomicView_Marker
+ add constraint FK126318B2777265A1
+ foreign key (markers_id)
+ references Marker;
+
+ alter table TaxonomicView_Marker_AUD
+ add constraint FK850F9D8334869AAE
+ foreign key (REV)
+ references AuditEvent;
+
+ alter table TaxonomicView_OriginalSource
+ add constraint FK447A09C43BAB2414
+ foreign key (sources_id)
+ references OriginalSource;
+
+ alter table TaxonomicView_OriginalSource
+ add constraint FK447A09C4D019B239
+ foreign key (TaxonomicView_id)
+ references TaxonomicView;
+
+ alter table TaxonomicView_OriginalSource_AUD
+ add constraint FK143B59534869AAE
+ foreign key (REV)
+ references AuditEvent;
+
+ alter table TaxonomicView_Rights
+ add constraint FK1B57064FD019B239
+ foreign key (TaxonomicView_id)
+ references TaxonomicView;
+
+ alter table TaxonomicView_Rights
+ add constraint FK1B57064FC13F7B21
+ foreign key (rights_id)
+ references Rights;
+
+ alter table TaxonomicView_Rights_AUD
+ add constraint FKF0E974A034869AAE
+ foreign key (REV)
+ references AuditEvent;
+
+ alter table TaxonomicView_TaxonNode
+ add constraint FKC7EC474D019B239
+ foreign key (TaxonomicView_id)
+ references TaxonomicView;
+
+ alter table TaxonomicView_TaxonNode
+ add constraint FKC7EC47418929176
+ foreign key (rootnodes_id)
+ references TaxonNode;
+
+ alter table TaxonomicView_TaxonNode_AUD
+ add constraint FK6E0B984534869AAE
+ foreign key (REV)
+ references AuditEvent;
+
alter table TermVocabulary
add constraint FK487AA6924FF2DB2C
foreign key (createdby_id)
AGENTBASE_CONTACT_PHONENUMBERS_AUD*,
AGENTBASE_CONTACT_URLS*,
AGENTBASE_CONTACT_URLS_AUD*,
+ AGENTBASE_CREDIT*,
+ AGENTBASE_CREDIT_AUD*,
AGENTBASE_DEFINEDTERMBASE*,
AGENTBASE_DEFINEDTERMBASE_AUD*,
AGENTBASE_EXTENSION*,
COLLECTION_ANNOTATION*,
COLLECTION_ANNOTATION_AUD*,
COLLECTION_AUD*,
+ COLLECTION_CREDIT*,
+ COLLECTION_CREDIT_AUD*,
COLLECTION_EXTENSION*,
COLLECTION_EXTENSION_AUD*,
COLLECTION_MARKER*,
COLLECTION_ORIGINALSOURCE_AUD*,
COLLECTION_RIGHTS*,
COLLECTION_RIGHTS_AUD*,
+ CREDIT*,
+ CREDIT_ANNOTATION*,
+ CREDIT_ANNOTATION_AUD*,
+ CREDIT_AUD*,
+ CREDIT_MARKER*,
+ CREDIT_MARKER_AUD*,
DB_VERSION*,
DEFINEDTERMBASE*,
DEFINEDTERMBASE_AUD*,
DESCRIPTIONBASE_ANNOTATION*,
DESCRIPTIONBASE_ANNOTATION_AUD*,
DESCRIPTIONBASE_AUD*,
+ DESCRIPTIONBASE_CREDIT*,
+ DESCRIPTIONBASE_CREDIT_AUD*,
DESCRIPTIONBASE_EXTENSION*,
DESCRIPTIONBASE_EXTENSION_AUD*,
DESCRIPTIONBASE_FEATURE*,
PERMISSIONGROUP_GRANTEDAUTHORITYIMPL*,
PERSON_KEYWORD*,
PERSON_KEYWORD_AUD*,
+ PUBLICATIONBASE_PUBLISHER_AUD*,
+ PUBLISHER*,
+ PUBLISHER_AUD*,
REFERENCEBASE*,
REFERENCEBASE_ANNOTATION*,
REFERENCEBASE_ANNOTATION_AUD*,
REFERENCEBASE_AUD*,
+ REFERENCEBASE_CREDIT*,
+ REFERENCEBASE_CREDIT_AUD*,
REFERENCEBASE_EXTENSION*,
REFERENCEBASE_EXTENSION_AUD*,
REFERENCEBASE_MARKER*,
SEQUENCE_ANNOTATION*,
SEQUENCE_ANNOTATION_AUD*,
SEQUENCE_AUD*,
+ SEQUENCE_CREDIT*,
+ SEQUENCE_CREDIT_AUD*,
SEQUENCE_EXTENSION*,
SEQUENCE_EXTENSION_AUD*,
SEQUENCE_GENBANKACCESSION*,
SPECIMENOROBSERVATIONBASE_ANNOTATION*,
SPECIMENOROBSERVATIONBASE_ANNOTATION_AUD*,
SPECIMENOROBSERVATIONBASE_AUD*,
+ SPECIMENOROBSERVATIONBASE_CREDIT*,
+ SPECIMENOROBSERVATIONBASE_CREDIT_AUD*,
SPECIMENOROBSERVATIONBASE_DERIVATIONEVENT*,
SPECIMENOROBSERVATIONBASE_DERIVATIONEVENT_AUD*,
SPECIMENOROBSERVATIONBASE_EXTENSION*,
TAXONBASE_ANNOTATION*,
TAXONBASE_ANNOTATION_AUD*,
TAXONBASE_AUD*,
+ TAXONBASE_CREDIT*,
+ TAXONBASE_CREDIT_AUD*,
TAXONBASE_EXTENSION*,
TAXONBASE_EXTENSION_AUD*,
TAXONBASE_MARKER*,
TAXONNAMEBASE_ANNOTATION*,
TAXONNAMEBASE_ANNOTATION_AUD*,
TAXONNAMEBASE_AUD*,
+ TAXONNAMEBASE_CREDIT*,
+ TAXONNAMEBASE_CREDIT_AUD*,
TAXONNAMEBASE_EXTENSION*,
TAXONNAMEBASE_EXTENSION_AUD*,
TAXONNAMEBASE_HYBRIDRELATIONSHIP*,
TAXONNAMEBASE_RIGHTS_AUD*,
TAXONNAMEBASE_TYPEDESIGNATIONBASE*,
TAXONNAMEBASE_TYPEDESIGNATIONBASE_AUD*,
+ TAXONNODE*,
+ TAXONNODE_ANNOTATION*,
+ TAXONNODE_ANNOTATION_AUD*,
+ TAXONNODE_AUD*,
+ TAXONNODE_MARKER*,
+ TAXONNODE_MARKER_AUD*,
+ TAXONOMICVIEW*,
+ TAXONOMICVIEW_ANNOTATION*,
+ TAXONOMICVIEW_ANNOTATION_AUD*,
+ TAXONOMICVIEW_AUD*,
+ TAXONOMICVIEW_CREDIT*,
+ TAXONOMICVIEW_CREDIT_AUD*,
+ TAXONOMICVIEW_EXTENSION*,
+ TAXONOMICVIEW_EXTENSION_AUD*,
+ TAXONOMICVIEW_MARKER*,
+ TAXONOMICVIEW_MARKER_AUD*,
+ TAXONOMICVIEW_ORIGINALSOURCE*,
+ TAXONOMICVIEW_ORIGINALSOURCE_AUD*,
+ TAXONOMICVIEW_RIGHTS*,
+ TAXONOMICVIEW_RIGHTS_AUD*,
+ TAXONOMICVIEW_TAXONNODE*,
+ TAXONOMICVIEW_TAXONNODE_AUD*,
TAXONRELATIONSHIP*,
TAXONRELATIONSHIP_ANNOTATION*,
TAXONRELATIONSHIP_ANNOTATION_AUD*,
<!ELEMENT AGENTBASE_AGENTBASE EMPTY>
<!ATTLIST AGENTBASE_AGENTBASE
- AGENTBASE_ID CDATA #IMPLIED
+ AGENTBASE_ID CDATA #REQUIRED
TEAMMEMBERS_ID CDATA #IMPLIED
+ SORTINDEX CDATA #REQUIRED
>
<!ELEMENT AGENTBASE_AGENTBASE_AUD EMPTY>
REV CDATA #REQUIRED
AGENTBASE_ID CDATA #REQUIRED
TEAMMEMBERS_ID CDATA #REQUIRED
+ SORTINDEX CDATA #REQUIRED
REVTYPE CDATA #IMPLIED
>
TITLECACHE CDATA #IMPLIED
CREATEDBY_ID CDATA #IMPLIED
UPDATEDBY_ID CDATA #IMPLIED
- CODE CDATA #IMPLIED
- NAME CDATA #IMPLIED
- ISPARTOF_ID CDATA #IMPLIED
NOMENCLATURALTITLE CDATA #IMPLIED
FIRSTNAME CDATA #IMPLIED
LASTNAME CDATA #IMPLIED
PREFIX CDATA #IMPLIED
SUFFIX CDATA #IMPLIED
PROTECTEDNOMENCLATURALTITLECACHE CDATA #IMPLIED
+ CODE CDATA #IMPLIED
+ NAME CDATA #IMPLIED
+ ISPARTOF_ID CDATA #IMPLIED
>
<!ELEMENT AGENTBASE_CONTACT_EMAILADDRESSES EMPTY>
REVTYPE CDATA #IMPLIED
>
+<!ELEMENT AGENTBASE_CREDIT EMPTY>
+<!ATTLIST AGENTBASE_CREDIT
+ AGENTBASE_ID CDATA #REQUIRED
+ CREDITS_ID CDATA #IMPLIED
+ SORTINDEX CDATA #REQUIRED
+>
+
+<!ELEMENT AGENTBASE_CREDIT_AUD EMPTY>
+<!ATTLIST AGENTBASE_CREDIT_AUD
+ REV CDATA #REQUIRED
+ AGENTBASE_ID CDATA #REQUIRED
+ CREDITS_ID CDATA #REQUIRED
+ SORTINDEX CDATA #REQUIRED
+ REVTYPE CDATA #IMPLIED
+>
+
<!ELEMENT AGENTBASE_DEFINEDTERMBASE EMPTY>
<!ATTLIST AGENTBASE_DEFINEDTERMBASE
AGENTBASE_ID CDATA #REQUIRED
SUPERCOLLECTION_ID CDATA #IMPLIED
>
+<!ELEMENT COLLECTION_CREDIT EMPTY>
+<!ATTLIST COLLECTION_CREDIT
+ COLLECTION_ID CDATA #REQUIRED
+ CREDITS_ID CDATA #IMPLIED
+ SORTINDEX CDATA #REQUIRED
+>
+
+<!ELEMENT COLLECTION_CREDIT_AUD EMPTY>
+<!ATTLIST COLLECTION_CREDIT_AUD
+ REV CDATA #REQUIRED
+ COLLECTION_ID CDATA #REQUIRED
+ CREDITS_ID CDATA #REQUIRED
+ SORTINDEX CDATA #REQUIRED
+ REVTYPE CDATA #IMPLIED
+>
+
<!ELEMENT COLLECTION_EXTENSION EMPTY>
<!ATTLIST COLLECTION_EXTENSION
COLLECTION_ID CDATA #REQUIRED
REVTYPE CDATA #IMPLIED
>
+<!ELEMENT CREDIT EMPTY>
+<!ATTLIST CREDIT
+ ID CDATA #REQUIRED
+ CREATED CDATA #IMPLIED
+ UUID CDATA #IMPLIED
+ UPDATED CDATA #IMPLIED
+ TEXT CDATA #IMPLIED
+ ABBREVIATEDTEXT CDATA #IMPLIED
+ CREATEDBY_ID CDATA #IMPLIED
+ UPDATEDBY_ID CDATA #IMPLIED
+ LANGUAGE_ID CDATA #IMPLIED
+ AGENT_ID CDATA #IMPLIED
+>
+
+<!ELEMENT CREDIT_ANNOTATION EMPTY>
+<!ATTLIST CREDIT_ANNOTATION
+ CREDIT_ID CDATA #REQUIRED
+ ANNOTATIONS_ID CDATA #REQUIRED
+>
+
+<!ELEMENT CREDIT_ANNOTATION_AUD EMPTY>
+<!ATTLIST CREDIT_ANNOTATION_AUD
+ REV CDATA #REQUIRED
+ CREDIT_ID CDATA #REQUIRED
+ ANNOTATIONS_ID CDATA #REQUIRED
+ REVTYPE CDATA #IMPLIED
+>
+
+<!ELEMENT CREDIT_AUD EMPTY>
+<!ATTLIST CREDIT_AUD
+ ID CDATA #REQUIRED
+ REV CDATA #REQUIRED
+ REVTYPE CDATA #IMPLIED
+ CREATED CDATA #IMPLIED
+ UUID CDATA #IMPLIED
+ UPDATED CDATA #IMPLIED
+ TEXT CDATA #IMPLIED
+ ABBREVIATEDTEXT CDATA #IMPLIED
+ CREATEDBY_ID CDATA #IMPLIED
+ UPDATEDBY_ID CDATA #IMPLIED
+ LANGUAGE_ID CDATA #IMPLIED
+ AGENT_ID CDATA #IMPLIED
+>
+
+<!ELEMENT CREDIT_MARKER EMPTY>
+<!ATTLIST CREDIT_MARKER
+ CREDIT_ID CDATA #REQUIRED
+ MARKERS_ID CDATA #REQUIRED
+>
+
+<!ELEMENT CREDIT_MARKER_AUD EMPTY>
+<!ATTLIST CREDIT_MARKER_AUD
+ REV CDATA #REQUIRED
+ CREDIT_ID CDATA #REQUIRED
+ MARKERS_ID CDATA #REQUIRED
+ REVTYPE CDATA #IMPLIED
+>
+
<!ELEMENT DB_VERSION EMPTY>
<!ATTLIST DB_VERSION
VERSION_INDEX CDATA #IMPLIED
SYMMETRIC CDATA #IMPLIED
TRANSITIVE CDATA #IMPLIED
DEFAULTCOLOR CDATA #IMPLIED
+ SUPPORTSCATEGORICALDATA CDATA #IMPLIED
SUPPORTSCOMMONTAXONNAME CDATA #IMPLIED
SUPPORTSDISTRIBUTION CDATA #IMPLIED
SUPPORTSINDIVIDUALASSOCIATION CDATA #IMPLIED
- SUPPORTSCATEGORICALDATA CDATA #IMPLIED
SUPPORTSQUANTITATIVEDATA CDATA #IMPLIED
SUPPORTSTAXONINTERACTION CDATA #IMPLIED
SUPPORTSTEXTDATA CDATA #IMPLIED
PARTOF_ID CDATA #IMPLIED
VOCABULARY_ID CDATA #IMPLIED
ORDERINDEX CDATA #IMPLIED
+ SYMMETRIC CDATA #IMPLIED
+ TRANSITIVE CDATA #IMPLIED
POINTAPPROXIMATION_ERRORRADIUS CDATA #IMPLIED
POINTAPPROXIMATION_LATITUDE CDATA #IMPLIED
POINTAPPROXIMATION_LONGITUDE CDATA #IMPLIED
POINTAPPROXIMATION_REFERENCESYSTEM_ID CDATA #IMPLIED
SHAPE_ID CDATA #IMPLIED
TYPE_ID CDATA #IMPLIED
+ ISO3166_A2 CDATA #IMPLIED
+ ISO639_1 CDATA #IMPLIED
+ ISO639_2 CDATA #IMPLIED
+ SUPPORTSCATEGORICALDATA CDATA #IMPLIED
SUPPORTSCOMMONTAXONNAME CDATA #IMPLIED
SUPPORTSDISTRIBUTION CDATA #IMPLIED
SUPPORTSINDIVIDUALASSOCIATION CDATA #IMPLIED
SUPPORTSQUANTITATIVEDATA CDATA #IMPLIED
SUPPORTSTAXONINTERACTION CDATA #IMPLIED
SUPPORTSTEXTDATA CDATA #IMPLIED
- ISO639_1 CDATA #IMPLIED
- ISO639_2 CDATA #IMPLIED
- SYMMETRIC CDATA #IMPLIED
- TRANSITIVE CDATA #IMPLIED
DEFAULTCOLOR CDATA #IMPLIED
- ISO3166_A2 CDATA #IMPLIED
>
<!ELEMENT DEFINEDTERMBASE_CONTINENT EMPTY>
TITLECACHE CDATA #IMPLIED
CREATEDBY_ID CDATA #IMPLIED
UPDATEDBY_ID CDATA #IMPLIED
- TAXONNAME_FK CDATA #IMPLIED
TAXON_FK CDATA #IMPLIED
+ TAXONNAME_FK CDATA #IMPLIED
+>
+
+<!ELEMENT DESCRIPTIONBASE_CREDIT EMPTY>
+<!ATTLIST DESCRIPTIONBASE_CREDIT
+ DESCRIPTIONBASE_ID CDATA #REQUIRED
+ CREDITS_ID CDATA #IMPLIED
+ SORTINDEX CDATA #REQUIRED
+>
+
+<!ELEMENT DESCRIPTIONBASE_CREDIT_AUD EMPTY>
+<!ATTLIST DESCRIPTIONBASE_CREDIT_AUD
+ REV CDATA #REQUIRED
+ DESCRIPTIONBASE_ID CDATA #REQUIRED
+ CREDITS_ID CDATA #REQUIRED
+ SORTINDEX CDATA #REQUIRED
+ REVTYPE CDATA #IMPLIED
>
<!ELEMENT DESCRIPTIONBASE_EXTENSION EMPTY>
CITATION_ID CDATA #IMPLIED
FEATURE_ID CDATA #IMPLIED
INDESCRIPTION_ID CDATA #IMPLIED
+ FORMAT_ID CDATA #IMPLIED
AREA_ID CDATA #IMPLIED
STATUS_ID CDATA #IMPLIED
+ ORDERRELEVANT CDATA #IMPLIED
UNIT_ID CDATA #IMPLIED
NAME CDATA #IMPLIED
LANGUAGE_ID CDATA #IMPLIED
TAXON2_ID CDATA #IMPLIED
ASSOCIATEDSPECIMENOROBSERVATION_ID CDATA #IMPLIED
- FORMAT_ID CDATA #IMPLIED
- ORDERRELEVANT CDATA #IMPLIED
>
<!ELEMENT DESCRIPTIONELEMENTBASE_LANGUAGESTRING EMPTY>
CREATEDBY_ID CDATA #IMPLIED
UPDATEDBY_ID CDATA #IMPLIED
REPRESENTATION_ID CDATA #IMPLIED
+ DURATION CDATA #IMPLIED
HEIGHT CDATA #IMPLIED
WIDTH CDATA #IMPLIED
- DURATION CDATA #IMPLIED
>
<!ELEMENT MEDIAREPRESENTATION_AUD EMPTY>
REVTYPE CDATA #IMPLIED
>
+<!ELEMENT PUBLICATIONBASE_PUBLISHER_AUD EMPTY>
+<!ATTLIST PUBLICATIONBASE_PUBLISHER_AUD
+ REV CDATA #REQUIRED
+ REFERENCEBASE_ID CDATA #REQUIRED
+ ID CDATA #REQUIRED
+ SORTINDEX CDATA #REQUIRED
+ REVTYPE CDATA #IMPLIED
+>
+
+<!ELEMENT PUBLISHER EMPTY>
+<!ATTLIST PUBLISHER
+ ID CDATA #REQUIRED
+ CREATED CDATA #IMPLIED
+ UUID CDATA #IMPLIED
+ PLACE CDATA #IMPLIED
+ PUBLISHERNAME CDATA #IMPLIED
+ CREATEDBY_ID CDATA #IMPLIED
+ REFERENCEBASE_ID CDATA #IMPLIED
+ SORTINDEX CDATA #IMPLIED
+>
+
+<!ELEMENT PUBLISHER_AUD EMPTY>
+<!ATTLIST PUBLISHER_AUD
+ ID CDATA #REQUIRED
+ REV CDATA #REQUIRED
+ REVTYPE CDATA #IMPLIED
+ CREATED CDATA #IMPLIED
+ UUID CDATA #IMPLIED
+ PLACE CDATA #IMPLIED
+ PUBLISHERNAME CDATA #IMPLIED
+ CREATEDBY_ID CDATA #IMPLIED
+>
+
<!ELEMENT REFERENCEBASE EMPTY>
<!ATTLIST REFERENCEBASE
DTYPE CDATA #IMPLIED
REPORTTYPE CDATA #IMPLIED
SCHOOL CDATA #IMPLIED
YEAR CDATA #IMPLIED
- PLACEPUBLISHED CDATA #IMPLIED
SERIESPART CDATA #IMPLIED
ISBN CDATA #IMPLIED
ISSN CDATA #IMPLIED
CREATEDBY_ID CDATA #IMPLIED
UPDATEDBY_ID CDATA #IMPLIED
AUTHORTEAM_ID CDATA #IMPLIED
+ DATEPUBLISHED_END CDATA #IMPLIED
+ DATEPUBLISHED_START CDATA #IMPLIED
+ TITLE CDATA #IMPLIED
+ SCHOOL_ID CDATA #IMPLIED
+ PAGES CDATA #IMPLIED
+ SERIES CDATA #IMPLIED
+ INSTITUTION_ID CDATA #IMPLIED
+ VOLUME CDATA #IMPLIED
+ INJOURNAL_ID CDATA #IMPLIED
+ INPROCEEDINGS_ID CDATA #IMPLIED
+ EDITOR CDATA #IMPLIED
+ SERIESPART CDATA #IMPLIED
+ INSERIES_ID CDATA #IMPLIED
+ EDITION CDATA #IMPLIED
+ ISBN CDATA #IMPLIED
+ ORGANIZATION CDATA #IMPLIED
ADDRESS CDATA #IMPLIED
ANNOTE CDATA #IMPLIED
BOOKTITLE CDATA #IMPLIED
CHAPTER CDATA #IMPLIED
- EDITION CDATA #IMPLIED
- EDITOR CDATA #IMPLIED
EPRINT CDATA #IMPLIED
HOWPUBLISHED CDATA #IMPLIED
INSTITUTION CDATA #IMPLIED
MONTH CDATA #IMPLIED
NOTE CDATA #IMPLIED
NUMBER CDATA #IMPLIED
- ORGANIZATION CDATA #IMPLIED
- PAGES CDATA #IMPLIED
PUBLISHER CDATA #IMPLIED
REPORTTYPE CDATA #IMPLIED
SCHOOL CDATA #IMPLIED
- SERIES CDATA #IMPLIED
- TITLE CDATA #IMPLIED
- VOLUME CDATA #IMPLIED
YEAR CDATA #IMPLIED
CROSSREF_ID CDATA #IMPLIED
TYPE_ID CDATA #IMPLIED
- DATEPUBLISHED_END CDATA #IMPLIED
- DATEPUBLISHED_START CDATA #IMPLIED
- INBOOK_ID CDATA #IMPLIED
- INPROCEEDINGS_ID CDATA #IMPLIED
- PLACEPUBLISHED CDATA #IMPLIED
- INSTITUTION_ID CDATA #IMPLIED
- SERIESPART CDATA #IMPLIED
- INSERIES_ID CDATA #IMPLIED
- ISBN CDATA #IMPLIED
- SCHOOL_ID CDATA #IMPLIED
ISSN CDATA #IMPLIED
- INJOURNAL_ID CDATA #IMPLIED
+ INBOOK_ID CDATA #IMPLIED
+>
+
+<!ELEMENT REFERENCEBASE_CREDIT EMPTY>
+<!ATTLIST REFERENCEBASE_CREDIT
+ REFERENCEBASE_ID CDATA #REQUIRED
+ CREDITS_ID CDATA #IMPLIED
+ SORTINDEX CDATA #REQUIRED
+>
+
+<!ELEMENT REFERENCEBASE_CREDIT_AUD EMPTY>
+<!ATTLIST REFERENCEBASE_CREDIT_AUD
+ REV CDATA #REQUIRED
+ REFERENCEBASE_ID CDATA #REQUIRED
+ CREDITS_ID CDATA #REQUIRED
+ SORTINDEX CDATA #REQUIRED
+ REVTYPE CDATA #IMPLIED
>
<!ELEMENT REFERENCEBASE_EXTENSION EMPTY>
PUBLISHEDIN_ID CDATA #IMPLIED
>
+<!ELEMENT SEQUENCE_CREDIT EMPTY>
+<!ATTLIST SEQUENCE_CREDIT
+ SEQUENCE_ID CDATA #REQUIRED
+ CREDITS_ID CDATA #IMPLIED
+ SORTINDEX CDATA #REQUIRED
+>
+
+<!ELEMENT SEQUENCE_CREDIT_AUD EMPTY>
+<!ATTLIST SEQUENCE_CREDIT_AUD
+ REV CDATA #REQUIRED
+ SEQUENCE_ID CDATA #REQUIRED
+ CREDITS_ID CDATA #REQUIRED
+ SORTINDEX CDATA #REQUIRED
+ REVTYPE CDATA #IMPLIED
+>
+
<!ELEMENT SEQUENCE_EXTENSION EMPTY>
<!ATTLIST SEQUENCE_EXTENSION
SEQUENCE_ID CDATA #REQUIRED
PRESERVATION_ID CDATA #IMPLIED
>
+<!ELEMENT SPECIMENOROBSERVATIONBASE_CREDIT EMPTY>
+<!ATTLIST SPECIMENOROBSERVATIONBASE_CREDIT
+ SPECIMENOROBSERVATIONBASE_ID CDATA #REQUIRED
+ CREDITS_ID CDATA #IMPLIED
+ SORTINDEX CDATA #REQUIRED
+>
+
+<!ELEMENT SPECIMENOROBSERVATIONBASE_CREDIT_AUD EMPTY>
+<!ATTLIST SPECIMENOROBSERVATIONBASE_CREDIT_AUD
+ REV CDATA #REQUIRED
+ SPECIMENOROBSERVATIONBASE_ID CDATA #REQUIRED
+ CREDITS_ID CDATA #REQUIRED
+ SORTINDEX CDATA #REQUIRED
+ REVTYPE CDATA #IMPLIED
+>
+
<!ELEMENT SPECIMENOROBSERVATIONBASE_DERIVATIONEVENT EMPTY>
<!ATTLIST SPECIMENOROBSERVATIONBASE_DERIVATIONEVENT
ORIGINALS_ID CDATA #REQUIRED
LSID_NAMESPACE CDATA #IMPLIED
LSID_OBJECT CDATA #IMPLIED
LSID_REVISION CDATA #IMPLIED
- TAXONSTATUSUNKNOWN CDATA #IMPLIED
PROTECTEDTITLECACHE CDATA #IMPLIED
TITLECACHE CDATA #IMPLIED
DOUBTFUL CDATA #IMPLIED
+ TAXONSTATUSUNKNOWN CDATA #IMPLIED
TAXONOMICCHILDRENCOUNT CDATA #IMPLIED
CREATEDBY_ID CDATA #IMPLIED
UPDATEDBY_ID CDATA #IMPLIED
UPDATEDBY_ID CDATA #IMPLIED
TAXONNAME_FK CDATA #IMPLIED
SEC_ID CDATA #IMPLIED
+ TAXONSTATUSUNKNOWN CDATA #IMPLIED
TAXONOMICCHILDRENCOUNT CDATA #IMPLIED
TAXONOMICPARENTCACHE_ID CDATA #IMPLIED
>
+<!ELEMENT TAXONBASE_CREDIT EMPTY>
+<!ATTLIST TAXONBASE_CREDIT
+ TAXONBASE_ID CDATA #REQUIRED
+ CREDITS_ID CDATA #IMPLIED
+ SORTINDEX CDATA #REQUIRED
+>
+
+<!ELEMENT TAXONBASE_CREDIT_AUD EMPTY>
+<!ATTLIST TAXONBASE_CREDIT_AUD
+ REV CDATA #REQUIRED
+ TAXONBASE_ID CDATA #REQUIRED
+ CREDITS_ID CDATA #REQUIRED
+ SORTINDEX CDATA #REQUIRED
+ REVTYPE CDATA #IMPLIED
+>
+
<!ELEMENT TAXONBASE_EXTENSION EMPTY>
<!ATTLIST TAXONBASE_EXTENSION
TAXONBASE_ID CDATA #REQUIRED
COMBINATIONAUTHORTEAM_ID CDATA #IMPLIED
EXBASIONYMAUTHORTEAM_ID CDATA #IMPLIED
EXCOMBINATIONAUTHORTEAM_ID CDATA #IMPLIED
- NAMEAPPROBATION CDATA #IMPLIED
- SUBGENUSAUTHORSHIP CDATA #IMPLIED
+ BREED CDATA #IMPLIED
+ ORIGINALPUBLICATIONYEAR CDATA #IMPLIED
+ PUBLICATIONYEAR CDATA #IMPLIED
ANAMORPHIC CDATA #IMPLIED
BINOMHYBRID CDATA #IMPLIED
HYBRIDFORMULA CDATA #IMPLIED
MONOMHYBRID CDATA #IMPLIED
TRINOMHYBRID CDATA #IMPLIED
- BREED CDATA #IMPLIED
- ORIGINALPUBLICATIONYEAR CDATA #IMPLIED
- PUBLICATIONYEAR CDATA #IMPLIED
CULTIVARNAME CDATA #IMPLIED
+ NAMEAPPROBATION CDATA #IMPLIED
+ SUBGENUSAUTHORSHIP CDATA #IMPLIED
+>
+
+<!ELEMENT TAXONNAMEBASE_CREDIT EMPTY>
+<!ATTLIST TAXONNAMEBASE_CREDIT
+ TAXONNAMEBASE_ID CDATA #REQUIRED
+ CREDITS_ID CDATA #IMPLIED
+ SORTINDEX CDATA #REQUIRED
+>
+
+<!ELEMENT TAXONNAMEBASE_CREDIT_AUD EMPTY>
+<!ATTLIST TAXONNAMEBASE_CREDIT_AUD
+ REV CDATA #REQUIRED
+ TAXONNAMEBASE_ID CDATA #REQUIRED
+ CREDITS_ID CDATA #REQUIRED
+ SORTINDEX CDATA #REQUIRED
+ REVTYPE CDATA #IMPLIED
>
<!ELEMENT TAXONNAMEBASE_EXTENSION EMPTY>
REVTYPE CDATA #IMPLIED
>
+<!ELEMENT TAXONNODE EMPTY>
+<!ATTLIST TAXONNODE
+ ID CDATA #REQUIRED
+ CREATED CDATA #IMPLIED
+ UUID CDATA #IMPLIED
+ UPDATED CDATA #IMPLIED
+ COUNTCHILDREN CDATA #IMPLIED
+ MICROREFERENCEFORPARENTCHILDRELATION CDATA #IMPLIED
+ CREATEDBY_ID CDATA #IMPLIED
+ UPDATEDBY_ID CDATA #IMPLIED
+ PARENT_ID CDATA #IMPLIED
+ REFERENCEFORPARENTCHILDRELATION_ID CDATA #IMPLIED
+ SYNONYMTOBEUSED_ID CDATA #IMPLIED
+ TAXON_ID CDATA #IMPLIED
+ TAXONOMICVIEW_ID CDATA #IMPLIED
+>
+
+<!ELEMENT TAXONNODE_ANNOTATION EMPTY>
+<!ATTLIST TAXONNODE_ANNOTATION
+ TAXONNODE_ID CDATA #REQUIRED
+ ANNOTATIONS_ID CDATA #REQUIRED
+>
+
+<!ELEMENT TAXONNODE_ANNOTATION_AUD EMPTY>
+<!ATTLIST TAXONNODE_ANNOTATION_AUD
+ REV CDATA #REQUIRED
+ TAXONNODE_ID CDATA #REQUIRED
+ ANNOTATIONS_ID CDATA #REQUIRED
+ REVTYPE CDATA #IMPLIED
+>
+
+<!ELEMENT TAXONNODE_AUD EMPTY>
+<!ATTLIST TAXONNODE_AUD
+ ID CDATA #REQUIRED
+ REV CDATA #REQUIRED
+ REVTYPE CDATA #IMPLIED
+ CREATED CDATA #IMPLIED
+ UUID CDATA #IMPLIED
+ UPDATED CDATA #IMPLIED
+ COUNTCHILDREN CDATA #IMPLIED
+ MICROREFERENCEFORPARENTCHILDRELATION CDATA #IMPLIED
+ CREATEDBY_ID CDATA #IMPLIED
+ UPDATEDBY_ID CDATA #IMPLIED
+ PARENT_ID CDATA #IMPLIED
+ REFERENCEFORPARENTCHILDRELATION_ID CDATA #IMPLIED
+ SYNONYMTOBEUSED_ID CDATA #IMPLIED
+ TAXON_ID CDATA #IMPLIED
+ TAXONOMICVIEW_ID CDATA #IMPLIED
+>
+
+<!ELEMENT TAXONNODE_MARKER EMPTY>
+<!ATTLIST TAXONNODE_MARKER
+ TAXONNODE_ID CDATA #REQUIRED
+ MARKERS_ID CDATA #REQUIRED
+>
+
+<!ELEMENT TAXONNODE_MARKER_AUD EMPTY>
+<!ATTLIST TAXONNODE_MARKER_AUD
+ REV CDATA #REQUIRED
+ TAXONNODE_ID CDATA #REQUIRED
+ MARKERS_ID CDATA #REQUIRED
+ REVTYPE CDATA #IMPLIED
+>
+
+<!ELEMENT TAXONOMICVIEW EMPTY>
+<!ATTLIST TAXONOMICVIEW
+ ID CDATA #REQUIRED
+ CREATED CDATA #IMPLIED
+ UUID CDATA #IMPLIED
+ UPDATED CDATA #IMPLIED
+ LSID_AUTHORITY CDATA #IMPLIED
+ LSID_LSID CDATA #IMPLIED
+ LSID_NAMESPACE CDATA #IMPLIED
+ LSID_OBJECT CDATA #IMPLIED
+ LSID_REVISION CDATA #IMPLIED
+ PROTECTEDTITLECACHE CDATA #IMPLIED
+ TITLECACHE CDATA #IMPLIED
+ MICROREFERENCE CDATA #IMPLIED
+ CREATEDBY_ID CDATA #IMPLIED
+ UPDATEDBY_ID CDATA #IMPLIED
+ NAME_ID CDATA #IMPLIED
+ REFERENCE_ID CDATA #IMPLIED
+>
+
+<!ELEMENT TAXONOMICVIEW_ANNOTATION EMPTY>
+<!ATTLIST TAXONOMICVIEW_ANNOTATION
+ TAXONOMICVIEW_ID CDATA #REQUIRED
+ ANNOTATIONS_ID CDATA #REQUIRED
+>
+
+<!ELEMENT TAXONOMICVIEW_ANNOTATION_AUD EMPTY>
+<!ATTLIST TAXONOMICVIEW_ANNOTATION_AUD
+ REV CDATA #REQUIRED
+ TAXONOMICVIEW_ID CDATA #REQUIRED
+ ANNOTATIONS_ID CDATA #REQUIRED
+ REVTYPE CDATA #IMPLIED
+>
+
+<!ELEMENT TAXONOMICVIEW_AUD EMPTY>
+<!ATTLIST TAXONOMICVIEW_AUD
+ ID CDATA #REQUIRED
+ REV CDATA #REQUIRED
+ REVTYPE CDATA #IMPLIED
+ CREATED CDATA #IMPLIED
+ UUID CDATA #IMPLIED
+ UPDATED CDATA #IMPLIED
+ LSID_AUTHORITY CDATA #IMPLIED
+ LSID_LSID CDATA #IMPLIED
+ LSID_NAMESPACE CDATA #IMPLIED
+ LSID_OBJECT CDATA #IMPLIED
+ LSID_REVISION CDATA #IMPLIED
+ PROTECTEDTITLECACHE CDATA #IMPLIED
+ TITLECACHE CDATA #IMPLIED
+ MICROREFERENCE CDATA #IMPLIED
+ CREATEDBY_ID CDATA #IMPLIED
+ UPDATEDBY_ID CDATA #IMPLIED
+ NAME_ID CDATA #IMPLIED
+ REFERENCE_ID CDATA #IMPLIED
+>
+
+<!ELEMENT TAXONOMICVIEW_CREDIT EMPTY>
+<!ATTLIST TAXONOMICVIEW_CREDIT
+ TAXONOMICVIEW_ID CDATA #REQUIRED
+ CREDITS_ID CDATA #IMPLIED
+ SORTINDEX CDATA #REQUIRED
+>
+
+<!ELEMENT TAXONOMICVIEW_CREDIT_AUD EMPTY>
+<!ATTLIST TAXONOMICVIEW_CREDIT_AUD
+ REV CDATA #REQUIRED
+ TAXONOMICVIEW_ID CDATA #REQUIRED
+ CREDITS_ID CDATA #REQUIRED
+ SORTINDEX CDATA #REQUIRED
+ REVTYPE CDATA #IMPLIED
+>
+
+<!ELEMENT TAXONOMICVIEW_EXTENSION EMPTY>
+<!ATTLIST TAXONOMICVIEW_EXTENSION
+ TAXONOMICVIEW_ID CDATA #REQUIRED
+ EXTENSIONS_ID CDATA #REQUIRED
+>
+
+<!ELEMENT TAXONOMICVIEW_EXTENSION_AUD EMPTY>
+<!ATTLIST TAXONOMICVIEW_EXTENSION_AUD
+ REV CDATA #REQUIRED
+ TAXONOMICVIEW_ID CDATA #REQUIRED
+ EXTENSIONS_ID CDATA #REQUIRED
+ REVTYPE CDATA #IMPLIED
+>
+
+<!ELEMENT TAXONOMICVIEW_MARKER EMPTY>
+<!ATTLIST TAXONOMICVIEW_MARKER
+ TAXONOMICVIEW_ID CDATA #REQUIRED
+ MARKERS_ID CDATA #REQUIRED
+>
+
+<!ELEMENT TAXONOMICVIEW_MARKER_AUD EMPTY>
+<!ATTLIST TAXONOMICVIEW_MARKER_AUD
+ REV CDATA #REQUIRED
+ TAXONOMICVIEW_ID CDATA #REQUIRED
+ MARKERS_ID CDATA #REQUIRED
+ REVTYPE CDATA #IMPLIED
+>
+
+<!ELEMENT TAXONOMICVIEW_ORIGINALSOURCE EMPTY>
+<!ATTLIST TAXONOMICVIEW_ORIGINALSOURCE
+ TAXONOMICVIEW_ID CDATA #REQUIRED
+ SOURCES_ID CDATA #REQUIRED
+>
+
+<!ELEMENT TAXONOMICVIEW_ORIGINALSOURCE_AUD EMPTY>
+<!ATTLIST TAXONOMICVIEW_ORIGINALSOURCE_AUD
+ REV CDATA #REQUIRED
+ TAXONOMICVIEW_ID CDATA #REQUIRED
+ SOURCES_ID CDATA #REQUIRED
+ REVTYPE CDATA #IMPLIED
+>
+
+<!ELEMENT TAXONOMICVIEW_RIGHTS EMPTY>
+<!ATTLIST TAXONOMICVIEW_RIGHTS
+ TAXONOMICVIEW_ID CDATA #REQUIRED
+ RIGHTS_ID CDATA #REQUIRED
+>
+
+<!ELEMENT TAXONOMICVIEW_RIGHTS_AUD EMPTY>
+<!ATTLIST TAXONOMICVIEW_RIGHTS_AUD
+ REV CDATA #REQUIRED
+ TAXONOMICVIEW_ID CDATA #REQUIRED
+ RIGHTS_ID CDATA #REQUIRED
+ REVTYPE CDATA #IMPLIED
+>
+
+<!ELEMENT TAXONOMICVIEW_TAXONNODE EMPTY>
+<!ATTLIST TAXONOMICVIEW_TAXONNODE
+ TAXONOMICVIEW_ID CDATA #REQUIRED
+ ROOTNODES_ID CDATA #REQUIRED
+>
+
+<!ELEMENT TAXONOMICVIEW_TAXONNODE_AUD EMPTY>
+<!ATTLIST TAXONOMICVIEW_TAXONNODE_AUD
+ REV CDATA #REQUIRED
+ TAXONOMICVIEW_ID CDATA #REQUIRED
+ ROOTNODES_ID CDATA #REQUIRED
+ REVTYPE CDATA #IMPLIED
+>
+
<!ELEMENT TAXONRELATIONSHIP EMPTY>
<!ATTLIST TAXONRELATIONSHIP
ID CDATA #REQUIRED