[Bug]: Incomplete Resource Sharing Data Model for Inter-Association Collaboration

[asterixix]

Describe the bug
The current data model doesn't support tracking shared resources between associations, creating a barrier to implementing inter-association resource sharing. There's no way to establish ownership policies, sharing permissions, or track resource movements between organizations.

Steps to Reproduce

1. Attempt to share an inventory item with a related association
2. Try to define access policies for shared resources
3. Look for database tables that track resource borrowing/lending between organizations
4. Observe that the necessary tables and relationships are missing

Expected behavior
The database should include appropriate tables and relationships to track resource sharing between organizations, including ownership, temporary transfers, access permissions, and usage history.

Screenshots
N/A - Data model issue

Desktop (please complete the following information):

• N/A - System-wide data model issue

Additional context
This data model limitation needs to be addressed as part of the MVP development. The enhanced model should support:

• Resource ownership and sharing policies
• Temporary or permanent resource transfers between organizations
• Access permissions for shared resources (view, borrow, edit)
• Request workflows and approval chains
• Usage tracking and history for shared resources
• Conflict detection for scheduling shared resources