区块链数据库建表用户表和交易表设计

用户表
uid int(10) ‘用户ID’,
username varchar(16) ‘用户名’,
password varchar(32) ‘密码’,
mobile char(15) ‘用户手机号’,
Nickname char(16) ‘昵称’,
sex tinyint(3) ‘性别’,
birthday date ‘生日’,
email char(32) ‘用户邮箱’,
Alipay varchar(10) ‘支付宝账号’,
WeChat varchar(10) ‘微信账号’,
score mediumint(8) ‘用户积分’,
login_times int(10) ‘登录次数’
Reg_ip bigint(20) ‘注册IP’,
reg_time int(10) ‘注册时间’,
reg_source int(10) ‘注册来源’,
last_login_ip bigint(20) ‘最后登录IP’,
last_login_time int(10) ‘最后登录时间’,
status tinyint(4) ‘用户状态’
update_time int(10) ‘更新时间’,
update_by VARCHAR(100) ‘更新人员’,

交易表
uid int(10) ‘用户ID’,
ORDER_ID char(24) ‘订单号’,
ID number char(15) ‘身份证号’,
Balance char(25) ‘余额’,
Bitcoin char(25) ‘数字货币枚数’,
Currency char(25) ‘交易币种如ETH’,
price char(25) ‘价格’,
type char(3) ’ buy’买 sell卖,
Transaction pair char(25) ‘交易对’,
Number char(25) ‘数量’,
State char(25) ‘账户状态’,