For the page count and the author identification, we have chosen
INT type (integer), as depicted in the following screenshot:
There are other attributes for fields, but we will leave them empty in this short
example. You might notice the Add 1 Field(s) dialog at the bottom of the screen. We
can use it to add some fields to this table creation panel by entering the appropriate
value and hitting Go. The number of rows would change according to the new
number of fields, leaving intact the information already entered about the first four
Fields. Before saving the page, let's define some keys.
Choosing Keys
A table should normally have a primary key (a field with unique content that
represents each row). Having a primary key is recommended for row identification,
better performance, and possible cross-table relations. A good value here is the ISBN;
so we select Primary for the isbn field. As $cfg['PropertiesIconic'] is set to TRUE
by default, we see icons indicating the various index possibilities. Moving the mouse
over them, or over the radio buttons, reveals Primary, Index, Unique, and Full text.
Index management (also referred to as Key management) can be done at
initial table creation, or later in the Structure sub-page of Table view.
Chapter 4
[ 71 ]
To improve the speed of queries we will make by author ID, we should add an index
on this field.
Pages:
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92