Table coupons description

From Zen Cart(tm) Wiki
Revision as of 12:24, 8 September 2006 by Allcanadiansearch.ca (talk | contribs)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to: navigation, search

Database Version

1.3.5


Description

Stores language-specific data about coupons. Non-language coupon data can be found in the coupons table.


Table Details

Primary Key

coupon_id
language_id

Indexed Fields

None.


Columns

coupon_id Primary Key Foreign Key

Links the coupon description data to the coupon. Foreign key to coupons.coupon_id.
Type: int(11)
Null: No
Default: 0


language_id Primary Key Foreign Key

Links the coupon description to a record in the languages table. Foreign key to languages.languages_id.
Type: int(11)
Null: No
Default: 0


coupon_name

The language-specific name of the coupon.
Type: varchar(32)
Null: No
Default:


coupon_description

The language-specific description of the coupon.
Type: text
Null: Yes
Default: NULL


Default Entries

None.