3 lines
184 B
SQL
3 lines
184 B
SQL
ALTER TABLE nurses ADD COLUMN IF NOT EXISTS employee_id INT;
|
|
ALTER TABLE nurses ADD CONSTRAINT fk_nurse_employee FOREIGN KEY (employee_id) REFERENCES employees(id) ON DELETE SET NULL;
|