You could keep the picture
directly in the table, but in most cases, it??™s much more
efficient to store the picture files in the file system and
have only their names stored into the database. If you
have a high-traffic web site, you might even want to
place the image files in a separate physical location (for
example, another hard disk) to increase site
performance. This field allows NULLs.
image_2 varchar(150) Stores the name of a second picture of the product, which
gets displayed on the product details page. It allows NULLs.
Field Name Data Type Description
thumbnail varchar(150) Stores the name of the product??™s thumbnail picture.
This image gets displayed in product lists when
browsing the catalog.
display smallint Stores a value specifying in what areas of the catalog
this product should be displayed. The possible values
are 0 (default), meaning the product is listed only in
the page of the category it??™s a part of ); 1, which indicates
that the product is also featured on the front
catalog page; 2, indicating the product is also featured
in the departments it??™s a part of; and 3, which means
the product is also featured on both the front and the
department pages. With the help of this field, the site
administrators can highlight a set of products that will
be of particular interest to visitors at a specific season,
holiday, and so on.
Pages:
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214