Describe the bug
The current database schema doesn't support hierarchical relationships between organizations, which is needed for the Advanced Association Management MVP. The existing tables only accommodate flat organization structures, leading to inability to represent parent-child relationships between associations.

Steps to Reproduce

1. Try to create a child organization under a parent organization
2. Attempt to represent a federation with multiple member clubs
3. Check database schema for association relationships
4. See that the schema lacks necessary foreign keys and relationship tables

Expected behavior
The database schema should support storing hierarchical relationships between organizations, allowing for multiple levels of parent-child relationships, with appropriate constraints and indices for efficient querying.

Screenshots
N/A - Database schema issue

Desktop (please complete the following information):

• N/A - System-wide database issue

Additional context
This is a foundational issue that needs to be addressed early in the development of the Advanced Association Management MVP. The schema update should consider:

• Hierarchical organization relationships (parent-child)
• Organization types and classification
• Support for permission inheritance along the hierarchy
• Efficient querying of nested organizational structures
• Integrity constraints to prevent circular references