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_no | number(9)Â | Â | |
more_notes | clob |  |
KeysÂ
primary key (job_no)Â
foreign key (job_no) references sp111_jobs (job_no)
Column Descriptions
Field | Description |
---|---|
job_no | Job identifier.  |
more_notes | An optional extra description text that can be supplied when the job is booked. |