Search Help Show/Hide Menu
Metadata Rubric
50%
3 / 6
View Report
PIRO Metadata Library > Pacific Islands Regional Office Observer Progra... > Pacific Islands Region Observer Program System >

Table: Media

Entity (ENT)  |  Pacific Islands Regional Office (PIRO)
GUID: gov.noaa.nmfs.inport:21885  |  Updated: August 9, 2022  |  Published / External 
Summary
Item Identification
Data Attributes
Catalog Details

Summary

Entity Information

Data Attribute / Type Description
ID
INT
TRIPID
INT
NOTES
VARCHAR
UPLOADFILENAME
VARCHAR
UPLOADFILEEXTENSION
VARCHAR
UPLOADCONTENTTYPE
VARCHAR
DATEVIDEOTAKEN
DATETIME
LASTUPDATE
DATETIME
LASTUPDATEBY
INT

Child Items

No Child Items for this record.

Contact Information

No contact information is available for this record.

Please contact the owner organization (PIRO) for inquiries on this record.

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