Hi,
I would like to make a database with a pyramid schema. How do i do it? Plz help!!
i.e. lv0 can have 0-n nodes (lv1) and lv1 can have 0-n nodes etc?
every node has id and parent_id. If parent_id = 0 (or NULL, whatever you like), it's top-level element. Else parent_id is id of the parent node.
Thank you!
The only problem is that you can't retrieve all the ancestors of a single element with one query, you need to do recursive requests.
