SCH · UC-SCH-01

UC-SCH-01 — Chuan bi du lieu xep TKB

Chuan bi du lieu xep TKB. This UC is contract-ready for implementation baseline; full 1:1 requires the blocker checks below.

Nguồn: docs/modules/sch/use-cases/UC-SCH-01.md · Sample data (fake VN)

S1 · Timetable input workspace

Timetable input workspace

termCode

API: `GET /timetable/preparation?termCode={NHHK}` · DB:

`KToHop`: `IDToHop`, `IDToHoc`, `NHHK`, `TenToHop`, `IDPhDK`, `SucChuaPH`, `SiSoTKB`, `SoTietTKB`, `IDLOPDOT`, `LinkHocOnline`; `KTKB`: `IDTKB`, `NHHK`, `IDToHo

S2 · Preparation import

Preparation import

dryRun

API: `POST /timetable/preparation/import` with `dryRun=true` · DB:

`KTKBTuan`: `IDTKBTuan`, `IDToHop`, `TuanBD`, `SoTuan`; `KLDKXTKB`: `IDLDKXTKB`, `IDToHop`, `NHHK`, `Thu`, `TietBD`, `SoTiet`, `MaLoi`, `TenLoi`, `IDPH`, `IDLoa

S3 · Constraints and priority

Constraints and priority

keywordtermCode

API: Covered by preparation GET/POST payload · DB:

`KDMHanCheCTXTKB`: `IDHanCheCTXTKB`, `MaHanCheCTXTKB`, `TenHanCheCTXTKB`, `DfHanCheCTXTKB`, `HuyHanCheCTXTKB`; `KDMHanCheCTXTKBCT`: `IDHanCheCTXTKBCT`, `IDHanCh

S4 · True gaps

True gaps

keywordtermCode

Mã	Họ tên	Lớp/Ngành	Trạng thái	Ghi chú
SV22010001	Nguyễn Văn An	CNTT-K18-01	Đang học	QĐ/2025/810
SV22010015	Trần Thị Bình	CNTT-K18-02	Tạm dừng	QĐ/2025/811
SV22010028	Lê Minh Châu	KT-K18-01	Đang học	QĐ/2025/812
SV22010042	Phạm Quốc Dũng	QTKD-K18-01	Nghỉ luôn	QĐ/2025/813
SV22010057	Hoàng Thu Hà	NN-K18-03	Đang học	QĐ/2025/814
SV22010063	Vũ Đức Khoa	CNTT-K18-01	Tốt nghiệp	QĐ/2025/815

API: API request payload remains generic `SchCommandRequest.payload` · DB: `DULIEUXEPTKBDA`, `CommonSCHDA`, `LOPDA`, `MonHocDPDA` method-level extraction rules are not available