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 Name | Field Type | Default | IS NULL | Field Comment | Index | Demo Data |
---|---|---|---|---|---|---|
AdID | int(10) | 否 | 广告编号 | |||
AdShow | varchar(10) | 否 | 广告展现量 | |||
AdClick | varchar(10) | 否 | 广告点击量 | |||
AdConver | varchar(10) | 否 | 广告转换量 | |||
AdShowPeo | varchar(10) | 否 | 展现量对应人数 | |||
AdClickPeo | varchar(10) | 否 | 点击量对应人数 | |||
AdCoverPeo | varchar(10) | 否 | 转换量对应人数 |