+ Use This Table All Design

MySQL Create Table SQL

Table Structure: okayapi_admanage_admaininformation:/tablelist/okayapi_admanage_admaininformation.html


-- MySQL Table okayapi_admanage_admaininformation
-- From: OkayAPI.com
CREATE TABLE `okayapi_admanage_admaininformation` (
    `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
    `AdID` int(10) NOT NULL COMMENT '广告ID',
    `AdName` varchar(20) NOT NULL COMMENT '广告名称',
    `AdType` varchar(20) NOT NULL COMMENT '费率',
    `AdRate` varchar(15) NOT NULL COMMENT '广告费率',
    `AdExamineState` varchar(10) NOT NULL COMMENT '广告审核状态',
    `AdHostID` varchar(10) NOT NULL COMMENT '广告主ID',
    `AdBeginTime` date NOT NULL COMMENT '广告开始时间',
    `AdEndTime` date NOT NULL COMMENT '广告结束时间',
    `OrderNumber` varchar(15) NOT NULL COMMENT '关联订单号',
    KEY `AdID` (`AdID`),
    KEY `AdName` (`AdName`),
    KEY `AdType` (`AdType`),
    KEY `AdRate` (`AdRate`),
    KEY `AdExamineState` (`AdExamineState`),
    KEY `AdHostID` (`AdHostID`),
    KEY `AdBeginTime` (`AdBeginTime`),
    KEY `AdEndTime` (`AdEndTime`),
    KEY `OrderNumber` (`OrderNumber`),
    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-9 of 9 results.
Field NameField TypeDefaultIS NULLField CommentIndexDemo Data
AdIDint(10)广告ID
AdNamevarchar(20)广告名称
AdTypevarchar(20)费率
AdRatevarchar(15)广告费率
AdExamineStatevarchar(10)广告审核状态
AdHostIDvarchar(10)广告主ID
AdBeginTimedate广告开始时间
AdEndTimedate广告结束时间
OrderNumbervarchar(15)关联订单号

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