14.1 sp153_job_more_notes
- Billy Sewell (Unlicensed)
Owned by Billy Sewell (Unlicensed)
Jan 26, 2024
Loading data...
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 14.1 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. |