+ Use This Table All Design

MySQL Create Table SQL

Table Structure: okayapi_72crm_admin_scene:/tablelist/okayapi_72crm_admin_scene.html


-- MySQL Table okayapi_72crm_admin_scene
-- From: OkayAPI.com
CREATE TABLE `okayapi_72crm_admin_scene` (
    `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
    `scene_id` int(10) NOT NULL COMMENT '',
    `okayapi_72crm_admin_scene_type` int(5) NOT NULL COMMENT '分类',
    `okayapi_72crm_admin_scene_name` varchar(50) NOT NULL COMMENT '场景名称',
    `user_id` bigint(20) NOT NULL COMMENT '用户ID',
    `sort` int(5) NOT NULL COMMENT '排序ID',
    `okayapi_72crm_admin_scene_data` text NOT NULL COMMENT '属性值',
    `is_hide` int(1) NOT NULL COMMENT '1隐藏',
    `is_system` int(1) NOT NULL COMMENT '1系统0自定义',
    `bydata` varchar(50) NOT NULL COMMENT '系统参数',
    `create_time` datetime NOT NULL COMMENT '创建时间',
    KEY `scene_id` (`scene_id`),
    KEY `okayapi_72crm_admin_scene_type` (`okayapi_72crm_admin_scene_type`),
    KEY `okayapi_72crm_admin_scene_name` (`okayapi_72crm_admin_scene_name`),
    KEY `user_id` (`user_id`),
    KEY `sort` (`sort`),
    KEY `okayapi_72crm_admin_scene_data` (`okayapi_72crm_admin_scene_data`),
    KEY `is_hide` (`is_hide`),
    KEY `is_system` (`is_system`),
    KEY `bydata` (`bydata`),
    KEY `create_time` (`create_time`),
    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-10 of 10 results.
Field NameField TypeDefaultIS NULLField CommentIndexDemo Data
scene_idint(10)
okayapi_72crm_admin_scene_typeint(5)分类
okayapi_72crm_admin_scene_namevarchar(50)场景名称
user_idbigint(20)用户ID
sortint(5)排序ID
okayapi_72crm_admin_scene_datatext属性值
is_hideint(1)1隐藏
is_systemint(1)1系统0自定义
bydatavarchar(50)系统参数
create_timedatetime创建时间

Guess You Like

MySQL Table Design okayapi_72crm_admin_config

MySQL Table Design okayapi_72crm_admin_dept

MySQL Table Design okayapi_72crm_admin_examine

MySQL Table Design okayapi_72crm_admin_examine_log

MySQL Table Design okayapi_72crm_admin_examine_record

MySQL Table Design okayapi_72crm_admin_examine_step

MySQL Table Design okayapi_72crm_admin_field_sort

MySQL Table Design okayapi_72crm_admin_fieldv

MySQL Table Design okayapi_72crm_admin_file

MySQL Table Design okayapi_72crm_admin_menu

MySQL Table Design okayapi_72crm_admin_message

MySQL Table Design okayapi_72crm_admin_record

MySQL Table Design okayapi_72crm_admin_role

MySQL Table Design okayapi_72crm_admin_role_menu

MySQL Table Design okayapi_72crm_admin_scene_default

MySQL Table Design okayapi_72crm_admin_user

MySQL Table Design okayapi_72crm_admin_user_role

MySQL Table Design okayapi_72crm_crm_achievement

MySQL Table Design okayapi_72crm_crm_action_record

MySQL Table Design okayapi_72crm_crm_area

TOP ↑