okayapi_f_base_dictionary - MySQ Table Design

MySQL Create Table SQL

Table Structure: okayapi_f_base_dictionary：/tablelist/okayapi_f_base_dictionary.html


-- MySQL Table okayapi_f_base_dictionary
-- From: OkayAPI.com
CREATE TABLE `okayapi_f_base_dictionary` (
    `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
    `okayapi_f_base_dictionary_name` varchar(64) NULL COMMENT '',
    `priority` int(11) NULL COMMENT '',
    `okayapi_f_base_dictionary_type` varchar(16) NULL COMMENT '',
    `okayapi_f_base_dictionary_value` varchar(128) NULL COMMENT '',
    `parent_id` bigint(20) NULL COMMENT '',
    KEY `okayapi_f_base_dictionary_name` (`okayapi_f_base_dictionary_name`),
    KEY `priority` (`priority`),
    KEY `okayapi_f_base_dictionary_type` (`okayapi_f_base_dictionary_type`),
    KEY `okayapi_f_base_dictionary_value` (`okayapi_f_base_dictionary_value`),
    KEY `parent_id` (`parent_id`),
    PRIMARY KEY (`id`)
) ENGINE=InnoDB COMMENT '财务管理-字典';

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	IS NULL	Index
okayapi_f_base_dictionary_name	varchar(64)	否
priority	int(11)	否
okayapi_f_base_dictionary_type	varchar(16)	是
okayapi_f_base_dictionary_value	varchar(128)	是
parent_id	bigint(20)	是	Normal Index