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 |