In-tray table (IN_TRAY)

The in-tray table describes an electronic in-basket that contains the timestamp when a message is received, the user ID of the person who sent the message, and the content of the message.

The in tray table is created with the following CREATE TABLE statement:

CREATE TABLE IN_TRAY
    (RECEIVED            TIMESTAMP,
     SOURCE              CHAR(8),
     SUBJECT             CHAR(64),
     NOTE_TEXT           VARCHAR(3000))

The table below gives the contents of the columns.

Column name	Description
RECEIVED	Date and time received
SOURCE	User ID of person sending the note
SUBJECT	Brief description of the note
NOTE_TEXT	The note