okayapi_crm_potentials - MySQ Table Design

MySQL Create Table SQL

Table Structure: okayapi_crm_potentials：/tablelist/okayapi_crm_potentials.html


-- MySQL Table okayapi_crm_potentials
-- From: OkayAPI.com
CREATE TABLE `okayapi_crm_potentials` (
    `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
    `potentials_name` varchar(255) NULL COMMENT '销售机会名称',
    `customer_id` int(11) NULL COMMENT '客户ID',
    `stage` varchar(255) NULL COMMENT '销售阶段',
    `possibility` tinyint(255) NULL DEFAULT '0' COMMENT '成交的可能性',
    `duedate` date NULL COMMENT '成交日期',
    `nextstep` varchar(255) NULL COMMENT '下一阶段',
    `deleted` tinyint(4) NULL DEFAULT '0' COMMENT '删除标识符：0未删除，1删除',
    `description` int(11) NULL COMMENT '描述',
    KEY `potentials_name` (`potentials_name`),
    KEY `customer_id` (`customer_id`),
    KEY `stage` (`stage`),
    KEY `possibility` (`possibility`),
    KEY `duedate` (`duedate`),
    KEY `nextstep` (`nextstep`),
    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-8 of 8 results.

Field Name	Field Type	Default	IS NULL	Field Comment	Demo Data
potentials_name	varchar(255)		是	销售机会名称
customer_id	int(11)		是	客户ID
stage	varchar(255)		是	销售阶段
possibility	tinyint(255)	0	是	成交的可能性	0
duedate	date		是	成交日期
nextstep	varchar(255)		是	下一阶段
deleted	tinyint(4)	0	否	删除标识符：0未删除，1删除	0
description	int(11)		是	描述