Slide Menu
Jump to Section...
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: Reminders

Entity (ENT)  |  Pacific Islands Regional Office (PIRO)
GUID: gov.noaa.nmfs.inport:21895  |  Updated: August 9, 2022  |  Published / External 

Item Identification

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

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
67
 Primary Key REMINDERID INT
67
 USERID INT
67
 TRIPID INT
67
 DUEDATE DATE
67
 TITLE VARCHAR
67
 FROMUSERID INT
67
 CREATEDON DATETIME

Attribute Details

REMINDERID

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

USERID

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

TRIPID

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

DUEDATE

CC ID: 178908
Seq. Order: 4
Data Storage Type: DATE
Max Length: 3
Required: No
Primary Key: No
Status: Active

TITLE

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

FROMUSERID

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

CREATEDON

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

Catalog Details

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