class CollectingEvent(Record):
field_number = Column("StationFieldNumber")
collecting_date = Column("StartDate")
gear = Column("Method")
locality = ForeignKey("LocalityID")
trip = ForeignKey("CollectingTripID")
@source_table("collector",
order_by="OrderNumber",
parent_field="CollectingEventID")
class Collector(Record):
agent = ForeignKey("AgentID")
class Preparation(Record):
preparer = ForeignKey("PreparedByID")
prep_date = Column("PreparedDate")
prep_type = Column(["PrepTypeID", "Name"])
count = Column("CountAmt")
tubes = Column("Number1", process=to_int)
used_up = Column("YesNo1")
storage = Column("Text1")
class CollectionObject(Record):
catalog_number = Column("CatalogNumber")
cataloged_date = Column("CatalogedDate")
preservation = Column(["CollectionObjectAttributeID", "Text10"])
tissue_type = Column(["CollectionObjectAttributeID", "Text12"])
size = Column(["CollectionObjectAttributeID", "Text11"])
sex = Column(["CollectionObjectAttributeID", "Text8"])
cataloger = ForeignKey("CatalogerID")
accession = ForeignKey("AccessionID")
collecting_event = ForeignKey("CollectingEventID")
#voucher = Column("collectionreltype")
@source_table("determination", parent_field="CollectionObjectID")
class Determination(Record):
determiner = ForeignKey("DeterminerID")
determination_date = Column("DeterminedDate")
type_status = Column("TypeStatusName")
taxon = ForeignKey("TaxonID")
@source_table("preparation", parent_field="CollectionObjectID")
class Preparation(Record):
preparer = ForeignKey("PreparedByID")
prep_date = Column("PreparedDate")
prep_type = Column(["PrepTypeID", "Name"])
count = Column("CountAmt")
tubes = Column("Number1", process=to_int)
used_up = Column("YesNo1")
storage = Column("Text1")
@source_table("dnasequence", parent_field="CollectionObjectID")
class DNASequence(Record):
bold_barcode_id = Column("BOLDBarcodeID")
molecule_type = Column("MoleculeType")
genbank_accession_number = Column("GenBankAccessionNumber")
gene_sequence = Column("GeneSequence")
total_residues = Column("TotalResidues")
comp_a = Column("CompA")
comp_c = Column("CompC")
comp_g = Column("CompG")
comp_t = Column("compT")
ambiguous_residues = Column("AmbiguousResidues")
sequenced_by = ForeignKey("AgentID")
class DNASequence(Record):
bold_barcode_id = Column("BOLDBarcodeID")
molecule_type = Column("MoleculeType")
genbank_accession_number = Column("GenBankAccessionNumber")
gene_sequence = Column("GeneSequence")
total_residues = Column("TotalResidues")
comp_a = Column("CompA")
comp_c = Column("CompC")
comp_g = Column("CompG")
comp_t = Column("compT")
ambiguous_residues = Column("AmbiguousResidues")
sequenced_by = ForeignKey("AgentID")
class Locality(Record):
name = Column("LocalityName")
geography = ForeignKey("GeographyID")
water_type = Column("ElevationMethod")
locality_detail = ReverseJoin('localitydetail', "LocalityID")
section = Column([locality_detail, "Section"])
township = Column([locality_detail, "Township"])
range = Column([locality_detail, "RangeDesc"])
island = Column([locality_detail, "Island"])
island_group = Column([locality_detail, "IslandGroup"])
water_body = Column([locality_detail, "WaterBody"])
drainage = Column([locality_detail, "Drainage"])
class CollectionObject(Record):
catalog_number = Column("CatalogNumber")
cataloged_date = Column("CatalogedDate")
size = Column(["CollectionObjectAttributeID", "Text11"])
sex = Column(["CollectionObjectAttributeID", "Text8"])
weight = Column(["CollectionObjectAttributeID", "Text2"])
cataloger = ForeignKey("CatalogerID")
accession = ForeignKey("AccessionID")
collecting_event = ForeignKey("CollectingEventID")
@source_table("determination", parent_field="CollectionObjectID")
class Determination(Record):
determiner = ForeignKey("DeterminerID")
determination_date = Column("DeterminedDate")
type_status = Column("TypeStatusName")
taxon = ForeignKey("TaxonID")
@source_table("preparation", parent_field="CollectionObjectID")
class Preparation(Record):
preparer = ForeignKey("PreparedByID")
prep_date = Column("PreparedDate")
prep_type = Column(["PrepTypeID", "Name"])
count = Column("CountAmt")
class ReferenceWork(Record):
type_of_work = Enum(
"ReferenceWorkType",
'Book ElectronicMedia Paper TechnicalReport Thesis SectionInBook'),
title = Column("Title")
publisher = Column("Publisher")
place_of_publication = Column("PlaceOfPublication")
volume = Column("Volume")
pages = Column("Pages")
date_of_work = Column("WorkDate")
url = Column("URL")
journal = ForeignKey("JournalID")
@source_table("author",
order_by="OrderNumber",
parent_field="ReferenceWorkID")
class Author(Record):
agent = ForeignKey("AgentID")
class Geography(Sp6Tree(treedef_table="geographytreedef", treedef_id=1)):
accepted = ForeignKey("AcceptedID")
class AccessionAgent(Record):
agent = ForeignKey("AgentID")
role = Column("Role")
class Author(Record):
agent = ForeignKey("AgentID")
class Taxon(Sp6Tree(treedef_table="taxontreedef", treedef_id=1)):
common_name = Column("CommonName")
source = Column("Source")
protected_status = Column("EnvironmentalProtectionStatus")
author = Column("Author")
accepted = ForeignKey("AcceptedID")
class Determination(Record):
determiner = ForeignKey("DeterminerID")
determination_date = Column("DeterminedDate")
type_status = Column("TypeStatusName")
taxon = ForeignKey("TaxonID")
class Preparation(Record):
preparer = ForeignKey("PreparedByID")
prep_date = Column("PreparedDate")
prep_type = Column(["PrepTypeID", "Name"])
count = Column("CountAmt")
class Collector(Record):
agent = ForeignKey("AgentID")