+ Use This Table All Design

MySQL Create Table SQL

Table Structure: okayapi_admanage_adeffect:/tablelist/okayapi_admanage_adeffect.html


-- MySQL Table okayapi_admanage_adeffect
-- From: OkayAPI.com
CREATE TABLE `okayapi_admanage_adeffect` (
    `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
    `AdID` int(10) NOT NULL COMMENT '广告编号',
    `AdShow` varchar(10) NOT NULL COMMENT '广告展现量',
    `AdClick` varchar(10) NOT NULL COMMENT '广告点击量',
    `AdConver` varchar(10) NOT NULL COMMENT '广告转换量',
    `AdShowPeo` varchar(10) NOT NULL COMMENT '展现量对应人数',
    `AdClickPeo` varchar(10) NOT NULL COMMENT '点击量对应人数',
    `AdCoverPeo` varchar(10) NOT NULL COMMENT '转换量对应人数',
    KEY `AdID` (`AdID`),
    KEY `AdShow` (`AdShow`),
    KEY `AdClick` (`AdClick`),
    KEY `AdConver` (`AdConver`),
    KEY `AdShowPeo` (`AdShowPeo`),
    KEY `AdClickPeo` (`AdClickPeo`),
    KEY `AdCoverPeo` (`AdCoverPeo`),
    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-7 of 7 results.
Field NameField TypeDefaultIS NULLField CommentIndexDemo Data
AdIDint(10)广告编号
AdShowvarchar(10)广告展现量
AdClickvarchar(10)广告点击量
AdConvervarchar(10)广告转换量
AdShowPeovarchar(10)展现量对应人数
AdClickPeovarchar(10)点击量对应人数
AdCoverPeovarchar(10)转换量对应人数

Guess You Like

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_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 ↑