/
sp153_job_more_notes

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. 

Related content

14.1 sp153_job_more_notes
14.1 sp153_job_more_notes
More like this
sp071_job_categories
sp071_job_categories
More like this
14.1 sp071_job_categories
14.1 sp071_job_categories
More like this