+ Use This Table All Design

MySQL Create Table SQL

Table Structure: okayapi_ry_gen_table:/tablelist/okayapi_ry_gen_table.html


-- MySQL Table okayapi_ry_gen_table
-- From: OkayAPI.com
CREATE TABLE `okayapi_ry_gen_table` (
    `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
    `table_id` bigint(20) NULL COMMENT '编号',
    `okayapi_ry_gen_table_table_name` varchar(200) NULL COMMENT '表名称',
    `table_comment` varchar(500) NULL COMMENT '表描述',
    `sub_table_name` varchar(64) NULL COMMENT '关联子表的表名',
    `sub_table_fk_name` varchar(64) NULL COMMENT '子表关联的外键名',
    `class_name` varchar(100) NULL COMMENT '实体类名称',
    `tpl_category` varchar(200) NULL DEFAULT 'crud' COMMENT '使用的模板(crud单表操作 tree树表操作 sub主子表操作)',
    `package_name` varchar(100) NULL COMMENT '生成包路径',
    `module_name` varchar(30) NULL COMMENT '生成模块名',
    `business_name` varchar(30) NULL COMMENT '生成业务名',
    `function_name` varchar(50) NULL COMMENT '生成功能名',
    `function_author` varchar(50) NULL COMMENT '生成功能作者',
    `gen_type` char(1) NULL DEFAULT '0' COMMENT '生成代码方式(0zip压缩包 1自定义路径)',
    `gen_path` varchar(200) NULL DEFAULT '/' COMMENT '生成路径(不填默认项目路径)',
    `okayapi_ry_gen_table_options` varchar(1000) NULL COMMENT '其它生成选项',
    `create_by` varchar(64) NULL COMMENT '创建者',
    `create_time` datetime NULL COMMENT '创建时间',
    `update_by` varchar(64) NULL COMMENT '更新者',
    `remark` varchar(500) NULL COMMENT '备注',
    KEY `table_id` (`table_id`),
    KEY `okayapi_ry_gen_table_table_name` (`okayapi_ry_gen_table_table_name`),
    KEY `table_comment` (`table_comment`),
    KEY `sub_table_name` (`sub_table_name`),
    KEY `sub_table_fk_name` (`sub_table_fk_name`),
    KEY `class_name` (`class_name`),
    KEY `tpl_category` (`tpl_category`),
    KEY `package_name` (`package_name`),
    KEY `module_name` (`module_name`),
    KEY `business_name` (`business_name`),
    KEY `function_name` (`function_name`),
    KEY `function_author` (`function_author`),
    KEY `gen_type` (`gen_type`),
    KEY `gen_path` (`gen_path`),
    KEY `okayapi_ry_gen_table_options` (`okayapi_ry_gen_table_options`),
    KEY `create_by` (`create_by`),
    KEY `create_time` (`create_time`),
    KEY `update_by` (`update_by`),
    KEY `remark` (`remark`),
    PRIMARY KEY (`id`)
) ENGINE=InnoDB COMMENT 'RuoYi后台管理系统-代码生成业务表';

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


MySQL database table structure design

Displaying 1-19 of 19 results.
Field NameField TypeDefaultIS NULLField CommentIndexDemo Data
table_idbigint(20)编号
okayapi_ry_gen_table_table_namevarchar(200)表名称
table_commentvarchar(500)表描述
sub_table_namevarchar(64)关联子表的表名
sub_table_fk_namevarchar(64)子表关联的外键名
class_namevarchar(100)实体类名称
tpl_categoryvarchar(200)crud使用的模板(crud单表操作 tree树表操作 sub主子表操作)crud
package_namevarchar(100)生成包路径
module_namevarchar(30)生成模块名
business_namevarchar(30)生成业务名
function_namevarchar(50)生成功能名
function_authorvarchar(50)生成功能作者
gen_typechar(1)0生成代码方式(0zip压缩包 1自定义路径)0
gen_pathvarchar(200)/生成路径(不填默认项目路径)/
okayapi_ry_gen_table_optionsvarchar(1000)其它生成选项
create_byvarchar(64)创建者
create_timedatetime创建时间
update_byvarchar(64)更新者
remarkvarchar(500)备注

Guess You Like

MySQL Table Design okayapi_ry_sys_dept

MySQL Table Design okayapi_ry_sys_user

MySQL Table Design okayapi_ry_sys_post

MySQL Table Design okayapi_ry_sys_role

MySQL Table Design okayapi_ry_sys_menu

MySQL Table Design okayapi_ry_sys_user_role

MySQL Table Design okayapi_ry_sys_role_menu

MySQL Table Design okayapi_ry_sys_role_dept

MySQL Table Design okayapi_ry_sys_user_post

MySQL Table Design okayapi_ry_sys_oper_log

MySQL Table Design okayapi_ry_sys_dict_type

MySQL Table Design okayapi_ry_sys_dict_data

MySQL Table Design okayapi_ry_sys_config

MySQL Table Design okayapi_ry_sys_logininfor

MySQL Table Design okayapi_ry_sys_user_online

MySQL Table Design okayapi_ry_sys_job

MySQL Table Design okayapi_ry_sys_job_log

MySQL Table Design okayapi_ry_sys_notice

MySQL Table Design okayapi_ry_gen_table_column

TOP ↑