Table Name   : Accn
Table Comment: A transaction in which the Museum gains title to one or more Collection Objects.

Table Name   : Accn_Coll_Event
Table Comment: 

Table Name   : Accn_Collector
Table Comment: This table joins Accn and Agent and is intended to be a repository of Collectors associated with an accession.

Table Name   : Accn_Taxonomy
Table Comment: 

Table Name   : Addr
Table Comment: A description of place that allows a common carrier to deliver an item of correspondence or package.  Includes everything after person and organization name.  May be PO box, or street address.

Table Name   : Agent
Table Comment: Supertype representing either a person, an organization, or an informal group of people.

Table Name   : Agent_Addr
Table Comment: 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.  Correctly entered addresses are never deleted, only marked as no longer valid.

Table Name   : Agent_Name
Table Comment: The various forms of names of agents.

Table Name   : Agent_Name_Role
Table Comment: This table contains roles in which an agent may be found.For example, Barbara Stein and Carla Cicero would have roles as both collectors and Curatorial Associates.

Table Name   : Agent_Relations
Table Comment: This table shows the various relationships between agents.

Table Name   : Biol_Indiv
Table Comment: A Cataloged_Item that represents (is/was) a biological individual (as opposed to an inanimate object such as a sound tape, photograph, map, etc.).

Table Name   : Biol_Indiv_Relations
Table Comment: This table holds the many (children) to many (maximum of 2 parents) relationship among Biological_Individuals.

Table Name   : Biol_Indiv_Remark
Table Comment: 

Table Name   : Biol_Indiv_to_Phantom_Reln
Table Comment: 

Table Name   : Bird
Table Comment: A Biological_Individual of the vertebrate class Aves.

Table Name   : Book
Table Comment: A book or other monographic publication.

Table Name   : Book_Section
Table Comment: A chapter or section in a book or other monographic publicaton.

Table Name   : Borrow
Table Comment: A transaction in which the Museum temporarily gains custody of collection objects to which it does not have title.

Table Name   : Cataloged_Item
Table Comment: A collection object that is identified (on paper) by an institution acronym, a collection code, and a catalog number.

Table Name   : Cataloged_Item_Remark
Table Comment: Remarks for Catloged_Items.

Table Name   : Citation
Table Comment: The mention of a Biological Individual in a Publication.

Table Name   : Coll_Obj_Other_ID_Num
Table Comment: Another identifying number of a collection object; typically another catalog number indicating the object's previous membership in another collection.  May also be used to hold an old catalog number if a new one has been assigned to eliminate duplicates.

Table Name   : Coll_Object
Table Comment: A generic supertype entity capable of representing the identity and kind of any collection item that must be described or tracked.  Some collection objects are logical, while others are physical objects.

Table Name   : Coll_Object_Habitat
Table Comment: This table contains habitat-related remarks for all types of collection objects.

Table Name   : Coll_Object_Remark
Table Comment: This table contains the various long ad-hoc remrks fields for collection objects.

Table Name   : Collecting_Event
Table Comment: A conjunction of time and place, describing an event in which a collection object is collected in the field.  Includes single instance for Unknown, which is used when ALL data of origin are unknown; collector, date, locality.

Table Name   : Collection
Table Comment: A group of similar items, held by an institution or private individual, in which each item has been assigned a catalog number and has been described.

Table Name   : Collector
Table Comment: Lists of collectors and their personal catalog numbers. For roles of collectors see Trans_Agent_Addr.

Table Name   : Common_Name
Table Comment: Table to hold common names for taxon_names.

Table Name   : Container
Table Comment: 

Table Name   : Container_History
Table Comment: 

Table Name   : Correspondence
Table Comment: Typically a letter, fax, or printed e-mail note that is filed in the MVZ's correspondence archive.  **Includes, receipt acknowledgement for all outgoing transactions.**

Table Name   : Deacc_Item
Table Comment: Indicates and describes the participation of collection object in a deaccession.

Table Name   : Deaccn
Table Comment: A Transaction in which the Museum relinquishes title to one or more collection objects.  (Removes it from the permanent collections.)

Table Name   : Digital_Audio_File
Table Comment: A computer file, containing a digital representation of an audio signal.

