parts

CREATE TABLE `parts` (
	`id` VARCHAR(36) NOT NULL,
	`name` VARCHAR(50) NOT NULL,
	`quantity_per_assembly` INT(11) NOT NULL,
	`total_quantity` INT(10) UNSIGNED NOT NULL,
	`act_part_id` VARCHAR(36) NOT NULL,
	`material_type` VARCHAR(100) NOT NULL,
	`powder_coat_colour` VARCHAR(100) NOT NULL,
	`status_id` INT(10) UNSIGNED NOT NULL,
	`deleted` TINYINT(1) UNSIGNED NOT NULL DEFAULT '0',
	`job_id` VARCHAR(36) NOT NULL,
	`unc_path` VARCHAR(255) NULL DEFAULT NULL,
	PRIMARY KEY (`id`),
	INDEX `job_id` (`job_id`),
	INDEX `status_id` (`status_id`)
)
ENGINE=InnoDB
ROW_FORMAT=DEFAULT