Kexi/Handbook/Building Simple Databases/Designing Database Tables: Difference between revisions
mNo edit summary |
(Marked this version for translation) |
||
| Line 1: | Line 1: | ||
<languages/> | <languages/> | ||
<translate> | <translate> | ||
===Designing Database Tables=== | ===Designing Database Tables=== <!--T:1--> | ||
<!--T:2--> | |||
First, there will be two tables added to your database: '''''persons''''' and '''''phone_numbers'''''. These are exactly the same tables as described in chapter [[Special:MyLanguage/Kexi/Handbook/Introduction to Databases/Database and Spreadsheet|Database and Spreadsheet]]. A layout for '''''Persons''''' can be found in section [[Special:MyLanguage/Kexi/Handbook/Introduction_to_Databases/Database_and_Spreadsheet#Data_integrity_and_validity|Data integrity and validity]] in that chapter. | First, there will be two tables added to your database: '''''persons''''' and '''''phone_numbers'''''. These are exactly the same tables as described in chapter [[Special:MyLanguage/Kexi/Handbook/Introduction to Databases/Database and Spreadsheet|Database and Spreadsheet]]. A layout for '''''Persons''''' can be found in section [[Special:MyLanguage/Kexi/Handbook/Introduction_to_Databases/Database_and_Spreadsheet#Data_integrity_and_validity|Data integrity and validity]] in that chapter. | ||
<!--T:3--> | |||
# Select <menuchoice>Insert->Table...</menuchoice> from the menubar. You can also use the button <menuchoice>Create object: table</menuchoice> on the Project Navigator's toolbar. | # Select <menuchoice>Insert->Table...</menuchoice> from the menubar. You can also use the button <menuchoice>Create object: table</menuchoice> on the Project Navigator's toolbar. | ||
<!--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 template 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'''. | # 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 template 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--> | |||
{{Prevnext2 | {{Prevnext2 | ||
|prevpage=Special:MyLanguage/Kexi/Handbook/Building_Simple_Databases | |prevpage=Special:MyLanguage/Kexi/Handbook/Building_Simple_Databases | ||
| Line 17: | Line 21: | ||
}} | }} | ||
<!--T:6--> | |||
[[Category:Kexi]] | [[Category:Kexi]] | ||
[[Category:Tutorials]] | [[Category:Tutorials]] | ||
</translate> | </translate> | ||
Revision as of 18:58, 14 December 2011
Designing Database Tables
First, there will be two tables added to your database: persons and phone_numbers. 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 menubar. You can also use the button on the Project Navigator's toolbar.
- 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 template 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.