🌐

UMID Federated Identity

One UMID across all apps, cross-platform auto-merge

UMID (UserMatrix ID) is the federated identity. One UMID runs through all UM-integrated apps, cross-platform accounts auto-merge. User identity is owned by users, apps are consumers.

Try Online Read Docs →

example.sql

// 用户主表
CREATE TABLE um_user (
  id BIGINT PRIMARY KEY AUTO_INCREMENT,
  openid VARCHAR(64),           -- UMID
  login_type VARCHAR(20),
  nickname VARCHAR(100),
  avatar VARCHAR(500),
  phone VARCHAR(20),
  email VARCHAR(100),
  score INT DEFAULT 0,
  balance DECIMAL(10,2) DEFAULT 0
);

-- 第三方绑定表（一个 UMID 可绑定多个平台）
CREATE TABLE um_oauth (
  user_id BIGINT,
  appid VARCHAR(32),
  type VARCHAR(20),             -- wx/alipay/qq/douyin
  openid VARCHAR(64),           -- 第三方 openid
  access_token VARCHAR(255)
);