okayapi_crm_salesorder - MySQ Table Design

MySQL Create Table SQL

Table Structure: okayapi_crm_salesorder：/tablelist/okayapi_crm_salesorder.html


-- MySQL Table okayapi_crm_salesorder
-- From: OkayAPI.com
CREATE TABLE `okayapi_crm_salesorder` (
    `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
    `salesorder_number` varchar(255) NULL COMMENT '销售订单号',
    `stage` varchar(255) NULL COMMENT '订单状态',
    `customer_id` int(11) NULL COMMENT '客户ID',
    `contacter_id` int(11) NULL COMMENT '联系人ID',
    `signdate` datetime NULL COMMENT '签约日期',
    `total` decimal(10,0) NULL COMMENT '总计',
    `gather_status` varchar(255) NULL COMMENT '收款状态',
    `deleted` tinyint(4) NULL DEFAULT '0' COMMENT '删除标识：0未删除，1删除',
    `description` text NULL COMMENT '描述信息',
    `tax` tinyint(4) NULL COMMENT '税收比例',
    `adjustment` decimal(10,0) NULL COMMENT '金额调整',
    KEY `salesorder_number` (`salesorder_number`),
    KEY `stage` (`stage`),
    KEY `customer_id` (`customer_id`),
    KEY `contacter_id` (`contacter_id`),
    KEY `signdate` (`signdate`),
    KEY `total` (`total`),
    KEY `gather_status` (`gather_status`),
    KEY `deleted` (`deleted`),
    KEY `description` (`description`),
    KEY `tax` (`tax`),
    KEY `adjustment` (`adjustment`),
    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-11 of 11 results.

Field Name	Field Type	Default	IS NULL	Field Comment	Demo Data
salesorder_number	varchar(255)		是	销售订单号
stage	varchar(255)		是	订单状态
customer_id	int(11)		是	客户ID
contacter_id	int(11)		是	联系人ID
signdate	datetime		是	签约日期
total	decimal(10,0)		是	总计
gather_status	varchar(255)		是	收款状态
deleted	tinyint(4)	0	否	删除标识：0未删除，1删除	0
description	text		是	描述信息
tax	tinyint(4)		是	税收比例
adjustment	decimal(10,0)		是	金额调整