shopnc数据字典探索.docx

活动表`shopnc_activity``activity_id`int(11)NOT NULLauto_increment备注:’id,`activity_title`varchar(255)NOT NULL备注:’标题,`activity_type`enum(1,2)defaultNULL备注:’活动类型1:商品2:团购,`activity_banner`varchar(255)NOT NULL备注:’活动横幅大图片,`activity_style`varchar(255)NOT NULL备注:’活动页面模板样式标识码,`activity_desc`varchar(1000)NOT NULL备注:’描述,`activity_start_date`int(10)NOT NULL备注:’开始时间,`activity_end_date`int(10)defaultNULL备注:’结束时间,`activity_sort`tinyint(1)unsignedNOT NULLdefault255备注:’排序,`activity_state`tinyint(1)unsignedNOT NULLdefault1备注:’活动状态0为关闭1为开启,主键(`activity_id`)活动细节表`shopnc_activity_detail``activity_detail_id`int(11)NOT NULLauto_increment备注:’id,`activity_id`int(11)NOT NULL备注:’活动编号,`item_id`int(11)NOT NULL备注:’商品或团购的编号,`item_name`varchar(255)NOT NULL备注:’商品或团购名称,`store_id`int(11)NOT NULL备注:’店铺编号,`store_name`varchar(255)NOT NULL备注:’店铺名称,`activity_detail_state`enum(0,1,2,3)NOT NULLdefault0备注:’审核状态0:(默认)待审核1:通过2:未通过3:再次申请,`activity_detail_sort`tinyint(1)unsignedNOT NULLdefault255备注:’排序,主键(`activity_detail_id`)买家地址信息表`shopnc_address``address_id`mediumint(10)unsignedNOT NULLauto_increment备注:’地址ID,`member_id`mediumint(10)unsignedNOT NULLdefault0备注:’会员ID,`true_name`varchar(50)NOT NULL备注:’会员姓名,`area_id`mediumint(10)unsignedNOT NULLdefault0备注:’地区ID,`city_id`mediumint(9)defaultNULL备注:’市级ID,`area_info`varchar(255)NOT NULLdefault备注:’地区内容,`address`varchar(255)NOT NULL备注:’地址,`zip_code`char(6)defaultNULL备注:’邮编,`tel_phone`varchar(20)defaultNULL备注:’座机电话,`mob_phone`varchar(15)defaultNULL备注:’手机电话,主键(`address_id`)管理员表`shopnc_admin``admin_id`int(11)unsignedNOT NULLauto_increment备注:’管理员ID,`admin_permission`varchar(3000)defaultNULL备注:’管理权限,`admin_name`varchar(20)NOT NULL备注:’管理员名称,`admin_password`varchar(32)NOT NULLdefault备注:’管理员密码,`admin_login_time`int(10)NOT NULLdefault0备注:’登录时间,`admin_login_num`int(11)NOT NULLdefault0备注:’登录次数,`admin_is_super`tinyint(1)NOT NULLdefault0备注:’是否超级管理员,主键(`admin_id`),KEY`member_id``admin_id`)广告表`shopnc_adv``adv_id`int(10)unsignedNOT NULLauto_increment备注:’广告自增标识编号,`ap_id`int(10)unsignedNOT