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 Name | Field Type | Default | IS NULL | Field Comment | Index | Demo Data |
---|---|---|---|---|---|---|
AdID | int(10) | 否 | 广告ID | |||
AdName | varchar(20) | 否 | 广告名称 | |||
AdType | varchar(20) | 否 | 费率 | |||
AdRate | varchar(15) | 否 | 广告费率 | |||
AdExamineState | varchar(10) | 否 | 广告审核状态 | |||
AdHostID | varchar(10) | 否 | 广告主ID | |||
AdBeginTime | date | 否 | 广告开始时间 | |||
AdEndTime | date | 否 | 广告结束时间 | |||
OrderNumber | varchar(15) | 否 | 关联订单号 |