Database schema design online

Database schema design online

My requirement was to design database schema online, so that I shall get a graphical representation of the design.

Googling gave this link

http://dbdsgnr.appspot.com/

Really a good Online - database design tool.

I am writing my experience ( for a short duration only : ) )

1. Design Tables ( Primary Key, Foreign Key etc )
2  Export the Database Design to Image Format
3. Export the Database Design to SQL ( I was impressed with this ! )
4. Store  it permanently and share via link ( like Google Doc's Document Sharing )
5. While creating the design, it prompts for the name of the database ( like Postgres, MySql etc)

With this I generated a sample database design and SQL as well.
See the following Image containing my database design.




SQL : See the SQL script here

http://pastebin.com/BSW9qKdw

But the SQL generated by this tool is not working with Postgres.
For ex. I mentioned a column of a table as primary key. The query generated was with the keyword "AUTO INCREMENT" . But in Postgres, query is to be changed to SERIAL.So need to do a Find  & Replace in text editor to run the query successfully.


You shall explore this site as well.
http://ondras.zarovi.cz/sql/demo/