Differences

This shows you the differences between two versions of the page.

--- devel:blueprints:consolidated-interface-table [2009/03/19 13:24] – morten
+++ devel:blueprints:consolidated-interface-table [2009/03/19 13:26] (current) – morten
@@ Line 61: / Line 61: @@
 </code>
+The gwport table contains a field dubbed ''metric'', which represents OSPF metric, where applicable.  A router interface may in reality use multiple routing protocols, so this piece of information should be in an ancillary table:
+<code sql>
+-- Routing protocol attributes
+CREATE TABLE rproto_attr (
+  id SERIAL NOT NULL,
+  interfaceid INT4 NOT NULL,
+  protoname VARCHAR NOT NULL, -- bgp/ospf/isis
+  metric INT4,
+  CONSTRAINT rproto_attr_pkey
+             PRIMARY KEY (id),
+  CONSTRAINT rproto_attr_interfaceid_fkey
+             FOREIGN KEY (interfaceid)
+             REFERENCES interface (interfaceid)
+);
+</code>