MySQL Create Table SQL
Table Structure: okayapi_moneymanager_permission:/tablelist/okayapi_moneymanager_permission.html
-- MySQL Table okayapi_moneymanager_permission
-- From: OkayAPI.com
CREATE TABLE `okayapi_moneymanager_permission` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`actionName` varchar(255) NULL COMMENT '',
`roleId` int(11) NULL COMMENT '',
`remark` varchar(255) NULL COMMENT '',
KEY `actionName` (`actionName`),
KEY `roleId` (`roleId`),
KEY `remark` (`remark`),
PRIMARY KEY (`id`)
) ENGINE=InnoDB COMMENT 'mm财务管理-权限';
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 |
---|---|---|---|---|---|---|
actionName | varchar(255) | 是 | ||||
roleId | int(11) | 是 | ||||
remark | varchar(255) | 是 |