|
EMPNO |
CHARACTER |
6 |
0 |
1251 |
|
|
|
|
|
PROJNO |
CHARACTER |
6 |
0 |
1251 |
|
|
|
|
|
ACTNO |
SMALLINT |
2 |
0 |
0 |
|
|
|
|
|
EMPTIME |
DECIMAL |
5 |
2 |
0 |
|
|
|
|
|
EMSTDATE |
DATE |
4 |
0 |
0 |
|
|
|
|
|
EMENDATE |
DATE |
4 |
0 |
0 |
|
|
|
|
Total: 6 column(s)
Total: 1 referenced table(s)
|
SYSIBM |
USER |
CONTROL=HELD, ALTER=HELD_GRANTABLE, DELETE=HELD_GRANTABLE, INDEX=HELD_GRANTABLE, INSERT=HELD_GRANTABLE, SELECT=HELD_GRANTABLE, REFERENCE=HELD_GRANTABLE, UPDATE=HELD_GRANTABLE |
Total: 1 autherisation(s)
CREATE TABLE "USER "."EMP_ACT" (
"EMPNO" CHAR(6) NOT NULL ,
"PROJNO" CHAR(6) NOT NULL ,
"ACTNO" SMALLINT NOT NULL ,
"EMPTIME" DECIMAL(5,2) ,
"EMSTDATE" DATE ,
"EMENDATE" DATE )
IN "USERSPACE1" ;
ALTER TABLE "USER "."EMP_ACT"
ADD CONSTRAINT "NOACTIONNOACTION" FOREIGN KEY
("EMPNO")
REFERENCES "USER "."EMPLOYEE"
("EMPNO")
ON DELETE NO ACTION
ON UPDATE NO ACTION
ENFORCED
ENABLE QUERY OPTIMIZATION;
List of tables