Table featured
From Zen Cart(tm) Wiki
Contents |
Database Version
- 1.3.5
Description
- Stores information about which products are marked as featured.
Table Details
Primary Key
Indexed Fields
Columns
featured_id 
- A unique, auto incremented value, to identify each featured product record.
Type: int(11) Null: No Default: Extra: auto_increment
products_id 
- 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
- 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
- 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
- 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
