+ Use This Table All Design

MySQL Create Table SQL

Table Structure: okayapi_ry_sys_dict_data:/tablelist/okayapi_ry_sys_dict_data.html


-- MySQL Table okayapi_ry_sys_dict_data
-- From: OkayAPI.com
CREATE TABLE `okayapi_ry_sys_dict_data` (
    `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
    `dict_code` bigint(20) NULL COMMENT '字典编码',
    `dict_sort` int(4) NULL DEFAULT '0' COMMENT '字典排序',
    `dict_label` varchar(100) NULL COMMENT '字典标签',
    `dict_value` varchar(100) NULL COMMENT '字典键值',
    `dict_type` varchar(100) NULL COMMENT '字典类型',
    `css_class` varchar(100) NULL COMMENT '样式属性(其他样式扩展)',
    `list_class` varchar(100) NULL COMMENT '表格回显样式',
    `is_default` char(1) NULL DEFAULT 'N' COMMENT '是否默认(Y是 N否)',
    `okayapi_ry_sys_dict_data_status` char(1) NULL DEFAULT '0' COMMENT '状态(0正常 1停用)',
    `create_by` varchar(64) NULL COMMENT '创建者',
    `create_time` datetime NULL COMMENT '创建时间',
    `update_by` varchar(64) NULL COMMENT '更新者',
    `remark` varchar(500) NULL COMMENT '备注',
    KEY `dict_code` (`dict_code`),
    KEY `dict_sort` (`dict_sort`),
    KEY `dict_label` (`dict_label`),
    KEY `dict_value` (`dict_value`),
    KEY `dict_type` (`dict_type`),
    KEY `css_class` (`css_class`),
    KEY `list_class` (`list_class`),
    KEY `is_default` (`is_default`),
    KEY `okayapi_ry_sys_dict_data_status` (`okayapi_ry_sys_dict_data_status`),
    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-13 of 13 results.
Field NameField TypeDefaultIS NULLField CommentIndexDemo Data
dict_codebigint(20)字典编码
dict_sortint(4)0字典排序0
dict_labelvarchar(100)字典标签
dict_valuevarchar(100)字典键值
dict_typevarchar(100)字典类型
css_classvarchar(100)样式属性(其他样式扩展)
list_classvarchar(100)表格回显样式
is_defaultchar(1)N是否默认(Y是 N否)N
okayapi_ry_sys_dict_data_statuschar(1)0状态(0正常 1停用)0
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_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

MySQL Table Design okayapi_ry_gen_table_column

TOP ↑