+ Use This Table All Design

MySQL Create Table SQL

Table Structure: okayapi_jsh_functions:/tablelist/okayapi_jsh_functions.html


-- MySQL Table okayapi_jsh_functions
-- From: OkayAPI.com
CREATE TABLE `okayapi_jsh_functions` (
    `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
    `Id` bigint(20) NULL COMMENT '主键',
    `Number` varchar(50) NULL COMMENT '编号',
    `Name` varchar(50) NULL COMMENT '名称',
    `PNumber` varchar(50) NULL COMMENT '上级编号',
    `URL` varchar(100) NULL COMMENT '链接',
    `State` bit(1) NULL COMMENT '收缩',
    `Sort` varchar(50) NULL COMMENT '排序',
    `Enabled` bit(1) NULL COMMENT '启用',
    `Type` varchar(50) NULL COMMENT '类型',
    `PushBtn` varchar(50) NULL COMMENT '功能按钮',
    `delete_Flag` varchar(1) NULL DEFAULT '0' COMMENT '删除标记,0未删除,1删除',
    KEY `Id` (`Id`),
    KEY `Number` (`Number`),
    KEY `Name` (`Name`),
    KEY `PNumber` (`PNumber`),
    KEY `URL` (`URL`),
    KEY `State` (`State`),
    KEY `Sort` (`Sort`),
    KEY `Enabled` (`Enabled`),
    KEY `Type` (`Type`),
    KEY `PushBtn` (`PushBtn`),
    KEY `delete_Flag` (`delete_Flag`),
    PRIMARY KEY (`id`)
) ENGINE=InnoDB COMMENT 'ERP进销存-功能模块表';

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


MySQL database table structure design

Displaying 1-11 of 11 results.
Field NameField TypeDefaultIS NULLField CommentIndexDemo Data
Idbigint(20)主键
Numbervarchar(50)编号
Namevarchar(50)名称
PNumbervarchar(50)上级编号
URLvarchar(100)链接
Statebit(1)收缩
Sortvarchar(50)排序
Enabledbit(1)启用
Typevarchar(50)类型
PushBtnvarchar(50)功能按钮
delete_Flagvarchar(1)0删除标记,0未删除,1删除0

Guess You Like

MySQL Table Design okayapi_smpss_admin

MySQL Table Design okayapi_smpss_category

MySQL Table Design okayapi_smpss_goods

MySQL Table Design okayapi_smpss_group

MySQL Table Design okayapi_smpss_log

MySQL Table Design okayapi_smpss_mbgroup

MySQL Table Design okayapi_smpss_member

MySQL Table Design okayapi_smpss_purchase

MySQL Table Design okayapi_smpss_region

MySQL Table Design okayapi_smpss_sales

MySQL Table Design okayapi_smpss_system

MySQL Table Design okayapi_smpss_tempsales

MySQL Table Design okayapi_dberp_accounts_receivable

MySQL Table Design okayapi_dberp_accounts_receivable_log

MySQL Table Design okayapi_dberp_admin

MySQL Table Design okayapi_dberp_admin_group

MySQL Table Design okayapi_dberp_app

MySQL Table Design okayapi_dberp_brand

MySQL Table Design okayapi_dberp_customer

MySQL Table Design okayapi_dberp_customer_category

TOP ↑