Slide Menu
Search Help Show/Hide Menu

Item Identification

Title: Table: Media
Short Name: Media
Status: In Work

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
67
ID INT
67
TRIPID INT
67
NOTES VARCHAR
67
UPLOADFILENAME VARCHAR
67
UPLOADFILEEXTENSION VARCHAR
67
UPLOADCONTENTTYPE VARCHAR
67
DATEVIDEOTAKEN DATETIME
67
LASTUPDATE DATETIME
67
LASTUPDATEBY INT

Attribute Details

ID

CC ID: 178739
Seq. Order: 1
Data Storage Type: INT
Max Length: 4
Required: Yes
Primary Key: No
Precision: 10
Status: Active

TRIPID

CC ID: 178740
Seq. Order: 2
Data Storage Type: INT
Max Length: 4
Required: No
Primary Key: No
Precision: 10
Status: Active

NOTES

CC ID: 178741
Seq. Order: 3
Data Storage Type: VARCHAR
Max Length: -1
Required: No
Primary Key: No
Status: Active

UPLOADFILENAME

CC ID: 178742
Seq. Order: 4
Data Storage Type: VARCHAR
Max Length: 95
Required: No
Primary Key: No
Status: Active

UPLOADFILEEXTENSION

CC ID: 178743
Seq. Order: 5
Data Storage Type: VARCHAR
Max Length: 5
Required: No
Primary Key: No
Status: Active

UPLOADCONTENTTYPE

CC ID: 178744
Seq. Order: 6
Data Storage Type: VARCHAR
Max Length: 50
Required: No
Primary Key: No
Status: Active

DATEVIDEOTAKEN

CC ID: 178745
Seq. Order: 7
Data Storage Type: DATETIME
Max Length: 8
Required: No
Primary Key: No
Status: Active

LASTUPDATE

CC ID: 178746
Seq. Order: 8
Data Storage Type: DATETIME
Max Length: 8
Required: No
Primary Key: No
Status: Active

LASTUPDATEBY

CC ID: 178747
Seq. Order: 9
Data Storage Type: INT
Max Length: 4
Required: No
Primary Key: No
Precision: 10
Status: Active

Catalog Details

Catalog Item ID: 21885
GUID: gov.noaa.nmfs.inport:21885
Metadata Record Created By: Eric Forney
Metadata Record Created: 2014-07-11 17:53+0000
Metadata Record Last Modified By: SysAdmin InPortAdmin
Metadata Record Last Modified: 2022-08-09 17:11+0000
Metadata Record Published: 2015-12-03
Owner Org: PIRO
Metadata Publication Status: Published Externally
Do Not Publish?: N
Metadata Last Review Date: 2015-12-03
Metadata Review Frequency: 1 Year
Metadata Next Review Date: 2016-12-03