Re: [sqlite] OT: Suitable table schema for object relationship

> A --> B --> C > \ >\--> D --> E You've drawn a tree, but your comments indicate that you want something more general. If you can restrict yourself to trees, you can probably use nested sets (invented by Joe Celko). These are fairly simple to manipulate. A Google search will turn

[sqlite] OT: Suitable table schema for object relationship

Hi, I trying to design a table schema that will allow link relationships between objects with the following features: * Show a direct link relationship between two objects * Be able to remove relationships * Find indirect links between objects (This is were it gets tricky) I have persisted