Kexi/Handbook/Building Simple Databases/Designing Database Tables: Difference between revisions
m add prevnext |
m KEXI uppercase |
||
| (8 intermediate revisions by 4 users not shown) | |||
| Line 1: | Line 1: | ||
<languages/> | <languages/> | ||
<!--FIXME to refer to these two tables later, sometimes the caption "Persons"/"Phones" and sometimes the Name "persons"/"phone_numbers" are used; together with different markup guilabel/replaceable, make that consistent. It is really confusing--> | |||
<translate> | <translate> | ||
===Designing Database Tables=== | ===Designing Database Tables=== <!--T:1--> | ||
First, there will be two tables added to your database: ''''' | <!--T:2--> | ||
First, there will be two tables added to your database: '''''Persons''''' and '''''Phones'''''. 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. | |||
# Select <menuchoice | <!--T:3--> | ||
<!--FIXME changes to the project navigator for 2.9.2 currently invalidate this--> | |||
# The Table Designer | # 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> | |||
<!--T:4--> | |||
# 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--> | |||
{{Prevnext2 | {{Prevnext2 | ||
|prevpage=Special:MyLanguage/Kexi/Handbook/Building_Simple_Databases | |prevpage=Special:MyLanguage/Kexi/Handbook/Building_Simple_Databases | ||
| Line 17: | Line 23: | ||
}} | }} | ||
<!--T:6--> | |||
[[Category:Kexi]] | [[Category:Kexi]] | ||
[[Category:Tutorials]] | [[Category:Tutorials]] | ||
</translate> | </translate> | ||
Latest revision as of 01:47, 20 December 2024
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.