+ Use This Table All Design

MySQL Create Table SQL

Table Structure: okayapi_saixs_ad_ad:/tablelist/okayapi_saixs_ad_ad.html


-- MySQL Table okayapi_saixs_ad_ad
-- From: OkayAPI.com
CREATE TABLE `okayapi_saixs_ad_ad` (
    `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
    `ad_name` varchar(100) NULL COMMENT '广告名称',
    `ad_url` varchar(200) NULL COMMENT '广告链接地址',
    `ad_site` int(11) NULL COMMENT '广告位',
    `site` int(11) NULL COMMENT '',
    `showsl` int(11) NULL DEFAULT '0' COMMENT '显示数量',
    `clicks` int(11) NULL DEFAULT '0' COMMENT '点击率',
    `image` varchar(100) NULL COMMENT '展示图片或flash',
    `price` int(11) NULL COMMENT '价格',
    `up_time` date NULL COMMENT '上线时间',
    `down_time` date NULL COMMENT '下线时间',
    `add_user` tinytext NULL COMMENT '添加用户',
    `state` int(11) NULL DEFAULT '0' COMMENT '状态',
    KEY `ad_name` (`ad_name`),
    KEY `ad_url` (`ad_url`),
    KEY `ad_site` (`ad_site`),
    KEY `site` (`site`),
    KEY `showsl` (`showsl`),
    KEY `clicks` (`clicks`),
    KEY `image` (`image`),
    KEY `price` (`price`),
    KEY `up_time` (`up_time`),
    KEY `down_time` (`down_time`),
    KEY `add_user` (`add_user`),
    KEY `state` (`state`),
    PRIMARY KEY (`id`)
) ENGINE=InnoDB COMMENT 'saixs广告管理-广告';

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 NameField TypeDefaultIS NULLField CommentIndexDemo Data
ad_namevarchar(100)广告名称
ad_urlvarchar(200)广告链接地址
ad_siteint(11)广告位
siteint(11)
showslint(11)0显示数量0
clicksint(11)0点击率0
imagevarchar(100)展示图片或flash
priceint(11)价格
up_timedate上线时间
down_timedate下线时间
add_usertinytext添加用户
stateint(11)0状态0

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_admaininformation

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