Assistance Fiscale & Droit du Travail – Questions/Réponses

Réponse
Aucune réponse sélectionnée.
CREATE TABLE categories ( id INT AUTO_INCREMENT PRIMARY KEY, name VARCHAR(100) NOT NULL, slug VARCHAR(100) UNIQUE, created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP ); CREATE TABLE subcategories ( id INT AUTO_INCREMENT PRIMARY KEY, category_id INT NOT NULL, parent_id INT DEFAULT NULL, -- Pour la hiérarchie (ex: sous-niveau 2 ou 3) name VARCHAR(100) NOT NULL, slug VARCHAR(100) UNIQUE, level TINYINT DEFAULT 1, -- Niveau dans la hiérarchie (1, 2, 3) created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP, FOREIGN KEY (category_id) REFERENCES categories(id) ON DELETE CASCADE, FOREIGN KEY (parent_id) REFERENCES subcategories(id) ON DELETE SET NULL ); CREATE TABLE questions ( id INT AUTO_INCREMENT PRIMARY KEY, subcategory_id INT NOT NULL, question_text TEXT NOT NULL, created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP, FOREIGN KEY (subcategory_id) REFERENCES subcategories(id) ON DELETE CASCADE ); CREATE TABLE answers ( id INT AUTO_INCREMENT PRIMARY KEY, question_id INT NOT NULL, answer_text TEXT NOT NULL, source VARCHAR(255), -- (ex: "Article L.122 du Code du travail du Mali") created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP, FOREIGN KEY (question_id) REFERENCES questions(id) ON DELETE CASCADE );