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 | 1x 1x 1x 1x 1x | module.exports = (sequelize, DataTypes) => {
const PaymentMethods = sequelize.define(
"PaymentMethods",
{
id: {
type: DataTypes.UUID,
defaultValue: DataTypes.UUIDV4,
primaryKey: true,
},
user_id: {
type: DataTypes.UUID,
defaultValue: DataTypes.UUIDV4,
primaryKey: true,
allowNull: false,
references: {
model: "tbl_users", // Change to your actual user table name
key: "id",
},
onUpdate: "CASCADE",
onDelete: "CASCADE",
},
card_brand: {
type: DataTypes.STRING(50),
allowNull: true,
},
last4: {
type: DataTypes.CHAR(20),
allowNull: true,
},
exp_month: {
type: DataTypes.INTEGER,
allowNull: true,
},
exp_year: {
type: DataTypes.INTEGER,
allowNull: true,
},
is_default: {
type: DataTypes.BOOLEAN,
allowNull: false,
defaultValue: false,
},
},
{
tableName: "tbl_payment_methods",
freezeTableName: true,
timestamps: true,
createdAt: "created_at",
updatedAt: "updated_at",
paranoid: false, // No deleted_at in original SQL
},
);
PaymentMethods.associate = (models) => {
PaymentMethods.belongsTo(models.User, {
foreignKey: "user_id",
as: "user",
});
};
return PaymentMethods;
};
|