Search Help Show/Hide Menu
Summary
Item Identification
Entity Info
Data Attributes
Catalog Details

Summary

Abstract

Details for biosample data types

Description

Details 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

Rubric Score Primary Key? Name Type Description
100
Primary Key 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

CC ID: 348131
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

CC ID: 348132
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

CC ID: 348133
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

CC ID: 348134
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

CC ID: 348135
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

CC ID: 348136
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

CC ID: 348130
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