About Network Visualizer

Project Overview

The Network Visualizer is a tool designed to explore and visualize relationships between companies and individuals in our database. It allows users to see connections, ownership structures, and other relationships in an interactive graph format.

Database Structure

Our database consists of two main tables:

Nodes Table

  • fiscal_code: Unique identifier for each entity
  • entity_type: Person or Company
  • name: Name of the entity
  • partita_iva: Tax ID for companies
  • address: Registered address
  • revenue: For companies
  • dob: Date of birth for individuals
  • gender: For individuals
  • place_of_birth: For individuals
  • province_of_birth: For individuals

Edges Table

  • source_fiscal: Fiscal code of the source entity
  • target_fiscal: Fiscal code of the target entity
  • relationship_type: Type of relationship (e.g., "Consigliere", "Azionista")
  • percentage: For relationships with a percentage value (e.g., ownership)

How to Use

To use the Network Visualizer:

  1. Enter a fiscal code in the search box
  2. Select the depth of relationships to display
  3. Click "Search" to generate the graph
  4. Interact with the graph by dragging nodes, hovering for details, or clicking for more information
  5. Use the "Take Screenshot" button to save the current view