+ Use This Table All Design

MySQL Create Table SQL

Table Structure: okayapi_admanage_aduser:/tablelist/okayapi_admanage_aduser.html


-- MySQL Table okayapi_admanage_aduser
-- From: OkayAPI.com
CREATE TABLE `okayapi_admanage_aduser` (
    `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
    `AdUserID` int(10) NOT NULL COMMENT '用户编号',
    `AdUserPhone` varchar(11) NOT NULL COMMENT '用户手机号',
    `RemainingPoints` varchar(15) NOT NULL COMMENT '积分数',
    `UserShow` varchar(15) NOT NULL COMMENT '被投放广告数量',
    `UserClick` varchar(15) NOT NULL COMMENT '点击数量',
    `UserConver` varchar(15) NOT NULL COMMENT '转化数量',
    KEY `AdUserID` (`AdUserID`),
    KEY `AdUserPhone` (`AdUserPhone`),
    KEY `RemainingPoints` (`RemainingPoints`),
    KEY `UserShow` (`UserShow`),
    KEY `UserClick` (`UserClick`),
    KEY `UserConver` (`UserConver`),
    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-6 of 6 results.
Field NameField TypeDefaultIS NULLField CommentIndexDemo Data
AdUserIDint(10)用户编号
AdUserPhonevarchar(11)用户手机号
RemainingPointsvarchar(15)积分数
UserShowvarchar(15)被投放广告数量
UserClickvarchar(15)点击数量
UserConvervarchar(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_advertising

MySQL Table Design okayapi_admanage_floatcard

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 ↑