slaj/doc/check_table_columns.sql

-- 查询所有 slaj 模块表的列信息
SELECT table_name, column_name, data_type, ordinal_position
FROM information_schema.columns
WHERE table_schema = 'slaj'
  AND table_name IN (
    -- eutr
    'obj_eutr_cour','bis_eutr_cour_cate','bis_eutr_cour_rec','bis_eutr_plan','bis_eutr_rec',
    'bis_eutr_exam','bis_eutr_exam_stra','bis_eutr_eq','bis_eutr_tque_opt','bis_eutr_eq_answ',
    'bis_eutr_cour_to_eq','bis_eutr_subject_of_cour','bis_eutr_offl_rec',
    -- sins
    'obj_sins','bis_sins_sche','bis_sins_sche_grop','bis_sins_report','obj_expert','obj_case',
    'bis_wiun_bere_bad','att_eng_res','rel_eng_org','rel_sins_org','rel_sins_group_expe',
    'rel_sins_group_pers','rel_sins_group_wiun','rel_sblz_config','sawf_cred_sapr',
    -- stan
    'bis_stan_cert','bis_stan_cert_cha_appl','bis_stan_cert_ext_appl','bis_stan_cert_rev',
    'bis_stan_revi_rec','bis_stan_score','bis_stan_self_eva_rep','bis_scen_revi',
    'bis_from_firsttria','obj_stan_appl','obj_stan_revi','obj_puno'
  )
ORDER BY table_name, ordinal_position;