14.1 sp309_spare_substitutes
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 14.1 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. |