okayapi_shopxo_s_attachment - MySQ Table Design

MySQL Create Table SQL

Table Structure: okayapi_shopxo_s_attachment：/tablelist/okayapi_shopxo_s_attachment.html


-- MySQL Table okayapi_shopxo_s_attachment
-- From: OkayAPI.com
CREATE TABLE `okayapi_shopxo_s_attachment` (
    `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
    `title` char(160) NULL COMMENT '名称',
    `original` char(160) NULL COMMENT '原始名称',
    `path_type` char(80) NULL COMMENT '路径标记',
    `size` int(11) NULL DEFAULT '0' COMMENT '大小（单位kb）',
    `ext` char(30) NULL COMMENT '类型（后缀名）',
    `okayapi_shopxo_s_attachment_type` char(30) NULL COMMENT '类型（file文件, image图片, scrawl涂鸦, video视频, remote远程抓取文件）',
    `url` char(255) NULL COMMENT 'url路径',
    `okayapi_shopxo_s_attachment_hash` text NULL COMMENT 'hash值',
    KEY `title` (`title`),
    KEY `original` (`original`),
    KEY `path_type` (`path_type`),
    KEY `size` (`size`),
    KEY `ext` (`ext`),
    KEY `okayapi_shopxo_s_attachment_type` (`okayapi_shopxo_s_attachment_type`),
    KEY `url` (`url`),
    KEY `okayapi_shopxo_s_attachment_hash` (`okayapi_shopxo_s_attachment_hash`),
    PRIMARY KEY (`id`)
) ENGINE=InnoDB COMMENT 'ShopXO商城-附件';

After replication, you can go to the database to create the database table.

MySQL database table structure design

Displaying 1-8 of 8 results.

Field Name	Field Type	Default	IS NULL	Field Comment	Index	Demo Data
title	char(160)		否	名称
original	char(160)		否	原始名称
path_type	char(80)		否	路径标记	Normal Index
size	int(11)	0	否	大小（单位kb）		0
ext	char(30)		否	类型（后缀名）
okayapi_shopxo_s_attachment_type	char(30)		否	类型（file文件, image图片, scrawl涂鸦, video视频, remote远程抓取文件）	Normal Index
url	char(255)		否	url路径
okayapi_shopxo_s_attachment_hash	text		是	hash值