water/server/plugin/saiadmin/db/20260909_water_agent.sql

CREATE TABLE IF NOT EXISTS `sa_water_agent` (
 `id` bigint unsigned NOT NULL AUTO_INCREMENT,
 `user_id` int unsigned DEFAULT NULL COMMENT '迁移来源账号，不自动授予供水权限',
 `name` varchar(120) NOT NULL,
 `contact` varchar(60) NOT NULL,
 `phone` varchar(30) NOT NULL,
 `region` varchar(160) NOT NULL DEFAULT '',
 `address` varchar(255) NOT NULL DEFAULT '',
 `status` tinyint NOT NULL DEFAULT 1,
 `contract_urls` json DEFAULT NULL,
 `identity_urls` json DEFAULT NULL,
 `extra_urls` json DEFAULT NULL,
 `created_at` datetime NOT NULL,
 `updated_at` datetime NOT NULL,
 PRIMARY KEY (`id`), UNIQUE KEY `uk_water_agent_user` (`user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='供水代理档案';