Table product music extra

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

Database Version

1.3.5


Description

Help.gif


Table Details

Primary Key

products_id

Indexed Fields

music_genre_id
artists_id
record_company_id


Columns

products_id Primary Key

Cross-reference link to the products table.
Type: int(11)
Null: No
Default: 0


artists_id

Cross-reference link to the record_artists table.
Type: int(11)
Null: No
Default: 0


record_company_id

Cross-reference link to the record_company table.
Type: int(11)
Null: No
Default: 0


music_genre_id Index

Cross-reference link to the music_genre table.
Type: int(11)
Null: No
Default: 0


Default Entries (assuming demo data installed)

products_id: 166
artists_id: 1
record_company_id: 0
music_genre_id: 1


products_id: 169
artists_id: 1
record_company_id: 1
music_genre_id: 2