dbTable: EQUIPMENT_INVENTORY

PURPOSE

This table stores information regarding the current disposition of equipment owned by the eMOLT program

TABLE DEFINITIONS

Field	Type	Collation	Null	Key	Default	Extra	Privileges	Comment
INVENTORY_ID	int	NULL	NO	PRI	NULL	auto_increment	select,insert,update,references	A unique identifier used in this database only
SERIAL_NUMBER	varchar(50)	utf8mb4_0900_ai_ci	NO		NULL		select,insert,update,references	The serial number of the hardware
EQUIPMENT_TYPE	set('LOGGER','DECK_BOX','COMMS_UNIT')	utf8mb4_0900_ai_ci	NO		NULL		select,insert,update,references	The broad category of equipment this item falls into
MAKE	varchar(50)	utf8mb4_0900_ai_ci	NO		NULL		select,insert,update,references	Equipment manufacturer
MODEL	varchar(50)	utf8mb4_0900_ai_ci	NO		NULL		select,insert,update,references	Model number or other identifier from manufacturer
SOFTWARE_VERSION	varchar(50)	utf8mb4_0900_ai_ci	YES		NULL		select,insert,update,references	Software version if applicable, else NULL
FIRMWARE_VERSION	varchar(50)	utf8mb4_0900_ai_ci	YES		NULL		select,insert,update,references	Firmware version if applicable, else NULL
CURRENT_LOCATION	set('HOME','LAB','VESSEL','MANUFACTURER','LOST','DECOMMISSIONED')	utf8mb4_0900_ai_ci	NO		NULL		select,insert,update,references	Where the equipment is currently located
CUSTODIAN	int	NULL	YES	MUL	NULL		select,insert,update,references	Contact of person who has possession of the equipment
FUNDING_SOURCE	int	NULL	YES	MUL	NULL		select,insert,update,references	How the initial purchase of the equipment was funded. This may not be known for older equipment, but should be tracked moving forward.
PURCHASE_DATE	datetime	NULL	YES		NULL		select,insert,update,references	When the equipment was purchased. This may not be known for older equipment, but should be tracked moving forward.
PURCHASE_PRICE_USD	int	NULL	YES		NULL		select,insert,update,references	The initial cost of the device in US Dollars. This may not be known for older equipment, but should be tracked moving forward.

MYSQL CODE