okayapi_crm_deliverys - MySQ Table Design

MySQL Create Table SQL

Table Structure: okayapi_crm_deliverys：/tablelist/okayapi_crm_deliverys.html


-- MySQL Table okayapi_crm_deliverys
-- From: OkayAPI.com
CREATE TABLE `okayapi_crm_deliverys` (
    `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
    `deliverys_num` varchar(255) NULL COMMENT '出库单号',
    `status` varchar(255) NULL COMMENT '状态',
    `salesorder_id` int(11) NULL COMMENT '合同订单号',
    `invoice_id` int(11) NULL COMMENT '发货单ID',
    `deliverystime` datetime NULL COMMENT '出库时间',
    `deleted` tinyint(255) NULL COMMENT '删除标识',
    KEY `deliverys_num` (`deliverys_num`),
    KEY `status` (`status`),
    KEY `salesorder_id` (`salesorder_id`),
    KEY `invoice_id` (`invoice_id`),
    KEY `deliverystime` (`deliverystime`),
    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-6 of 6 results.

Field Name	Field Type	IS NULL	Field Comment
deliverys_num	varchar(255)	是	出库单号
status	varchar(255)	是	状态
salesorder_id	int(11)	是	合同订单号
invoice_id	int(11)	是	发货单ID
deliverystime	datetime	是	出库时间
deleted	tinyint(255)	是	删除标识