Salary Market

CREATE TABLE setting_xxxxxxxx (
id INT AUTO_INCREMENT PRIMARY KEY,
label TEXT NOT NULL,
code TEXT NOT NULL,
langueid iNT NOT NULL,
active boolean,
FOREIGN KEY (langueid) REFERENCES langue(id) ON DELETE CASCADE
);

CREATE TABLE setting_xxxxxxxx (
id INT AUTO_INCREMENT PRIMARY KEY,
label TEXT NOT NULL,
code TEXT NOT NULL,
langueid INT NOT NULL,
parentid INT NOT NULL,
FOREIGN KEY (langueid) REFERENCES langue(id) ON DELETE CASCADE
);

• TODO: revenant sur l'architecture chaque table separé (setting_country , setting_business_sector,setting_geographic_extent,..)
• + ajouter column (languageId) avec relation
• dans l'api create : en garde le meme path url (/type)
• prends en consideration language (fr,en)

Proposition