The way I've usually seen it done is that the foreign key columns still exist. The relationships are there, the database just doesn't enforce them. The items

The way I've usually seen it done is that the foreign key columns still exist. The relationships are there, the database just doesn't enforce them. The items table might have a shopping_cart_id column