Files
Sathira Sri Sathara 9d3d431416 feat: implement identity and security features
- Added account types and privileged account types constants.
- Created admin user controller for updating user security fields.
- Developed role assignment controller for managing user roles.
- Implemented validation middleware for request schemas.
- Defined user role and auth session models for database interactions.
- Created services for authentication, email notifications, and OTP handling.
- Developed OAuth service for Google and Apple authentication.
- Added JWT utility functions for token generation and verification.
- Implemented comprehensive tests for authentication, session management, and password policies.
- Created migration for updating user schema and adding new tables for auth sessions and user identities.
2026-09-03 13:56:18 +05:30

14 lines
693 B
JavaScript

module.exports = (sequelize, DataTypes) => {
const UserIdentity = sequelize.define("UserIdentity", {
id: { type: DataTypes.UUID, primaryKey: true },
user_id: { type: DataTypes.STRING, allowNull: false },
provider: { type: DataTypes.ENUM("google", "apple"), allowNull: false },
provider_subject: { type: DataTypes.STRING, allowNull: false },
provider_email: DataTypes.STRING,
}, { tableName: "user_identities", timestamps: true, indexes: [
{ unique: true, fields: ["provider", "provider_subject"] }, { fields: ["user_id"] },
] });
UserIdentity.associate = (db) => UserIdentity.belongsTo(db.User, { foreignKey: "user_id", as: "user" });
return UserIdentity;
};