Table: SF_BIOSAMP_BIOSAMPLE_TYPES
Entity (ENT) | Northeast Fisheries Science Center (NEFSC)GUID: gov.noaa.nmfs.inport:34607 | Updated: August 9, 2022 | Published / External
-
View As
- Full List View
- Printable Form
- EXPORTS
- InPort XML
- View in Hierarchy
Summary
Details for biosample data types
DescriptionDetails for biosample data types
Entity Information
Entity Type
Data Table
Data Attribute / Type | Description |
---|---|
BIOSAMPLE_TYPE
VARCHAR2 |
Unique biosample type identifier |
BIOSAMPLE_TYPE_DESCR
VARCHAR2 |
Description of the type of biosample collected |
BIOSAMPLE_DATA_FORMAT
VARCHAR2 |
Oracle database data format |
BIOSAMPLE_DATA_LENGTH
NUMBER |
Number of characters allowed during data entry |
BIOSAMPLE_DATA_PRECISION
NUMBER |
Number of digits allowed after the decimal point |
BIOSAMPLE_SAMPLE_ID_REQ
NUMBER |
Indicatition of whether a samle id is required yes=1 no=0 |
BIOSAMPLE_DATA_TYPE_REF
NUMBER |
Biosample data type, support table NERS.SF_BIOSAMP_DATA_TYPES |
Child Items
No Child Items for this record.
Contact Information
No contact information is available for this record.
Please contact the owner organization (NEFSC) for inquiries on this record.
Item Identification
Title: | Table: SF_BIOSAMP_BIOSAMPLE_TYPES |
---|---|
Short Name: | SF_BIOSAMP_BIOSAMPLE_TYPES |
Status: | Completed |
Abstract: |
Details for biosample data types |
Notes: |
Loaded by batch 9250, 09-01-2016 14:18 |
Entity Information
Entity Type: | Data Table |
---|---|
Active Version?: | Yes |
Schema Name: | NERS |
Description: |
Details for biosample data types |
Data Attributes
Attribute Summary
Name | Type | Description | ||
---|---|---|---|---|
100
|
BIOSAMPLE_TYPE | VARCHAR2 | Unique biosample type identifier | |
100
|
BIOSAMPLE_TYPE_DESCR | VARCHAR2 | Description of the type of biosample collected | |
100
|
BIOSAMPLE_DATA_FORMAT | VARCHAR2 | Oracle database data format | |
100
|
BIOSAMPLE_DATA_LENGTH | NUMBER | Number of characters allowed during data entry | |
100
|
BIOSAMPLE_DATA_PRECISION | NUMBER | Number of digits allowed after the decimal point | |
100
|
BIOSAMPLE_SAMPLE_ID_REQ | NUMBER | Indicatition of whether a samle id is required yes=1 no=0 | |
100
|
BIOSAMPLE_DATA_TYPE_REF | NUMBER | Biosample data type, support table NERS.SF_BIOSAMP_DATA_TYPES |
Attribute Details
BIOSAMPLE_TYPE
Seq. Order: | 1 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 3 |
Required: | Yes |
Primary Key: | Yes |
Status: | Active |
Description: |
Unique biosample type identifier |
General Data Type: | VARCHAR2 |
BIOSAMPLE_TYPE_DESCR
Seq. Order: | 2 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 250 |
Required: | Yes |
Primary Key: | No |
Status: | Active |
Description: |
Description of the type of biosample collected |
General Data Type: | VARCHAR2 |
BIOSAMPLE_DATA_FORMAT
Seq. Order: | 3 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 10 |
Required: | Yes |
Primary Key: | No |
Status: | Active |
Description: |
Oracle database data format |
General Data Type: | VARCHAR2 |
BIOSAMPLE_DATA_LENGTH
Seq. Order: | 4 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | Yes |
Primary Key: | No |
Precision: | 3 |
Scale: | 0 |
Status: | Active |
Description: |
Number of characters allowed during data entry |
General Data Type: | NUMBER |
BIOSAMPLE_DATA_PRECISION
Seq. Order: | 5 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 2 |
Scale: | 0 |
Status: | Active |
Description: |
Number of digits allowed after the decimal point |
General Data Type: | NUMBER |
BIOSAMPLE_SAMPLE_ID_REQ
Seq. Order: | 6 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | Yes |
Primary Key: | No |
Precision: | 1 |
Scale: | 0 |
Status: | Active |
Description: |
Indicatition of whether a samle id is required yes=1 no=0 |
General Data Type: | NUMBER |
BIOSAMPLE_DATA_TYPE_REF
Seq. Order: | 7 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | Yes |
Primary Key: | No |
Precision: | 38 |
Status: | Active |
Description: |
Biosample data type, support table NERS.SF_BIOSAMP_DATA_TYPES |
General Data Type: | NUMBER |
Foreign Key Relations: |
NERS.SF_BIOSAMP_DATA_TYPES |
Catalog Details
Catalog Item ID: | 34607 |
---|---|
GUID: | gov.noaa.nmfs.inport:34607 |
Metadata Record Created By: | Patricia L Jones |
Metadata Record Created: | 2016-09-01 14:18+0000 |
Metadata Record Last Modified By: | SysAdmin InPortAdmin |
Metadata Record Last Modified: | 2022-08-09 17:11+0000 |
Metadata Record Published: | 2016-09-01 |
Owner Org: | NEFSC |
Metadata Publication Status: | Published Externally |
Do Not Publish?: | N |
Metadata Last Review Date: | 2016-09-01 |
Metadata Review Frequency: | 1 Year |
Metadata Next Review Date: | 2017-09-01 |