1,143
edits
Project:Inventory system: Difference between revisions
From London Hackspace Wiki
→Database schema
| Line 50: | Line 50: | ||
title VARCHAR(255) NOT NULL UNIQUE, | title VARCHAR(255) NOT NULL UNIQUE, | ||
category TINYINT UNSIGNED NOT NULL -- category.id | category TINYINT UNSIGNED NOT NULL -- category.id | ||
); | ); | ||
| Line 69: | Line 63: | ||
item1 MEDIUMINT UNSIGNED NOT NULL, -- item.id | item1 MEDIUMINT UNSIGNED NOT NULL, -- item.id | ||
item2 MEDIUMINT UNSIGNED NOT NULL -- item.id | item2 MEDIUMINT UNSIGNED NOT NULL -- item.id | ||
); | |||
CREATE TABLE property ( | |||
id SMALLINT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY, | |||
category TINYINT UNSIGNED NOT NULL DEFAULT 0, -- category.id -- IF 0 THEN common | |||
name VARCHAR(255) NOT NULL | |||
); | |||
CREATE TABLE property_values ( | |||
id INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY, | |||
property SMALLINT UNSIGNED NOT NULL, -- property.id | |||
`value` VARCHAR(255) NOT NULL | |||
); | ); | ||
