program to make a database scratch

sapoxgn

Anyone knows/use a program to make a scratch of a database?

Like.. linking the table relations and all this stuff??

i aways make it on papel.. but sometimes i get lost with my own scratches :rolleyes:

i m gonna make some big databases with a lot of tables and i wanna make it as clean as possible 😃

thanx for any help 🙂

devinemke

sometimes i use MSAccess to temp out data structures before i hammer it together in mySQL. Access has a feature whereby you can have a visual layout of all of the tables and how they relate to one another.

sapoxgn

Originally posted by devinemke
sometimes i use MSAccess to temp out data structures before i hammer it together in mySQL. Access has a feature whereby you can have a visual layout of all of the tables and how they relate to one another.

hum.. still i dont like msacess it could be a good tool...

thanx for replying 🙂

poisa

PhpMyAdmin has a nice feature that creates a PDF file with the database schemas and the database relations.

It's quite cool. You see the whole database each related field is connected to each other with an arrow in the direction of the relation. Also primary keys are highlighted. You can customize the position of the tables too (though it might take a minute or two to get the hang of it using the DHTML editor, if you have a large amount of tables).

If you have the pma db and tables setup correctly, PhpMyAdmin will remember related fields and already generated PDFs.

sapoxgn

Originally posted by poisa
PhpMyAdmin has a nice feature that creates a PDF file with the database schemas and the database relations.

It's quite cool. You see the whole database each related field is connected to each other with an arrow in the direction of the relation. Also primary keys are highlighted. You can customize the position of the tables too (though it might take a minute or two to get the hang of it using the DHTML editor, if you have a large amount of tables).

If you have the pma db and tables setup correctly, PhpMyAdmin will remember related fields and already generated PDFs.

This should be a good tool, anyway i wanna make the scratch before creating the tables causa i still dont have all the database in mind.. and its a large one.. so make it an have to edit fields is not a good idea 🙂