Table Name   : Egg_Nest
Table Comment: A member in the Egg_Nest Collection; either a set (clutch) of eggs taken from a single nest, a nest only, or both.

Table Name   : Egg_Nest_Parasite
Table Comment: Parasitic birds remarks associated with Eggs and Nest.

Table Name   : Egg_Nest_Remark
Table Comment: This table contains the various long remark fields associated with Egg_Nests.

Table Name   : Egg_Nest_Temp_Remark
Table Comment: This is a table to temporarily hold unparsed data associated with Egg_Nests.

Table Name   : Electronic_Address
Table Comment: An electronic mail address.  Typically of the form: 'user-id'@'subnet.net.domain'.

Table Name   : Field_Notebook_Section
Table Comment: Sections of field notebooks, chapters in books, and bodies of correspondence (e.g. a letter).

Table Name   : Film
Table Comment: A cataloged item that is a film (moving image based on a photographic process).  Is composed of Film Clips.

Table Name   : Film_Clip
Table Comment: A sequence of images (i.e., frames -- either on celluloid or video) that documents an organism (behavior), person, place, etc.

Table Name   : Film_Clip_in_Film
Table Comment: Records that a Film_Clip is contained in a Film.

Table Name   : Geog_Auth_Rec
Table Comment: Geographic authority file providing accepted values for political and natural geographic entities.

Table Name   : Geog_Relations
Table Comment: 

Table Name   : Group_Master
Table Comment: An informally constituted group of people, typically designated by person_name + "et al".  Each group must be linked to at least one valid person.

Table Name   : Group_Member
Table Comment: This table records the many-to-many relationship between groups and people.

Table Name   : Herp
Table Comment: A Biological Individual of the vertebrate class Amphibia or Reptilia.

Table Name   : Histo_Slide_Series
Table Comment: A Collection_Object that is a series of Histological_Slides, prepared from a single Biological_Individual or part thereof.

Table Name   : Identification
Table Comment: Identification histories for specimens. An identification is a correspondence between a specimen and a taxon_name (lexicon term). Cataloged_Items have an accepted identification, but may also have "outdated" identifications kept in perpetuity.

Table Name   : Image_Content
Table Comment: Join table between Image Subjects and the subjective content which can be linked to other data in the database.

Table Name   : Image_Object
Table Comment: Informatio regarding the physical embodiment of an image in a specific medium; includes digital manifestations.

Table Name   : Image_Object_Agent_Role
Table Comment: Roles played by Agents in relation to Image_Objects (e.g. the person for whom a slide was made).

Table Name   : Image_Subject
Table Comment: Subjective information associated with an image without regard for its physical medum.

Table Name   : Image_Subject_Remarks
Table Comment: Additional subjective image information from KK's image database.

Table Name   : Journal
Table Comment: A serial publication.  Represents an authority list for Journals (serial publications);  not a subtype of Publication (Journal Article is subtype of Publication).

Table Name   : Journal_Article
Table Comment: An article in a Journal.

Table Name   : Karyo_Slide
Table Comment: A Collection_Object that is a Karyological_Slide, prepared from a Biological_Individual.

Table Name   : Lat_Long
Table Comment: Indicates a place (point) on the earth.

Table Name   : Loan_Installment
Table Comment: 

