+ Use This Table All Design

MySQL Create Table SQL

Table Structure: okayapi_jsh_app:/tablelist/okayapi_jsh_app.html


-- MySQL Table okayapi_jsh_app
-- From: OkayAPI.com
CREATE TABLE `okayapi_jsh_app` (
    `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
    `Id` bigint(20) NULL COMMENT '主键',
    `Number` varchar(50) NULL COMMENT '编号',
    `Name` varchar(50) NULL COMMENT '名称',
    `Type` varchar(50) NULL COMMENT '类型',
    `Icon` varchar(50) NULL COMMENT '图标',
    `URL` varchar(50) NULL COMMENT '编号',
    `Width` varchar(50) NULL COMMENT '宽度',
    `Height` varchar(50) NULL COMMENT '高度',
    `ReSize` bit(1) NULL COMMENT '是否可改变大小',
    `OpenMax` bit(1) NULL COMMENT '最大化',
    `Flash` bit(1) NULL COMMENT '是否切换',
    `ZL` varchar(50) NULL COMMENT '类型',
    `Sort` varchar(50) NULL COMMENT '排序',
    `Remark` varchar(200) NULL COMMENT '备注',
    `Enabled` bit(1) NULL COMMENT '是否启用',
    `delete_Flag` varchar(1) NULL DEFAULT '0' COMMENT '删除标记,0未删除,1删除',
    KEY `Id` (`Id`),
    KEY `Number` (`Number`),
    KEY `Name` (`Name`),
    KEY `Type` (`Type`),
    KEY `Icon` (`Icon`),
    KEY `URL` (`URL`),
    KEY `Width` (`Width`),
    KEY `Height` (`Height`),
    KEY `ReSize` (`ReSize`),
    KEY `OpenMax` (`OpenMax`),
    KEY `Flash` (`Flash`),
    KEY `ZL` (`ZL`),
    KEY `Sort` (`Sort`),
    KEY `Remark` (`Remark`),
    KEY `Enabled` (`Enabled`),
    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-16 of 16 results.
Field NameField TypeDefaultIS NULLField CommentIndexDemo Data
Idbigint(20)主键
Numbervarchar(50)编号
Namevarchar(50)名称
Typevarchar(50)类型
Iconvarchar(50)图标
URLvarchar(50)编号
Widthvarchar(50)宽度
Heightvarchar(50)高度
ReSizebit(1)是否可改变大小
OpenMaxbit(1)最大化
Flashbit(1)是否切换
ZLvarchar(50)类型
Sortvarchar(50)排序
Remarkvarchar(200)备注
Enabledbit(1)是否启用
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 ↑