okayapi_admanage_adhost - MySQ Table Design

MySQL Create Table SQL

Table Structure: okayapi_admanage_adhost：/tablelist/okayapi_admanage_adhost.html


-- MySQL Table okayapi_admanage_adhost
-- From: OkayAPI.com
CREATE TABLE `okayapi_admanage_adhost` (
    `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
    `AdHostID` int(10) NOT NULL COMMENT '广告主编号',
    `AdHostName` varchar(20) NOT NULL COMMENT '广告主名称（单位、部门、个人）',
    `AdHostTel` varchar(15) NOT NULL COMMENT '广告主联系方式（号码、地址）',
    `AdHostAddress` varchar(30) NOT NULL COMMENT '',
    `AdHostAdMoney` varchar(10) NOT NULL COMMENT '广告币',
    `AdHostRealMoney` varchar(10) NOT NULL COMMENT '实际金额',
    KEY `AdHostID` (`AdHostID`),
    KEY `AdHostName` (`AdHostName`),
    KEY `AdHostTel` (`AdHostTel`),
    KEY `AdHostAddress` (`AdHostAddress`),
    KEY `AdHostAdMoney` (`AdHostAdMoney`),
    KEY `AdHostRealMoney` (`AdHostRealMoney`),
    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-6 of 6 results.

Field Name	Field Type	IS NULL	Field Comment
AdHostID	int(10)	否	广告主编号
AdHostName	varchar(20)	否	广告主名称（单位、部门、个人）
AdHostTel	varchar(15)	否	广告主联系方式（号码、地址）
AdHostAddress	varchar(30)	否
AdHostAdMoney	varchar(10)	否	广告币
AdHostRealMoney	varchar(10)	否	实际金额