Difference between revisions of "Table featured"

From Zen Cart(tm) Wiki
Jump to: navigation, search
m (Reverted edits by Torke (Talk); changed back to last version by Allcanadiansearch.ca)
Line 1: Line 1:
{{Template:menuBarDevelopers}}
 
== Database Version ==
 
:1.3.5
 
  
 
== Description ==
 
:Stores information about which products are marked as featured.
 
 
 
== Table Details ==
 
=== Primary Key ===
 
:[[Table featured#featured_id|featured_id]]
 
 
=== Indexed Fields ===
 
:[[Table featured#status|status]]
 
:[[Table featured#products_id|products_id]]
 
:[[Table featured#featured_date_available|featured_date_available]]
 
:[[Table featured#expires_date|expires_date]]
 
 
 
== Columns ==
 
=== featured_id [[Image:Primary_key.gif|Primary Key]]===
 
:A unique, auto incremented value, to identify each featured product record.
 
<BLOCKQUOTE>
 
{|
 
| Type: || int(11)
 
|-
 
| Null: || No
 
|-
 
| Default: ||
 
|-
 
| Extra: || auto_increment
 
|}
 
</BLOCKQUOTE>
 
 
 
=== products_id [[Image:Foreign_key.gif|Foreign Key]] [[Image:Index.gif|Index]]===
 
:Links the featured table to the featured product in the [[Table products|products]] table. Foreign key to [[Table products#products_id|products.products_id]].
 
<BLOCKQUOTE>
 
{|
 
| Type: || int(11)
 
|-
 
| Null: || No
 
|-
 
| Default: || 0
 
|}
 
</BLOCKQUOTE>
 
 
 
=== featured_date_added ===
 
:The date and time the product was marked as featured.
 
<BLOCKQUOTE>
 
{|
 
| Type: || datetime
 
|-
 
| Null: || Yes
 
|-
 
| Default: || ''NULL''
 
|}
 
</BLOCKQUOTE>
 
 
 
=== featured_last_modified ===
 
:The date and time the featured product was last modified.
 
<BLOCKQUOTE>
 
{|
 
| Type: || datetime
 
|-
 
| Null: || Yes
 
|-
 
| Default: || ''NULL''
 
|}
 
</BLOCKQUOTE>
 
 
 
=== expires_date [[Image:Index.gif|Index]] ===
 
:The date the product is not longer a featured item.
 
<BLOCKQUOTE>
 
{|
 
| Type: || date
 
|-
 
| Null: || No
 
|-
 
| Default: || 0001-01-01
 
|}
 
</BLOCKQUOTE>
 
 
 
=== date_status_change ===
 
:The date and time the product status last changed.
 
<BLOCKQUOTE>
 
{|
 
| Type: || datetime
 
|-
 
| Null: || Yes
 
|-
 
| Default: || ''NULL''
 
|}
 
</BLOCKQUOTE>
 
 
 
=== status [[Image:Index.gif|Index]]===
 
:The status of the featured product. Can be set to ''0'' (off - not featured) or ''1'' (on - featured).
 
<BLOCKQUOTE>
 
{|
 
| Type: || int(1)
 
|-
 
| Null: || No
 
|-
 
| Default: || 1
 
|}
 
</BLOCKQUOTE>
 
 
 
=== featured_date_available [[Image:Index.gif|Index]]===
 
:The date the product will be marked as a featured item.
 
<BLOCKQUOTE>
 
{|
 
| Type: || date
 
|-
 
| Null: || No
 
|-
 
| Default: || 0001-01-01
 
|}
 
</BLOCKQUOTE>
 
 
 
== Default Entries ==
 
<BLOCKQUOTE>
 
{|
 
|  [[Table featured#featured_id|featured_id]]: || 1
 
|-
 
|  [[Table featured#products_id|products_id]]: || 34
 
|-
 
|  [[Table featured#featured_date_added|featured_date_added]]: || 2004-02-21 16:34:31
 
|-
 
|  [[Table featured#featured_last_modified|featured_last_modified]]: || 2004-02-21 16:34:31
 
|-
 
|  [[Table featured#expires_date|expires_date]]: || 0001-01-01
 
|-
 
|  [[Table featured#date_status_change|date_status_change]]: || 2004-02-21 16:34:31
 
|-
 
|  [[Table featured#status|status]]: || 1
 
|-
 
|  [[Table featured#featured_date_available|featured_date_available]]: || 0001-01-01
 
|}
 
</BLOCKQUOTE>
 
 
 
<BLOCKQUOTE>
 
{|
 
|  [[Table featured#featured_id|featured_id]]: || 2
 
|-
 
|  [[Table featured#products_id|products_id]]: || 8
 
|-
 
|  [[Table featured#featured_date_added|featured_date_added]]: || 2004-02-21 17:04:54
 
|-
 
|  [[Table featured#featured_last_modified|featured_last_modified]]: || 2004-02-21 22:31:52
 
|-
 
|  [[Table featured#expires_date|expires_date]]: || 2004-02-27
 
|-
 
|  [[Table featured#date_status_change|date_status_change]]: || 2004-04-25 22:50:50
 
|-
 
|  [[Table featured#status|status]]: || 0
 
|-
 
|  [[Table featured#featured_date_available|featured_date_available]]: || 2004-02-21
 
|}
 
</BLOCKQUOTE>
 
 
 
<BLOCKQUOTE>
 
{|
 
|  [[Table featured#featured_id|featured_id]]: || 3
 
|-
 
|  [[Table featured#products_id|products_id]]: || 12
 
|-
 
|  [[Table featured#featured_date_added|featured_date_added]]: || 2004-02-21 17:10:49
 
|-
 
|  [[Table featured#featured_last_modified|featured_last_modified]]: || 2004-02-21 17:10:49
 
|-
 
|  [[Table featured#expires_date|expires_date]]: || 0001-01-01
 
|-
 
|  [[Table featured#date_status_change|date_status_change]]: || 2004-02-21 17:10:49
 
|-
 
|  [[Table featured#status|status]]: || 1
 
|-
 
|  [[Table featured#featured_date_available|featured_date_available]]: || 0001-01-01
 
|}
 
</BLOCKQUOTE>
 
 
 
<BLOCKQUOTE>
 
{|
 
|  [[Table featured#featured_id|featured_id]]: || 4
 
|-
 
|  [[Table featured#products_id|products_id]]: || 27
 
|-
 
|  [[Table featured#featured_date_added|featured_date_added]]: || 2004-02-21 22:30:53
 
|-
 
|  [[Table featured#featured_last_modified|featured_last_modified]]: || ''NULL''
 
|-
 
|  [[Table featured#expires_date|expires_date]]: || 0001-01-01
 
|-
 
|  [[Table featured#date_status_change|date_status_change]]: || ''NULL''
 
|-
 
|  [[Table featured#status|status]]: || 1
 
|-
 
|  [[Table featured#featured_date_available|featured_date_available]]: || 0001-01-01
 
|}
 
</BLOCKQUOTE>
 
 
 
<BLOCKQUOTE>
 
{|
 
|  [[Table featured#featured_id|featured_id]]: || 5
 
|-
 
|  [[Table featured#products_id|products_id]]: || 26
 
|-
 
|  [[Table featured#featured_date_added|featured_date_added]]: || 2004-02-21 22:31:24
 
|-
 
|  [[Table featured#featured_last_modified|featured_last_modified]]: || ''NULL''
 
|-
 
|  [[Table featured#expires_date|expires_date]]: || 0001-01-01
 
|-
 
|  [[Table featured#date_status_change|date_status_change]]: || ''NULL''
 
|-
 
|  [[Table featured#status|status]]: || 1
 
|-
 
|  [[Table featured#featured_date_available|featured_date_available]]: || 0001-01-01
 
|}
 
</BLOCKQUOTE>
 
 
 
<BLOCKQUOTE>
 
{|
 
|  [[Table featured#featured_id|featured_id]]: || 6
 
|-
 
|  [[Table featured#products_id|products_id]]: || 40
 
|-
 
|  [[Table featured#featured_date_added|featured_date_added]]: || 2004-05-13 22:50:33
 
|-
 
|  [[Table featured#featured_last_modified|featured_last_modified]]: || ''NULL''
 
|-
 
|  [[Table featured#expires_date|expires_date]]: || 0001-01-01
 
|-
 
|  [[Table featured#date_status_change|date_status_change]]: || ''NULL''
 
|-
 
|  [[Table featured#status|status]]: || 1
 
|-
 
|  [[Table featured#featured_date_available|featured_date_available]]: || 0001-01-01
 
|}
 
</BLOCKQUOTE>
 
 
 
<BLOCKQUOTE>
 
{|
 
|  [[Table featured#featured_id|featured_id]]: || 7
 
|-
 
|  [[Table featured#products_id|products_id]]: || 171
 
|-
 
|  [[Table featured#featured_date_added|featured_date_added]]: || 2004-07-12 15:47:22
 
|-
 
|  [[Table featured#featured_last_modified|featured_last_modified]]: || ''NULL''
 
|-
 
|  [[Table featured#expires_date|expires_date]]: || 0001-01-01
 
|-
 
|  [[Table featured#date_status_change|date_status_change]]: || ''NULL''
 
|-
 
|  [[Table featured#status|status]]: || 1
 
|-
 
|  [[Table featured#featured_date_available|featured_date_available]]: || 0001-01-01
 
|}
 
</BLOCKQUOTE>
 
 
 
<BLOCKQUOTE>
 
{|
 
|  [[Table featured#featured_id|featured_id]]: || 8
 
|-
 
|  [[Table featured#products_id|products_id]]: || 172
 
|-
 
|  [[Table featured#featured_date_added|featured_date_added]]: || 2004-07-12 15:47:29
 
|-
 
|  [[Table featured#featured_last_modified|featured_last_modified]]: || ''NULL''
 
|-
 
|  [[Table featured#expires_date|expires_date]]: || 0001-01-01
 
|-
 
|  [[Table featured#date_status_change|date_status_change]]: || ''NULL''
 
|-
 
|  [[Table featured#status|status]]: || 1
 
|-
 
|  [[Table featured#featured_date_available|featured_date_available]]: || 0001-01-01
 
|}
 
</BLOCKQUOTE>
 
 
 
<BLOCKQUOTE>
 
{|
 
|  [[Table featured#featured_id|featured_id]]: || 9
 
|-
 
|  [[Table featured#products_id|products_id]]: || 168
 
|-
 
|  [[Table featured#featured_date_added|featured_date_added]]: || 2004-07-12 15:47:37
 
|-
 
|  [[Table featured#featured_last_modified|featured_last_modified]]: || ''NULL''
 
|-
 
|  [[Table featured#expires_date|expires_date]]: || 0001-01-01
 
|-
 
|  [[Table featured#date_status_change|date_status_change]]: || ''NULL''
 
|-
 
|  [[Table featured#status|status]]: || 1
 
|-
 
|  [[Table featured#featured_date_available|featured_date_available]]: || 0001-01-01
 
|}
 
</BLOCKQUOTE>
 
 
 
<BLOCKQUOTE>
 
{|
 
|  [[Table featured#featured_id|featured_id]]: || 10
 
|-
 
|  [[Table featured#products_id|products_id]]: || 169
 
|-
 
|  [[Table featured#featured_date_added|featured_date_added]]: || 2004-07-12 15:47:45
 
|-
 
|  [[Table featured#featured_last_modified|featured_last_modified]]: || ''NULL''
 
|-
 
|  [[Table featured#expires_date|expires_date]]: || 0001-01-01
 
|-
 
|  [[Table featured#date_status_change|date_status_change]]: || ''NULL''
 
|-
 
|  [[Table featured#status|status]]: || 1
 
|-
 
|  [[Table featured#featured_date_available|featured_date_available]]: || 0001-01-01
 
|}
 
</BLOCKQUOTE>
 

Revision as of 00:37, 5 December 2007