okayapi_72crm_admin_fieldv - MySQ Table Design

MySQL Create Table SQL

Table Structure: okayapi_72crm_admin_fieldv：/tablelist/okayapi_72crm_admin_fieldv.html


-- MySQL Table okayapi_72crm_admin_fieldv
-- From: OkayAPI.com
CREATE TABLE `okayapi_72crm_admin_fieldv` (
    `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
    `field_id` int(11) NULL COMMENT '',
    `okayapi_72crm_admin_fieldv_name` varchar(255) NULL COMMENT '字段名称',
    `okayapi_72crm_admin_fieldv_value` longtext NULL COMMENT '',
    `create_time` datetime NULL COMMENT '',
    `batch_id` varchar(32) NULL COMMENT '',
    KEY `field_id` (`field_id`),
    KEY `okayapi_72crm_admin_fieldv_name` (`okayapi_72crm_admin_fieldv_name`),
    KEY `okayapi_72crm_admin_fieldv_value` (`okayapi_72crm_admin_fieldv_value`),
    KEY `create_time` (`create_time`),
    KEY `batch_id` (`batch_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-5 of 5 results.

Field Name	Field Type	IS NULL	Field Comment	Index
field_id	int(11)	是
okayapi_72crm_admin_fieldv_name	varchar(255)	是	字段名称
okayapi_72crm_admin_fieldv_value	longtext	是
create_time	datetime	是
batch_id	varchar(32)	是		Normal Index