okayapi_smpss_group - MySQ Table Design - OkayAPI.com

+ Use This Table All Design

MySQL Create Table SQL

Table Structure: okayapi_smpss_group：/tablelist/okayapi_smpss_group.html


-- MySQL Table okayapi_smpss_group
-- From: OkayAPI.com
CREATE TABLE `okayapi_smpss_group` (
    `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
    `group_name` varchar(60) NOT NULL COMMENT '',
    `action_code` text NOT NULL COMMENT '权限范围',
    `state` tinyint(1) NOT NULL DEFAULT '1' COMMENT '0禁用 1可以',
    KEY `group_name` (`group_name`),
    KEY `action_code` (`action_code`),
    KEY `state` (`state`),
    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
group_name	varchar(60)		否
action_code	text		否	权限范围
state	tinyint(1)	1	否	0禁用 1可以		1

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

MySQL Table Design okayapi_dberp_finance_payable