1,143
edits
Project:Inventory system: Difference between revisions
From London Hackspace Wiki
→Database schema
| Line 94: | Line 94: | ||
queue TINYINT UNSIGNED NOT NULL, -- queue.id | queue TINYINT UNSIGNED NOT NULL, -- queue.id | ||
item MEDIUMINT UNSIGNED NOT NULL, -- item.id | item MEDIUMINT UNSIGNED NOT NULL, -- item.id | ||
resolved BOOLEAN DEFAULT NULL -- 0 = Ignored, 1 = Done, NULL = Pending | resolved BOOLEAN DEFAULT NULL, -- 0 = Ignored, 1 = Done, NULL = Pending | ||
resolved_date TIMESTAMP DEFAULT NULL | resolved_date TIMESTAMP DEFAULT NULL | ||
); | ); | ||
</pre> | </pre> | ||
