okayapi_crm_gathers - MySQ Table Design

MySQL Create Table SQL

Table Structure: okayapi_crm_gathers：/tablelist/okayapi_crm_gathers.html


-- MySQL Table okayapi_crm_gathers
-- From: OkayAPI.com
CREATE TABLE `okayapi_crm_gathers` (
    `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
    `gathers_num` varchar(255) NULL COMMENT '应收款编号',
    `customer_id` int(11) NULL COMMENT '客户ID',
    `saleorder_id` int(11) NULL COMMENT '销售单号',
    `invoice_id` int(11) NULL COMMENT '发货单',
    `amount` decimal(10,0) NULL COMMENT '应收金额',
    `gather_date` datetime NULL COMMENT '应收日期',
    `memo` text NULL COMMENT '摘要',
    `deleted` tinyint(255) NULL COMMENT '删除标识:0未删除，1删除',
    KEY `gathers_num` (`gathers_num`),
    KEY `customer_id` (`customer_id`),
    KEY `saleorder_id` (`saleorder_id`),
    KEY `invoice_id` (`invoice_id`),
    KEY `amount` (`amount`),
    KEY `gather_date` (`gather_date`),
    KEY `memo` (`memo`),
    KEY `deleted` (`deleted`),
    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	IS NULL	Field Comment
gathers_num	varchar(255)	是	应收款编号
customer_id	int(11)	是	客户ID
saleorder_id	int(11)	是	销售单号
invoice_id	int(11)	是	发货单
amount	decimal(10,0)	是	应收金额
gather_date	datetime	是	应收日期
memo	text	是	摘要
deleted	tinyint(255)	是	删除标识:0未删除，1删除