okayapi_crm_accountrecordss - MySQ Table Design

MySQL Create Table SQL

Table Structure: okayapi_crm_accountrecordss：/tablelist/okayapi_crm_accountrecordss.html


-- MySQL Table okayapi_crm_accountrecordss
-- From: OkayAPI.com
CREATE TABLE `okayapi_crm_accountrecordss` (
    `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
    `title` varchar(255) NULL COMMENT '主题',
    `customer` varchar(255) NULL COMMENT '客户',
    `start_date` date NULL COMMENT '开始时间',
    `serviceitem` text NULL COMMENT '服务内容',
    `feedback` text NULL COMMENT '反馈',
    `contacter_id` int(255) NULL COMMENT '联系人',
    `create_time` timestamp NULL DEFAULT '0000-00-00 00:00:00' COMMENT '创建时间',
    `deleted` tinyint(4) NULL DEFAULT '0' COMMENT '删除标识：0未删除，1删除',
    `description` int(11) NULL COMMENT '描述信息',
    KEY `title` (`title`),
    KEY `customer` (`customer`),
    KEY `start_date` (`start_date`),
    KEY `serviceitem` (`serviceitem`),
    KEY `feedback` (`feedback`),
    KEY `contacter_id` (`contacter_id`),
    KEY `create_time` (`create_time`),
    KEY `deleted` (`deleted`),
    KEY `description` (`description`),
    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-9 of 9 results.

Field Name	Field Type	Default	IS NULL	Field Comment	Demo Data
title	varchar(255)		是	主题
customer	varchar(255)		是	客户
start_date	date		是	开始时间
serviceitem	text		是	服务内容
feedback	text		是	反馈
contacter_id	int(255)		是	联系人
create_time	timestamp	0000-00-00 00:00:00	否	创建时间	0000-00-00 00:00:00
deleted	tinyint(4)	0	否	删除标识：0未删除，1删除	0
description	int(11)		是	描述信息