Description

Directory structure:

• data: Insert some test data.
• procedures: Operations functions of clusure table in postgres dbms.
• triggers: Just one trigger used to chanage parent/child relationship of nodes when add/move nodes in the tree.
• all-in-one.sql: All codes of procedures and triggers
• create_table_structure.sql: Create postgres database tables.

References

Building a nested hierarchy of JSON in a relational DB