Kexi/Handbook/Building Simple Databases/Designing Database Tables: Difference between revisions
(Merging Burkhards fixes to k.d.o version) |
(Merging Burkhards fixes to k.d.o version) |
||
| Line 8: | Line 8: | ||
<!--T:3--> | <!--T:3--> | ||
# Select <menuchoice | # 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''' proposed you a generic name like | # The Table Designer's window will appear. Looking at the top of designer's window you will notice that '''Kexi''' proposed you a generic name like '''Table1''' for the new table. The table design is not saved yet so you will be able to assign more proper name later. Moreover, because of the same reason, the table name is not yet visible in the '''Project Navigator'''. | ||
<!--T:5--> | <!--T:5--> | ||
Revision as of 13:38, 7 April 2012
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 proposed you a generic name like Table1 for the new table. The table design is not saved yet so you will be able to assign more proper name later. Moreover, because of the same reason, the table name is not yet visible in the Project Navigator.