MySQL Create Table SQL
Table Structure: okayapi_xbinstore_tb_index_slide_ad:/tablelist/okayapi_xbinstore_tb_index_slide_ad.html
-- MySQL Table okayapi_xbinstore_tb_index_slide_ad
-- From: OkayAPI.com
CREATE TABLE `okayapi_xbinstore_tb_index_slide_ad` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`alt` varchar(5) NULL COMMENT '提示',
`clog` varchar(100) NULL COMMENT 'log号',
`ext1` varchar(5) NULL COMMENT '无',
`href` varchar(500) NULL COMMENT '网址',
`logV` varchar(5) NULL COMMENT 'log等级',
`src` varchar(200) NULL COMMENT '大图片',
`srcB` varchar(200) NULL COMMENT '小图片',
`okayapi_xbinstore_tb_index_slide_ad_status` int(1) NULL DEFAULT '1' COMMENT '状态。可选值:1(正常),2(删除)',
`sort_order` int(4) NULL DEFAULT '1' COMMENT '排序',
`logDomain` varchar(200) NULL COMMENT 'log记录网址前缀',
`created` datetime NULL COMMENT '',
`updated` datetime NULL COMMENT '',
KEY `alt` (`alt`),
KEY `clog` (`clog`),
KEY `ext1` (`ext1`),
KEY `href` (`href`),
KEY `logV` (`logV`),
KEY `src` (`src`),
KEY `srcB` (`srcB`),
KEY `okayapi_xbinstore_tb_index_slide_ad_status` (`okayapi_xbinstore_tb_index_slide_ad_status`),
KEY `sort_order` (`sort_order`),
KEY `logDomain` (`logDomain`),
KEY `created` (`created`),
KEY `updated` (`updated`),
PRIMARY KEY (`id`)
) ENGINE=InnoDB COMMENT 'B2C商城-首页轮播广告';
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 Name | Field Type | Default | IS NULL | Field Comment | Index | Demo Data |
---|---|---|---|---|---|---|
alt | varchar(5) | 是 | 提示 | |||
clog | varchar(100) | 是 | log号 | |||
ext1 | varchar(5) | 是 | 无 | |||
href | varchar(500) | 是 | 网址 | |||
logV | varchar(5) | 是 | log等级 | |||
src | varchar(200) | 是 | 大图片 | |||
srcB | varchar(200) | 是 | 小图片 | |||
okayapi_xbinstore_tb_index_slide_ad_status | int(1) | 1 | 是 | 状态。可选值:1(正常),2(删除) | 1 | |
sort_order | int(4) | 1 | 是 | 排序 | 1 | |
logDomain | varchar(200) | 是 | log记录网址前缀 | |||
created | datetime | 是 | ||||
updated | datetime | 是 |