+ Use This Table All Design

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 NameField TypeDefaultIS NULLField CommentIndexDemo Data
TrafficCardIDint(10)流量卡编号
TrafficCardNumvarchar(15)流量卡卡号
TrafficCardPwdvarchar(20)流量卡密码
md5Pwdvarchar(50)md5加密密码
TrafficCardTypevarchar(15)流量卡类型
statevarchar(10)激活状态
AdUserPhonevarchar(11)用户手机号
UserPointsvarchar(15)用户所花积分数

Guess You Like

MySQL Table Design okayapi_admanage_adeffect

MySQL Table Design okayapi_admanage_adeffect_h

MySQL Table Design okayapi_admanage_adhost

MySQL Table Design okayapi_admanage_adlog

MySQL Table Design okayapi_admanage_admaininformation

MySQL Table Design okayapi_admanage_admaterial

MySQL Table Design okayapi_admanage_admin

MySQL Table Design okayapi_admanage_aduser

MySQL Table Design okayapi_admanage_advertising

MySQL Table Design okayapi_admanage_targetuser

MySQL Table Design okayapi_saixs_ad_ad

MySQL Table Design okayapi_saixs_ad_admin

MySQL Table Design okayapi_saixs_ad_ad_site

MySQL Table Design okayapi_saixs_ad_ip

MySQL Table Design okayapi_saixs_ad_site

MySQL Table Design okayapi_guanggaobao_bid_detail

MySQL Table Design okayapi_guanggaobao_character

MySQL Table Design okayapi_guanggaobao_demand_image

MySQL Table Design okayapi_guanggaobao_demand_information

MySQL Table Design okayapi_guanggaobao_manager

TOP ↑