Document toolboxDocument toolbox

sp153_job_more_notes

This table contains additional description for a job, which may be supplied when a job is booked, and may be displayed on a gantt client on request.

HouseKeeping

This table is tidied by sp_dbtidy's Job group.


 

Table Definition

Field
Type
Default
Nullable
job_nonumber(9)  (error)
more_notesclob  (tick)

Keys 

primary key (job_no) 
foreign key (job_no) references sp111_jobs (job_no)

Column Descriptions

FieldDescription
job_no Job identifier.  
more_notesAn optional extra description text that can be supplied when the job is booked.Â