okayapi_saixs_ad_ip - MySQ Table Design - OkayAPI.com

+ Use This Table All Design

MySQL Create Table SQL

Table Structure: okayapi_saixs_ad_ip：/tablelist/okayapi_saixs_ad_ip.html


-- MySQL Table okayapi_saixs_ad_ip
-- From: OkayAPI.com
CREATE TABLE `okayapi_saixs_ad_ip` (
    `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
    `ip` varchar(20) NULL COMMENT 'ip地址',
    `ad_site_id` int(11) NULL DEFAULT '0' COMMENT '广告位id',
    `ad_id` int(11) NULL DEFAULT '0' COMMENT '广告id',
    `clicks` int(11) NULL DEFAULT '0' COMMENT '数量',
    KEY `ip` (`ip`),
    KEY `ad_site_id` (`ad_site_id`),
    KEY `ad_id` (`ad_id`),
    KEY `clicks` (`clicks`),
    PRIMARY KEY (`id`)
) ENGINE=InnoDB COMMENT 'saixs广告管理-IP';

After replication, you can go to the database to create the database table.

MySQL database table structure design

Displaying 1-4 of 4 results.

Field Name	Field Type	Default	IS NULL	Field Comment	Index	Demo Data
ip	varchar(20)		是	ip地址
ad_site_id	int(11)	0	是	广告位id		0
ad_id	int(11)	0	是	广告id		0
clicks	int(11)	0	是	数量		0

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