Database Design
Database Design :
Database design is the process of producing a detailed data model of a database. This model contains all the needed physical design choices and physical storage parameters needed to generate DDL which can then be used to create a database. A fully attributed data model contains detailed attributes for each entity.
From : en.wikipedia.org/wiki/Database_design
PGDesigner
PGDesigner is an attempt at implementing a datamodel designer for PostgreSQL. Good datamodeling tools already exist, but none are open source. So here we are.
Currently Implemented Features:
) Connection to Postgres database
) Ability to run queries on database and display results on results box
) Importing of table objects with foreign key references into diagram from database
) Saving and loading of diagram to file
) Adding of new (blank) tables to diagram
) Changing table names in diagram
) Adding, removing, and changing columns of tables in the diagram
) Mouse resizing and moving of table objects
) Mouse moving of foreign key objects
) Generation of actual SQL commands to create diagrammed database
) Drag and Drop creation of foreign key relationships
) Coloring of tables for easy organization
) Full print preview and paginated printing support of diagram
) Allow selection of multiple tables for moving more than one at a time
visit
PGDesigner
PGDesigner was visited : 171 times
Loading .....