Tablename: species
Species of animals under study. One row for each species.
Field name | Field type | Field length | Field description |
---|---|---|---|
species_id | integer | None | Unique record id number. | species_common_name | character varying | 50 | Species common name, such as Northern Elephant Seal, etc. | genus | character varying | 50 | Species genus. | species_scientific_name | character varying | 50 | Species scientific name | taxon_group_id | integer | None | Id number of taxonomic group. Link to the taxon_groups table. | species_code | character varying | 4 | Four-character species code as used in Costa lab deployment ID, e.g. “CASL” for California sea lion. | comments | text | None | Comments. | tag_data_folder | character varying | 50 | Subdirectory where tag data files are stored on file server. | topp_id_prefix | character varying | 2 | Two digits species code used in TOPP ID (if TOPP species). | release_to_topp | boolean | None | “True” if data from animals of this species will default to having their data released to TOPP web site. | working_group_id | integer | None | Id number of research working group such as Marine Mammal, Seabird, etc. Link to the working_groups table. |