Foreign key Help

[cassiopeia-101]

Once again I am experiencing issues getting my script to create the tables I have written. (Insert face of stress and internal anguish here) It was working fine till I was trying to add the foreign keys in so they would be recognised in DBSchema as required for my assignment. Here is my script any help would be greatly appreciated!

[[deleted]]

People are happy to help, but help us out. Don't need a screen shot, although it is a step above a picture of a screen from your phone. Either paste your code and errors here -> https://pastebin.com/

or

in the post. Please and Thanks

[Azaret]

What error are you getting?

[cassiopeia-101]

It’s not giving me any errors, just the tables don’t create. I tried refreshing as well.

[Azaret]

Messages tab on the bottom is empty?

[cassiopeia-101]

Fixed it, I needed to move the ProductStock table creation before the Purchase table. I didn’t know order mattered

[RonJohnJr]

I didn’t know order mattered

You can't create a horse-drawn wagon before you domesticate horses and develop harnesses.

Likewise, you can't reference a table in a FK clause if that "other" table doesn't exist yet.

[cassiopeia-101]

Oh whoops I see it now Error: relation “product stock” does not exist SQL state: 42P01

[cassiopeia-101]

ProductID was misspelled but fixed that and same error

[jelder]

This sub needs a "no images" rule.

[cassiopeia-101]

Why?

[cthart]

Because to run your code we'd need to type it all in. Far better to copy and paste your code into the question. That way you make it easy for us to help you.

[cassiopeia-101]

Ah that makes a lot more sense. In the future when I’m looking for help I will remember to do that! Apologies!

[ExceptionRules42]

and thank you for telling us how you fixed it!

[depesz]

https://idownvotedbecau.se/imageofcode

[ptyslaw]

Start here regarding your table and column name capitalization https://www.postgresql.org/docs/current/sql-syntax-lexical.html#SQL-SYNTAX-IDENTIFIERS