Setting up Inital Database Schema

[Hamish Gray]

Hi,

I am new to MySQL but not DB's in general. Having normally used GUIs (SQL Server, MS Access etc) to build table and the like.

When creating tables etc is it normal practice to build the tables 1st, setting up data types, Primary keys etc then once all the tables are there go back and Ammend the tables to set the relationships???

My aim is to have one script to build the lot and I was putting in relationships as I went but then realised the order I build my table would be important then.

My guess is I have answered my own question, but would like to know if there is any other standard methods people use.

thanks
Hamish