Table Name: Accn Table Column Name Table Column Attribute Definition ----------------- --------------------------------- Transaction_id Primary identifier for the Accn. Accn_Type Accn_Type_name that describes accession. Indicates how the material was acquired by the Museum. Rule: IN ("Gift", "Purchased", "Salvaged", "MVZ_trip", "Found in Museum"). Accn_Num_Prefix Prefix associated with an accession number. Accn_Num Acc_Num that identifies accession; the visible filing number for an accession (transaction). Accn_Num_Suffix Suffix associated with an accession number. Received_Date Date of receipt for accession. String to accommodate fuzzy dates. Accn_Status The current status of the accession. Rule: IN ("in process", "complete") Table Name: Accn_Coll_Event Table Column Name Table Column Attribute Definition ----------------- --------------------------------- Collecting_Event_id Transaction_id Table Name: Accn_Collector Table Column Name Table Column Attribute Definition ----------------- --------------------------------- Agent_id Foreign key to the Agent table. Fieldnotes_fg Flag to show whether the agent has field notes for specimens in this accession. Transaction_id Foreign key to the Accn table. Table Name: Accn_Taxonomy Table Column Name Table Column Attribute Definition ----------------- --------------------------------- Taxon_Name_id Accn_Taxon_Order An attribute by which the taxa for an accession can be sorted (e.g., phylogenetically). Transaction_id Table Name: Addr Table Column Name Table Column Attribute Definition ----------------- --------------------------------- Addr_id The primary identifier of Address. Street_Addr1 First line of the Street Address that belongs to Address. Street_Addr2 Second line of the Street Address that belongs to Address. City The name of the City that contains Address. State State that contains Address; abbreviation for a US or Canadian State, or a fully spelled out state name. Zip The zip code for an address (may include international zipcodes). Country_Cde State that contains Address; the abbreviation or a fully spelled out country name. Mail_Stop A code used internally within a large organization to speed mail sorting and delivery to departments and offices. Formatted_Addr Allows a user to concatenate elements of an address, and format it the way it should appear as an address label, and then save it. (Does not include Org or Person name.) Table Name: Agent Table Column Name Table Column Attribute Definition ----------------- --------------------------------- Agent_id The primary identifier of Agent. Agent_Type The subtype designation for this Agent. Agent_Remarks Ad-hoc remarks for this agent. Preferred_Agent_Name_id Foreign key to the preferred agent name for the agent. Table Name: Agent_Addr Table Column Name Table Column Attribute Definition ----------------- --------------------------------- Addr_id Address that is used by Agent_Addr. Job_Title Job_Title that describes Agent_Addr. A person has a job title only in association with an organization. E.g., Curator, Collection Manager, Keeper, Assistant Professor. Agent_Addr_Current_fg Indicates whether Agent_Addr is current or not. Agent_Addr_Remarks Ad-hoc remarks for this Agent_Addr. Agent_Addr_id The primary identifier of Agent_Addr. Agent_Addr_Type The type of address this record contains (e.g. "home", "mailing"). Agent_id The person (if any) whose address this is. Table Name: Agent_Name Table Column Name Table Column Attribute Definition ----------------- --------------------------------- Agent_Name_Type The type of name this record represents (e.g. "aka","married name", "maiden name", "abbreviation", "acronym") Donor_Card_Present_fg Shows whether a name in this form appears in the donor index catalog. Agent_Name One form of the various names for the given agent. Agent_id The foreign key to the Agent to which this name refers. Agent_Name_id The identifying key for the given Agent_Name. Table Name: Agent_Name_Role Table Column Name Table Column Attribute Definition ----------------- --------------------------------- Agent_Name_id The Agent_Name that exhibits this role. Agent_Name_Role_Type A role in which an agent's name may be cast (e.g. curatorial assistant, curatorial associate, guest). Table Name: Agent_Relations Table Column Name Table Column Attribute Definition ----------------- --------------------------------- Related_Agent_id The object agent in a relationship between agents. Agent_Relationship The type of relationship between the subject and object agents (e.g. Agent_id "married to" Related_Agent_id). The inverse relationship should also exist, as should the identity relationship. Agent_id The subject agent in a relationship between agents. Table Name: Biol_Indiv Table Column Name Table Column Attribute Definition ----------------- --------------------------------- Numeric_Age_Units Units of the numeric age given for a biological individual. Numeric_Age The age of an individual, expressed as an integer. (Units are not assumed and must be entered in the Number_Age_Units field). Weight The value part of the expression of weight for an individual. Weight_Units The units associated with Weight. Verbatim_Preservation_Date The date on which a specimen was killed or preserved. Biological_Individual_Type A classification variable indicating the subtype of the Biol_Indiv. Rule: IN ('M' for mammal, 'B' for bird, 'H' for herp, 'F' for fish) Collection_Object_id Age_Class The age of an individual, expressed as an age class (e.g, embryo, larva, pouch young, nestling, juvenile, sub-adult, adult). Sex_Cde Indicates sex of individual. Rule: IN("male", "female", "unknown") varchar(10) allows for these to be spelled out. Sex_Cde_Mod Sex code modifier for Biological Individual. Contains qualifiers (modifier) of sex code, e.g., '?'. Table Name: Biol_Indiv_Relations Table Column Name Table Column Attribute Definition ----------------- --------------------------------- Related_Coll_Object_id The foreign key to the Biol_Indiv to which this Biol_Indiv is related. Biol_Indiv_Relationship The relationship between the subject and object biological individuals (e.g. Collection_Object_id "mother of" Related_Coll_Object_id). The inverse relationship should also exist, as should the identity relationship. Collection_Object_id Table Name: Biol_Indiv_Remark Table Column Name Table Column Attribute Definition ----------------- --------------------------------- Age_Remarks Remarks associated with the age fields of Biol_Indiv. Age_Det_Method Indicated what features were used to determine the age class of an individual. (Particularly important for birds.) Stomach_Cont A description of stomach contents. Applies to descriptions made in field or subsequently from retained stomach contents. Does not indicate that stomach contents were retained. (see specimen part). Measurements Remarks associated with the measurement fields of Biol_Indiv or its subtypes. Collection_Object_id Repro_Data Remarks associated with the reproductive status of the biological individual. Sex_Det_Method A description of the method used to determine the sex of the individual. Sex_Remarks Remarks associated with the sex of the biological individual. Table Name: Biol_Indiv_to_Phantom_Reln Table Column Name Table Column Attribute Definition ----------------- --------------------------------- Biol_Indiv_Relationship The relationship between a collected biological individual and a biological individual observed, but not collected. Collection_Object_id Phantom_Biol_Indiv_id The observed, but uncollected biological individual in a relationship between a collected biological individual and a biological individual observed, but not collected. Table Name: Bird Table Column Name Table Column Attribute Definition ----------------- --------------------------------- Fat_Deposition Remarks associated with fat (deposit) for this bird. Molt_Condition Remarks associated with molt condition. Colors Unrestricted remarks on plumage colors. Collection_Object_id Tape_Recording_fg Flag to indicate presence of Tape_id for this bird. Associated_Egg_Nest_id Foreign key an Egg/Nest with which this bird is associated. Table Name: Book Table Column Name Table Column Attribute Definition ----------------- --------------------------------- Publication_id The primary identifier of the book. Edited_Work_fg Indicates whether Book is edited work or not. Volume_Number The volume number of a publication. Stored an an integer; output styles may be complicated (e.g., roman numeral representations). Page_Total Page_Total of Book, as it will be printed. May contain both roman and arabic numerals. Publisher_Name The name of the Publisher. Should also include City. (Alternatively, could use Agent_Address, but Address entity curently requires street address, not needed for citation of Publisher.) Table Name: Book_Section Table Column Name Table Column Attribute Definition ----------------- --------------------------------- Publication_id The primary identifier of this Book Section. Book_id The book of which this section is a part Book_Section_Type The type of book section (e.g., field notebook section, book chapter). Begins_Page_Number First Page_Number of Book_Section. Ends_Page_Number Last Page_Number of Book_Section. Book_Section_Order The numerical position of the Book Section among the sections in a Book. Table Name: Borrow Table Column Name Table Column Attribute Definition ----------------- --------------------------------- Transaction_id The primery identifier of this borrow (transaction). Lenders_Trans_Num_Cde Lenders_Trans_Num_cde that Lender uses to identify a Borrow on paper. Borrow_Num Borrow_Num that identifies a Borrow on paper. Lenders_Invoice_Returned_fg Flag to indicate that MVZ has signed and returned the lender's invoice for Transaction_id. Received_Date Date of receipt for Borrow. Due_Date Date that Borrow is due on. Lenders_Loan_Date The date on the paper work sent by the lender. Sometimes helps to identify a Borrow Transaction. Borrow_Status Indicates the current status of the Borrow. Rule: IN ("open", "partially returned", "returned") Lenders_Instructions Any special instructions issued by the lender for the care, handling, permissions, and shipping of the borrowed material. Table Name: Cataloged_Item Table Column Name Table Column Attribute Definition ----------------- --------------------------------- Collection_Cde A code or name designating a separate series of catalog numbers within an institution. Rule: IN ("Mamm", "Bird", "Corr", "Herp", "Egg", "Hild", "Film", "FC", "Vocal", "Tape", "Img", "Page"). Collecting_Event_id Collecting event that produced cataloged item. Cataloged_Item_Type Indicates the subtype that this Cataloged Item represents. Examples: 'M' for Model, 'EN' for Egg/Nest, 'Bl' for Biological Individual, 'IS' for Image Subject, 'T' for Tape, 'VS' for Vocal Series. Security_Cde An integer code denoting security measures to take when presenting data for this cataloged_item (e.g., 0 = 'none', 1 = 'specimen', 2 = 'locality', 3 = 'collectors', etc.). Collection_Object_id Accepted_Identification_id The currently accepted taxonomic identification for this Cataloged_Item. This field does not exist as a foreign key relationship to Identification because it would cause an illegal cycle. Cat_Num Part of a visible unique key that identifies a cataloged item (not the primary key of Collection Object). Combination of collection_cde and catalog_number must be unique for all cataloged items. Accn_id Accession that contains Collection_Object. Table Name: Cataloged_Item_Remark Table Column Name Table Column Attribute Definition ----------------- --------------------------------- Taxir_Coll_Name The combined values for various collector name fields as they were stored in TAXIR. Taxir_Remarks_Verbatim The remark field as stored in TAXIR. Collection_Object_id Table Name: Citation Table Column Name Table Column Attribute Definition ----------------- --------------------------------- Type_Status Taxonomic_Type_Status that is conferred upon a "specimen" by a Citation. Rule: Type_Status and Taxon_Name_id must either both contain values or both must be empty. Occurs_Page_Number Page_number that contains beginning of Citation. Citation_Remarks Remarks that describe Citation. Citation_Text Meant to be a the full text of the citation as a publishable reference. rep_Published_Year This is a denormalized field from Publication. Publication_id The publication in which this citation occurs. Cit_Current_fg Indicates whether Citation affecting the type status of the taxon name is most current or not. Collection_Object_id Cited_Taxon_Name_id The identifier of the taxon name in the lexicon wich is represented in this citation. Used only when the citation is a type citation. Table Name: Coll_Obj_Other_ID_Num Table Column Name Table Column Attribute Definition ----------------- --------------------------------- Other_ID_Type Indicates nature (origin) of other id number; e.g., catalog number. Uses standard codes. Collection_Object_id Other_ID_Num Additional ID numbers applied to a collection object. Typically a previous catalog number. Used to cross-reference old number when new number is assigned. Table Name: Coll_Object Table Column Name Table Column Attribute Definition ----------------- --------------------------------- Lot_Count The number of individuals in a specimen lot, or the number of copies of an image in a given medium that exist in the collection. Duplicates must have the same Image_Subject; they must be made from the same source. Coll_Obj_Disposition Indicates current disposition of collection object. Last_Edit_Date Date of last edit for collection object. Barcode_id Condition A description of the latest documented condition of the Image_Object. Flags This field can be used to flag Coll Objects. The intention is to have a single letter code to represent each flag (e.g., 'S' could signify Coll Objects with suspect dispositions). Coll_Object_Type The subtype designation for this Coll_Object. Controlled by ctColl_Object_Type. Collection_Object_id Last_Edited_Person_id Person who last edited Coll_Object. Entered_Person_id Person_id who entered Coll_Object. Coll_Object_Entered_Date Date of entry for collection object. Table Name: Coll_Object_Habitat Table Column Name Table Column Attribute Definition ----------------- --------------------------------- Habitat Ad-hoc remarks associated with microhabitat for the collection object. Habitat for the locality under with an object is collected should be recorded in Colecting_Event.Habitat. Collection_Object_id Foreign key to the collection object to which this habitat refers. Table Name: Coll_Object_Remark Table Column Name Table Column Attribute Definition ----------------- --------------------------------- Disposition_Remarks Remarks explaining the disposition of the collection object. Coll_Object_Remarks Remarks associated with a Collection Object. For Images, these should be remarks concerning the physical Image_Object. Remarks concerning the image subject matter should be placed in the related Image_Subject remarks field. Collection_Object_id Table Name: Collecting_Event Table Column Name Table Column Attribute Definition ----------------- --------------------------------- Collecting_Event_id The primary identifier of Collecting_Event. Locality_id Locality that was site of Collecting_Event. Began_Date Date of beginning of Collecting_Event. Rule: Ended_Date and Began_Date must either both contain values or both be empty. Ended_Date Date of ending of Collecting_Event. Verbatim_Date The literal expression of collecting date as given by the collector. Verbatim_Locality The expression of specific locality, entered as closely as possible to the original text provided by the collector (in field notes). A different description of specific locality can be made for each collecting event at a single locality. Coll_Event_Remarks Remarks about Collecting_Event. Valid_Distribution_fg Shows whether the Locality should be considered in distribution analysis. 0 when locality is for zoo or market where a specimen was acquired; 1 when locality represents the natural range of the specimen. Collecting_Source Shows the source of specimens for the collecting event, IN (wild caught, market, zoo, lab, aviary, pet shop, breeder, customs). Collecting_Method The method used to collect objects during this collecting event (e.g., 'trawl', 'trapline', 'pitfall traps', etc.). Habitat A keyword list of habitat types associated with the collecting event. Microhabitat, such as 'in leaf debris under log' is an attribute of the Coll_Object_Habitat table. Table Name: Collection Table Column Name Table Column Attribute Definition ----------------- --------------------------------- Collection_Cde A code or name designating a separate series of catalog numbers within an institution. Rule: IN ("Mamm", "Bird", "Herp", "Egg", "Hild", "Film", "FC", "VS", "Tape", "Img") Institution_Acronym Institution acronym that maintains collection. Default is 'MVZ'. Descr Description of collection. Collection The display value for the collection code. Table Name: Collector Table Column Name Table Column Attribute Definition ----------------- --------------------------------- Coll_Num Incremental portion of an identifying number of a specimen, typically assigned by collector at time of collection. Does not include prefixes or suffixes. Data type is real number to allow decimals if used by collector. Coll_Num_Prefix The prefix on a collector's number. May include other letters, separators, and numbers (typically last two digits of year) that differentiate multiple series by same collector. Alternatively, a single alphanumeric collector "number" may be stored in this single field. Coll_Num_Suffix The suffix of a collectors number; typically appended as -a or -b to distinguish among duplicate numbers. Begins with the first non-numeric character following the numeric portion of a collector's number. Includes separators and other alpha-numerics. Coll_Order The number of the order in which the collector appears in the cataloged record. Collection_Object_id Collector_Role The role played by the agent with respect to the specimen. IN ('c' for collector, 'p' for preparator, 'g' for photographer, 'd' for donor). Agent_id Identifier of an agent who participated in the collection of this collection object. Table Name: Common_Name Table Column Name Table Column Attribute Definition ----------------- --------------------------------- Common_Name The Common_Name associated with a Taxon_Name. Taxon_Name_id Foreign key to the Taxon_Name to which the Common_Name refers. Table Name: Container Table Column Name Table Column Attribute Definition ----------------- --------------------------------- Container_id Primary key for the Container table. Can act as a super type of any Collection_Object as well as accommodating non-collection_objects as containers. Container_Type The type of container (e.g., box, case, freezer, freezer rack, jar, range, room, shelf, shelving unit, tray, package, museum, specimen, shipment). Label The label to print and attach to the container. Description The description of the container. Barcode The ASCII character representation of the barcode. When printed in an appropriate font, this value will result in a valid barcode label. Table Name: Container_History Table Column Name Table Column Attribute Definition ----------------- --------------------------------- Parent_Container_id The foreign key to the parent container in which this container was installed. Install_Date The date/time on which this container was installed in its parent container. Container_id Table Name: Correspondence Table Column Name Table Column Attribute Definition ----------------- --------------------------------- Correspondence_id The primary identifier of Correspondence. Correspondence_Type The subtype of Correspondence (e.g., 'Loan_Request'). From_Agent_Addr_id The Agent Address that was the source of the Correspondence. To_Agent_Addr_id The Agent Address to which the Correspondence was destined. Written_Date The date on which the Correspondence was written. Folder_Label The file folder label that contains this Correspondence. Filed_Under_Name The Name under which the Correspondence was filed. Correspondence_Remarks Remarks about the Correspondence, including the nature of it. Table Name: Deacc_Item Table Column Name Table Column Attribute Definition ----------------- --------------------------------- Collection_Object_id Deaccession_Item_Remarks Remarks that are for the deaccession item. Transaction_id The deaccn of which this collection object is a member. Table Name: Deaccn Table Column Name Table Column Attribute Definition ----------------- --------------------------------- Transaction_id The primary identifier of the deaccession. Deaccn_Type The deaccession type that describes deaccession; the reason (standard category) why items were deaccessioned. Rule: IN ("discarded", "Exchanged", "Lost", "Grant", "Gift", "Lost in Transit") Deaccn_Num Deaccession number that identifies deaccession on paper. Deaccn_Status Deaccession status that describes deaccession; the current processing status of a deaccession transaction. Rule: IN ("in process", "complete") Table Name: Digital_Audio_File Table Column Name Table Column Attribute Definition ----------------- --------------------------------- Tape_id Digital_Audio_File_id The primary identifier of Digital_Audio_File Table Name: Egg_Nest Table Column Name Table Column Attribute Definition ----------------- --------------------------------- Field_Egg_Count Number of eggs in the nest observed in the field. Coll_Egg_Count Egg count that Egg_Nest has in collection (Does not include parasite eggs). Set_Mark Set marks may represent several concepts (but inconsistantly), including collector's number, count of eggs in set. They are typically written in a numerator/denominator format. A standard interpretation-expression syntax will be required. Original_Data_Source Indicates the original source of data for an egg_nest item (an egg-set and/or nest). Can be more than one for an egg set or nest. Rule: IN ("Egg_Data_Slip", "Ledger", "Field_Notes") Collection_Object_id Multiple_Clutch_fg Flag denoting if this Egg/Nest contains multiple clutches. Egg_Nest_Combo Indicates Egg_Nest combinations. Rule: IN ('eggs only', 'nest only', 'eggs + nest', 'none') Table Name: Egg_Nest_Parasite Table Column Name Table Column Attribute Definition ----------------- --------------------------------- Field_Parasite_Egg_Count The count of parasite eggs in the field. Coll_Parasite_Egg_Count The count of parasite eggs in the collection. Parasite_Taxon_Name_id The lexicon_id for Egg_Nest parasite. Collection_Object_id Table Name: Egg_Nest_Remark Table Column Name Table Column Attribute Definition ----------------- --------------------------------- Egg_Nest_Descr Remarks concerning the desription of the Egg_Nest. Incubation_Stage Remarks concerning the incubation stage of eggs in a nest. Collection_Object_id Table Name: Egg_Nest_Temp_Remark Table Column Name Table Column Attribute Definition ----------------- --------------------------------- Egg_Nest_Remarks Temporary field to hold Egg_Nest data for further manipulation. Collection_Object_id Table Name: Electronic_Address Table Column Name Table Column Attribute Definition ----------------- --------------------------------- Electronic_Addr The primary identifier of an electronic address (e-mail, URL, etc.). Electronic_Addr_Type The type of Electronic_Addr. RULE: IN ['e-mail','URL'] Agent_id The Agent to which this electronic address refers. Table Name: Field_Notebook_Section Table Column Name Table Column Attribute Definition ----------------- --------------------------------- Publication_id Begin_Date The first date referenced in a Section. End_Date The last date referenced in a Section. Begins_Collectors_Num The "lowest" collector's number referenced in the Section. Note: This field is a varchar to allow for prefixes, suffixes and decimals. Ends_Collectors_Num The "highest" collector's number referenced in the Section. Note: This field is a varchar to allow for prefixes, suffixes and decimals. Field_Notebook_Section_Type Denotes the type of field notebook section (e.g. letter, catalog, journal, species account) Table Name: Film Table Column Name Table Column Attribute Definition ----------------- --------------------------------- Film_Title Title of film (if exists and is known). Collection_Object_id Table Name: Film_Clip Table Column Name Table Column Attribute Definition ----------------- --------------------------------- Film_Speed Film_Speed ofFilm_Clip. An integer value indicating the original film speed in frames per second. Playing_Time Playing_Time of Film_Clip. Indicates playing time (at normal speed). Use time data type if supported in tools; else store in seconds and display as appropriate. Collection_Object_id Table Name: Film_Clip_in_Film Table Column Name Table Column Attribute Definition ----------------- --------------------------------- Film_id Start_Position Start_Position of Film_Clip in Film. Indicates the starting position of a film_clip (i.e., a moving image segment or scene) on a particular film (or video). Should be expressed in time from beginning of film. Film_Clip_id Table Name: Geog_Auth_Rec Table Column Name Table Column Attribute Definition ----------------- --------------------------------- Geog_Auth_Rec_id The primary identifier of Geog_Auth_Rec. Continent_Ocean A continent or ocean. Country A country or country-like geo-political entity (e.g. U.S. Trust Territory of the Pacific). State_Prov The largest administrative subdivision of a country. County A second level of administrative subdivision; contains counties in the UK, USA and Canada. Quad Feature A geographic area encompassing multiple geo-political administrative divisions. Island The name of a single island. Island_Group The name of a group of islands. Sea The name of a sea, whether inland or pelagic. Valid_Catalog_Term_fg Source_Authority Higher_Geog This is a calculated, persistnet column made up of continent + country + state + county + island + island_group. Table Name: Geog_Relations Table Column Name Table Column Attribute Definition ----------------- --------------------------------- Geog_Auth_Rec_id The subject higher geography record in a relationship between higher geography records. Related_Geog_Auth_Rec_id The object higher geography record in a relationship between higher geography records. Geog_Relationship The relationship between two higher geography records. Table Name: Group_Master Table Column Name Table Column Attribute Definition ----------------- --------------------------------- Agent_id The primary identifier of the group. Table Name: Group_Member Table Column Name Table Column Attribute Definition ----------------- --------------------------------- Member_Agent_id Foreign key to the member of the Group. Member_Order The order of appearance of the member in the group. Group_Agent_id Foreign key to the Group to which the member belongs. Table Name: Herp Table Column Name Table Column Attribute Definition ----------------- --------------------------------- Snout_Vent_Length_Units The units in which the snout-vent length are recorded. Carapace_Length The value part of the Carapace Length measurement. Carapace_Length_Units Snout_Vent_Length Length of specimen from tip of snout to vent. Collection_Object_id Table Name: Histo_Slide_Series Table Column Name Table Column Attribute Definition ----------------- --------------------------------- Part_Name Part_name that is sectioned in Histological_Slide_Series. Study_Name The name of study for which slide series was created. Slide_Numbers_Present The slide numbers present in slide series. Card_Number Card_Number of index card associated with slide series. Histo_Stain_Proc Indicates staining procedure used on series. A text description, not a controlled vocabulary. If this should instead be a quickly searchable list of stain types used, the field should be shortened and the relationship to series should be many to many. Embedding_Medium Indicates the material in which the specimen or tissue was embedded prior to sectioning. Stored as expandable controlled vocabulary. DBW_Notebook_Number DBW notebook number associated with slide series. Section_Orientation Indicates the orientation of the sections of the specimen (part); e.g., cross section, transverse, frontal, sagittal, etc. Histo_Prep_Meth A description of the techniques used to prepare tissue in a histological series. Includes description of decalcification method, embedding/perfusion method, etc. Histo_Derived_From_Biol_Indv Start_Box_Number First Box_Number in which the slide series is housed. Collection_Object_id Section_Width The width of histological sections; expressed in microns. Used as label, not for calculations(?). Slide_Count The number (count) of slides in a Histological_Slide_Series. End_Box_Number End Box_Number in which the slide series is housed. Last_Slide_Number Number of last slide in slide series. First_Slide_Number Number of first slide in slide series. Table Name: Identification Table Column Name Table Column Attribute Definition ----------------- --------------------------------- Made_Date Date of Identification. ID_Made_By_Agent_id Agent who made the new identification. Nature_Of_ID Indicates the nature of a determination, such as whether the identification is based on geography or not. Rule IN: 'ssp. based on geog.', 'sp. based on geog.', 'field ID', 'expert ID' Accepted_ID_fg This Identification_id is the accepted taxonomic identification for this collection_object_id. Note: There cannot be more than one accepted taxonomic identification for a given collection_object_id. Identification_Remarks Remarks associated with this identification. Identification_id The primary identifier of Identification. Identification_Modifier Indicates whether identification is: uncertain (?); applied taxon name is for cognate of unnamed taxon (cf.); etc. Collection_Object_id Taxon_Name_id The lexicon_id that was used in Identification. Table Name: Image_Content Table Column Name Table Column Attribute Definition ----------------- --------------------------------- Referenced_Image_Object_id Collection_Object_id Locality_id Foreign key to a referenced locality, if any. RULE: If not Null, then Image_Content_Type="Place" Taxon_Name_id Image_Content_Descr Description of Image_Content meant to identify the reference in the user interface. Relationship Image_Subject_id Image_Content_id The primary identifier of Image_Content. Page_id Foreign key to a referenced Page, if any. Ref_Date The date for an Image_Content_Type of "date." Image_Content_Type The type of reference. Controlled by the ctImage_Content_Type code table. Agent_id Foreign key to a referenced agent, if any. RULE: If not Null, then Image_Content_Type="Person" Table Name: Image_Object Table Column Name Table Column Attribute Definition ----------------- --------------------------------- Image_Object_Type The subtype designation for the Image_Object. RULE: In(Still_Image, Film, Film_Clip). Controlled by the ctImage_Object_Type code table. Made_From_Image_Object_id Foreign key to another Image Object from which this Image Object was made. Image_Object_Storage_Loc The location where the Image_Object is stored. Controlled by the ctImage_Storage_Loc code table. Made_For_Purpose Purpose for which the Image_Object was created. Controlled by the ctImage_Made_For_Purpose code table. URL_id Image_Subject_id Collection_Object_id Original_fg Indicates whether Image is original or not. Controlled by the ctFlag_Yes_No code table. Made_Date Date that Image_Object was made. Image_Object_Medium Indicates the medium of a physical image. Examples: 'VHS', '16 mm', 'Kodachrome', 'b/w slide', 'b/w photo', 'color photo'. Controlled by ctImage_Object_Medium code table. Table Name: Image_Object_Agent_Role Table Column Name Table Column Attribute Definition ----------------- --------------------------------- Image_Object_Agent_Role The role played by an Agent with respect to an Image_Object (e.g. "made for"). Controlled by the ctImage_Object_Agent_Role code table. Collection_Object_id Agent_id Foreign key to the Agent who plays a role with respect to the Image_Object. Table Name: Image_Subject Table Column Name Table Column Attribute Definition ----------------- --------------------------------- Image_Title The title of an image. Image_Subject A description of the basic subject matter of an image. Image_Subject_id Table Name: Image_Subject_Remarks Table Column Name Table Column Attribute Definition ----------------- --------------------------------- Veg_Type Question Subject_Type_2 Subject_Type_1 Entered_Date Life_Zone Ref_In_Pub print_copies Expedition Veg_Species Image_Subject_id Other_Use Exhibition Image_Pub Pub_Year Table Name: Journal Table Column Name Table Column Attribute Definition ----------------- --------------------------------- Journal_id Primary key for Journals. Journal_Abbreviation Abbreviation of the Journal name. Publisher_Name The name of the Publisher. Should also include City. Journal_Name Full name of the Journal. Table Name: Journal_Article Table Column Name Table Column Attribute Definition ----------------- --------------------------------- Publication_id The primary identifier of the Journal Article. Journal_id Foreign key to the Journal in which the article is published. Begins_Page_Number Page_Number that is beginning of Journal_Article. Ends_Page_Number Page_Number that is ending of Journal_Article. Volume_Number The volume number of a publication. Stored as an integer; output styles may be complicated (e.g., roman numeral representations). Issue_Number Issue_Number that contains Journal_Article. Table Name: Karyo_Slide Table Column Name Table Column Attribute Definition ----------------- --------------------------------- Karyo_Stain_Proc Indicates stain type or protocol (recipe) used to stain slide. Karyo_Derived_From_Biol_Indv Karyo_Prep_Meth Indicates the method used to treat tissue and affix chromosomes to slides. Karyo_Slide_Num A number (visible) appended to the specimen's catalog number to identify a particular slide; a sub-number -- i.e., appended to catalog number. Collection_Object_id Table Name: Lat_Long Table Column Name Table Column Attribute Definition ----------------- --------------------------------- Orig_Lat_Long_Units A code indicating the original form of the latitude longitude value; in {Deg. Min. Sec.,Decimal Degrees, UTM} Determined_By_Agent_id Foreign key to the Agent who made the Lat_Long determination. Determined_Date Date of determination for Lat_Long. UTM_Zone UTM_NS The magnitude of the north-south directional in a UTM coordinate pair. UTM_EW The magnitude of the east-west directional in a UTM coordinate pair. Datum The name of the geodetic datum on which the reference source is based (e.g., "NAD27", "WGS-84"). Lat_Long_For_NNP_fg Flag showing whether the recorded Lat-Long is for the Nearest_Named_Place (1 if True, 0 if the Lat_Long is for the Specific_Locality). Nearest_Named_Place The name of the nearest place to the specific locality that can be located on a map or with a gazeteer. Field_Verified_fg Shows whether this Lat_Long has been verified in the field for the given Locality. Lat_Long_Ref_Source A code indicating the reference from which a latitude - longitude was determined. For example, the name of a specific map or gazeteer, or a Geodetic Datum. Lat_Long_Remarks Remarks associated with Lat_Long. Max_Error_Units The units in which the Max_Error_Distance are recorded (IN m, ft, km, mi). Max_Error_Distance The maximum possible error in distance between the recorded Lat_Long and the actual Lat_Long of the specific locality. Accepted_Lat_Long_fg Shows whether this Lat_Long is the accepted one for a Locality. Dec_Lat_Min The minutes part of a latitude measure in degrees and decimal minutes. Rule: BETWEEN 0 and 60. Lat_Min Lat_Min of Lat_Long. Rule: BETWEEN 0 and 60. Lat_Sec Lat_Sec of Lat_Long. Rule: BETWEEN 0 and 60. Lat_Long_id The primary identifier of Lat_Long. Lat_Deg Lat_Deg of Lat_Long. Rule: BETWEEN 0 and 90. Locality_id Locality that Lat_Long is for. Dec_Long Longitude value expressed as decimal degrees. Long_Dir Lat_Dir of Lat_Long. Rule: IN ("E", "W") Long_Sec Long_Sec of Lat_Long. Rule: BETWEEN 0 and 60. Dec_Lat Latitude value expressed as decimal degrees. Lat_Dir Lat_Dir of Lat_Long. Rule: IN ("N", "S") Long_Deg Long_Deg of Lat_Long. Rule: BETWEEN 0 and 180. Long_Min Long_Min of Lat_Long. Rule: BETWEEN 0 and 60. Dec_Long_Min The minutes part of a longitude measure in degrees and decimal minutes. Rule: BETWEEN 0 and 60. Table Name: Loan_Installment Table Column Name Table Column Attribute Definition ----------------- --------------------------------- Installment_Order The order of this installment among the installment for a Loan Request. Loan_Installment_Status The status of the Loan Installment (e.g., in progress, shipped, returned, reinstalled). Loan_Num_Suffix An alphanumeric suffix to the loan number. Lender_Inv_Ret_fg Flag to show whether the lender's invoice has been returned. Borrower_Inv_Ret_fg Flag to show whether the borrower's invoice has been returned. Loan_Type Correspondence_id Foreign key to the Loan Request that initiated the Loan installments. Transaction_id Unique key for the Loan Installment transaction. Loan_Num Loan number (visible) that loan is filed under. Loan_Num_Prefix An alphanumeric prefix to the loan number. Installment_Due_Date The date on which the Loan Installment is supposed to be returned. Completed_Date The date on which all Loan Items for al shipments for the Loan Installment have been reconciled. Table Name: Loan_Item Table Column Name Table Column Attribute Definition ----------------- --------------------------------- Item_Descr Description of the loaned item for the printed invoice. Reconciled_Date Date of reconciliation of Loan_Item. Item_Instructions Specific instructions for care, use, etc. of a collection object by the borrower. Loan_Item_Remarks Remarks that were received for Loan_Item from the borrower; used if borrower notes discrepancy between acutal condition and described condition. Transaction_id Reconciled_By_Person_id Person who reconciled Loan_Item. Collection_Object_id The foreign key to the Coll_Object being sent out in the Shipment. Container_id Table Name: Loan_Request Table Column Name Table Column Attribute Definition ----------------- --------------------------------- Correspondence_id Unique key to the Correspondence for this Loan Request. Installment_Count The number of intended Loan Installments for this Loan Request. Request_Status The status of the Loan Request (e.g., open, complete). Loan_Instructions The instructions and/or notes for the recipient of the Installments generated from the Loan Request. Request_Closed_Date Shipping_Instructions Table Name: Locality Table Column Name Table Column Attribute Definition ----------------- --------------------------------- Locality_id The primary identifier of Locality. Geog_Auth_Rec_id Named_Place that is near Locality. Accepted_Lat_Long_id Maximum_Elevation Elevation of Locality. Rule: Orig_Elev_Units and Maximum_Elevation must either both contain values or both be empty. Rule: Maximum_Elevation and Minimum_Elevation must either both contain values or both be empty. Minimum_Elevation Elevation of Locality. Rule: Maximum_Elevation and Minimum_Elevation must either both contain values or both be empty. Orig_Elev_Units Original units given for elevation; meters (m) or feet (ft). Rule: IN ("m", "ft") Rule: Orig_Elev_Units and Maximum_Elevation must either both contain values or both be empty. Township Township of Locality. Rule: Township and Range must either both contain values or both be empty. Rule: Township and Township_Direction must either both contain values or both be empty. Township_Direction Direction of Township value. Rule: IN ("N", "S") Rule: Township_Direction and Range_Direction must either both contain values or both be empty. Range Range of Locality. Rule: Township and Range must either both contain values or both be empty. Rule: Range and Range_Direction must either both contain values or both be empty. Range_Direction Direction of Range value. Rule: IN ("E", "W") Section Section of Locality. Rule: BETWEEN 1 and 16. Rule: Township_Direction and Range_Direction must either both contain values or both be empty. Rule: There must be a value in Range before a value can be entered in Section. Section_Part Section_Part of Locality. Rule: IN ("NW", "NE", "SE", "SW"). Rule: There must be a value in Section before a value can be entered in Section_Part. Spec_Locality All geographic information within the largest geopolitical subdivision of a country other than the USA. Within the USA it is all geographic information within the county. Note: See also Verbatim_Locality in Collecting_Event. Locality_Remarks Remarks associated with Locality. Legacy_Spec_Locality_fg Designates whether the specific locality for this record had its origin in legacy data. Table Name: Mammal Table Column Name Table Column Attribute Definition ----------------- --------------------------------- Ear_Length Ear_Length of the Mammal. Hind_Foot_Length Hind_Foot_Length of the Mammal. Tragus_Length Tragus_Length of the Mammal. Forearm_Length Forearm_Length of the Mammal. Length_Units The units in which all of the lengths are recorded. Collection_Object_id Tail_Length Tail_Length of the Mammal. Karyotype_Slides_fg Indicates whether Mammal has Karyotype_slides or not. Total_Length Total_Length of the Mammal. Table Name: Model Table Column Name Table Column Attribute Definition ----------------- --------------------------------- Model_Descr A description of the model. Collection_Object_id Table Name: Notes_of_Coll_Event Table Column Name Table Column Attribute Definition ----------------- --------------------------------- Publication_id Collecting_Event_id The identifier of the collecting event referenced by this field note section. Table Name: Org Table Column Name Table Column Attribute Definition ----------------- --------------------------------- Dept_Unit Department or division within parent organization. Agent_id The primary identifier of the organization. Table Name: Page Table Column Name Table Column Attribute Definition ----------------- --------------------------------- Page_id The primary identifier for a page Publication_id Section_Page_Order The numerical order of this page in a section. Note: This is not necessarily the page number printed on a page. Page_Num he page number as written on the page, as opposed to the oder of the page in the section. Table Name: Part_Matrix Table Column Name Table Column Attribute Definition ----------------- --------------------------------- mammal_skin_and_skull_fg mammal_skin_only_fg other_part_fg mvzfc bird_wing_fg skull_only_fg mammal_skin_fg non_herp_fluid_pres_fg fluid_text skel_text tissue_text herp_s_no part_count skull_text skin_text other_part_text herp_wet_flat_skin_fg tissue_fg herp_dry_flat_skin_fg skull_fg Collection_Object_id Sex_Cde Biol_Indiv_Type bird_flat_skin_fg bird_study_skin_fg herp_whole_other_fluid_fg bird_body_skin_fg complete_skel_fg partial_skel_fg herp_whole_cs_fg herp_whole_alc_fg herp_whole_formalin_fg Table Name: Permit Table Column Name Table Column Attribute Definition ----------------- --------------------------------- Exp_Date Date of expiration of Permit. Renewed_Date Date of last renewal for Permit. Permit_Num The identifying number for the permit; used only if the issuing body has assigned an id. MVZ does not create this code; it must accommodate letters, numbers, etc. Permit_Type The type of a permit. IN(export, import, MVZ authorized, salvage, transfer of property, scientific collecting, mixed). Permit_Remarks Remarks that are for Permit. Permit_id The primary identifier of Permit. Issued_To_Agent_id Foreign key to the agent to whom the permit was issued. Issued_By_Agent_id Foreign key to the agent resposible for issuing the permit. Issued_Date Date that Permit was issued on. Table Name: Permit_Shipment Table Column Name Table Column Attribute Definition ----------------- --------------------------------- Container_id Permit_id Permit that authorizes Shipment. Table Name: Permit_Trans Table Column Name Table Column Attribute Definition ----------------- --------------------------------- Permit_id Permit that authorizes Transaction. Transaction_id Transaction that is authorized by Permit. Table Name: Person Table Column Name Table Column Attribute Definition ----------------- --------------------------------- Suffix The suffix of a person's name: e.g., Sr., Jr., II, III, etc. Do not enter degrees held, honorifics, or job titles. Middle_Name A person's middle name or names if more than one. (Any names between first given name and family name.) Enter initials if known and full middle name(s) not known. If multiple initials, separate with space; do not use periods. Birth_Date Date of birth of Person. Death_Date Date of death of Person. Person_id The primary identifier of the person. Note that an actual human being may be represented as more than one person if that person's name changes. In such an event a relationship between the two representations should be made in the Agent_Relations table. First_Name A person's first name (first given name). Prefix The honorific prefix to be used in addresses; e.g., Mr., Ms., Mrs., Dr., etc. Last_Name A person's last name (family name). Table Name: Phantom_Biol_Indiv Table Column Name Table Column Attribute Definition ----------------- --------------------------------- Phantom_Biol_Indiv_id Primary key to track Phantom Biological Individuals (individuals observed, but not collected). Sex_Cde Indicates sex of individual. Rule: IN("male", "female", "unknown") varchar(10) allows for these to be spelled out. Sex_Cde_Mod Age_Class Repro_Data Non_Repro_Behavior Habitat Table Name: Phantom_Relations Table Column Name Table Column Attribute Definition ----------------- --------------------------------- Phantom_Biol_Indiv_id The subject phantom biological individual in a relationship between phantom biological individuals. Related_Phantom_Biol_Indiv_id The object phantom biological individual in a relationship between phantom biological individuals. Biol_Indiv_Relationship The relationship between the subject and object phantom biological individuals (e.g. Phantom_Biol_Indiv_id "mother of" Related_Phantom_Biol_Indiv_id). The inverse relationship should also exist, as should the identity relationship. Table Name: Phone Table Column Name Table Column Attribute Definition ----------------- --------------------------------- Agent_Addr_id The identifier for the Agent Addr with which this Phone number is associated. Phone_Num A Phone_Num is a code (alphanumeric) containing a sequence of numbers that can be dialed on a telephone to connect to another telephone (including fax machines). Contains alphanumerics, e.g., parens, hyphens, "ext.", etc. Phone_Label Indicates the specific use and/or location of a phone; e.g., office, lab, home, message. Table Name: Project Table Column Name Table Column Attribute Definition ----------------- --------------------------------- Project_id The primary identifier for a project. Start_Date Start date for the project. End_Date Start date for the project. Project_Name A descriptive name for a Project. For expeditions, typically the leader of the field party, the place (region), and the year(s). Project_Description Project description. Project_Remarks Remarks about the Project. Table Name: Project_Agent Table Column Name Table Column Attribute Definition ----------------- --------------------------------- Project_Agent_Role The role played by the agent on the Project. Project_Agent_Remarks Remarks pertaining to this agent with respect to this project. Agent_Name_id Project_id The Project on which the agent fills the given role. Table Name: Project_Coll_Event Table Column Name Table Column Attribute Definition ----------------- --------------------------------- Collecting_Event_id Foreign key to the event in the list of events for a project. Project_id Foreign key to the Project in the list of events for a project. Table Name: Project_Publication Table Column Name Table Column Attribute Definition ----------------- --------------------------------- Publication_id Foreign key to the Publication in the list of Publications from a Project. Project_Publication_Remarks Remarks pertaining to the relationship between the publication and the Project. Project_id Foreign key to the Project in the list of Publications from a Project. Table Name: Project_Taxonomy Table Column Name Table Column Attribute Definition ----------------- --------------------------------- Project_id Taxon_Name_id Project_Taxon_Role Project_Taxon_Remarks Table Name: Project_Trans Table Column Name Table Column Attribute Definition ----------------- --------------------------------- Transaction_id Foreign key to the Transaction in the list of Transactions for a Project. Project_Trans_Remarks Remarks pertaining to the releationship between the Project and the Transaction. Project_id Foreign key to the Project in the list of Transactions for a Project. Table Name: Publication Table Column Name Table Column Attribute Definition ----------------- --------------------------------- Publication_id The primary identifier of Publication. Published_Year Year of Publication. Rule: BETWEEN 1700 and 2010 Publication_Type Indicates kind of publication. (A publication may be of only one type.) Rule: IN ("Journal_Article", "Book", "Book_Section", "Correspondence Folder") Publication_Loc The location of Publication within the MVZ. Publication_Title Title of Publication. Publication_Remarks Remarks that concern Publication. Table Name: Publication_Author_Name Table Column Name Table Column Attribute Definition ----------------- --------------------------------- Publication_id The identifier of the publication for which this agent is an author. Agent_Name_id Foreign key to the name of the author of the Publication occupying this position in the list of authors. Author_Position Indicates the cardinal position of author in relationship to authored object. Default = 1. Table Name: Publication_Year Table Column Name Table Column Attribute Definition ----------------- --------------------------------- Publication_id Pub_Year One of potentially many years over which a publication's content spans. Used especially for Field Notebooks. Table Name: Sequence_Repos_Article Table Column Name Table Column Attribute Definition ----------------- --------------------------------- Publication_id Sequence_Repository_id Accn_Num Table Name: Sequence_Repository Table Column Name Table Column Attribute Definition ----------------- --------------------------------- Sequence_Repository_id Repository_Name URL Table Name: Shipment Table Column Name Table Column Attribute Definition ----------------- --------------------------------- Package_Weight Package_Weight of Shipment. Hazmat_fg Indicates whether Shipment contains hazmat or not. Shipped_Date Date of Shipment. Carriers_Tracking_Number An identification code assigned to a shipment (package) by the carrier. May contain alphanumeric characters and separators. Contents A brief description of the material contained in the shipment, to be printed on labels, customs forms, etc. (to be read by non-biologists). Insured_For_Insured_Value Insured value of Shipment. Shipment_Remarks Remarks that are for Shipment. Foreign_Shipment_fg Flag toshow where the shipment is to a foreign rather thana domestic destination. Transaction_id Transaction that is shipped in Shipment. From_Agent_Addr_id Agent_Address that sends Shipment. Container_id Shipped_Carrier_Method Shipping method. Rule: Shipped_Carrier_Method and Shipped_Carrier_Cde must be both null or both not null. Example: Shipped_Carrier_Cde= "FedEx",Shipped_Carrier_Method= "Overnight" Shipped_To_Agent_Addr_id Agent_Address that receives Shipment. Packed_By_Agent_id Hand_Carried_Agent_Addr_id Agent_Address that hand carries Shipment. Rule: At least one of Hand_Carried_Agent_Addr_id or Shipped_Carrier_cde must contain a value. Rule: Only one of Hand_Carried_Agent_Addr_id or Shipped_Carrier_cde must contain a value. Table Name: Species_Tape Table Column Name Table Column Attribute Definition ----------------- --------------------------------- Taxon_Name_id The lexicon_id of the term identifying a species that is recorded on Species_Tape. Collection_Object_id Table Name: Specimen_Part Table Column Name Table Column Attribute Definition ----------------- --------------------------------- Specimen_Storage_Loc Indicates storage location of an item. Used only if non-standard. Preserved_In_ETOH_fg Flag to indicate Specimen_Part was preserved in ethanol rather than formalin. Tissues from these specimens can then be used in DNA analysis, i.e., whole specimen can be used as a tissue sample. Transformation_Date Transformation_Date generally refers to the date when ethanol-preserved specimens are cleared and stained. Could be used for other types of transformations, but they should then be explained in Coll_Object_Remarks. Derived_From_Biol_Indv Collection_Object_id Preserv_Method Indicates preservation method(s) used for a specimen. Used only if non-standard for the part. Part_Name Indicates the name of the part. Must be a valid name for a part of a specimen. (Vocabulary maintained in an authority file.) Part_Modifier A series of one or more adjectives describing specimen part. Table Name: Still_Image Table Column Name Table Column Attribute Definition ----------------- --------------------------------- Dimensions Dimensions of Still_Image. Contra_Info Contra_Info from KK's image database. Collection_Object_id Table Name: Tape Table Column Name Table Column Attribute Definition ----------------- --------------------------------- Tape_Format Tape_Format of Tape. Rule: IN ('Reel', 'Cassette') Tape_Type Tape_Type of Tape. Rule: IN ('Master', 'Species') Collection_Object_id Table Name: Tax_Protect_Status Table Column Name Table Column Attribute Definition ----------------- --------------------------------- Listed_Date The date the taxon received this Protection Status. Protect_Status_Name Indicates the status of a taxon (species or subspecies) on a regulatory list (e.g., endangered, threatened, etc.). Protect_Status_Remarks Remarks concerning the protection status of a taxon. Taxon_Name_id The identifier of the taxon name represented on the Protection List. Protection_List_Name The name or acronym of a regulatory agency that designates protection status for species. Table Name: Taxon_Relations Table Column Name Table Column Attribute Definition ----------------- --------------------------------- Related_Taxon_Name_id The object taxon name record in a relationship between taxa. Taxon_Relationship The relationship between the subject and object taxon names (e.g. Taxon_Name_id "synonym of" Related_Taxon_Name_id). The inverse relationship should also exist, as should the identity relationship. Taxon_Name_id The subject taxon name in a relationship between taxa. Table Name: Taxonomy Table Column Name Table Column Attribute Definition ----------------- --------------------------------- Taxon_Name_id The unique id for a row in the lexicon table. Phylclass The class in which the taxon occurs. Phylorder The order in which the taxon occurs. Suborder Family The family in which the taxon occurs. Subfamily The subfamily in which the taxon occurs. Genus The genus in which the taxon occurs. Subgenus The subgenus in which the taxon occurs. Species The species in which the taxon occurs. Subspecies The subspecies in which the taxon occurs. Valid_Catalog_Term_fg A boolean flag to indicate if this Taxon_Name_id is valid to use in cataloging. Source_Authority The taxonomic authority from which this Taxon_Name is taken. Full_Taxon_Name Contains the full string of names from class on down. Use for searching purposes. Scientific_Name Contains the full string of names from genus on down. Use for searching purposes. Author_Text Author attribution as appended to the scientific name. Table Name: Tissue_Prep Table Column Name Table Column Attribute Definition ----------------- --------------------------------- Prep_Storage_Medium Storage_Medium for this Tissue_Prep_id. Rule: IN('Dry', 'Water', 'Chelex', '1XTBE') DNA_Conc DNA_Concentration of Tissue_Prep. Original_Volume Volume of Tissue_Prep_id. Used only if Storage_Medium is 'Dry'. Prep_From_Tissue_Sample_id Tissue_Prep_Num The identifying tissue prep number. Prep_From_Prep_id Collection_Object_id Prepared_Date Date that Tissue_Prep was prepared. Prepared_By_Agent_id Foreign key to the agent who prepared the Tissue Prep. Tissue_Prep_Method Indicates the method used to prepare the Tissue_Prep. Table Name: Tissue_Sample Table Column Name Table Column Attribute Definition ----------------- --------------------------------- Tissue_Type A list of the types of tissues in the sample (e.g., heart, liver, muscle, kidney...). Tissue_Vial_Type The type of vials the tissue sample is stored in. Rule: IN('Small Glass', 'Lg Glass', 'Lg Cryo', 'Std Glass', 'Std Cryo') Is_Subsample_fg Shows if this tissue is a subsample from another tissue. Sampled_From_Obj_id Foreign key to the Coll_Object from which this Tissue was subsampled. Could be another Tissue or a Specimen_Part. Collection_Object_id Tissue_Preserv_Meth Tissue_preservation method of Tissue_Sample. Rule: IN ('frozen', 'ethanol', 'freeze_dried', 'buffer' (type)) Derived_From_Biol_Indiv Tissue_Sample_Num A sub-number, used to provide visible identification of a Tissue_Sample -- in combination with the full catalog number of the biological individual from which the sample was taken. Table Name: Trans Table Column Name Table Column Attribute Definition ----------------- --------------------------------- Corresp_fg This is a denormalization to show whether a transaction has any associated correspondence. Received_Agent_id The id of the Agent by which the Transaction was received. Transaction_Type Designates the subtype of transaction such as loan, borrow, accession, etc. Nature_Of_Material A summary description of the items covered by the transaction. Trans_Remarks Remarks that are for transaction. Transaction_id The primary identifier of Trans. Trans_Entered_Agent_id The identifier of the person entering the transaction into the database. Auth_Agent_id The identifier of the person authorizing the transaction. Trans_Date Date of Transaction. Table Name: Trans_Agent_Addr Table Column Name Table Column Attribute Definition ----------------- --------------------------------- Transaction_id The identifier of the transaction for which this Trans Agent Addr is referenced. Agent_Addr_id An agent address is a person with an address, an organization with an address, or a person affiliated with an organization and a particular address. Agents conducting new transactions must have an address. Trans_Agent_Role_Name Indicates role played by Agent. (e.g., borrower, lender, donor, etc.); Agent_Role must be valid for Transaction_Type. Table Name: Trans_Relations Table Column Name Table Column Attribute Definition ----------------- --------------------------------- Transaction_id The subject transaction in a relationship between transactions. Related_Transaction_id The subject transaction in a relationship between transactions. Trans_Relationship The relationship between two transactions. Table Name: URL Table Column Name Table Column Attribute Definition ----------------- --------------------------------- URL_id The primary identifier for a URL. URL The Univeral Reference Locator address or directory path. Filename The filename for URLs of the "file" type. URL_Type The type of host on which the URL is located (e.g. "file", "http", "ftp"). Controlled by the ctURL_Type code table. Collection_Object_id The foreign key to the Image Object with which the URL is associated. Viewer_id Foreign key to a viewer for the URL. Table Name: Viewer Table Column Name Table Column Attribute Definition ----------------- --------------------------------- Viewer_id Viewer Path Params Table Name: Vocal_Series Table Column Name Table Column Attribute Definition ----------------- --------------------------------- Indiv_Num_On_Tape The identifier of the individual (by taxon) on the source tape. Cues_Count Indicates total number of cues, verbal counts made by the collector, while recording a series of vocalizations from an individual. Collector gives cues between vocalizations in series. Vocal_Type_Details Background_Vocals Background_Noise Collection_Object_id Vocal_Type Vocalization_Type of Vocal_Series. Rule: IN('Flight Call', 'Advertising Song', 'Alarm Call') From_Biol_Indiv_id From_Phantom_Biol_Indiv_id Table Name: Vocal_Series_Cut_History Table Column Name Table Column Attribute Definition ----------------- --------------------------------- Taxon_Cut_Num Collection_Object_id Taxon_Name_id Table Name: Vocal_Series_On_Tape Table Column Name Table Column Attribute Definition ----------------- --------------------------------- Original_fg Designates whether this Vocal Recording is an original (1) or not (0). Copied_From_Voc_Series_id Copied_From_Tape_id Tape_id Tape_id Tape_Side Tape_side of Vocalization_Recording.