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")