MySQL Create Table SQL
Table Structure: okayapi_admanage_floatcard:/tablelist/okayapi_admanage_floatcard.html
-- MySQL Table okayapi_admanage_floatcard
-- From: OkayAPI.com
CREATE TABLE `okayapi_admanage_floatcard` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`TrafficCardID` int(10) NOT NULL COMMENT '流量卡编号',
`TrafficCardNum` varchar(15) NOT NULL COMMENT '流量卡卡号',
`TrafficCardPwd` varchar(20) NOT NULL COMMENT '流量卡密码',
`md5Pwd` varchar(50) NOT NULL COMMENT 'md5加密密码',
`TrafficCardType` varchar(15) NOT NULL COMMENT '流量卡类型',
`state` varchar(10) NOT NULL COMMENT '激活状态',
`AdUserPhone` varchar(11) NOT NULL COMMENT '用户手机号',
`UserPoints` varchar(15) NOT NULL COMMENT '用户所花积分数',
KEY `TrafficCardID` (`TrafficCardID`),
KEY `TrafficCardNum` (`TrafficCardNum`),
KEY `TrafficCardPwd` (`TrafficCardPwd`),
KEY `md5Pwd` (`md5Pwd`),
KEY `TrafficCardType` (`TrafficCardType`),
KEY `state` (`state`),
KEY `AdUserPhone` (`AdUserPhone`),
KEY `UserPoints` (`UserPoints`),
PRIMARY KEY (`id`)
) ENGINE=InnoDB COMMENT '广告管理-流量卡密表';
After replication, you can go to the database to create the database table.
MySQL database table structure design
Displaying 1-8 of 8 results.
Field Name | Field Type | Default | IS NULL | Field Comment | Index | Demo Data |
---|---|---|---|---|---|---|
TrafficCardID | int(10) | 否 | 流量卡编号 | |||
TrafficCardNum | varchar(15) | 否 | 流量卡卡号 | |||
TrafficCardPwd | varchar(20) | 否 | 流量卡密码 | |||
md5Pwd | varchar(50) | 否 | md5加密密码 | |||
TrafficCardType | varchar(15) | 否 | 流量卡类型 | |||
state | varchar(10) | 否 | 激活状态 | |||
AdUserPhone | varchar(11) | 否 | 用户手机号 | |||
UserPoints | varchar(15) | 否 | 用户所花积分数 |