ylrz_saas_pharmacy/adminui/scripts/check-lobster-schema.js

const mysql = require('mysql2/promise')
const DB = process.argv[2] || 'fs_tenant_cs1'
const cfg = {
  host: 'cq-cdb-8fjmemkb.sql.tencentcdb.com', port: 27220,
  user: 'root', password: 'Ylrz_1q2w3e4r5t6y', database: DB, charset: 'utf8mb4'
}
async function main() {
  const c = await mysql.createConnection(cfg)
  const [cols] = await c.query(
    "SELECT COLUMN_NAME FROM information_schema.COLUMNS WHERE TABLE_SCHEMA=DATABASE() AND TABLE_NAME='lobster_sales_corpus' ORDER BY ORDINAL_POSITION"
  )
  const [instCols] = await c.query(
    "SELECT COLUMN_NAME FROM information_schema.COLUMNS WHERE TABLE_SCHEMA=DATABASE() AND TABLE_NAME='lobster_workflow_instance' AND COLUMN_NAME IN ('dept_id','binding_id','channel_type','company_user_id')"
  )
  console.log('lobster_sales_corpus columns:', cols.map(r => r.COLUMN_NAME).join(', '))
  console.log('lobster_workflow_instance scope cols:', instCols.map(r => r.COLUMN_NAME).join(', ') || '(none)')
  await c.end()
}
main().catch(e => { console.error(e); process.exit(1) })