Slide Menu
Search Help Show/Hide Menu

Item Identification

Title: Table: SASI_FIGURES
Short Name: SASI_FIGURES
Status: Completed
Abstract:

Data file table for Figures 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 Figures information type

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
Primary Key YEAR_SPECIES_STOCK_ID NUMBER ID of the year/species/stock for this Figures file
100
Primary Key FILE_ID NUMBER Figures 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

CC ID: 350024
Seq. Order: 1
Data Storage Type: NUMBER
Max Length: 22
Required: Yes
Primary Key: Yes
Precision: 38
Status: Active
Description:

ID of the year/species/stock for this Figures file

General Data Type: NUMBER
Foreign Key Relations:

SASI.SASI_YEAR_SPECIES_STOCKS

FILE_ID

CC ID: 350025
Seq. Order: 2
Data Storage Type: NUMBER
Max Length: 22
Required: Yes
Primary Key: Yes
Precision: 38
Status: Active
Description:

Figures table file ID

General Data Type: NUMBER

FILE_NAME

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

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

CC ID: 350028
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: 34880
GUID: gov.noaa.nmfs.inport:34880
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