`telphone` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL
DEFAULT NULL COMMENT '电话',
`email` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT
NULL COMMENT '邮箱',
`age` int(20) NULL DEFAULT NULL COMMENT '年龄',
`registerTime` timestamp(0) NULL DEFAULT NULL COMMENT '注册时间',
`usertype` int(1) NULL DEFAULT NULL COMMENT '终端类型,0:PC,1:移动端,
2 小程序',
PRIMARY KEY (`userid`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT
= Dynamic;
CREATE TABLE IF NOT EXISTS `userdetail` (
`userdetailid` int(20) NOT NULL COMMENT '主键',
`userid` int(20) NULL DEFAULT NULL COMMENT '用户 ID',
`edu` int(1) NULL DEFAULT NULL COMMENT '学历',
`profession` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL
DEFAULT NULL COMMENT '职业',
`marriage` int(20) NULL DEFAULT NULL COMMENT '婚姻状况,1:未婚,2:已婚,
3:离异,4:未知',
`haschild` int(1) NULL DEFAULT NULL COMMENT '1:没有孩子,2:有孩子,3:
未知',
`hascar` int(1) NULL DEFAULT NULL COMMENT '1:有车,2:无车,3:未知',
`hashourse` int(1) NULL DEFAULT NULL COMMENT '1:有房,2:无房,3:未知
',
`telphonebrand` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL
DEFAULT NULL COMMENT '手机品牌',
PRIMARY KEY (`userdetailid`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT