MySQL Create Table SQL
Table Structure: okayapi_jsh_tenant：/tablelist/okayapi_jsh_tenant.html
-- MySQL Table okayapi_jsh_tenant
-- From: OkayAPI.com
CREATE TABLE `okayapi_jsh_tenant` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`tenant_id` bigint(20) NULL COMMENT '用户id',
`login_name` varchar(255) NULL COMMENT '登录名',
`user_num_limit` int(11) NULL COMMENT '用户数量限制',
`bills_num_limit` int(11) NULL COMMENT '单据数量限制',
KEY `tenant_id` (`tenant_id`),
KEY `login_name` (`login_name`),
KEY `user_num_limit` (`user_num_limit`),
KEY `bills_num_limit` (`bills_num_limit`),
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-4 of 4 results.
| Field Name | Field Type | Default | IS NULL | Field Comment | Index | Demo Data |
|---|---|---|---|---|---|---|
| tenant_id | bigint(20) | 是 | 用户id | |||
| login_name | varchar(255) | 是 | 登录名 | |||
| user_num_limit | int(11) | 是 | 用户数量限制 | |||
| bills_num_limit | int(11) | 是 | 单据数量限制 |
