Properties

Name: EMPLOYEE 
Schema: USER 
Status: NORMAL 
Create time: 16.06.2006 
Tablespace: USERSPACE1 
Index tablespace:  
Long tablespace:  
Base table schema:  
Base table:  
Rowtype schema:  
Rowtype name:  
Description:  

Columns

Name Type Length Scale Codepage Identity Nulls Default Description
  EMPNO  CHARACTER  1251         
  FIRSTNME  VARCHAR  12  1251         
  MIDINIT  CHARACTER  1251         
  LASTNAME  VARCHAR  15  1251         
  WORKDEPT  CHARACTER  1251         
  PHONENO  CHARACTER  1251         
  HIREDATE  DATE         
  JOB  CHARACTER  1251         
  EDLEVEL  SMALLINT         
  SEX  CHARACTER  1251         
  BIRTHDATE  DATE         
  SALARY  DECIMAL         
  BONUS  DECIMAL         
  COMM  DECIMAL         
Total: 14 column(s)

Indexes

Name Unique rule Type Colnames Description
  USER.CC1151778928062  PRIMARY  REGULAR  EMPNO   
Total: 1 index(s)

Referencing tables

Table Foreign key Primary key
  USER.EMP_RESUME  CC1151778995891  CC1151778928062 
  USER.EMP_ACT  NOACTIONNOACTION  CC1151778928062 
Total: 2 referencing table(s)

Autherisations

Grantor Grantee Authorities
  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)

SQL

CREATE TABLE "USER    "."EMPLOYEE"  (
          "EMPNO" CHAR(6) NOT NULL ,
          "FIRSTNME" VARCHAR(12) NOT NULL ,
          "MIDINIT" CHAR(1) NOT NULL ,
          "LASTNAME" VARCHAR(15) NOT NULL ,
          "WORKDEPT" CHAR(3) ,
          "PHONENO" CHAR(4) ,
          "HIREDATE" DATE ,
          "JOB" CHAR(8) ,
          "EDLEVEL" SMALLINT NOT NULL ,
          "SEX" CHAR(1) ,
          "BIRTHDATE" DATE ,
          "SALARY" DECIMAL(9,2) ,
          "BONUS" DECIMAL(9,2) ,
          "COMM" DECIMAL(9,2) )  
         IN "USERSPACE1" ;

ALTER TABLE "USER    "."EMPLOYEE"
    ADD CONSTRAINT "CC1151778928062" PRIMARY KEY
        ("EMPNO");

See Also

List of tables