Entering and generating default data

VP-UML let you design your database with entity relationship diagram (ERD), and finally generate the design to database as database schema. On top of the schema that will be generated, you can also specify default data to add to database upon database generation.

Entering default data

Default data has to be entered in the table record editor. To enable the editor, right click on the background of diagram and selecting Show Table Record Editor from the popup menu.

To show table record editor

Then, select in diagram the entity you want to enter its default data.

Selecting entity

Enter the data in the editor. Double click on a cell to start editing. Click Enter to end editing.

Edited sample data

Selecting foreign key value

To select a foreign key value, click on the cell to popup the drop down menu, and select the value from the menu.

Selecting FK value

Sometimes, you may be uncertain to what the foreign values represent. You can click on the ... button to show the additional pane, and select the proper record from the pane.

Selecting record

Removing a record

To remove a record, select the record you want to remove and click on the Delete record button.

Removing record

Validating records

Record validation helps verify the correctness of entered data. To validate, click on the Validate records button.

Validating records

If anything wrong is detected, the Message pane will popup and a message will appear in it.

Message appear when something goes wrong

Generating default data

To generate sample data to database:

1. Select Tools > Database > Generate Database... from the main menu.
2. Check Export to database and Generate sample data. If you are creating the database the first time, select Create Database for the drop down menu of Generate Database. If you just want to generate data to a previously created database, select Update Database.
   

   Generating database with sample data

3. Click OK to continue.