Kexi/Handbook/Building Simple Databases/Designing Database Tables

From KDE UserBase Wiki
Revision as of 19:51, 27 April 2015 by Inksi (talk | contribs) (grammatical changes for readability)
Other languages:

Designing Database Tables

First, there will be two tables added to your database: Persons and Phones. These are exactly the same tables as described in chapter Database and Spreadsheet. A layout for Persons can be found in section Data integrity and validity in that chapter.

  1. Select Table from the toolbar. You can also use Create object: table in the context menu of the Tables item in the Project Navigator.
  2. The Table Designer's window will appear. Looking at the top of designer's window you will notice that Kexi proposes a generic name like Table1 for the new table. The table design is not yet saved and you can assign a more suitable name. At this stage the table name is therefore not visible in the Project Navigator.