Kexi/Handbook/Building Simple Databases/Designing Database Tables: Difference between revisions
(Merging Burkhards fixes to k.d.o version) |
m (grammatical changes for readability) |
||
| (One intermediate revision by the same user not shown) | |||
| Line 8: | Line 8: | ||
<!--T:3--> | <!--T:3--> | ||
<!--FIXME changes to the project navigator for 2.9.2 currently invalidate this--> | |||
# Select <menuchoice>Table</menuchoice> from the toolbar. You can also use <menuchoice>Create object: table</menuchoice> in the context menu of the <menuchoice>Tables</menuchoice> item in the Project Navigator. </translate> | # Select <menuchoice>Table</menuchoice> from the toolbar. You can also use <menuchoice>Create object: table</menuchoice> in the context menu of the <menuchoice>Tables</menuchoice> item in the Project Navigator. </translate> | ||
<translate> | <translate> | ||
<!--T:4--> | <!--T:4--> | ||
# The Table Designer | # The Table Designer window will appear. Looking at the window's tab you will see that '''Kexi''' gives a generic name like '''Table1''' for the new table. The table design is not yet saved, you will be able to assign a more suitable name later. Also, the table name is not yet visible in the '''Project Navigator'''. | ||
<!--T:5--> | <!--T:5--> | ||
Latest revision as of 13:38, 1 May 2015
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.
- Select from the toolbar. You can also use in the context menu of the item in the Project Navigator.
- The Table Designer window will appear. Looking at the window's tab you will see that Kexi gives a generic name like Table1 for the new table. The table design is not yet saved, you will be able to assign a more suitable name later. Also, the table name is not yet visible in the Project Navigator.