YZ
Size: a a a
YZ
N
N
const meetingInvitees = sequelizeClient.define('meeting_invitees', {
id: {
type: DataTypes.UUID,
defaultValue: DataTypes.UUIDV4,
primaryKey: true,
allowNull: false
},
meetingId: {
type: DataTypes.STRING
},
accessToken: {
type: DataTypes.STRING,
unique: true,
allowNull: false
},
status: {
type: DataTypes.STRING,
allowNull: false
}
}, {
hooks: {
beforeCount(options: any): HookReturn {
options.raw = true;
}
},
indexes: [{
unique: true,
fields: ['userId', 'meetingId', 'status']
}]
});N
N
error: Unhandled Rejection at: Promise {"name":"SequelizeDatabaseError","parent":{"length":241,"name":"error","severity":"ERROR","code":"42804","detail":"Key columns \"meetingId\" and \"id\" are of incompatible types: character varying and uuid.","file":"tablecmds.c","line":"8069","routine":"ATAddForeignKeyConstraint","sql":"CREATE TABLE IF NOT EXISTS \"meeting_invitees\" (\"id\" UUID NOT NULL , \"meetingId\" VARCHAR(255) NOT NULL REFERENCES \"meetings\" (\"id\") ON DELETE NO ACTION ON UPDATE CASCADE, \"accessToken\" VARCHAR(255) NOT NULL UNIQUE, \"status\" VARCHAR(255) NOT NULL, \"createdAt\" TIMESTAMP WITH TIME ZONE NOT NULL, \"updatedAt\" TIMESTAMP WITH TIME ZONE NOT NULL, \"userId\" VARCHAR(255) NOT NULL REFERENCES \"users\" (\"id\") ON DELETE NO ACTION ON UPDATE CASCADE, PRIMARY KEY (\"id\"));"},"original":{"length":241,"name":"error","severity":"ERROR","code":"42804","detail":"Key columns \"meetingId\" and \"id\" are of incompatible types: character varying and uuid.","file":"tablecmds.c","line":"8069","routine":"ATAddForeignKeyConstraint","sql":"CREATE TABLE IF NOT EXISTS \"meeting_invitees\" (\"id\" UUID NOT NULL , \"meetingId\" VARCHAR(255) NOT NULL REFERENCES \"meetings\" (\"id\") ON DELETE NO ACTION ON UPDATE CASCADE, \"accessToken\" VARCHAR(255) NOT NULL UNIQUE, \"status\" VARCHAR(255) NOT NULL, \"createdAt\" TIMESTAMP WITH TIME ZONE NOT NULL, \"updatedAt\" TIMESTAMP WITH TIME ZONE NOT NULL, \"userId\" VARCHAR(255) NOT NULL REFERENCES \"users\" (\"id\") ON DELETE NO ACTION ON UPDATE CASCADE, PRIMARY KEY (\"id\"));"},"sql":"CREATE TABLE IF NOT EXISTS \"meeting_invitees\" (\"id\" UUID NOT NULL , \"meetingId\" VARCHAR(255) NOT NULL REFERENCES \"meetings\" (\"id\") ON DELETE NO ACTION ON UPDATE CASCADE, \"accessToken\" VARCHAR(255) NOT NULL UNIQUE, \"status\" VARCHAR(255) NOT NULL, \"createdAt\" TIMESTAMP WITH TIME ZONE NOT NULL, \"updatedAt\" TIMESTAMP WITH TIME ZONE NOT NULL, \"userId\" VARCHAR(255) NOT NULL REFERENCES \"users\" (\"id\") ON DELETE NO ACTION ON UPDATE CASCADE, PRIMARY KEY (\"id\”));”}N
N
YZ
N
А

А
N
N
YZ
YZ
А
А

А
А