[FR] - Add all different types of entities in databases

[hkdeman]

Right now we show only Tables and Views for SQL based databases.

I want to show all different ones - like Triggers, Functions, etc.

Think about it in detail on what are the best features to add and also for non-SQL equivalent?

[hkdeman]

@claude try to fix and create a PR

[claude]

Claude finished @hkdeman's task —— View job • claude/issue-601-20250904-1225 • Create PR ➔

---

Implementation Complete ✅

I've successfully implemented support for additional database entities in WhoDB:

Backend Implementation:

• Added new entity types: Functions, Procedures, Triggers, Indexes, Sequences, and Types
• Extended the plugin interface with methods for each entity type
• Implemented comprehensive PostgreSQL support with proper SQL queries
• Added MongoDB index support with type detection
• Created GraphQL schema types and resolvers for all entities

Frontend Implementation:

• Created a generic EntityPage component that displays all entity types
• Added GraphQL queries for each entity type
• Updated sidebar navigation to show entity-specific menu items
• Added database-specific logic (e.g., Sequences/Types only for PostgreSQL)
• Used appropriate icons for each entity type

Key Features:

• SQL databases show: Functions, Procedures, Triggers, Indexes
• PostgreSQL additionally shows: Sequences and User-defined Types
• MongoDB shows: Indexes with type information
• Each entity card shows relevant attributes and expandable definitions
• Search functionality for filtering entities

The implementation follows the existing patterns in the codebase and maintains clean separation between CE and EE editions.