Table: SASI_BACKGROUND
Entity (ENT) | Northeast Fisheries Science Center (NEFSC)GUID: gov.noaa.nmfs.inport:34878 | Updated: August 9, 2022 | Published / External
-
View As
- Full List View
- Printable Form
- EXPORTS
- InPort XML
- View in Hierarchy
Summary
Data file table for Background information type
DescriptionData file table for Background information type
Entity Information
Entity Type
Data Table
Data Attribute / Type | Description |
---|---|
YEAR_SPECIES_STOCK_ID
NUMBER |
ID for the year/species/stock for this Background file |
FILE_ID
NUMBER |
Background table file ID |
FILE_NAME
VARCHAR2 |
File name for this file |
FILE_EXT
VARCHAR2 |
File extension for this file |
FILE_CONTENTS
BLOB |
The contents of this file |
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: SASI_BACKGROUND |
---|---|
Short Name: | SASI_BACKGROUND |
Status: | Completed |
Abstract: |
Data file table for Background information type |
Notes: |
Loaded by batch 9290, 09-14-2016 14:18 |
Entity Information
Entity Type: | Data Table |
---|---|
Active Version?: | Yes |
Schema Name: | SASI |
Description: |
Data file table for Background information type |
Data Attributes
Attribute Summary
Name | Type | Description | ||
---|---|---|---|---|
100
|
YEAR_SPECIES_STOCK_ID | NUMBER | ID for the year/species/stock for this Background file | |
100
|
FILE_ID | NUMBER | Background table file ID | |
100
|
FILE_NAME | VARCHAR2 | File name for this file | |
100
|
FILE_EXT | VARCHAR2 | File extension for this file | |
100
|
FILE_CONTENTS | BLOB | The contents of this file |
Attribute Details
YEAR_SPECIES_STOCK_ID
Seq. Order: | 1 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | Yes |
Primary Key: | Yes |
Precision: | 38 |
Status: | Active |
Description: |
ID for the year/species/stock for this Background file |
General Data Type: | NUMBER |
Foreign Key Relations: |
SASI.SASI_YEAR_SPECIES_STOCKS |
FILE_ID
Seq. Order: | 2 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | Yes |
Primary Key: | Yes |
Precision: | 38 |
Status: | Active |
Description: |
Background table file ID |
General Data Type: | NUMBER |
FILE_NAME
Seq. Order: | 3 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 100 |
Required: | Yes |
Primary Key: | No |
Status: | Active |
Description: |
File name for this file |
General Data Type: | VARCHAR2 |
FILE_EXT
Seq. Order: | 4 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 6 |
Required: | Yes |
Primary Key: | No |
Status: | Active |
Description: |
File extension for this file |
General Data Type: | VARCHAR2 |
FILE_CONTENTS
Seq. Order: | 5 |
---|---|
Data Storage Type: | BLOB |
Required: | Yes |
Primary Key: | No |
Status: | Active |
Description: |
The contents of this file |
General Data Type: | BLOB |
Catalog Details
Catalog Item ID: | 34878 |
---|---|
GUID: | gov.noaa.nmfs.inport:34878 |
Metadata Record Created By: | Patricia L Jones |
Metadata Record Created: | 2016-09-14 14:18+0000 |
Metadata Record Last Modified By: | SysAdmin InPortAdmin |
Metadata Record Last Modified: | 2022-08-09 17:11+0000 |
Metadata Record Published: | 2019-06-17 |
Owner Org: | NEFSC |
Metadata Publication Status: | Published Externally |
Do Not Publish?: | N |
Metadata Last Review Date: | 2019-06-17 |
Metadata Review Frequency: | 1 Year |
Metadata Next Review Date: | 2020-06-17 |