+ Use This Table All Design

MySQL Create Table SQL

Table Structure: okayapi_fie_asset:/tablelist/okayapi_fie_asset.html


-- MySQL Table okayapi_fie_asset
-- From: OkayAPI.com
CREATE TABLE `okayapi_fie_asset` (
    `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
    `user_id` bigint(20) NULL DEFAULT '0' COMMENT '用户id',
    `file_size` bigint(20) NULL DEFAULT '0' COMMENT '文件大小,单位B',
    `create_time` int(10) NULL DEFAULT '0' COMMENT '上传时间',
    `okayapi_fie_asset_status` tinyint(3) NULL DEFAULT '1' COMMENT '状态;1:可用,0:不可用',
    `download_times` int(10) NULL DEFAULT '0' COMMENT '下载次数',
    `file_key` varchar(64) NULL COMMENT '文件惟一码',
    `filename` varchar(100) NULL COMMENT '文件名',
    `file_path` varchar(100) NULL COMMENT '文件路径,相对于upload目录,可以为url',
    `file_md5` varchar(32) NULL COMMENT '文件md5值',
    `file_sha1` varchar(40) NULL COMMENT '',
    `suffix` varchar(10) NULL COMMENT '文件后缀名,不包括点',
    `more` text NULL COMMENT '其它详细信息,JSON格式',
    KEY `user_id` (`user_id`),
    KEY `file_size` (`file_size`),
    KEY `create_time` (`create_time`),
    KEY `okayapi_fie_asset_status` (`okayapi_fie_asset_status`),
    KEY `download_times` (`download_times`),
    KEY `file_key` (`file_key`),
    KEY `filename` (`filename`),
    KEY `file_path` (`file_path`),
    KEY `file_md5` (`file_md5`),
    KEY `file_sha1` (`file_sha1`),
    KEY `suffix` (`suffix`),
    KEY `more` (`more`),
    PRIMARY KEY (`id`)
) ENGINE=InnoDB COMMENT 'fie内容管理-资源表';

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
user_idbigint(20)0用户id0
file_sizebigint(20)0文件大小,单位B0
create_timeint(10)0上传时间0
okayapi_fie_asset_statustinyint(3)1状态;1:可用,0:不可用1
download_timesint(10)0下载次数0
file_keyvarchar(64)文件惟一码
filenamevarchar(100)文件名
file_pathvarchar(100)文件路径,相对于upload目录,可以为url
file_md5varchar(32)文件md5值
file_sha1varchar(40)
suffixvarchar(10)文件后缀名,不包括点
moretext其它详细信息,JSON格式

Guess You Like

MySQL Table Design okayapi_message

MySQL Table Design okayapi_article

MySQL Table Design okayapi_fie_admin_menu

MySQL Table Design okayapi_fie_auth_access

MySQL Table Design okayapi_fie_auth_rule

MySQL Table Design okayapi_fie_comment

MySQL Table Design okayapi_fie_hook

MySQL Table Design okayapi_fie_hook_plugin

MySQL Table Design okayapi_fie_link

MySQL Table Design okayapi_fie_nav

MySQL Table Design okayapi_fie_nav_menu

MySQL Table Design okayapi_fie_option

MySQL Table Design okayapi_fie_plugin

MySQL Table Design okayapi_fie_portal_category

MySQL Table Design okayapi_fie_portal_category_post

MySQL Table Design okayapi_fie_portal_post

MySQL Table Design okayapi_fie_portal_tag

MySQL Table Design okayapi_fie_portal_tag_post

MySQL Table Design okayapi_fie_recycle_bin

MySQL Table Design okayapi_fie_role

TOP ↑