#1045

Line Items Need Orders

Design the order_lines table for order line items. It needs id as the primary key, required order_id referencing orders(id), and required qty; the database must not allow a line item for a missing order.

CREATE/ALTER/DROP biss — l-ebda SELECT fl-aħħar mhu meħtieġ.

Ir-riżultat tal-query tiegħek jidher hawn

L-ebda skema tal-bidu

Dan l-eżerċizzju jibda mingħajr tabelli — toħloqhom permezz ta' CREATE TABLE.