Table Name   : Loan_Item
Table Comment: A particular line-item on a particular loan; typically refers to a single collection object.  A Loan-Item may be a cataloged or uncataloged object (there is no count, so it can't be a lot, unless count is put in remarks).

Table Name   : Loan_Request
Table Comment: 

Table Name   : Locality
Table Comment: A place where a collecting event was conducted.

Table Name   : Mammal
Table Comment: A Biological Individual of the vertebrate class Mammalia.

Table Name   : Model
Table Comment: A cataloged item (e.g., in Heldebrand Collection) that is a model of an anatomical structure or a reconstruction of a fossil taxon; may also demonstrate a function within a larger vertebrate taxon.

Table Name   : Notes_of_Coll_Event
Table Comment: This table was derived from the fact 'Field_Note_Section describes Collecting_Event'.

Table Name   : Org
Table Comment: Organization is typically a formally constituted body, such as an institution, or a department, or an office, within an institution or agency.

Table Name   : Page
Table Comment: Pages in a field notebook section or in correspondence.

Table Name   : Part_Matrix
Table Comment: 

Table Name   : Permit
Table Comment: A Permit is a document issued by an organization (usually but not necessarily a governmental entity), that grants permission for another agent to perform certain restricted actions, including to possess restricted material.

Table Name   : Permit_Shipment
Table Comment: This table was derived from the fact 'Permit authorizes Shipment', and records this many-to-many relationship.

Table Name   : Permit_Trans
Table Comment: This table was derived from the fact 'Permit authorizes Transaction', and records the many-to-many relationship.

Table Name   : Person
Table Comment: An individual human being for whom the application must have a single representation.

Table Name   : Phantom_Biol_Indiv
Table Comment: 

Table Name   : Phantom_Relations
Table Comment: 

Table Name   : Phone
Table Comment: This table was derived from the fact 'Agent_Address has Phone_Number with Phone_Label'.

Table Name   : Project
Table Comment: An 'event' in which one or more collectors visit one or more localities, and conduct one or more collecting events; bounded by departure and return dates.

Table Name   : Project_Agent
Table Comment: This association tble implements a many-to-many relationship, and was derived from the fact 'Agent participated in Expedition'.

Table Name   : Project_Coll_Event
Table Comment: 

Table Name   : Project_Publication
Table Comment: 

Table Name   : Project_Taxonomy
Table Comment: 

Table Name   : Project_Trans
Table Comment: 

Table Name   : Publication
Table Comment: Supertype representing bodies of literature whether actually published or not (e.g. books, journal articles, field notebooks, and correspondence files).

Table Name   : Publication_Author_Name
Table Comment: This table records the many to many relationship between Author (Agents) and Publications.  Agent is Author_position (i.e., first, second, third, etc.) author of Publication.

Table Name   : Publication_Year
Table Comment: 

Table Name   : Sequence_Repos_Article
Table Comment: 

Table Name   : Sequence_Repository
Table Comment: 

Table Name   : Shipment
Table Comment: A shipment is a single outgoing package that may or may not contain collection objects (i.e., may contain something other than a Transaction, such as a large printout).

Table Name   : Species_Tape
Table Comment: An audio tape that contains copies of vocalization series from many Master_Tapes, but of the same species.

Table Name   : Specimen_Part
Table Comment: A part of a specimen (biological specimen); may range from a single anatomical structure, to an anatomical region, to an entire individual.

Table Name   : Still_Image
Table Comment: A physical image that is a still image (not a moving image).

Table Name   : Tape
Table Comment: A reel or cassette tape that holds vocalization recordings.

Table Name   : Tax_Protect_Status
Table Comment: Valid_Taxon_Name may have a Protection_Status on a Protection_List.

Table Name   : Taxon_Relations
Table Comment: This table contains all the relationships among Taxon_Names.

Table Name   : Taxonomy
Table Comment: A table containing the terms used in taxonomy along with the authority and whether the name is used internally for cataloging.

Table Name   : Tissue_Prep
Table Comment: A Tissue_Sample that contains prepared tissue (i.e., ground tissue in buffer, protein extract, or DNA extract).

Table Name   : Tissue_Sample
Table Comment: A collection object, taken from a biological individual, that will (or has been) used in genetic analysis.

Table Name   : Trans
Table Comment: An action that changes custody of, and/or title to, one or more collection items.

Table Name   : Trans_Agent_Addr
Table Comment: This table was derived from the fact 'Transaction is conducted by Agent_Address as Agent_Role'.

Table Name   : Trans_Relations
Table Comment: 

Table Name   : URL
Table Comment: Universal Reference Locators. Accomodates addresses for local, network and internet locations.

Table Name   : Viewer
Table Comment: 

Table Name   : Vocal_Series
Table Comment: A recording or a series of recordings of an animal vocalization. They are similar to other cataloged items in being evidence of an organism at a place and time, gathered by a Person. It is the logical entity as opposed to the physical medium.

Table Name   : Vocal_Series_Cut_History
Table Comment: 

Table Name   : Vocal_Series_On_Tape
Table Comment: A recording of a Vocalization_Series on a Tape. It is the physical entity of the vocal series. Implements a many-to-many relationship between the logical event (vocal_series) and the potentially many copies of it.