Design View

The design view is the core of kinodb’s database design functionality.  In Design view, you see a diagram representing part or all of your database design – your database may contain as many of these diagrams as you wish.  Below is a screenshot of the design view. (show full size)

Typically each of these diagrams will represent a specific section of your data model, and you can include each table in your database on any number of diagrams. Within each diagram, you can arrange tables from your database design as required, showing the links and relationships between them.

Diagrams are normally shown in kinodb’s own diagram format, which shows all field definitions and the relationships between tables, as shown in the image below:

Any diagram can also be viewed as a standard Entity Relationship Diagram (ERD) - this shows less design detail but will be more familiar to many database designers. The image below shows the same kinodb diagram in ERD format:

In Design view, you can:

• Add tables and fields
• Create relationships between tables
• Table and field behaviour
• Document your database
• Testing your database immediately
• Instant HTML reporting

See Also