water/server/plugin/saiadmin/db/20260901_add_rental_user.sql

CREATE TABLE IF NOT EXISTS `sa_rental_user` (
    `id`                BIGINT UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '用户ID',
    `agent_id`          INT UNSIGNED NOT NULL DEFAULT 0 COMMENT '所属平台代理ID',
    `source`            TINYINT NOT NULL DEFAULT 1 COMMENT '来源：1微信 2支付宝',
    `openid`            VARCHAR(128) NOT NULL DEFAULT '' COMMENT '平台用户标识',
    `unionid`           VARCHAR(128) NOT NULL DEFAULT '' COMMENT '跨应用用户标识',
    `nickname`          VARCHAR(100) NOT NULL DEFAULT '' COMMENT '用户昵称',
    `phone`             VARCHAR(32) NOT NULL DEFAULT '' COMMENT '手机号码',
    `avatar`            VARCHAR(500) NOT NULL DEFAULT '' COMMENT '头像地址',
    `deposit_amount`    DECIMAL(12,2) NOT NULL DEFAULT 0.00 COMMENT '已交押金',
    `wallet_balance`    DECIMAL(12,2) NOT NULL DEFAULT 0.00 COMMENT '钱包余额',
    `card_balance`      DECIMAL(12,2) NOT NULL DEFAULT 0.00 COMMENT '储值卡余额',
    `card_gift_balance` DECIMAL(12,2) NOT NULL DEFAULT 0.00 COMMENT '储值卡赠额',
    `status`            TINYINT NOT NULL DEFAULT 1 COMMENT '状态：1正常 2禁用',
    `register_at`       DATETIME NULL COMMENT '注册时间',
    `created_by`        INT NULL,
    `updated_by`        INT NULL,
    `create_time`       DATETIME NULL,
    `update_time`       DATETIME NULL,
    `delete_time`       DATETIME NULL,
    PRIMARY KEY (`id`),
    KEY `idx_rental_user_source_time` (`source`, `register_at`),
    KEY `idx_rental_user_phone` (`phone`),
    KEY `idx_rental_user_agent` (`agent_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='小程序租借用户';