okayapi_crm_competitor - MySQ Table Design

MySQL Create Table SQL

Table Structure: okayapi_crm_competitor：/tablelist/okayapi_crm_competitor.html


-- MySQL Table okayapi_crm_competitor
-- From: OkayAPI.com
CREATE TABLE `okayapi_crm_competitor` (
    `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
    `competitor_name` varchar(255) NULL COMMENT '竞争对手',
    `advantage` text NULL COMMENT '优势',
    `power` varchar(255) NULL COMMENT '竞争力',
    `deleted` tinyint(4) NULL DEFAULT '0' COMMENT '删除标识符号,0未删除，1删除',
    `disadvantaged` int(11) NULL COMMENT '劣势',
    `strategy` int(11) NULL COMMENT '策略',
    `description` int(11) NULL COMMENT '备注',
    KEY `competitor_name` (`competitor_name`),
    KEY `advantage` (`advantage`),
    KEY `power` (`power`),
    KEY `deleted` (`deleted`),
    KEY `disadvantaged` (`disadvantaged`),
    KEY `strategy` (`strategy`),
    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-7 of 7 results.

Field Name	Field Type	Default	IS NULL	Field Comment	Demo Data
competitor_name	varchar(255)		是	竞争对手
advantage	text		是	优势
power	varchar(255)		是	竞争力
deleted	tinyint(4)	0	否	删除标识符号,0未删除，1删除	0
disadvantaged	int(11)		是	劣势
strategy	int(11)		是	策略
description	int(11)		是	备注