19 lines
561 B
TypeScript
19 lines
561 B
TypeScript
import db from '../src/database/models/index.js';
|
|
|
|
async function checkColumn() {
|
|
try {
|
|
const [results]: any = await db.sequelize.query(`
|
|
SELECT column_name, data_type, udt_name
|
|
FROM information_schema.columns
|
|
WHERE table_name = 'request_participants' AND column_name = 'participantType'
|
|
`);
|
|
console.log('Column definition:', results[0]);
|
|
} catch (error: any) {
|
|
console.error('Error fetching column:', error.message);
|
|
} finally {
|
|
process.exit(0);
|
|
}
|
|
}
|
|
|
|
checkColumn();
|