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 |