Employee resumé table (EMP_RESUME)

 

The employee resumé table contains a resumé for each employee identified by an employee number.

The employee resumé table is created with the following CREATE TABLE and ALTER TABLE statements: 

CREATE TABLE EMP_RESUME  
             (EMPNO CHAR(6) NOT NULL, 
              RESUME_FORMAT VARCHAR(10) NOT NULL, 
              RESUME CLOB(5K), 
              EMP_ROWID CHAR(40) NOT NULL DEFAULT '', 
              PRIMARY KEY (EMPNO,RESUME_FORMAT))



ALTER TABLE EMP_RESUME             ADD COLUMN DL_RESUME DATALINK(1000)
                LINKTYPE URL NO LINK CONTROL



ALTER TABLE EMP_RESUME 
              ADD FOREIGN KEY (EMPNO) 
              REFERENCES EMPLOYEE 
              ON DELETE RESTRICT

The following index is created: 

CREATE UNIQUE INDEX XEMP_RESUME 
              ON EMP_RESUME (EMPNO,RESUME_FORMAT)

The table below shows the content of the columns.

Column name Description
EMPNO Employee number
RESUME_FORMAT Format of text stored in RESUME
RESUME Resumé
EMP_ROWID Unique row id, not currently used

 

Parent topic:

DB2 Universal Database for iSeries sample tables