Slide Menu
Search Help Show/Hide Menu

Item Identification

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

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

Data Attributes

Attribute Summary

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

General Data Type: NUMBER
Foreign Key Relations:

SASI.SASI_YEAR_SPECIES_STOCKS

FILE_ID

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

Models table file ID

General Data Type: NUMBER

FILE_NAME

CC ID: 350041
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: 350042
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: 350043
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: 34884
GUID: gov.noaa.nmfs.inport:34884
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