dbTable: HARDWARE_ADDRESSES - GMaynard1/emolt_serverside GitHub Wiki
PURPOSE
This table stores information about hardware addressess assigned to particular sensors or other items in the equipment inventory. They are recorded separately because they can change if equipment is refurbished by the manufacturer
TABLE DEFINITIONS
| Field | Type | Collation | Null | Key | Default | Extra | Privileges | Comment |
|---|---|---|---|---|---|---|---|---|
| HARDWARE_ID | int | NULL | NO | PRI | NULL | auto_increment | select,insert,update,references | A unique identifier used in this database only |
| INVENTORY_ID | int | NULL | YES | MUL | NULL | select,insert,update,references | Foreign key from EQUIPMENT_INVENTORY | |
| ADDRESS_TYPE | varchar(50) | utf8mb4_0900_ai_ci | YES | NULL | select,insert,update,references | Type of address (e.g., MAC, Satellite, Bluetooth) | ||
| HARDWARE_ADDRESS | varchar(100) | utf8mb4_0900_ai_ci | YES | NULL | select,insert,update,references | The actual address |