Skip to content

Instantly share code, notes, and snippets.

@joevandyk
Created June 7, 2012 22:54
Show Gist options
  • Select an option

  • Save joevandyk/2892196 to your computer and use it in GitHub Desktop.

Select an option

Save joevandyk/2892196 to your computer and use it in GitHub Desktop.
begin;
-- orders have many line_items, refunds have many line_items, but a refund can't be associated with line items from different orders.
create table orders(id integer primary key);
create table line_items(id integer primary key, order_id integer references orders);
create table refunds(id integer primary key);
create table line_items_refunds(line_item_id integer references line_items, refund_id integer references refunds);
insert into orders values (1);
insert into orders values (2);
-- each order has one associated line item.
insert into line_items values (1, 1);
insert into line_items values (2, 2);
-- create a refund..
insert into refunds values (1);
-- Problem! We have line items from two different orders associated with the refund.
insert into line_items_refunds (line_item_id, refund_id) values (1, 1);
insert into line_items_refunds (line_item_id, refund_id) values (2, 1);
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment