======================================================================== [TABLE] MKQDK [FILE] /root/disk_3tb/earlywarning/database/MKQDK.csv [AVAILABLE_COLUMNS] ['NHHK', 'IDKQDK', 'IDSV', 'IDToHoc', 'NgayThem', 'NgayDoiNhom', 'NgayNhapDiem', 'NgayLock', 'GcHuyDK'] [MISSING_COLUMNS] [] [ROWS] 1,378,743 [FIELD] NHHK: non_null=1,378,743 coverage=100.00% date_example=- [FIELD] IDKQDK: non_null=1,378,743 coverage=100.00% date_example=- [FIELD] IDSV: non_null=1,378,743 coverage=100.00% date_example=- [FIELD] IDToHoc: non_null=1,378,743 coverage=100.00% date_example=- [FIELD] NgayThem: non_null=1,378,743 coverage=100.00% date_example=2018-11-30 14:57:06.000 [FIELD] NgayDoiNhom: non_null=45,303 coverage=3.29% date_example=2025-07-25 17:06:43.280 [FIELD] NgayNhapDiem: non_null=1,182,674 coverage=85.78% date_example=2018-11-30 15:09:57.000 [FIELD] NgayLock: non_null=96,312 coverage=6.99% date_example=2020-06-01 07:44:39.000 [FIELD] GcHuyDK: non_null=0 coverage=0.00% date_example=- [RECENT_SEMESTERS] [('20222', 88688), ('20223', 3781), ('20231', 103142), ('20232', 80303), ('20233', 5781), ('20241', 91904), ('20242', 78897), ('20243', 5504), ('20251', 96208), ('20252', 79701)] ======================================================================== [TABLE] KToHoc [FILE] /root/disk_3tb/earlywarning/database/KToHoc.csv [AVAILABLE_COLUMNS] ['NHHK', 'IDToHoc', 'IDMH', 'NgayThem', 'SiSoDDK'] [MISSING_COLUMNS] [] [ROWS] 33,037 [FIELD] NHHK: non_null=33,037 coverage=100.00% date_example=- [FIELD] IDToHoc: non_null=33,037 coverage=100.00% date_example=- [FIELD] IDMH: non_null=33,037 coverage=100.00% date_example=- [FIELD] NgayThem: non_null=33,037 coverage=100.00% date_example=2022-10-03 10:37:57.000 [FIELD] SiSoDDK: non_null=33,036 coverage=100.00% date_example=- [RECENT_SEMESTERS] [('20223', 62), ('20231', 2637), ('20232', 2157), ('20233', 118), ('20241', 2777), ('20242', 2334), ('20243', 99), ('20251', 2989), ('20252', 2300), ('20253', 1)] ======================================================================== [TABLE] MTGDK [FILE] /root/disk_3tb/earlywarning/database/MTGDK.csv [AVAILABLE_COLUMNS] ['NHHK', 'NgayBDDKMH', 'NgayKTDKMH'] [MISSING_COLUMNS] [] [ROWS] 221 [FIELD] NHHK: non_null=221 coverage=100.00% date_example=- [FIELD] NgayBDDKMH: non_null=208 coverage=94.12% date_example=2018-07-02 00:00:00.000 [FIELD] NgayKTDKMH: non_null=208 coverage=94.12% date_example=2018-07-15 00:00:00.000 [RECENT_SEMESTERS] [('20181', 1), ('20211', 1), ('20212', 14), ('20213', 1), ('20222', 1), ('20231', 4), ('20232', 3), ('20241', 192), ('20251', 3), ('20252', 1)] ======================================================================== [TABLE] HDMNHHK [FILE] /root/disk_3tb/earlywarning/database/HDMNHHK.csv [AVAILABLE_COLUMNS] ['NHHK', 'NgayBDHK', 'NgayBDXacNhanKQDK', 'NgayKTXacNhanKQDK'] [MISSING_COLUMNS] [] [ROWS] 72 [FIELD] NHHK: non_null=72 coverage=100.00% date_example=- [FIELD] NgayBDHK: non_null=72 coverage=100.00% date_example=2014-06-16 00:00:00.000 [FIELD] NgayBDXacNhanKQDK: non_null=0 coverage=0.00% date_example=- [FIELD] NgayKTXacNhanKQDK: non_null=0 coverage=0.00% date_example=- [RECENT_SEMESTERS] [('20222', 1), ('20223', 1), ('20231', 1), ('20232', 1), ('20233', 1), ('20241', 1), ('20242', 1), ('20243', 1), ('20251', 1), ('20252', 1)] ======================================================================== [TABLE] DDTBHK [FILE] /root/disk_3tb/earlywarning/database/DDTBHK.csv [AVAILABLE_COLUMNS] ['NHHK', 'IDSV', 'NgayThem'] [MISSING_COLUMNS] [] [ROWS] 602,025 [FIELD] NHHK: non_null=602,025 coverage=100.00% date_example=- [FIELD] IDSV: non_null=602,025 coverage=100.00% date_example=- [FIELD] NgayThem: non_null=602,025 coverage=100.00% date_example=2022-03-09 11:55:01.000 [RECENT_SEMESTERS] [('20222', 32462), ('20223', 12141), ('20231', 36045), ('20232', 36230), ('20233', 15054), ('20241', 38350), ('20242', 33726), ('20243', 12946), ('20251', 36410), ('20252', 32970)] ======================================================================== [TABLE] DDTBHP [FILE] /root/disk_3tb/earlywarning/database/DDTBHP.csv [AVAILABLE_COLUMNS] ['NHHK', 'IDSV', 'IDMH', 'NgayDK', 'NgayThem'] [MISSING_COLUMNS] [] [ROWS] 1,486,096 [FIELD] NHHK: non_null=1,486,096 coverage=100.00% date_example=- [FIELD] IDSV: non_null=1,486,096 coverage=100.00% date_example=- [FIELD] IDMH: non_null=1,486,096 coverage=100.00% date_example=- [FIELD] NgayDK: non_null=1,486,096 coverage=100.00% date_example=2020-12-24 10:36:22.000 [FIELD] NgayThem: non_null=1,486,096 coverage=100.00% date_example=2026-03-09 15:34:32.000 [RECENT_SEMESTERS] [('20222', 91855), ('20223', 3830), ('20231', 126501), ('20232', 89863), ('20233', 5827), ('20241', 105762), ('20242', 87700), ('20243', 8492), ('20251', 101873), ('20252', 83761)] ======================================================================== [TABLE] SSVHK [FILE] /root/disk_3tb/earlywarning/database/SSVHK.csv [AVAILABLE_COLUMNS] ['NHHK', 'IDSV', 'NgayThem', 'HienDienSV'] [MISSING_COLUMNS] [] [ROWS] 754,074 [FIELD] NHHK: non_null=754,074 coverage=100.00% date_example=- [FIELD] IDSV: non_null=754,074 coverage=100.00% date_example=- [FIELD] NgayThem: non_null=754,074 coverage=100.00% date_example=2021-01-20 16:16:12.000 [FIELD] HienDienSV: non_null=754,074 coverage=100.00% date_example=- [RECENT_SEMESTERS] [('20223', 29941), ('20231', 35580), ('20232', 35783), ('20233', 33167), ('20241', 37850), ('20242', 33277), ('20243', 29462), ('20251', 36142), ('20252', 32765), ('20253', 32416)] [AUDIT_COMPLETE]