CREATE TABLE JOB_CONTACTS(
JOB_ID INT NOT NULL,
CONTACT_PERSON VARCHAR(25) NOT NULL,
PHONE VARCHAR(12) NOT NULL,
EMAIL VARCHAR(50) NOT NULL,
PRIMARY_KEY(JOB_ID),
FOREIGN KEY (JOB_ID) REFERENCES JOB(JOB_ID) ON DELETE CASCADE
) ENGINE=Innodb;