okayapi_fie_recycle_bin - MySQ Table Design

MySQL Create Table SQL

Table Structure: okayapi_fie_recycle_bin：/tablelist/okayapi_fie_recycle_bin.html


-- MySQL Table okayapi_fie_recycle_bin
-- From: OkayAPI.com
CREATE TABLE `okayapi_fie_recycle_bin` (
    `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
    `object_id` int(11) NOT NULL DEFAULT '0' COMMENT '删除内容 id',
    `create_time` int(10) NOT NULL DEFAULT '0' COMMENT '创建时间',
    `okayapi_fie_recycle_bin_table_name` varchar(60) NOT NULL COMMENT '删除内容所在表名',
    `okayapi_fie_recycle_bin_name` varchar(255) NOT NULL COMMENT '删除内容名称',
    `user_id` bigint(20) NOT NULL DEFAULT '0' COMMENT '用户id',
    KEY `object_id` (`object_id`),
    KEY `create_time` (`create_time`),
    KEY `okayapi_fie_recycle_bin_table_name` (`okayapi_fie_recycle_bin_table_name`),
    KEY `okayapi_fie_recycle_bin_name` (`okayapi_fie_recycle_bin_name`),
    KEY `user_id` (`user_id`),
    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-5 of 5 results.

Field Name	Field Type	Default	IS NULL	Field Comment	Demo Data
object_id	int(11)	0	是	删除内容 id	0
create_time	int(10)	0	是	创建时间	0
okayapi_fie_recycle_bin_table_name	varchar(60)		是	删除内容所在表名
okayapi_fie_recycle_bin_name	varchar(255)		是	删除内容名称
user_id	bigint(20)	0	否	用户id	0