| Field | Type | Null | Default | Comments |
|---|---|---|---|---|
| prefix | char(6) | No | The six digits of the OUI itself , seperators omitted | |
| comp_id | int(10) | No | ID of the company that is assigned this OUI (points to tb_company) | |
| date | date | Yes | NULL | The date this OUI was first added. |
| dev_id | mediumint(8) | Yes | NULL | ID of the device class associated with this OUI (points to tb_device) |
| model_id | mediumint(8) | Yes | NULL | ID of the particular model of device associated with this OUI (points to tb_model) |
| media_id | mediumint(8) | Yes | NULL | ID of the media type for this device class (points to tb_media) |
| dar | tinyint(3) | No | 3 | Data Accuracy Rating, a simple numeric value to indicate the approximate accuracy of this entry overall. Standard range is 1 through 5. |
| notes | tinytext | Yes | NULL | Any notes about this OUI entry, such as data sources, URLs, etc. |
| Field | Type | Null | Default | Comments |
|---|---|---|---|---|
| comp_id | int(10) | No | Unique ID for each entry, primary key | |
| parent_comp_id | int(10) | Yes | NULL | Company ID of parent company (if any) |
| compname | varchar(128) | No | Name of company or organization | |
| address1 | varchar(128) | Yes | NULL | Current Address (line 1) |
| address2 | varchar(128) | Yes | NULL | Current Address (line 2) |
| address3 | varchar(128) | Yes | NULL | Current Address (line 3) |
| address4 | varchar(128) | Yes | NULL | |
| address5 | varchar(128) | Yes | NULL | |
| country | varchar(64) | No | Current country | |
| date | date | Yes | NULL | Date this company first appeared in OUI knowledgebase |
| orgcompname | varchar(128) | Yes | NULL | Original company name |
| orgaddress1 | varchar(128) | Yes | NULL | Original Address (line 1) |
| orgaddress2 | varchar(128) | Yes | NULL | Original Address (line 2) |
| orgaddress3 | varchar(128) | Yes | NULL | Original Address (line 3) |
| orgaddress4 | varchar(128) | Yes | NULL | |
| orgaddress5 | varchar(128) | Yes | NULL | |
| orgcountry | varchar(64) | Yes | NULL | Original company |
| notes | tinytext | Yes | NULL | Any notes about this company entry (i.e. history, URLs, etc) |
| Field | Type | Null | Default | Comments |
|---|---|---|---|---|
| dev_id | mediumint(10) | No | Unique ID for each device class entry, primary key | |
| devname | varchar(128) | No | Device Class/Device Name | |
| notes | mediumtext | Yes | NULL | Any notes about this device entry (i.e. similarity to other devices, possible sub-classes, etc) |
| Field | Type | Null | Default | Comments |
|---|---|---|---|---|
| media_id | mediumint(8) | No | Unique ID for each media type entry. These values are to be referenced in a bitmask from the tb_OUI table, to support multiple media type entries for each OUI | |
| medianame | varchar(128) | No | Name of media type | |
| notes | mediumtext | Yes | NULL | Any notes about this media type (i.e. aliases, URLs, etc) |
| Field | Type | Null | Default | Comments |
|---|---|---|---|---|
| model_id | mediumint(8) | No | Unique ID for each device model entry, primary key | |
| dev_id | mediumint(8) | Yes | NULL | ID of device class this model entry is associated with (i.e. "Blackberry" is a model of "Smartphone" devices) |
| modelname | varchar(128) | No | Name of the device model | |
| notes | tinytext | Yes | NULL | Any notes about this device model (i.e. model number, reference URL, aliases, etc) |