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)

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

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.