Kexi/Handbook/Building Simple Databases/Designing Database Tables: Difference between revisions
(Merging Burkhards fixes to k.d.o version) |
m (grammatical changes for readability) |
||
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's window will appear. Looking at the top of designer's window you will notice that '''Kexi''' | # 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'''. | ||
<!--T:5--> | <!--T:5--> |
Revision as of 19:51, 27 April 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'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.