Description
noneTable properties
| name | value |
|---|
| name | JESSE.STAFF
|
| created | 3/16/2010 8:49:03 PM
|
| tablespace | USERSPACE1
|
| status | normal
|
| percent free | no statistics |
| rows | 35 |
| pages | 1 |
| average row length | 45 |
Columns
| column | datatype | default | nulls | PK | FK | UQ | comment |
|---|
| ID
| SMALLINT
(2)
|
| N
|
|
|
|
|
| NAME
| VARCHAR
(9)
|
| Y
|
|
|
|
|
| DEPT
| SMALLINT
(2)
|
| Y
|
|
|
|
|
| JOB
| CHARACTER
(5)
|
| Y
|
|
|
|
|
| YEARS
| SMALLINT
(2)
|
| Y
|
|
|
|
|
| SALARY
| DECIMAL
(7,2)
|
| Y
|
|
|
|
|
| COMM
| DECIMAL
(7,2)
|
| Y
|
|
|
|
|
Triggers
Dependency graph
Objects that depend on JESSE.STAFF
Sample rows
| ID | NAME | DEPT | JOB | YEARS | SALARY | COMM |
|---|
| 10
| Sanders
| 20
| Mgr
| 7
| 98357.50
|
|
| 20
| Pernal
| 20
| Sales
| 8
| 78171.25
| 612.45
|
| 30
| Marenghi
| 38
| Mgr
| 5
| 77506.75
|
|
| 40
| O'Brien
| 38
| Sales
| 6
| 78006.00
| 846.55
|
| 50
| Hanes
| 15
| Mgr
| 10
| 80659.80
|
|
| 60
| Quigley
| 38
| Sales
|
| 66808.30
| 650.25
|
| 70
| Rothman
| 15
| Sales
| 7
| 76502.83
| 1152.00
|
| 80
| James
| 20
| Clerk
|
| 43504.60
| 128.20
|
| 90
| Koonitz
| 42
| Sales
| 6
| 38001.75
| 1386.70
|
| 100
| Plotz
| 42
| Mgr
| 7
| 78352.80
|
|
Code
CREATE TABLE "JESSE "."STAFF" (
"ID" SMALLINT NOT NULL ,
"NAME" VARCHAR(9) ,
"DEPT" SMALLINT ,
"JOB" CHAR(5) ,
"YEARS" SMALLINT ,
"SALARY" DECIMAL(7,2) ,
"COMM" DECIMAL(7,2) )
IN "USERSPACE1" ;