OOCYTE
Entity (ENT) | Northeast Fisheries Science Center (NEFSC)GUID: gov.noaa.nmfs.inport:35894 | Updated: August 9, 2022 | Published / External
Summary
Item Identification
Entity Info
Data Attributes
Catalog Details
Data Attributes
Attribute Summary
|
|
Name | Type | Description |
|---|---|---|---|---|
|
100
|
|
FISH_ID_CODE | VARCHAR2 | Unique code for each sampled fish. |
|
100
|
MASS_OF_SUBSAMPLE | NUMBER | Mass in grams of the ovarian subsample | |
|
100
|
OVARY_LOBE | CHAR | Ovary lobe for a subsample: RIGHT or LEFT | |
|
100
|
LOCATION_IN_OVARY | CHAR | Region within ovary subsample was taken: ANTERIOR, MIDDLE, POSTERIOR | |
|
100
|
OOCYTE_COUNT | NUMBER | Count of individual oocytes in an ovarian subsample | |
|
100
|
COMMENTS | VARCHAR2 | Comments field for the fecundity subsample | |
|
100
|
IMAGE_QUALITY | NUMBER | Qualitative score of the quality of the image(s) taken for image processing of a fecundity subsample: 1 = GOOD, 2 = ADEQUATE, or 3 = POOR (not usable) | |
|
100
|
|
SUBSAMPLE | NUMBER | Individual sequential identifier for fecundity subsamples; unique within each specimen |
|
100
|
OOCYTE_ID | NUMBER | No longer used. |
Attribute Details
FISH_ID_CODE
CC ID: 362249
| Seq. Order: | 1 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 20 |
| Required: | Yes |
| Primary Key: | Yes |
| Status: | Active |
| Description: |
Unique code for each sampled fish. |
| General Data Type: | VARCHAR2 |
| Foreign Key Relations: |
FISH_ORGANISM.FISH_ID_CODE |
MASS_OF_SUBSAMPLE
CC ID: 362250
| Seq. Order: | 2 |
|---|---|
| Data Storage Type: | NUMBER |
| Max Length: | 22 |
| Required: | No |
| Primary Key: | No |
| Precision: | 38 |
| Scale: | 4 |
| Status: | Active |
| Description: |
Mass in grams of the ovarian subsample |
| General Data Type: | NUMBER |
OVARY_LOBE
CC ID: 362251
| Seq. Order: | 3 |
|---|---|
| Data Storage Type: | CHAR |
| Max Length: | 1 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Ovary lobe for a subsample: RIGHT or LEFT |
| General Data Type: | CHAR |
LOCATION_IN_OVARY
CC ID: 362252
| Seq. Order: | 4 |
|---|---|
| Data Storage Type: | CHAR |
| Max Length: | 1 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Region within ovary subsample was taken: ANTERIOR, MIDDLE, POSTERIOR |
| General Data Type: | CHAR |
OOCYTE_COUNT
CC ID: 362253
| Seq. Order: | 5 |
|---|---|
| Data Storage Type: | NUMBER |
| Max Length: | 22 |
| Required: | No |
| Primary Key: | No |
| Precision: | 5 |
| Scale: | 0 |
| Status: | Active |
| Description: |
Count of individual oocytes in an ovarian subsample |
| General Data Type: | NUMBER |
COMMENTS
CC ID: 362254
| Seq. Order: | 6 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 500 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Comments field for the fecundity subsample |
| General Data Type: | VARCHAR2 |
IMAGE_QUALITY
CC ID: 362255
| Seq. Order: | 7 |
|---|---|
| Data Storage Type: | NUMBER |
| Max Length: | 22 |
| Required: | No |
| Primary Key: | No |
| Precision: | 38 |
| Scale: | 0 |
| Status: | Active |
| Description: |
Qualitative score of the quality of the image(s) taken for image processing of a fecundity subsample: 1 = GOOD, 2 = ADEQUATE, or 3 = POOR (not usable) |
| General Data Type: | NUMBER |
SUBSAMPLE
CC ID: 362256
| Seq. Order: | 8 |
|---|---|
| Data Storage Type: | NUMBER |
| Max Length: | 22 |
| Required: | Yes |
| Primary Key: | Yes |
| Precision: | 2 |
| Scale: | 0 |
| Status: | Active |
| Description: |
Individual sequential identifier for fecundity subsamples; unique within each specimen |
| General Data Type: | NUMBER |
OOCYTE_ID
CC ID: 362257
| Seq. Order: | 9 |
|---|---|
| Data Storage Type: | NUMBER |
| Max Length: | 22 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
No longer used. |
| General Data Type: | NUMBER |