| 字段 |
类型 |
长度 |
备注 |
| u_id |
int |
10 |
主键u_id |
| u_loginid |
varchar |
20 |
联系方式 |
| u_nickname |
varchar |
20 |
昵称 |
| u_name |
varchar |
20 |
姓名 |
| u_sex |
tinyint |
2 |
性别(0男 1女) |
| u_avatarurl |
varchar |
100 |
用户头像url |
| u_lon |
double |
8 |
地址经度 |
| u_lat |
double |
8 |
地址纬度 |
| u_rank |
tinyint |
3 |
用户等级(0普通会员 1黄金会员 2钻石会员) |
| u_credit |
int |
25 |
积分 |
| u_collectionurl |
varchar |
100 |
收藏商家url(数组) |
| u_address |
varchar |
60 |
地址 |
| u_registrtime |
datetime |
4 |
注册时间 |
| u_nationid |
int |
10 |
国家 |
| u_cityid |
int |
10 |
城市 |
| u_provinceid |
int |
10 |
省份 |
| u_day |
int |
10 |
日增用户数量 |
| u_totle |
int |
10 |
总用户数量 |
|
DROP TABLE IF EXISTS `user`;
CREATE TABLE `user` (
`u_id` int(10) NOT NULL AUTO_INCREMENT,
`u_loginid` varchar(20) COLLATE utf8_bin NOT NULL DEFAULT '',
`u_nickname` varchar(20) COLLATE utf8_bin DEFAULT '',
`u_name` varchar(20) COLLATE utf8_bin DEFAULT '',
`u_sex` tinyint(2) DEFAULT '0',
`u_avatarurl` varchar(100) COLLATE utf8_bin DEFAULT '',
`u_lon` double(18,8) DEFAULT '0.00000000',
`u_lat` double(18,8) DEFAULT '0.00000000',
`u_rank` tinyint(3) DEFAULT '0',
`u_credit` int(25) DEFAULT '100',
`u_collectionurl` varchar(100) COLLATE utf8_bin DEFAULT '',
`u_address` varchar(60) COLLATE utf8_bin DEFAULT '',
`u_registertime` datetime(4) DEFAULT NULL,
`u_nationid` int(10) DEFAULT '3',
`u_provinceid` int(10) DEFAULT '6',
`u_cityid` int(10) DEFAULT '2122',
`u_day` int(10) DEFAULT '0',
`u_totle` int(10) DEFAULT '0',
PRIMARY KEY (`u_id`),
KEY `u_nationid` (`u_nationid`),
KEY `u_provinceid` (`u_provinceid`),
KEY `u_cityid` (`u_cityid`),
CONSTRAINT `u_cityid` FOREIGN KEY (`u_cityid`) REFERENCES `city` (`c_id`),
CONSTRAINT `u_nationid` FOREIGN KEY (`u_nationid`) REFERENCES `nation` (`n_id`),
CONSTRAINT `u_provinceid` FOREIGN KEY (`u_provinceid`) REFERENCES `province` (`p_id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8 COLLATE=utf8_bin;