- 项目编号：
-
其他系统220223151809143
- 项目名称：
- 其他系统-天天团购系统数据库表结构
- 数据库类型：
- MSSQL
- 表名：
- system_members
- 简称：
- system_members
- 描述：
- system_members
-
# 名称 标题 类型 长度 小数 允许空 自增 主键 外键 索引 描述 1 aboutme aboutme varchar 255 0 aboutme 2 accessmasks accessmasks tinyint 1 0 accessmasks 3 adminid adminid tinyint 1 0 adminid 4 bday bday date 0 0 bday 5 at_count at_count int 10 0 at_count 6 at_new at_new int 10 0 at_new 7 credits credits int 10 0 credits 8 email email varchar 150 0 email 9 dateformat dateformat varchar 30 0 dateformat 10 create_tag_count create_tag_count int 10 0 create_tag_count 11 city city varchar 48 0 city 12 comment_new comment_new int 10 0 comment_new 13 disallow_beiguanzhu disallow_beiguanzhu tinyint 1 0 disallow_beiguanzhu 14 checked checked tinyint 1 0 checked 15 gender gender tinyint 1 0 gender 16 extcredits1 extcredits1 int 10 0 extcredits1 17 extcredits2 extcredits2 int 10 0 extcredits2 18 invisible invisible tinyint 1 0 invisible 19 face face varchar 180 0 face 20 last_month_credit last_month_credit int 10 0 last_month_credit 21 image_count image_count int 10 0 image_count 22 invite_count invite_count int 10 0 invite_count 23 invitecode invitecode varchar 48 0 invitecode 24 follow_count follow_count int 10 0 follow_count 25 fans_count fans_count int 10 0 fans_count 26 email2 email2 varchar 150 0 email2 27 fans_new fans_new int 10 0 fans_new 28 favoritemy_new favoritemy_new int 10 0 favoritemy_new 29 finder finder int 10 0 finder 30 findtime findtime int 10 0 findtime 31 password password varchar 32 0 password 32 secques secques varchar 24 0 secques 33 regip regip varchar 45 0 regip 34 regdate regdate int 10 0 regdate 35 lastip lastip varchar 45 0 lastip 36 lastvisit lastvisit int 10 0 lastvisit 37 lastactivity lastactivity int 10 0 lastactivity 38 lastpost lastpost int 10 0 lastpost 39 oltime oltime int 10 0 oltime 40 pageviews pageviews int 10 0 pageviews 41 sigstatus sigstatus tinyint 1 0 sigstatus 42 ppp ppp tinyint 1 0 ppp 43 pmsound pmsound tinyint 1 0 pmsound 44 showemail showemail tinyint 1 0 Y showemail 45 newsletter newsletter tinyint 1 0 newsletter 46 newpm newpm tinyint 1 0 newpm 47 role_id role_id tinyint 1 0 role_id 48 role_type role_type varchar 18 0 role_type 49 new_msg_count new_msg_count tinyint 1 0 new_msg_count 50 own_tags own_tags int 10 0 own_tags 51 login_count login_count int 10 0 login_count 52 phone phone varchar 45 0 phone 53 last_year_rank last_year_rank int 10 0 last_year_rank 54 last_month_rank last_month_rank int 10 0 last_month_rank 55 last_week_rank last_week_rank int 10 0 last_week_rank 56 last_year_credit last_year_credit int 10 0 last_year_credit 57 last_week_credit last_week_credit int 10 0 last_week_credit 58 noticenum noticenum int 10 0 noticenum 59 province province varchar 48 0 province 60 qq qq varchar 30 0 qq 61 msn msn varchar 150 0 msn 62 money money decimal 10 2 money 63 uid 自增字段 int(10) 4 0 Y Y 自增字段 64 username username varchar 45 0 username 65 tpp tpp tinyint 1 0 tpp 66 styleid styleid int 10 0 styleid 67 timeformat timeformat tinyint 1 0 timeformat 68 timeoffset timeoffset varchar 12 0 timeoffset 69 tag_count tag_count int 10 0 tag_count 70 tag tag varchar 255 0 tag 71 truename truename varchar 48 0 truename 72 this_year_rank this_year_rank int 10 0 this_year_rank 73 this_month_rank this_month_rank int 10 0 this_month_rank 74 this_week_rank this_week_rank int 10 0 this_week_rank 75 this_year_credit this_year_credit int 10 0 this_year_credit 76 this_month_credit this_month_credit int 10 0 this_month_credit 77 this_week_credit this_week_credit int 10 0 this_week_credit 78 view_times view_times int 10 0 view_times 79 use_tag_count use_tag_count int 10 0 use_tag_count 80 ucuid ucuid int 10 0 ucuid 81 topic_count topic_count int 10 0 topic_count 82 topic_favorite_count topic_favorite_count int 10 0 topic_favorite_count 83 tag_favorite_count tag_favorite_count int 10 0 tag_favorite_count 84 validate validate tinyint 1 0 validate 85 totalpay totalpay decimal 10 2 Y totalpay
- 项目名称：
- 其他系统-天天团购系统数据库表结构
- 项目简介：
- 天天团购系统数据库表结构 天天团购系统数据库表结构 天天团购系统数据库表结构
- 相关表结构：
-
MSSQL-其他系统-天天团购系统数据库表结构【表名：system_failedlogins】system_failedlogins
MSSQL-其他系统-天天团购系统数据库表结构【表名：system_log】system_log
MSSQL-其他系统-天天团购系统数据库表结构【表名：system_memberfields】system_memberfields
MSSQL-其他系统-天天团购系统数据库表结构【表名：system_members】system_members
MSSQL-其他系统-天天团购系统数据库表结构【表名：system_onlinetime】system_onlinetime
MSSQL-其他系统-天天团购系统数据库表结构【表名：system_report】system_report
MSSQL-其他系统-天天团购系统数据库表结构【表名：system_robot】system_robot
MSSQL-其他系统-天天团购系统数据库表结构【表名：system_robot_ip】system_robot_ip
MSSQL-其他系统-天天团购系统数据库表结构【表名：system_robot_log】system_robot_log
MSSQL-其他系统-天天团购系统数据库表结构【表名：system_role】system_role
在线客服