I have a bunch of code below to create a language table, but there's a mistake closing the parenthesis. When I tried to run, the foreign keys of the speech table, i. H. (Presenter, Job_ID, Post_Date), not successfully referenced to the main table P_Assignment (Staff_ID, Job_ID, Post_Date). See picture attached.
CREATE TABLE language
(Event_name varchar (100) not null)
Event_Date Date is not null
Order_Num int not null,
Content_Abst varchar (250) is not null
Contact int not null
Moderator int not null
Job_ID int not null
Post_date date is not null
CONSTRAINT Speech_PK PRIMARY KEY (event name, event date, order number),
CONSTRAINT Speech_FK1 FOREIGN KEY (event name, event date) REFERENCES T_Event (event name, event date),
CONSTRAINT Speech_FK2 FOREIGN KEY (Contact) REFERENCES NP_Personal (Staff_ID),
CONSTRAINT Speech_FK3 FOREIGN KEY REFERENCES P_Assignment (Staff_ID, Job_ID, Post_Date)
Would be glad about advice from the community. Thank you in advance!