Inventory

From Dallas Makerspace
Jump to: navigation, search

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