Description
noneTable properties
| name | value |
|---|
| name | JESSE.IN_TRAY
|
| created | 3/16/2010 8:49:03 PM
|
| tablespace | USERSPACE1
|
| status | normal
|
| percent free | no statistics |
| rows | 3 |
| pages | 1 |
| average row length | 496 |
Columns
| column | datatype | default | nulls | PK | FK | UQ | comment |
|---|
| RECEIVED
| TIMESTAMP
(10,6)
|
| Y
|
|
|
|
|
| SOURCE
| CHARACTER
(8)
|
| Y
|
|
|
|
|
| SUBJECT
| CHARACTER
(64)
|
| Y
|
|
|
|
|
| NOTE_TEXT
| VARCHAR
(3000)
|
| Y
|
|
|
|
|
Sample rows
| RECEIVED | SOURCE | SUBJECT | NOTE_TEXT |
|---|
| 12/25/1988 5:12:30 PM
| BADAMSON
| FWD: Fantastic year! 4th Quarter Bonus.
| To: JWALKER Cc: QUINTANA, NICHOLLS Jim, Looks like our hard work has paid off. I have some good...
|
| 12/23/1988 8:53:58 AM
| ISTERN
| FWD: Fantastic year! 4th Quarter Bonus.
| To: Dept_D11 Congratulations on a job well done. Enjoy this year's bonus. Irv <Forwarding f...
|
| 12/22/1988 2:07:21 PM
| CHAAS
| Fantastic year! 4th Quarter Bonus.
| To: All_Managers Our 4th quarter results are in. We pulled together as a team and exceeded our pl...
|
Code
CREATE TABLE "JESSE "."IN_TRAY" (
"RECEIVED" TIMESTAMP ,
"SOURCE" CHAR(8) ,
"SUBJECT" CHAR(64) ,
"NOTE_TEXT" VARCHAR(3000) )
IN "USERSPACE1" ;