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: Upload

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

Summary

Entity Information

Data Attribute / Type Description
ID
INT
TRIPID
INT
INCIDENTID
INT
UPLOADFILE
VARBINARY
NOTES
VARCHAR
UPLOADFILENAME
VARCHAR
UPLOADCONTENTTYPE
VARCHAR
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: Upload
Short Name: Upload
Status: In Work

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
67
 Primary Key ID INT
67
 TRIPID INT
67
 INCIDENTID INT
67
 UPLOADFILE VARBINARY
67
 NOTES VARCHAR
67
 UPLOADFILENAME VARCHAR
67
 UPLOADCONTENTTYPE VARCHAR
67
 LASTUPDATE DATETIME
67
 LASTUPDATEBY INT

Attribute Details

ID

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

TRIPID

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

INCIDENTID

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

UPLOADFILE

CC ID: 178982
Seq. Order: 4
Data Storage Type: VARBINARY
Max Length: -1
Required: No
Primary Key: No
Status: Active

NOTES

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

UPLOADFILENAME

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

UPLOADCONTENTTYPE

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

LASTUPDATE

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

LASTUPDATEBY

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

Catalog Details

Catalog Item ID: 21901
GUID: gov.noaa.nmfs.inport:21901
Metadata Record Created By: Eric Forney
Metadata Record Created: 2014-07-11 18:05+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