|
recipe_id
|
int(6)
|
|
|
|
|
author
|
varchar(64)
|
utf8_unicode_ci
|
|
|
|
attribution
|
text
|
utf8_unicode_ci
|
|
|
|
main_ing_id
|
varchar(6)
|
utf8_unicode_ci
|
|
|
|
menu_cat_id
|
varchar(6)
|
utf8_unicode_ci
|
|
|
|
methods_id
|
varchar(38)
|
utf8_unicode_ci
|
|
|
|
collections_id
|
varchar(6)
|
utf8_unicode_ci
|
|
|
|
prod_fam_used
|
varchar(90)
|
utf8_unicode_ci
|
|
|
|
item_code_used
|
varchar(90)
|
utf8_unicode_ci
|
|
|
|
name
|
varchar(90)
|
utf8_unicode_ci
|
|
|
|
name_mex
|
varchar(90)
|
utf8_unicode_ci
|
|
|
|
preptime
|
varchar(255)
|
utf8_unicode_ci
|
|
|
|
marinatetime
|
varchar(64)
|
utf8_unicode_ci
|
|
|
|
inactivetime
|
varchar(64)
|
utf8_unicode_ci
|
|
|
|
cooktime
|
varchar(64)
|
utf8_unicode_ci
|
|
|
|
totaltime
|
varchar(64)
|
utf8_unicode_ci
|
|
|
|
yield
|
varchar(90)
|
utf8_unicode_ci
|
|
|
|
ingredients
|
text
|
utf8_unicode_ci
|
|
|
|
instructions
|
text
|
utf8_unicode_ci
|
|
|
|
recipe_image
|
varchar(128)
|
utf8_unicode_ci
|
|
|
|
small_recipe_image
|
varchar(128)
|
utf8_unicode_ci
|
|
|
|
created_date
|
date
|
|
|
|
|
mod_date
|
date
|
|
|
|
|
expire_date
|
date
|
|
|
|
|
status
|
tinyint(4)
|
|
|
|
|
recipe_usage
|
text
|
utf8_unicode_ci
|
|
|
|
created_by
|
varchar(40)
|
utf8_unicode_ci
|
|
|
|
influencer
|
varchar(64)
|
utf8_unicode_ci
|
|
|
|
thumb_head
|
varchar(32)
|
utf8_unicode_ci
|
|
|
|
featured
|
varchar(256)
|
utf8_unicode_ci
|
|
|
|
short_desc
|
text
|
utf8_unicode_ci
|
|
|
|
long_desc
|
text
|
utf8_unicode_ci
|
|
|
|
vc_id
|
int(6)
|
|
|
|
|
coupon
|
varchar(1)
|
utf8_unicode_ci
|
|
|
|
viewcount
|
int(8)
|
|
|
|
