shopnc数据字典.docx

活动表`shopnc_activity` `activity_id` int(11) NOT NULL auto_increment 备注:’id, `activity_title` varchar(255) NOT NULL 备注:’标题, `activity_type` enum(1,2) default NULL 备注:’活动类型 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) default NULL 备注:’结束时间, `activity_sort` tinyint(1) unsigned NOT NULL default 255 备注:’排序, `activity_state` tinyint(1) unsigned NOT NULL default 1 备注:’活动状态 0为关闭 1为开启, 主键(`activity_id`) 活动细节表`shopnc_activity_detail` `activity_detail_id` int(11) NOT NULL auto_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 NULL default 0 备注:’审核状态 0:(默认)待审核 1:通过 2:未通过 3:再次申请, `activity_detail_sort` tinyint(1) unsigned NOT NULL default 255 备注:’排序, 主键(`activity_detail_id`) 买家地址信息表`shopnc_address` `address_id` mediumint(10) unsigned NOT NULL auto_increment 备注:’地址ID, `member_id` mediumint(10) unsigned NOT NULL default 0 备注:’会员ID, `true_name` varchar(50) NOT NULL 备注:’会员姓名, `area_id` mediumint(10) unsigned NOT NULL default 0 备注:’地区ID, `city_id` mediumint(9) default NULL 备注:’市级ID, `area_info` varchar(255) NOT NULL default 备注:’地区内容, `address` varchar(255) NOT NULL 备注:’地址, `zip_code` char(6) default NULL 备注:’邮编, `tel_phone` varchar(20) default NULL 备注:’座机电话, `mob_phone` varchar(15) default NULL 备注:’手机电话, 主键(`address_id`) 管理员表`shopnc_admin` `admin_id` int(11) unsigned NOT NULL auto_increment 备注:’管理员ID, `admin_permission` varchar(3000) default NULL 备注:’管理权限, `admin_name` varchar(20) NOT NULL 备注:’管理员名称, `admin_password` varchar(32) NOT NULL default 备注:’管理员密码, `admin_login_time` int(10) NOT NULL default 0 备注:’登录时间, `admin_login_num` int