/
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_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. |
, multiple selections available,
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