ecshop数据字典

ECSHOP数据字典

Table Name

Column Name

Column Datatype

用户账目日志表mall_account_loglog_idCHAR (10)user_idCHAR (10)user_moneyDECIMAL (10)frozen_moneyDECIMAL (10)rank_pointsCHAR (10)pay_pointsCHAR (10)change_timeINTEGER (-2)change_descVARCHAR (255)change_typeTINYINT (-2)

广告表(位置,类型,名称,链接,图片,开始,结束,广告主相关信息,点击是否显示)mall_adad_idSMALLINT (-2)position_idSMALLINT (-2)media_typeTINYINT (-2)ad_nameVARCHAR (60)ad_linkVARCHAR (255)ad_codeTEXT (-2)start_timeINTEGER (-2)end_timeINTEGER (-2)link_manVARCHAR (60)link_emailVARCHAR (60)link_phoneVARCHAR (60)click_countCHAR (10)enabledTINYINT (-2)mall_ad_customad_idCHAR (10)ad_typeTINYINT (-2)ad_nameVARCHAR (60)add_timeINTEGER (-2)contentCHAR (10)urlVARCHAR (255)ad_statusTINYINT (-2)广告位(名称,宽,高,描述,样式)mall_ad_positionposition_idTINYINT (-2)position_nameVARCHAR (60)ad_widthSMALLINT (-2)ad_heightSMALLINT (-2)position_descVARCHAR (255)position_styleTEXT (-2)管理权限分配(父类ID，权限代码)mall_admin_actionaction_idTINYINT (-2)parent_idTINYINT (-2)action_codeVARCHAR (20)管理日志(登陆时间,登陆ID,操作描述,IP)mall_admin_loglog_idINTEGER (-2)log_timeINTEGER (-2)user_idTINYINT (-2)log_infoVARCHAR (255)ip_addressVARCHAR (15)

管理留言(发送id,接收id,发送日期,阅读日期,是否已读,是否删除,标题，内容)