sp309_spare_substitutes
- Jason Andrew
Owned by Jason Andrew
Oct 02, 2024
1 min read
Loading data...
This table holds any spare substitutes specified as part of the requirements for a job.
HouseKeeping
This table is tidied by sp_dbtidy's Job group.
Â
Table Definition
Field | Type | Default | Nullable |
|---|---|---|---|
| job_no | number(9)Â | Â |  |
| job_equip_no | number(3)Â | Â | |
| resource_no | number(9)Â | Â | |
| substitute | number(1)Â | Â | |
| resource_ref | varchar2(30) |  |  |
Keys
foreign key (job_no, job_equip_no) references sp110_job_equipment (job_no, job_equip_no)
Column Descriptions
| Field | Description |
|---|---|
| job_no | Job identifier |
| job_equip_no | Equipment requirement number (value between 1 and 30). |
| resource_no | Resource Identifier. |
| substitute | Identifies whether the resource identifier is a substitute: 0 - first choice spare 1 - substitute spare  |
| resource_ref | 'External' spare reference. |