-
Notifications
You must be signed in to change notification settings - Fork 0
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.
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 |
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 |
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 |