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 
Summary
Item Identification
Data Attributes
Catalog Details

Summary

Entity Information

Data Attribute / Type Description
REMINDERID
INT
USERID
INT
TRIPID
INT
DUEDATE
DATE
TITLE
VARCHAR
FROMUSERID
INT
CREATEDON
DATETIME

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