MySQL Create Table SQL
Table Structure: okayapi_sys_authitemchild：/tablelist/okayapi_sys_authitemchild.html
-- MySQL Table okayapi_sys_authitemchild
-- From: OkayAPI.com
CREATE TABLE `okayapi_sys_authitemchild` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`parent` varchar(64) NOT NULL COMMENT '权限管理表',
`child` varchar(64) NOT NULL COMMENT '',
KEY `parent` (`parent`),
KEY `child` (`child`),
PRIMARY KEY (`id`)
) ENGINE=InnoDB COMMENT 'CRM-权限_认证项父子关系';
After replication, you can go to the database to create the database table.
MySQL database table structure design
Displaying 1-2 of 2 results.
| Field Name | Field Type | Default | IS NULL | Field Comment | Index | Demo Data |
|---|---|---|---|---|---|---|
| parent | varchar(64) | 否 | 权限管理表 | |||
| child | varchar(64) | 否 |
