Changes between Version 2 and Version 3 of Internal/Inventory-alternative

Timestamp:

Oct 26, 2007, 8:52:10 PM (17 years ago)

Author:

Joseph F. Miklojcik III

Comment:

copied in device table schema from old page

Internal/Inventory-alternative

@@ -18 +18 @@
  6. testbeds ( = "resources" in the previous schema )
 
-
 === devices table ===
-
-This is similar to the previous schema - see: [wiki:Internal/Inventory Inventory]
+|| Field       || Type         || Null || Key || Default || Extra          || Description ||
+|| ID          || int(11)      || NO   || PRI || NULL    || auto_increment || ||
+|| vendor_id   || varchar(8)   || NO   ||     || 0       ||                || ||
+|| device_id   || varchar(8)   || NO   ||     || 0       ||                || ||
+|| OUI         || varchar(8)   || YES  ||     || NULL    ||                || [http://en.wikipedia.org/wiki/Organizationally_Unique_Identifier Organizationally Unique Identifier]||
+|| description || varchar(255) || NO   ||     ||         ||                || ||
 
 === interfaces table ===