MySQL Create Table SQL
Table Structure: okayapi_crm_warehouse：/tablelist/okayapi_crm_warehouse.html
-- MySQL Table okayapi_crm_warehouse
-- From: OkayAPI.com
CREATE TABLE `okayapi_crm_warehouse` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`warehouse_name` varchar(255) NOT NULL COMMENT '仓库名称',
`description` varchar(255) NOT NULL COMMENT '仓库描述',
`enabled` tinyint(255) NOT NULL DEFAULT '1' COMMENT '是否启用：1启用，0禁用',
`deleted` tinyint(4) NOT NULL DEFAULT '0' COMMENT '删除标识：0未删除，1删除',
KEY `warehouse_name` (`warehouse_name`),
KEY `description` (`description`),
KEY `enabled` (`enabled`),
KEY `deleted` (`deleted`),
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-4 of 4 results.
| Field Name | Field Type | Default | IS NULL | Field Comment | Index | Demo Data |
|---|---|---|---|---|---|---|
| warehouse_name | varchar(255) | 是 | 仓库名称 | |||
| description | varchar(255) | 是 | 仓库描述 | |||
| enabled | tinyint(255) | 1 | 否 | 是否启用：1启用，0禁用 | 1 | |
| deleted | tinyint(4) | 0 | 否 | 删除标识：0未删除，1删除 | 0 |
