Slide Menu
Search Help Show/Hide Menu

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