+ Use This Table All Design

MySQL Create Table SQL

Table Structure: okayapi_jsh_system_config:/tablelist/okayapi_jsh_system_config.html


-- MySQL Table okayapi_jsh_system_config
-- From: OkayAPI.com
CREATE TABLE `okayapi_jsh_system_config` (
    `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
    `company_name` varchar(50) NULL COMMENT '公司名称',
    `company_contacts` varchar(20) NULL COMMENT '公司联系人',
    `company_address` varchar(50) NULL COMMENT '公司地址',
    `company_tel` varchar(20) NULL COMMENT '公司电话',
    `company_fax` varchar(20) NULL COMMENT '公司传真',
    `company_post_code` varchar(20) NULL COMMENT '公司邮编',
    `depot_flag` varchar(1) NULL DEFAULT '0' COMMENT '仓库启用标记,0未启用,1启用',
    `customer_flag` varchar(1) NULL DEFAULT '0' COMMENT '客户启用标记,0未启用,1启用',
    `tenant_id` bigint(20) NULL COMMENT '租户id',
    `delete_Flag` varchar(1) NULL DEFAULT '0' COMMENT '删除标记,0未删除,1删除',
    KEY `company_name` (`company_name`),
    KEY `company_contacts` (`company_contacts`),
    KEY `company_address` (`company_address`),
    KEY `company_tel` (`company_tel`),
    KEY `company_fax` (`company_fax`),
    KEY `company_post_code` (`company_post_code`),
    KEY `depot_flag` (`depot_flag`),
    KEY `customer_flag` (`customer_flag`),
    KEY `tenant_id` (`tenant_id`),
    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-10 of 10 results.
Field NameField TypeDefaultIS NULLField CommentIndexDemo Data
company_namevarchar(50)公司名称
company_contactsvarchar(20)公司联系人
company_addressvarchar(50)公司地址
company_telvarchar(20)公司电话
company_faxvarchar(20)公司传真
company_post_codevarchar(20)公司邮编
depot_flagvarchar(1)0仓库启用标记,0未启用,1启用0
customer_flagvarchar(1)0客户启用标记,0未启用,1启用0
tenant_idbigint(20)租户id
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 ↑