okayapi_smpss_mbgroup - MySQ Table Design - OkayAPI.com

+ Use This Table All Design

MySQL Create Table SQL

Table Structure: okayapi_smpss_mbgroup：/tablelist/okayapi_smpss_mbgroup.html


-- MySQL Table okayapi_smpss_mbgroup
-- From: OkayAPI.com
CREATE TABLE `okayapi_smpss_mbgroup` (
    `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
    `mgroup_name` varchar(32) NOT NULL COMMENT '',
    `credit` int(10) NOT NULL COMMENT '消费金额',
    `discount` int(3) NOT NULL COMMENT '折扣',
    KEY `mgroup_name` (`mgroup_name`),
    KEY `credit` (`credit`),
    KEY `discount` (`discount`),
    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-3 of 3 results.

Field Name	Field Type	Default	IS NULL	Field Comment	Index	Demo Data
mgroup_name	varchar(32)		否
credit	int(10)		否	消费金额
discount	int(3)		否	折扣

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_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

MySQL Table Design okayapi_dberp_finance_payable