MySQL Create Table SQL
Table Structure: okayapi_72crm_admin_scene_default:/tablelist/okayapi_72crm_admin_scene_default.html
-- MySQL Table okayapi_72crm_admin_scene_default
-- From: OkayAPI.com
CREATE TABLE `okayapi_72crm_admin_scene_default` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`default_id` int(11) NOT NULL COMMENT '',
`okayapi_72crm_admin_scene_default_type` int(5) NOT NULL COMMENT '类型',
`user_id` bigint(20) NOT NULL COMMENT '人员ID',
`scene_id` int(11) NOT NULL COMMENT '场景ID',
KEY `default_id` (`default_id`),
KEY `okayapi_72crm_admin_scene_default_type` (`okayapi_72crm_admin_scene_default_type`),
KEY `user_id` (`user_id`),
KEY `scene_id` (`scene_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-4 of 4 results.
Field Name | Field Type | Default | IS NULL | Field Comment | Index | Demo Data |
---|---|---|---|---|---|---|
default_id | int(11) | 否 | ||||
okayapi_72crm_admin_scene_default_type | int(5) | 否 | 类型 | |||
user_id | bigint(20) | 否 | 人员ID | |||
scene_id | int(11) | 否 | 场景ID |