okayapi_admanage_admaterial - MySQ Table Design

MySQL Create Table SQL

Table Structure: okayapi_admanage_admaterial：/tablelist/okayapi_admanage_admaterial.html


-- MySQL Table okayapi_admanage_admaterial
-- From: OkayAPI.com
CREATE TABLE `okayapi_admanage_admaterial` (
    `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
    `AdMaterialID` int(10) NOT NULL COMMENT '广告物料ID',
    `AdMaterialName` varchar(15) NOT NULL COMMENT '广告物料名称',
    `AdImage` varchar(10) NOT NULL COMMENT '广告物料图片',
    `AdvertisingUrl` varchar(20) NOT NULL COMMENT '生成的投放URL链接',
    KEY `AdMaterialID` (`AdMaterialID`),
    KEY `AdMaterialName` (`AdMaterialName`),
    KEY `AdImage` (`AdImage`),
    KEY `AdvertisingUrl` (`AdvertisingUrl`),
    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-4 of 4 results.

Field Name	Field Type	IS NULL	Field Comment
AdMaterialID	int(10)	否	广告物料ID
AdMaterialName	varchar(15)	否	广告物料名称
AdImage	varchar(10)	否	广告物料图片
AdvertisingUrl	varchar(20)	否	生成的投放URL链接