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 Name | Field Type | Default | IS NULL | Field Comment | Index | Demo Data |
---|---|---|---|---|---|---|
AdID | int(10) | 否 | 广告ID | |||
AdvertisingState | varchar(15) | 否 | 广告投放状态 | |||
AdMaterialID | int(10) | 否 | 投放物料ID | |||
AdPosition | varchar(15) | 否 | 广告投放位置(顶,底,漂浮) | |||
AdvertisingPriority | varchar(5) | 否 | 广告投放优先级 | |||
TargetUserID | int(10) | 否 | 目标用户群ID | |||
AdvertisingFreq | int(10) | 否 | 投放频次 | |||
AdvertisingTunnel | varchar(15) | 否 | 投放渠道 | |||
LimitNumPerDay | varchar(5) | 否 | 每日投放上限 | |||
EffectiveBeginTime | varchar(20) | 否 | 投放有效时间段 | |||
HitPeopleNum | int(10) | 否 | 投放命中人数 | |||
HitNum | int(10) | 否 | 投放命中次数 |