CREATE TABLE ORDER_ITEMS (
order_item_id NUMBER(3) PRIMARY KEY,
job_id NUMBER(3),
task_id NUMBER(3),
quantity NUMBER(4),
cost NUMBER(6,2),
other_details VARCHAR2,
FOREIGN KEY (job_id) REFERENCES JOBS (job_id),
FOREIGN KEY (task_id) REFERENCES STANDARD_TASKS(task_id),
FOREIGN KEY (order_item_id) REFERENCES INVOICE_LINE_ITEMS (order_item_id)
);