+ Use This Table All Design

MySQL Create Table SQL

Table Structure: okayapi_moneymanager_menu:/tablelist/okayapi_moneymanager_menu.html


-- MySQL Table okayapi_moneymanager_menu
-- From: OkayAPI.com
CREATE TABLE `okayapi_moneymanager_menu` (
    `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
    `menuId` varchar(36) NULL COMMENT '',
    `okayapi_moneymanager_menu_name` varchar(255) NULL COMMENT '',
    `url` varchar(255) NULL COMMENT '',
    `href` varchar(255) NULL COMMENT '',
    `okayapi_moneymanager_menu_no` int(11) NULL COMMENT '',
    `roleId` int(11) NULL COMMENT '',
    KEY `menuId` (`menuId`),
    KEY `okayapi_moneymanager_menu_name` (`okayapi_moneymanager_menu_name`),
    KEY `url` (`url`),
    KEY `href` (`href`),
    KEY `okayapi_moneymanager_menu_no` (`okayapi_moneymanager_menu_no`),
    KEY `roleId` (`roleId`),
    PRIMARY KEY (`id`)
) ENGINE=InnoDB COMMENT 'mm财务管理-菜单';

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


MySQL database table structure design

Displaying 1-6 of 6 results.
Field NameField TypeDefaultIS NULLField CommentIndexDemo Data
menuIdvarchar(36)
okayapi_moneymanager_menu_namevarchar(255)
urlvarchar(255)
hrefvarchar(255)
okayapi_moneymanager_menu_noint(11)
roleIdint(11)

Guess You Like

MySQL Table Design okayapi_f_base_component_resource

MySQL Table Design okayapi_f_base_data_control

MySQL Table Design okayapi_f_base_dictionary

MySQL Table Design okayapi_f_base_log_info

MySQL Table Design okayapi_f_base_module

MySQL Table Design okayapi_f_base_organization

MySQL Table Design okayapi_f_base_organization_role

MySQL Table Design okayapi_f_base_permission

MySQL Table Design okayapi_f_base_role

MySQL Table Design okayapi_f_base_role_permission

MySQL Table Design okayapi_f_base_role_permission_data_control

MySQL Table Design okayapi_f_base_user

MySQL Table Design okayapi_f_base_user_role

MySQL Table Design okayapi_f_sample_product

MySQL Table Design okayapi_f_sample_task

MySQL Table Design okayapi_moneymanager_billforin

MySQL Table Design okayapi_moneymanager_billforout

MySQL Table Design okayapi_moneymanager_message

MySQL Table Design okayapi_moneymanager_page

MySQL Table Design okayapi_moneymanager_permission

TOP ↑