Database Schema

marwa66

Hello every body,

I found that there is no foreign keys between the tables in the database????

it seems strange!!!

Do I have a problem or it's designed this way?

because i found that it should have foreign keys

thanks

Chefkeks

There are foreign keys in the database when I'm correct - please correct me if I am wrong.For example take a look at the following tables:ost_attachmentost_fileYou should noticed that the "file_id" in the ost_attachment is link to the actual "id" in the ost_file table.

marwa66

i tried to insert an attachment with file_id equal to 50 which is not found in file table and i didn't get errors????

so i realized that there is no foreign key, they set just the columns names but in the database they are not declared.

even i tried to export the database to sql file so that i could see the relations on workbench, i didn't found any declaration for foreign keys in the exported file.