Document toolboxDocument toolbox

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_nonumber(9)  (error)
job_equip_nonumber(3)  (error)
resource_nonumber(9)  (error)
substitutenumber(1)  (error)
resource_ref varchar2(30)  (tick)

Keys

foreign key (job_no, job_equip_no) references 14.1 sp110_job_equipment (job_no, job_equip_no)

Column Descriptions

FieldDescription
job_noJob identifier 
job_equip_noEquipment requirement number (value between 1 and 30). 
resource_noResource Identifier. 
substitute

Identifies whether the resource identifier is a substitute:

0 - first choice spare

1 - substitute spare  

resource_ref'External' spare reference.