Why did primal keys auto-generate for some of my entities when I converted my entity model to a relational model?

26 Views Asked by At

I produced a relational model from my entity model and some of my entitiess now have primal keys that I didn't generate. I will provide some images from the diagrams. My Add entity In the realatioanl model Add entity

The problem is that these auto-generated keys translate to the ddl script generated from the relational model, like so:

`CREATE SEQUENCE add_add_id_seq START WITH 1 NOCACHE ORDER;`

And when I convert the script to MySQL, it produces these lines:

`CALL CreateSequence('add_add_id_seq', 1, 1);`

It calls procedures that I have not created so an error occures and the code isn't compiling. Why is this happening? What can I do to fix it? Thank you for your time. Here are the complete diagrams. Here is the entity model and here is the relational model.

0

There are 0 best solutions below