tblStationSpecies
Entity (ENT) | Alaska Fisheries Science Center (AFSC)GUID: gov.noaa.nmfs.inport:23954 | Updated: August 9, 2022 | Published / External
Entity Information
| Description: |
3.0 Species associated with each band |
|---|
Data Attributes
Attribute Summary
|
|
Name | Type | Description |
|---|---|---|---|---|
|
100
|
species_ID | Unknown | Unique ID number | |
|
100
|
band_ID | Unknown | BioBand ID - Links table to a bioband | |
|
100
|
SppTxtCode | Unknown | SppTXtCode used for data entry, and links to lookup to allow queries using the full species name. | |
|
100
|
SppTextCodeCombined | Unknown | to combined a few spp names to standard one: Fucus, Lottia spp etc | |
|
100
|
abundance | VARCHAR2 | A=Abundant;C=Common;F=Few;R=Rare | |
|
100
|
microhab | Unknown | Tidepool; Underboulder; etc. | |
|
100
|
comments | Unknown | Comments about a particular species. | |
|
100
|
oldBand_ID | Unknown | -no description- | |
|
100
|
CreatedDate | Unknown | -no description- |
Attribute Details
species_ID
CC ID: 228592
| Data Storage Type: | Unknown |
|---|---|
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Unique ID number |
| Allowed Values: | No domain defined. |
band_ID
CC ID: 228593
| Data Storage Type: | Unknown |
|---|---|
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
BioBand ID - Links table to a bioband |
| Allowed Values: | Unable to resolve domain. |
SppTxtCode
CC ID: 228594
| Data Storage Type: | Unknown |
|---|---|
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
SppTXtCode used for data entry, and links to lookup to allow queries using the full species name. |
| Allowed Values: | Unable to resolve domain. |
SppTextCodeCombined
CC ID: 228595
| Data Storage Type: | Unknown |
|---|---|
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
to combined a few spp names to standard one: Fucus, Lottia spp etc |
| Allowed Values: | No domain defined. |
abundance
CC ID: 228596
| Data Storage Type: | VARCHAR2 |
|---|---|
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
A=Abundant;C=Common;F=Few;R=Rare |
| Allowed Values: | A, C, F, R |
microhab
CC ID: 228597
| Data Storage Type: | Unknown |
|---|---|
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Tidepool; Underboulder; etc. |
| Allowed Values: | No domain defined. |
comments
CC ID: 228598
| Data Storage Type: | Unknown |
|---|---|
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Comments about a particular species. |
| Allowed Values: | No domain defined. |
oldBand_ID
CC ID: 228599
| Data Storage Type: | Unknown |
|---|---|
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
-no description- |
| Allowed Values: | No domain defined. |
CreatedDate
CC ID: 228600
| Data Storage Type: | Unknown |
|---|---|
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
-no description- |
| Allowed Values: | No domain defined. |
Catalog Details
| Catalog Item ID: | 23954 |
|---|---|
| GUID: | gov.noaa.nmfs.inport:23954 |
| Metadata Record Created By: | Emily A Fergusson |
| Metadata Record Created: | 2015-03-16 15:41+0000 |
| Metadata Record Last Modified By: | SysAdmin InPortAdmin |
| Metadata Record Last Modified: | 2022-08-09 17:11+0000 |
| Metadata Record Published: | 2016-05-18 |
| Owner Org: | AFSC |
| Metadata Publication Status: | Published Externally |
| Do Not Publish?: | N |
| Metadata Last Review Date: | 2016-05-18 |
| Metadata Review Frequency: | 1 Year |
| Metadata Next Review Date: | 2017-05-18 |