sp264_job_skills
- Jason Andrew
Owned by Jason Andrew
Oct 02, 2024
1 min read
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 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. |