MySQL Create Table SQL
Table Structure: okayapi_jsh_unit：/tablelist/okayapi_jsh_unit.html
-- MySQL Table okayapi_jsh_unit
-- From: OkayAPI.com
CREATE TABLE `okayapi_jsh_unit` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`UName` varchar(50) NULL COMMENT '名称，支持多单位',
`tenant_id` bigint(20) NULL COMMENT '租户id',
`delete_Flag` varchar(1) NULL DEFAULT '0' COMMENT '删除标记，0未删除，1删除',
KEY `UName` (`UName`),
KEY `tenant_id` (`tenant_id`),
KEY `delete_Flag` (`delete_Flag`),
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-3 of 3 results.
| Field Name | Field Type | Default | IS NULL | Field Comment | Index | Demo Data |
|---|---|---|---|---|---|---|
| UName | varchar(50) | 是 | 名称，支持多单位 | |||
| tenant_id | bigint(20) | 是 | 租户id | |||
| delete_Flag | varchar(1) | 0 | 是 | 删除标记，0未删除，1删除 | 0 |
