• Home
• com.vwkit
• matrix-business-starter-pay
• 2.1.5
• source code
• create_pay_table.sql

×

Project download

Many resources are needed to download a project. Please understand that we have to compensate our server costs. Thank you in advance.
Project price only 1 $

You can buy this project and download/modify it how often you want.

business-sql.create_pay_table.sql Maven / Gradle / Ivy

CREATE TABLE matrix_business_pay
(
    `id`           bigint(10) NOT NULL AUTO_INCREMENT COMMENT '主键',
    `type_code`     VARCHAR(255)   NOT NULL COMMENT '类型编码',
    `pay_id`       VARCHAR(255)   NOT NULL COMMENT '支付ID',
    `order_id`     VARCHAR(255)   NOT NULL COMMENT '订单号',
    `price`        DECIMAL(20, 2) NOT NULL COMMENT '支付金额',
    `body`         TEXT           NOT NULL COMMENT '支付请求体',
    `url`          VARCHAR(255)   NOT NULL COMMENT '支付跳转url',
    `actual_price` DECIMAL(20, 2) COMMENT '实际支付金额',
    `out_trade_no` VARCHAR(255) COMMENT '第三方订单号',
    `pay_mode`     VARCHAR(20)    NOT NULL COMMENT '支付方式',
    `pay_channel`  VARCHAR(20)    NOT NULL COMMENT '支付渠道',
    `order_by`     INT(10) NOT NULL DEFAULT 0 COMMENT '排序字段',
    `create_time`  DATETIME       NOT NULL COMMENT '创建时间',
    `update_time`  DATETIME       NOT NULL COMMENT '更新时间',
    `status`       INT(1) NOT NULL DEFAULT 0 COMMENT '状态(0:未支付,1:已支付,-1:删除)',
    PRIMARY KEY (`id`) USING BTREE,
    UNIQUE KEY `pay_id` (`pay_id`) USING HASH
) DEFAULT CHARSET = utf8mb4 COMMENT '支付流水表'