13 lines
386 B
SQL
13 lines
386 B
SQL
create table if not exists order_details
|
|
(
|
|
orderid integer not null
|
|
constraint fk_order_details_orders
|
|
references orders (orderid),
|
|
productid integer not null
|
|
constraint fk_order_details_products
|
|
references products(productid),
|
|
constraint pk_order_details
|
|
primary key (orderid, productid),
|
|
quantity integer not null
|
|
);
|