Data Structure
zCI's data structure consists of 32 tables with relationships described in picture below.
| Num. | Column Name | Data Type | Explanation |
|---|---|---|---|
| 1. | computerid | unsigned integer, auto increment | Computer identification number |
| 2. (a) | modelid | unsigned integer, auto increment | Component model's identification number |
(b) | RAM[modelid] | unsigned integer | RAM size in megabyte |
(c) | FLOPPY[modelid] | unsigned tiny integer | 1:floppy drive exist;0:floppy drive not exist |
| (d) | OWNERSHIP_MONITOR[modelid], OWNERSHIP_PERIPHERAL[modelid] | unsigned integer | Ownership model ID. |
| 3. | name | variable-length character | Component model's name |
| 4. | registerdate | date | Item registration date |
| 5. | removed | date | Item's removal date |
| 6. | serialnumber | 31 character | Item serial number |
| 7 | reserved | 1 character | Marking computers are reserved. "Y" means reserved |
| 8. | COMPUTER_SYTEM[hostname] | 31 character | Computer's hostname |
| 9. | COMPUTER_SYTEM[user] | 31 character | Computer's user name |
| 10. | COMPUTER_SYTEM[domain] | unsigned integer | Network domain category ID. |
| 11. | COMPUTER_SYTEM[zciid] | unsigned integer | Identification number for non-branded computers |
| 12. | MODEL_CATEGORY[vendor] | max. 31 characters | Computer vendor's name |
| 13. | MODEL_CATEGORY[model] | max. 63 characters | Computer model |
| 14. | MODEL_CATEGORY[version] | max. 31 characters | Computer model's version |
| 15. | PROCESSOR_CATEGORY[speed] | unsigned integer | Processor maximum speed in MHz, not current speed |
| 16. | HARDDISK_CATEGORY[size] | unsigned small integer | Harddisk's size in GB |
| 17. | NIC[mac] | 17 characters | MAC Address |
| 18. | NIC[ipaddress] | max. 15 characters | Adapter's first IP Address |
| Num. | Value | Type |
|---|---|---|
| 1. | 1000 | Own |
| 2. | 2000 | Lease |
| 3. | 3000 | End of Ownership |
| 4. | 4000 | End of Lease |