okayapi_72crm_crm_contract

-- MySQL Table okayapi_72crm_crm_contract
-- From: OkayAPI.com
CREATE TABLE `okayapi_72crm_crm_contract` (
    `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
    `contract_id` int(11) NULL COMMENT '',
    `okayapi_72crm_crm_contract_name` varchar(50) NULL COMMENT '合同名称',
    `customer_id` int(11) NULL COMMENT '客户ID',
    `business_id` int(11) NULL COMMENT '商机ID',
    `check_status` int(4) NULL DEFAULT '0' COMMENT '0 未审核 1 审核通过 2 审核拒绝 3 审核中 4 已撤回 5草稿 6 作废',
    `examine_record_id` int(11) NULL COMMENT '审核记录ID',
    `order_date` datetime NULL COMMENT '下单日期',
    `create_user_id` bigint(20) NULL COMMENT '创建人ID',
    `owner_user_id` bigint(20) NULL COMMENT '负责人ID',
    `create_time` datetime NULL COMMENT '创建时间',
    `num` varchar(255) NULL COMMENT '合同编号',
    `start_time` datetime NULL COMMENT '开始时间',
    `end_time` datetime NULL COMMENT '结束时间',
    `money` decimal(18,2) NULL COMMENT '合同金额',
    `discount_rate` decimal(10,2) NULL COMMENT '整单折扣',
    `total_price` decimal(10,2) NULL COMMENT '产品总金额',
    `okayapi_72crm_crm_contract_types` varchar(255) NULL COMMENT '合同类型',
    `payment_type` varchar(255) NULL COMMENT '付款方式',
    `batch_id` varchar(32) NULL COMMENT '批次 比如附件批次',
    `ro_user_id` longtext NULL COMMENT '只读权限',
    `rw_user_id` longtext NULL COMMENT '读写权限',
    `contacts_id` int(11) NULL COMMENT '客户签约人（联系人id）',
    `remark` varchar(255) NULL COMMENT '备注',
    `company_user_id` int(11) NULL COMMENT '公司签约人',
    KEY `contract_id` (`contract_id`),
    KEY `okayapi_72crm_crm_contract_name` (`okayapi_72crm_crm_contract_name`),
    KEY `customer_id` (`customer_id`),
    KEY `business_id` (`business_id`),
    KEY `check_status` (`check_status`),
    KEY `examine_record_id` (`examine_record_id`),
    KEY `order_date` (`order_date`),
    KEY `create_user_id` (`create_user_id`),
    KEY `owner_user_id` (`owner_user_id`),
    KEY `create_time` (`create_time`),
    KEY `num` (`num`),
    KEY `start_time` (`start_time`),
    KEY `end_time` (`end_time`),
    KEY `money` (`money`),
    KEY `discount_rate` (`discount_rate`),
    KEY `total_price` (`total_price`),
    KEY `okayapi_72crm_crm_contract_types` (`okayapi_72crm_crm_contract_types`),
    KEY `payment_type` (`payment_type`),
    KEY `batch_id` (`batch_id`),
    KEY `ro_user_id` (`ro_user_id`),
    KEY `rw_user_id` (`rw_user_id`),
    KEY `contacts_id` (`contacts_id`),
    KEY `remark` (`remark`),
    KEY `company_user_id` (`company_user_id`),
    PRIMARY KEY (`id`)
) ENGINE=InnoDB COMMENT 'CRM-合同表';

After replication, you can go to the database to create the database table.