Explorer in Gridfox

The Explorer feature in Gridfox provides a visual representation of your entire data model, making it easy to understand, manage, and organise your tables, fields, and relationships. With Explorer, you can seamlessly visualise how your data is structured and interconnected.

Key Features of Explorer

Visualise Your Data Model

Explorer displays all your tables, fields, and relationships in a clear and intuitive layout, like a modern take on Microsoft Access. Easily grasp how different elements of your project relate to each other at a glance.

Drag-and-Drop Organisation

You can effortlessly drag tables within the Explorer canvas to organise your view according to your preference, improving readability and clarity of complex data structures.

Creating and Managing Tables

Explorer allows real-time management of your data model:

• Create Tables: Add new tables directly within Explorer.
• Edit Tables: Modify existing tables, updating table names and adjusting fields.
• Delete Tables: Remove tables that are no longer required, keeping your data model tidy and focused.

Creating and Managing Relationships

Efficiently establish and manage relationships between tables directly within Explorer:

• Add Relationships: Define new relationships using intuitive controls.
• Edit Relationships: Adjust relationship types and related tables.
• Delete Relationships: Remove outdated or unnecessary relationships easily.

Adding and Editing Fields

Explorer simplifies the management of fields within tables:

• Add Fields: Insert new fields into existing tables directly from the Explorer view.
• Edit Fields: Update field names, data types, or attributes effortlessly.

How to Use Explorer

1. Access Explorer: Navigate to your project dashboard and click on the Explorer option.
2. Organise Your Tables: Drag tables around the canvas to customise your visual layout.
3. Manage Tables and Fields: Select a table to quickly add, edit, or delete fields.
4. Define Relationships: Connect tables by creating relationships using Explorer’s intuitive interface.

Best Practices

• Regularly update your Explorer view to reflect the current structure of your project.
• Clearly name tables, fields, and relationships for easy recognition.
• Use the drag-and-drop functionality to logically group related tables.

Explorer in Gridfox provides powerful, visual management of your data structures, enabling streamlined oversight, intuitive adjustments, and effective communication of complex data models.