This shows you the differences between two versions of the page.
Both sides previous revision Previous revision | |||
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> | </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> | ||
+ |