MySQL Create Table SQL
Table Structure: okayapi_crm_warehouse_user：/tablelist/okayapi_crm_warehouse_user.html
-- MySQL Table okayapi_crm_warehouse_user
-- From: OkayAPI.com
CREATE TABLE `okayapi_crm_warehouse_user` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`warehouse_id` int(11) NOT NULL COMMENT '仓库ID',
`user_id` int(11) NOT NULL COMMENT '用户ID',
KEY `warehouse_id` (`warehouse_id`),
KEY `user_id` (`user_id`),
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 |
|---|---|---|---|---|---|---|
| warehouse_id | int(11) | 否 | 仓库ID | |||
| user_id | int(11) | 否 | 用户ID |
