Import BD MYSQL relationships

0

I have a question, make some internal relations, by a BD designer this is the result:

However, make an export of the BD and install it on another Computer, and although the data DB is fine, there are no relationships ... to what is due? and how should I fix it:

That's how BD is when I import it into another Team:

    
asked by Andres Felipe Diaz 12.05.2017 в 15:25
source

1 answer

0

In your export you should be able to see something like ForeignKey .

Do the export again and find if you have something like I said.

Something like that

CREATE TABLE Orders (
OrderID int NOT NULL,
OrderNumber int NOT NULL,
PersonID int,
PRIMARY KEY (OrderID),
FOREIGN KEY (PersonID) REFERENCES Persons(PersonID)

);

    
answered by 03.07.2017 / 07:20
source