myNMS
explain tables of DB: NMS
IP_MAC |
| Field | Type | Null | Key | Default | Extra |
|---|
| IPadd | char(15) | | MUL | | |
| MAC | char(12) | | MUL | | |
| time1 | int(10) unsigned | YES | | | |
| time2 | int(10) unsigned | | MUL | 0 | |
IP_MAC_user |
| Field | Type | Null | Key | Default | Extra |
|---|
| IPadd | char(15) | | MUL | | |
| MAC | char(12) | YES | | | |
| username | char(8) | | MUL | | |
| mtime | int(10) unsigned | | MUL | 0 | |
IP_hostnames |
| Field | Type | Null | Key | Default | Extra |
|---|
| IPadd | varchar(15) | | PRI | | |
| names | text | | | | |
IP_hosts |
| Field | Type | Null | Key | Default | Extra |
|---|
| IPadd | char(15) | | MUL | | |
| name | char(30) | | PRI | | |
MAC_connections |
| Field | Type | Null | Key | Default | Extra |
|---|
| MAC | char(12) | | PRI | | |
| deviceID | int(10) unsigned | YES | | | |
| ifIndex | int(10) unsigned | YES | | | |
| nMACs | int(10) unsigned | YES | | | |
| mtime | timestamp(14) | YES | | | |
SNMP_ifTable |
| Field | Type | Null | Key | Default | Extra |
|---|
| deviceID | int(10) unsigned | | PRI | 0 | |
| ifIndex | int(10) unsigned | | PRI | 0 | |
| Descr | tinytext | YES | | | |
| Type | varchar(60) | YES | | | |
| Speed | int(10) unsigned | YES | | | |
| PhysAddress | varchar(12) | YES | | | |
| AdminStatus | varchar(4) | YES | | | |
| OperStatus | varchar(4) | YES | | | |
| LastChangeAt | int(10) unsigned | YES | | | |
| Name | varchar(20) | YES | | | |
SNMP_ipAddrTable |
| Field | Type | Null | Key | Default | Extra |
|---|
| deviceID | int(10) unsigned | | MUL | 0 | |
| IPadd | char(15) | | MUL | | |
| ifIndex | int(10) unsigned | | | 0 | |
| NetMask | char(15) | | | | |
| Status | int(10) unsigned | YES | | | |
SNMP_system |
| Field | Type | Null | Key | Default | Extra |
|---|
| deviceID | int(10) unsigned | | PRI | 0 | |
| sysName | tinytext | YES | | | |
| sysDescr | tinytext | YES | | | |
| sysContact | tinytext | YES | | | |
| sysLocation | tinytext | YES | | | |
| sysObjectID | varchar(30) | | | | |
| sysObjIDtxt | varchar(80) | YES | | | |
| sysServices | int(10) unsigned | | MUL | 0 | |
| ifNumber | int(10) unsigned | YES | | | |
| UpSinceTime | int(10) unsigned | | | 0 | |
| mtime | int(10) unsigned | | | 0 | |
Shared_Users |
| Field | Type | Null | Key | Default | Extra |
|---|
| username | char(8) | | MUL | | |
| IPadd | char(15) | | MUL | | |
| MAC | char(12) | YES | | | |
| mtime | int(10) unsigned | | MUL | 0 | |
Vendor_MAC |
| Field | Type | Null | Key | Default | Extra |
|---|
| Code | char(6) | | PRI | | |
| Vendor | char(8) | | MUL | | |
| Vendor_name | char(90) | YES | | | |
| Comment | char(70) | YES | | | |
dot1d |
| Field | Type | Null | Key | Default | Extra |
|---|
| deviceID | int(10) unsigned | | PRI | 0 | |
| ifIndex | int(10) unsigned | | PRI | 0 | |
| MAC | char(12) | | PRI | | |
| nMACs | int(10) unsigned | | | 0 | |
| mtime | int(10) unsigned | YES | | | |
export_hosts |
| Field | Type | Null | Key | Default | Extra |
|---|
| hostname | char(30) | | MUL | | |
| filesystem | char(40) | | MUL | | |
netgroup_hosts |
| Field | Type | Null | Key | Default | Extra |
|---|
| groupname | char(15) | | MUL | | |
| hostname | char(30) | | MUL | | |
netgroup_users |
| Field | Type | Null | Key | Default | Extra |
|---|
| groupname | char(15) | | MUL | | |
| username | char(8) | | MUL | | |
passwd |
| Field | Type | Null | Key | Default | Extra |
|---|
| username | varchar(8) | | PRI | | |
| pwd | varchar(13) | | | | |
| pwd_ctime | int(10) unsigned | | | 0 | |
| uid | int(10) unsigned | | | 0 | |
| gid | int(10) unsigned | | | 0 | |
| full_name | tinytext | YES | | | |
| home | tinytext | | | | |
| shell | tinytext | | | | |
| email_address | tinytext | YES | | | |
| email_aliases | tinytext | YES | | | |
quotas |
| Field | Type | Null | Key | Default | Extra |
|---|
| uid | int(10) unsigned | | PRI | 0 | |
| bhard | int(10) unsigned | | | 0 | |
| bsoft | int(10) unsigned | | | 0 | |
| bcurr | int(10) unsigned | | | 0 | |
| btime | int(10) unsigned | | | 0 | |
| fhard | int(10) unsigned | | | 0 | |
| fsoft | int(10) unsigned | | | 0 | |
| fcurr | int(10) unsigned | | | 0 | |
| ftime | int(10) unsigned | | | 0 | |
| ctime | int(10) unsigned | | | 0 | |