+ Use This Table All Design

MySQL Create Table SQL

Table Structure: okayapi_admanage_adlog:/tablelist/okayapi_admanage_adlog.html


-- MySQL Table okayapi_admanage_adlog
-- From: OkayAPI.com
CREATE TABLE `okayapi_admanage_adlog` (
    `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
    `AdID` int(10) NOT NULL DEFAULT '0' COMMENT '',
    `OptTime` varchar(20) NOT NULL COMMENT '操作时间',
    `OptHour` varchar(5) NOT NULL COMMENT '操作时的小时',
    `OptDay` varchar(5) NOT NULL COMMENT '操作时是几号',
    `OptMonth` varchar(5) NOT NULL COMMENT '操作时的月份',
    `OptYear` varchar(5) NOT NULL COMMENT '操作时的年份',
    `OptType` varchar(10) NOT NULL COMMENT '操作类型show/click/conver',
    KEY `AdID` (`AdID`),
    KEY `OptTime` (`OptTime`),
    KEY `OptHour` (`OptHour`),
    KEY `OptDay` (`OptDay`),
    KEY `OptMonth` (`OptMonth`),
    KEY `OptYear` (`OptYear`),
    KEY `OptType` (`OptType`),
    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)00
OptTimevarchar(20)操作时间
OptHourvarchar(5)操作时的小时
OptDayvarchar(5)操作时是几号
OptMonthvarchar(5)操作时的月份
OptYearvarchar(5)操作时的年份
OptTypevarchar(10)操作类型show/click/conver

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