14.1 sp264_job_skills
- Billy Sewell (Unlicensed)
Owned by Billy Sewell (Unlicensed)
Jan 26, 2024
Loading data...
This table is used to define the set of skills required by a specified job.
HouseKeeping
This table is tidied by sp_dbtidy's Job group.
Table Definition
Field | Type | Default | Nullable |
|---|---|---|---|
| job_no | number(9) |  | |
| skill_no | number(9) | | |
| skill_level | number(2) | |
Keys
primary key (job_no, skill_no)
foreign key (skill_no) references 14.1 sp211_resources (resource_no)
Column Descriptions
| Field | Description |
|---|---|
| job_no | Job identifier. |
| skill_no | Resource identifier of the required skill. |
| skill_level | The required skill level for the employee to be assigned the task. |