Network Schema

This page describes the schema layout for the technical network relations inside of the PostgreSQL database. There are three relations associated with the technical networks which are networks, nodes and edges. Each of these relations is described in detail below.

Networks

The relation "networks" is designed to show what networks exist and are defined by two commit IDs where new_commit_id is the most recent commit and network_id is the unique network identifier.

new_commit_id	old_commit_id	network_id
character varying(255)	character varying(255)	integer not null auto_increment

Nodes

The relation "nodes" is designed to represent a node in the technical network graph and contains information about that node, mainly the name of the node. The label column is the name of the node and the network_id associates it to a specific network.

id	label	network_id
character varying(255)	character varying(255)	integer

Edges

The relation "edges" is designed to represent an edge in the technical network graph between two given nodes. Source and target are the connected node.

source	target	weight	network_id
character varying(255)	character varying(255)	integer	integer