7

常见功能流程图汇总

 3 years ago
source link: https://zsmhub.github.io/post/%E5%AE%9E%E6%88%98%E6%A1%88%E4%BE%8B/%E5%B8%B8%E8%A7%81%E5%8A%9F%E8%83%BD%E6%B5%81%E7%A8%8B%E5%9B%BE%E6%B1%87%E6%80%BB/
Go to the source link to view the article. You can view the picture content, updated content and better typesetting reading experience. If the link is broken, please click the button below to view the snapshot at that time.
neoserver,ios ssh client

常见功能流程图汇总

2021-05-17 约 454 字 预计阅读 1 分钟

后端流程图

友盟一键登录文档

  1. 一键登录接口文档：点击前往
  2. 服务端签名机制：点击前往

微信授权登录 api 文档

点击前往

// 一个user对应多个wechat: 多个微信账号授权可以绑定到同一个手机号
CREATE TABLE `user_wechat` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `user_id` bigint(20) unsigned NOT NULL DEFAULT '0' COMMENT 'userId',
  `unionid` varchar(100) COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '用户统一标识，针对一个微信开放平台帐号下的应用同一用户唯一',
  `openid` varchar(100) COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '普通用户的标识，对当前开发者帐号唯一',
  `nickname` varchar(100) COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '昵称',
  `gender` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT '性别：1男 2女',
  `province` varchar(60) COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '省份',
  `city` varchar(60) COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '城市',
  `country` varchar(60) COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '国家',
  `avatar` varchar(255) COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '头像',
  `privilege` varchar(255) COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '用户特权信息',
  `access_token` varchar(255) COLLATE utf8mb4_general_ci NOT NULL DEFAULT '',
  `refresh_token` varchar(255) COLLATE utf8mb4_general_ci NOT NULL DEFAULT '',
  `created_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  UNIQUE KEY `uix_user_wechat_openid` (`openid`),
  KEY `idx_user_wechat_user_id` (`user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='微信账号信息表';

report

Recommend

About Joyk


Aggregate valuable and interesting links.
Joyk means Joy of geeK