Learn Relational Databases by Building a Mario Database - Build a Mario Database

Backend Development
1

Screenshot (79)
Screenshot (79)1920×940 114 KB

Tell us what’s happening:
Describe your issue in detail here.

Your code so far

Your browser information:

User Agent is: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/110.0.0.0 Safari/537.36

Challenge: Learn Relational Databases by Building a Mario Database - Build a Mario Database

Link to the challenge:

I have been facing this ERROR: column “action_id” referenced in foreign key constraint does not exist can somebody help me what to do. Do i need to Add action_id in characters table.

2

Try it out!

You can always delete the column.

3

I recieved this as ERROR: there is no unique constraint matching given keys for referenced table “characters”

4

I think you need to add UNIQUE to the newly create column prior to turning it to a PRIMARY KEY.

5

there’s no error It was my mistake in place of reference_table I tried to place characters instead of actios . Thank you for your help.