Press n or j to go to the next uncovered block, b, p or k for the previous block.
| 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 | 1x 1x 1x 1x 1x 1x 1x | // User model definition
module.exports = (sequelize, DataTypes) => {
const AddressVerification = sequelize.define(
"AddressVerification",
{
id: {
type: DataTypes.UUID,
defaultValue: DataTypes.UUIDV4,
primaryKey: true,
},
user_id: {
type: DataTypes.UUID,
allowNull: false,
references: {
model: "tbl_users", // Name of the target model
key: "id", // Key in the target model
},
onUpdate: "CASCADE",
onDelete: "CASCADE",
},
address_id: {
type: DataTypes.UUID,
allowNull: false,
references: {
model: "tbl_addresses", // Name of the target model
key: "id", // Key in the target model
},
onUpdate: "CASCADE",
onDelete: "CASCADE",
},
campaign_id: {
type: DataTypes.UUID,
allowNull: false,
references: {
model: "tbl_campaigns", // Name of the target model
key: "id", // Key in the target model
},
onUpdate: "CASCADE",
onDelete: "CASCADE",
},
otp_code: {
type: DataTypes.STRING,
unique: true,
allowNull: false,
},
status: {
type: DataTypes.ENUM,
allowNull: false,
defaultValue: "pending",
values: ["pending", "verified", "failed", "delivered"],
validate: {
isIn: [["pending", "verified", "failed", "delivered"]],
},
},
attempts: {
type: DataTypes.INTEGER,
allowNull: false,
defaultValue: 0,
},
expires_at: {
type: DataTypes.DATE,
allowNull: false,
},
sent_at: {
type: DataTypes.DATE,
allowNull: false,
},
verified_at: {
type: DataTypes.DATE,
allowNull: false,
},
mailing_provider_url: {
type: DataTypes.TEXT,
allowNull: false,
},
},
{
tableName: "tbl_address_verification",
freezeTableName: true,
timestamps: true,
paranoid: true,
createdAt: "created_at",
updatedAt: "updated_at",
deletedAt: "deleted_at",
hooks: {},
},
);
AddressVerification.associate = (models) => {
AddressVerification.belongsTo(models.User, {
foreignKey: "user_id",
as: "user",
});
AddressVerification.belongsTo(models.Campaign, {
foreignKey: "campaign_id",
as: "campaign",
});
AddressVerification.belongsTo(models.Addresses, {
foreignKey: "address_id",
as: "address",
});
};
return AddressVerification;
};
|