9 lines
382 B
SQL
9 lines
382 B
SQL
CREATE TABLE IF NOT EXISTS non_conformities (
|
|
id INT AUTO_INCREMENT PRIMARY KEY,
|
|
description TEXT NOT NULL,
|
|
type ENUM('produit', 'processus', 'service') NOT NULL,
|
|
status ENUM('ouvert', 'en_analyse', 'action_lancee', 'clos') NOT NULL DEFAULT 'ouvert',
|
|
gravity ENUM('mineure', 'majeure', 'critique') NOT NULL,
|
|
created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP
|
|
);
|