How to maintain user-modifiable order of items in SQL
My application handles many-to-one relationships between packages and documents. A package contains multiple documents. They are currently stored in PostgreSQL database using tables package
and document
, where table document
has a foreign key column package-id
.