+ Use This Table All Design

MySQL Create Table SQL

Table Structure: okayapi_admanage_advertising:/tablelist/okayapi_admanage_advertising.html


-- MySQL Table okayapi_admanage_advertising
-- From: OkayAPI.com
CREATE TABLE `okayapi_admanage_advertising` (
    `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
    `AdID` int(10) NOT NULL COMMENT '广告ID',
    `AdvertisingState` varchar(15) NOT NULL COMMENT '广告投放状态',
    `AdMaterialID` int(10) NOT NULL COMMENT '投放物料ID',
    `AdPosition` varchar(15) NOT NULL COMMENT '广告投放位置(顶,底,漂浮)',
    `AdvertisingPriority` varchar(5) NOT NULL COMMENT '广告投放优先级',
    `TargetUserID` int(10) NOT NULL COMMENT '目标用户群ID',
    `AdvertisingFreq` int(10) NOT NULL COMMENT '投放频次',
    `AdvertisingTunnel` varchar(15) NOT NULL COMMENT '投放渠道',
    `LimitNumPerDay` varchar(5) NOT NULL COMMENT '每日投放上限',
    `EffectiveBeginTime` varchar(20) NOT NULL COMMENT '投放有效时间段',
    `HitPeopleNum` int(10) NOT NULL COMMENT '投放命中人数',
    `HitNum` int(10) NOT NULL COMMENT '投放命中次数',
    KEY `AdID` (`AdID`),
    KEY `AdvertisingState` (`AdvertisingState`),
    KEY `AdMaterialID` (`AdMaterialID`),
    KEY `AdPosition` (`AdPosition`),
    KEY `AdvertisingPriority` (`AdvertisingPriority`),
    KEY `TargetUserID` (`TargetUserID`),
    KEY `AdvertisingFreq` (`AdvertisingFreq`),
    KEY `AdvertisingTunnel` (`AdvertisingTunnel`),
    KEY `LimitNumPerDay` (`LimitNumPerDay`),
    KEY `EffectiveBeginTime` (`EffectiveBeginTime`),
    KEY `HitPeopleNum` (`HitPeopleNum`),
    KEY `HitNum` (`HitNum`),
    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-12 of 12 results.
Field NameField TypeDefaultIS NULLField CommentIndexDemo Data
AdIDint(10)广告ID
AdvertisingStatevarchar(15)广告投放状态
AdMaterialIDint(10)投放物料ID
AdPositionvarchar(15)广告投放位置(顶,底,漂浮)
AdvertisingPriorityvarchar(5)广告投放优先级
TargetUserIDint(10)目标用户群ID
AdvertisingFreqint(10)投放频次
AdvertisingTunnelvarchar(15)投放渠道
LimitNumPerDayvarchar(5)每日投放上限
EffectiveBeginTimevarchar(20)投放有效时间段
HitPeopleNumint(10)投放命中人数
HitNumint(10)投放命中次数

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