Slide Menu
Search Help Show/Hide Menu

Item Identification

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

Data file table for Captions 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 Captions 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 Captions file
100
Primary Key FILE_ID NUMBER Captions 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: 350019
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 Captions file

General Data Type: NUMBER

FILE_ID

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

Captions table file ID

General Data Type: NUMBER

FILE_NAME

CC ID: 350021
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: 350022
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: 350023
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: 34879
GUID: gov.noaa.nmfs.inport:34879
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