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 106 107 108 109 110 | 1x 1x 1x 1x 1x 1x 1x 1x | const { DataTypes, Sequelize } = require("sequelize");
const bcrypt = require("bcrypt");
const { sequelize } = require("../config/sequelize");
// User model definition
module.exports = (sequelize) => {
const Campaign = sequelize.define(
"Campaign",
{
id: {
type: DataTypes.UUID,
defaultValue: DataTypes.UUIDV4,
primaryKey: true,
// autoIncrement: 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",
},
addresses_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_name: {
type: DataTypes.STRING,
unique: true,
allowNull: false,
},
company_name: {
type: DataTypes.STRING,
unique: true,
allowNull: false,
},
brand_color: {
type: DataTypes.STRING,
allowNull: false,
defaultValue: "#9b87f5",
},
status: {
type: DataTypes.ENUM,
allowNull: false,
defaultValue: "Active",
values: ["Active", "Paused", "Archived"],
validate: {
// isIn: [['Active', 'Paused', 'Archived']]
},
},
postcard_front_img_url: {
type: DataTypes.TEXT,
allowNull: false,
},
company_logo_url: {
type: DataTypes.TEXT,
allowNull: false,
},
postback_url: {
type: DataTypes.TEXT,
allowNull: false,
},
return_address: {
type: DataTypes.TEXT,
allowNull: false,
},
total_sent: {
type: DataTypes.INTEGER,
allowNull: false,
defaultValue: 0,
},
total_verified: {
type: DataTypes.INTEGER,
allowNull: false,
defaultValue: 0,
},
campaign_end_at: {
type: DataTypes.DATE,
allowNull: true,
},
},
{
tableName: "tbl_campaigns",
freezeTableName: true,
timestamps: true,
paranoid: true,
createdAt: "created_at",
updatedAt: "updated_at",
deletedAt: "deleted_at",
hooks: {},
},
);
Campaign.associate = (models) => {
Campaign.belongsTo(models.User, {
foreignKey: "user_id",
as: "user",
});
};
return Campaign;
};
|