· 8 years ago · Nov 24, 2017, 11:48 AM
1FOREIGN KEY (id) REFERENCES Personne(id)
2
3CREATE TABLE IF NOT EXISTS Client (
4id BIGINT UNSIGNED NOT NULL,
5ref_commune BIGINT UNSIGNED NOT NULL,
6ref_staff_admin BIGINT UNSIGNED NOT NULL,
7
8FOREIGN KEY (id) REFERENCES Personne(id),
9FOREIGN KEY (ref_commune) REFERENCES Commune(id),
10FOREIGN KEY (ref_staff_admin) REFERENCES Staff_admin(id)