1,143
edits
Project:Inventory system: Difference between revisions
From London Hackspace Wiki
→Database schema
(→Ideas) |
|||
| Line 63: | Line 63: | ||
property SMALLINT UNSIGNED NOT NULL, -- property.id | property SMALLINT UNSIGNED NOT NULL, -- property.id | ||
`value` VARCHAR(255) | `value` VARCHAR(255) | ||
); | |||
CREATE TABLE item_links ( | |||
id INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY, | |||
item1 MEDIUMINT UNSIGNED NOT NULL, -- item.id | |||
item2 MEDIUMINT UNSIGNED NOT NULL -- item.id | |||
); | ); | ||
