| ID|   | Fname |   | Starttime|    | Weekday|   |Workstation - Alloted Composite Rank|

|中国内地| | | | | | | | | | | | | | 3 | 3 | 3 | | | 3 | | | | 3 | | 1830 | | r | | 7 | | 128 | | al | | 1830 | | w |冲突| 129 | | am | 830 | | m | 2 | | | 129 | | am | | 830 2 | | | | | 129 ||上午| | | | | | | | | | | | | |中国| | | | | | | | | | t | | 1 | | | 132 | | bi | | 830 | | | w | 1 | | 133 | br | | 1000 | s | 7 | | 133 | | br | | 1830 | | | m |冲突| 133 | | br ||1830 | | | | | | | | | | | | | | | | | | | | ca | | 1000 | | | s | 6 | | | 135 | | ca | | 1830 | | m | 6 | | 135 | | ca | | 1900 | | | m | | 6 | | | 1830 | | w | 6|
我试着用mysql创建一个复合列，这样这10个人就可以坐在7个工作站上，没有时间和日期的冲突；我尝试过创建partion by starttime/order by id但没有成功。任何帮助都将不胜感激。