Inventory

This information may be outdated.
If you feel this is in error, please remove the {{outdated}} template.

Software

The Dallas Makerspace inventory system is currently under development. It is licensed under the GNU Affero General Public License.

The software is available at: https://github.com/Dallas-Makerspace/Inventory

Database Schema

Items:

Field	Type	Null	Default	Extra
id	int(10) unsigned	NOT	none	auto_increment
created	datetime	NOT	none
modified	datetime	NOT	none
name	varchar(255)	NOT	none
function	varchar(255)	NULL	NULL
manufacturer	varchar(255)	NULL	NULL
room_id	int(10) unsigned	NOT	none
location	varchar(255)	NOT	none
qty	unsigned smallint(5)	NOT	0
notes	text	NULL	NULL

• Primary Key: id

Rooms:

Field	Type	Null	Default	Extra
id	int(10) unsigned	NOT	none	auto_increment
name	varchar(255)	NOT	none

• Primary Key: id

Verifications:

Field	Type	Null	Default	Extra
id	int(10) unsigned	NOT	none	auto_increment
item_id	int(10) unsigned	NOT	none
created	datetime	NOT	none
username	varchar(255)	NOT	none
comment	text	NULL	NULL

• Primary Key: id

Comments:

Field	Type	Null	Default	Extra
id	int(10) unsigned	NOT	none	auto_increment
item_id	int(10) unsigned	NOT	none
created	datetime	NOT	none
username	varchar(255)	NOT	none
message	text	NOT	none

• Primary Key: id

Categories:

Field	Type	Null	Default	Extra
id	int(10) unsigned	NOT	none	auto_increment
parent_id	int(10) unsigned	NOT	none
name	varchar(255)	NOT	none
lft	int(10) unsigned	NOT	none
rght	int(10) unsigned	NOT	none
item_count	smallint(5)	NULL	NULL

• Primary Key: id

Items_Categories:

Field	Type	Null	Default	Extra
id	int(10) unsigned	NOT	none	auto_increment
item_id	int(10) unsigned	NOT	none
category_id	int(10) unsigned	NOT	none

• Primary Key: id

Uploads:

Field	Type	Null	Default	Extra
id	int(10) unsigned	NOT	none	auto_increment
item_id	int(10) unsigned	NOT	none
name	varchar(255)	NOT	none
description	varchar(255)	NULL	NULL
type	varchar(255)	NOT	none
size	int(10) unsigned	NOT	none
created	datetime	NOT	none

• Primary Key: id