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

### Ownership Category Table Value

Num. | Value | Type
--- | --- | ---
1. | 1000 | Own
2. | 2000 | Lease
3. | 3000 | End of Ownership
4. | 4000 | End of Lease