Table featured

From Zen Cart(tm) Wiki
Jump to: navigation, search

Database Version

1.3.5


Description

Stores information about which products are marked as featured.


Table Details

Primary Key

featured_id

Indexed Fields

status
products_id
featured_date_available
expires_date


Columns

featured_id Primary Key

A unique, auto incremented value, to identify each featured product record.
Type: int(11)
Null: No
Default:
Extra: auto_increment


products_id Foreign Key Index

Links the featured table to the featured product in the products table. Foreign key to products.products_id.
Type: int(11)
Null: No
Default: 0


featured_date_added

The date and time the product was marked as featured.
Type: datetime
Null: Yes
Default: NULL


featured_last_modified

The date and time the featured product was last modified.
Type: datetime
Null: Yes
Default: NULL


expires_date Index

The date the product is not longer a featured item.
Type: date
Null: No
Default: 0001-01-01


date_status_change

The date and time the product status last changed.
Type: datetime
Null: Yes
Default: NULL


status Index

The status of the featured product. Can be set to 0 (off - not featured) or 1 (on - featured).
Type: int(1)
Null: No
Default: 1


featured_date_available Index

The date the product will be marked as a featured item.
Type: date
Null: No
Default: 0001-01-01


Default Entries

featured_id: 1
products_id: 34
featured_date_added: 2004-02-21 16:34:31
featured_last_modified: 2004-02-21 16:34:31
expires_date: 0001-01-01
date_status_change: 2004-02-21 16:34:31
status: 1
featured_date_available: 0001-01-01


featured_id: 2
products_id: 8
featured_date_added: 2004-02-21 17:04:54
featured_last_modified: 2004-02-21 22:31:52
expires_date: 2004-02-27
date_status_change: 2004-04-25 22:50:50
status: 0
featured_date_available: 2004-02-21


featured_id: 3
products_id: 12
featured_date_added: 2004-02-21 17:10:49
featured_last_modified: 2004-02-21 17:10:49
expires_date: 0001-01-01
date_status_change: 2004-02-21 17:10:49
status: 1
featured_date_available: 0001-01-01


featured_id: 4
products_id: 27
featured_date_added: 2004-02-21 22:30:53
featured_last_modified: NULL
expires_date: 0001-01-01
date_status_change: NULL
status: 1
featured_date_available: 0001-01-01


featured_id: 5
products_id: 26
featured_date_added: 2004-02-21 22:31:24
featured_last_modified: NULL
expires_date: 0001-01-01
date_status_change: NULL
status: 1
featured_date_available: 0001-01-01


featured_id: 6
products_id: 40
featured_date_added: 2004-05-13 22:50:33
featured_last_modified: NULL
expires_date: 0001-01-01
date_status_change: NULL
status: 1
featured_date_available: 0001-01-01


featured_id: 7
products_id: 171
featured_date_added: 2004-07-12 15:47:22
featured_last_modified: NULL
expires_date: 0001-01-01
date_status_change: NULL
status: 1
featured_date_available: 0001-01-01


featured_id: 8
products_id: 172
featured_date_added: 2004-07-12 15:47:29
featured_last_modified: NULL
expires_date: 0001-01-01
date_status_change: NULL
status: 1
featured_date_available: 0001-01-01


featured_id: 9
products_id: 168
featured_date_added: 2004-07-12 15:47:37
featured_last_modified: NULL
expires_date: 0001-01-01
date_status_change: NULL
status: 1
featured_date_available: 0001-01-01


featured_id: 10
products_id: 169
featured_date_added: 2004-07-12 15:47:45
featured_last_modified: NULL
expires_date: 0001-01-01
date_status_change: NULL
status: 1
featured_date_available: 0001-01-01