|
 |
Computer
Fields:
| Field |
Type |
Comments |
| ComputerID | int(11) | |
| OfficeID | int(11) | |
| MACAddress | varchar(17) | |
| OfficeName | varchar | |
| ComputerName | varchar | |
| OperatingSystem | varchar | |
| WordVersion | varchar | |
| CPU | varchar | |
| CPU_MHz | int(11) | |
| PhysicalMemory | int(11) | |
| ScreenWidth | int(11) | |
| ScreenHeight | int(11) | |
| ScreenPixelsPerInch | int(11) | |
| LocalIPAddress | varchar | |
| PublicIPAddress | varchar | |
| LastLogOn | datetime | |
| LogonName | varchar | |
| LogonOffice | varchar | |
| Message | text | |
| MessageAction | int(11) | |
| ShutdownTime | datetime | |
| ExpectedReturn | datetime | |
| Closed | tinyint(1) | |
| ClosedMessage | text | |
| Created | datetime | |
| LoggedOn | tinyint(1) | |
| LocalDatabase | tinyint(1) | |
| NoErrorLog | tinyint(1) | |
| Build | int(11) | |
| BuildDate | datetime | |
Indexes:
| Key |
Column |
Comment |
| PRIMARY | ComputerID | |
| MACAddress | MACAddress | |
|
|
© Radical Solutions Limited 2005
|
|