Comparador de bases de dados

untis-horarios-copy -> untis-horarios-teste

InputFormat

8 linha(s) com diferencas
Estado SCHOOL_ID SCHOOLYEAR_ID VERSION_ID INPUT_FORMAT_ID Owner Counter USER_ID Deleted SortId Name Longname WindowDef Flags MiscData PictureData1 PictureData2 Font Printer PrintFont ActualELEMENT_ID2 HeaderFields Type2 ColumnsStr ColumnsActiveStr ColWidthsStr LayoutHaeder ColsFixed NoCol ColWidth NoColTeacher TypeX Field1 Field2 Field3 Field4 Field5 Field6 Field7 Field8 Field9 Field10 Flags1
Modificado 40245 20262027 1 4 0
Original418
Copy444
Original2
Copy4
 0 0 Tur Turma
OriginalTur~FP~Sd~100~18~0~20090727~20090727~87~-9~-1~-1~830~659~559~0~0~"0~0"~0-1-1-0-0~
CopyTur~AP~Sd~100~1~0~20090727~20090727~0~0~-1~-1~1240~437~317~0~0~"0~0"~0-1-1-0-0~
 OVflprstv0 158/203~0 NULL NULL 80;400;1;Arial 0;0;20;20;20;20 110;400;1;Arial 0 NULL 0 NULL NULL NULL 0 1 10 0 10 K
Originaldradr~D~~~~1~250~0~0~~,kname~f~~~"TURMAS"~2~690~16~1~~,lname~D~~~~3~1320~0~0~~,text~D~~~~4~1215~0~0~~,besre~D~~~~5~900~0~0~~,kraum~D~~~~6~495~0~0~~,klehr~L~~~~9~3945~0~0~~,kmitp~D~~~~7~1170~0~0~~,ksttg~D~~~~8~900~0~0~~,fwocw~D~~~~10~720~0~0~~,fwocs~D~~~~11~435~0~0~~
Copydradr~D~~~~1~300~0~0~~,kname~f~~~"TURMAS"~2~672~16~1~~,lname~D~~~~3~1296~0~0~~,text~D~~~~4~1188~0~0~~,besre~D~~~~5~876~0~0~~,kraum~D~~~~6~480~0~0~~,klehr~L~~~~9~3924~0~0~~,kmitp~D~~~~7~1152~0~0~~,ksttg~D~~~~8~888~0~0~~,fwocw~D~~~~10~696~0~0~~,fwocs~D~~~~11~420~0~0~~
 NULL NULL NULL NULL NULL NULL NULL NULL NULL k
Modificado 40245 20262027 1 4 4
Original355
Copy444
 4 0
Original4
Copy0
 Tur Turma
OriginalTur~~Sd~100~18~0~20090727~20090727~0~0~-1~-1~574~551~431~0~0~"0~0"~0-1-1-0-0~
CopyTur~A~Sd~100~1~0~20090727~20090727~0~0~-1~-1~1240~437~317~0~0~"0~0"~0-1-1-0-0~
 NVflprstv0 158/203~0 NULL NULL 80;400;1;Arial 0;0;20;20;20;20 110;400;1;Arial 0 NULL 0 NULL NULL NULL 0 1 10 0 10 K dradr~D~~~~1~300~0~0~~,kname~f~~~"TURMAS"~2~672~16~1~~,lname~D~~~~3~1296~0~0~~,text~D~~~~4~1188~0~0~~,besre~D~~~~5~876~0~0~~,kraum~D~~~~6~480~0~0~~,klehr~L~~~~9~3924~0~0~~,kmitp~D~~~~7~1152~0~0~~,ksttg~D~~~~8~888~0~0~~,fwocw~D~~~~10~696~0~0~~,fwocs~D~~~~11~420~0~0~~ NULL NULL NULL NULL NULL NULL NULL NULL NULL k
Modificado 40245 20262027 1 9 0
Original430
Copy444
 4 0 0 A-Tur Turma
OriginalA-Tur~P~Un~100~0~0~20130916~20130916~0~551~-1~-1~1250~551~431~0~0~"0~0"~0-0-0-0-0~
CopyA-Tur~AP~Un~100~0~0~20130916~20130916~0~437~-1~-1~1240~437~317~0~0~"0~0"~0-0-0-0-0~
 OTprstv0 265/10~0 NULL NULL 80;400;0;Arial 0;0;20;20;20;20 100;400;1;Arial 0 NULL 0 00010203040506070809101112131415161718 1111111111111110000 0600084008552490121507800900081018600540091513200930205504950495066008700600 0 0 0 0 10 K
Originalunr~D~~~~1~510~0~0~~,ukopp~D~~~~2~1230~0~0~~,nvpls~D~~~~3~1035~0~0~~,stuwo~D~~~~4~585~0~0~~,jstdn~D~~~~136~648~0~0~~,ulehr~L~~~~7~870~0~0~~,ufach~L~~~~5~4215~0~1~~,uklas~D~~~~9~765~0~0~~,uraum~~~~~10~1230~0~0~~,usrau~~~~~14~1245~0~0~~,utext~~~~~13~585~0~0~~,besru~D~~~~6~1755~0~0~~,uztxt~~~~~8~840~19~0~~,uztx2~~~~~11~1350~0~0~~,untzr~~~~~21~1770~0~0~~,udopp~D~~~~16~885~0~0~~,ublok~D~~~~20~585~0~0~~,algru~D~~~~18~975~0~0~~,grvrt~D~~~~19~780~0~0~~,ukzr~D~~~~12~570~0~0~~,ukzM~D~~~~15~570~0~0~~,wert~D~~~~17~720~0~0~~
Copyunr~D~~~~1~492~0~0~~,ukopp~D~~~~2~1116~0~0~~,nvpls~D~~~~3~1020~0~0~~,stuwo~D~~~~4~552~0~0~~,jstdn~D~~~~137~648~0~0~~,ulehr~L~~~~7~852~0~0~~,ufach~L~~~~5~2772~0~1~~,uklas~D~~~~9~744~0~0~~,uraum~~~~~10~1212~0~0~~,usrau~~~~~14~1224~0~0~~,utext~~~~~13~552~0~0~~,besru~D~~~~6~876~0~0~~,uztxt~~~~~8~816~19~0~~,uztx2~~~~~11~1332~0~0~~,untzr~~~~~21~1752~0~0~~,udopp~D~~~~16~864~0~0~~,ublok~D~~~~20~552~0~0~~,algru~D~~~~18~960~0~0~~,grvrt~D~~~~19~768~0~0~~,ukzr~D~~~~12~552~0~0~~,ukzM~D~~~~15~552~0~0~~,wert~D~~~~17~696~0~0~~
 NULL NULL NULL NULL NULL NULL NULL NULL NULL k
Modificado 40245 20262027 1 9 4
Original430
Copy444
 4 0 0 A-Tur Turma
OriginalA-Tur~~Un~100~0~0~20130916~20130916~0~551~-1~-1~1250~551~431~0~0~"0~0"~0-0-0-0-0~
CopyA-Tur~A~Un~100~0~0~20130916~20130916~0~437~-1~-1~1240~437~317~0~0~"0~0"~0-0-0-0-0~
 NTprstv0 265/10~0 NULL NULL 80;400;0;Arial 0;0;20;20;20;20 100;400;1;Arial 0 NULL 0 00010203040506070809101112131415161718 1111111111111110000 0600084008552490121507800900081018600540091513200930205504950495066008700600 0 0 0 0 10 K
Originalunr~D~~~~1~510~0~0~~,ukopp~D~~~~2~1230~0~0~~,nvpls~D~~~~3~1035~0~0~~,stuwo~D~~~~4~585~0~0~~,jstdn~D~~~~136~648~0~0~~,ulehr~L~~~~7~870~0~0~~,ufach~L~~~~5~4215~0~1~~,uklas~D~~~~9~765~0~0~~,uraum~~~~~10~1230~0~0~~,usrau~~~~~14~1245~0~0~~,utext~~~~~13~585~0~0~~,besru~D~~~~6~1755~0~0~~,uztxt~~~~~8~840~19~0~~,uztx2~~~~~11~1350~0~0~~,untzr~~~~~21~1770~0~0~~,udopp~D~~~~16~885~0~0~~,ublok~D~~~~20~585~0~0~~,algru~D~~~~18~975~0~0~~,grvrt~D~~~~19~780~0~0~~,ukzr~D~~~~12~570~0~0~~,ukzM~D~~~~15~570~0~0~~,wert~D~~~~17~720~0~0~~
Copyunr~D~~~~1~492~0~0~~,ukopp~D~~~~2~1116~0~0~~,nvpls~D~~~~3~1020~0~0~~,stuwo~D~~~~4~552~0~0~~,jstdn~D~~~~137~648~0~0~~,ulehr~L~~~~7~852~0~0~~,ufach~L~~~~5~2772~0~1~~,uklas~D~~~~9~744~0~0~~,uraum~~~~~10~1212~0~0~~,usrau~~~~~14~1224~0~0~~,utext~~~~~13~552~0~0~~,besru~D~~~~6~876~0~0~~,uztxt~~~~~8~816~19~0~~,uztx2~~~~~11~1332~0~0~~,untzr~~~~~21~1752~0~0~~,udopp~D~~~~16~864~0~0~~,ublok~D~~~~20~552~0~0~~,algru~D~~~~18~960~0~0~~,grvrt~D~~~~19~768~0~0~~,ukzr~D~~~~12~552~0~0~~,ukzM~D~~~~15~552~0~0~~,wert~D~~~~17~696~0~0~~
 NULL NULL NULL NULL NULL NULL NULL NULL NULL k
Modificado 40245 20262027 1 26 0
Original1
Copy444
Original1
Copy4
 0 26 Tur-45 Turma-45
OriginalTur-45~P~Vr~100~0~0~20250923~20250923~1365~432~-1~-1~551~480~150~250~0~~0-0-0-0-0~
CopyTur-45~AFP~Vr~100~0~0~20250923~20250923~1240~396~-1~-1~676~480~150~250~0~~0-0-0-0-0~
 Oprstv0 0/0~0 NULL NULL 80;400;1; 0;0;20;20;20;20 100;400;1;Arial 0 NULL 0 NULL NULL NULL 0 0 0 0 10 K dradr~D~~~~0~650~0~0~~,kname~~~~~0~550~0~0~~,lname~~~~~0~1500~0~0~~,text~~~~~0~1000~0~0~~,besre~~~~~0~1000~0~0~~,kabt~~~~~0~1000~0~0~~,ktpwy~~~~~0~1000~0~0~~,ktpwx~~~~~0~1000~0~0~~,kttgy~~~~~0~1000~0~0~~,kttgx~~~~~0~1000~0~0~~,ktmpy~~~~~0~1000~0~0~~,ktmpx~~~~~0~1000~0~0~~,kthfx~~~~~0~1000~0~0~~,kalia~~~~~0~1000~0~0~~,kraum~~~~~0~650~0~0~~,stat1~~~~~0~1000~0~0~~,sttaf~~~~~0~1000~0~0~~,sulzw~~~~~0~650~0~0~~,sulzm~~~~~0~650~0~0~~,sulzt~~~~~0~650~0~0~~,kstuf~~~~~0~1000~0~0~~,namvj~~~~~0~1000~0~0~~,kdvon~~~~~0~650~0~0~~,kdbis~~~~~0~650~0~0~~,ksule~~~~~0~1000~0~0~~,klehr~~~~~0~650~0~0~~,chper~~~~~0~... fwocs~~~~~0~650~0~0~~ NULL NULL NULL NULL NULL NULL NULL NULL k
Modificado 40245 20262027 1 27 0
Original355
Copy444
 4 0 27 Tur-48 Turma-48
OriginalTur-48~P~Zw~100~0~0~20130919~20130919~574~0~-1~-1~676~551~250~142~0~~0-0-0-0-0~
CopyTur-48~AP~Zw~100~0~0~20130919~20130919~1240~0~-1~-1~676~396~250~142~0~~0-0-0-0-0~
 Oprstv0 0/0~0 NULL NULL 80;400;1; 0;0;20;20;20;20 100;400;1;Arial 0 NULL 0 NULL NULL NULL 0 0 0 0 10 K NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL k
Modificado 40245 20262027 1 27 4
Original355
Copy444
 4 0 27 Tur-48 Turma-48
OriginalTur-48~~Zw~100~0~0~20130919~20130919~574~0~-1~-1~676~551~250~142~0~~0-0-0-0-0~
CopyTur-48~A~Zw~100~0~0~20130919~20130919~1240~0~-1~-1~676~396~250~142~0~~0-0-0-0-0~
 prstv0 0/0~0 NULL NULL 80;400;1; 0;0;20;20;20;20 100;400;1;Arial 0 NULL 0 NULL NULL NULL 0 0 0 0 10 K NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL k
Removido 40245 20262027 1 26 4 444 4 0 26 Tur-45 Turma-45 Tur-45~AF~Vr~100~0~0~20250923~20250923~1240~396~-1~-1~676~480~150~250~0~~0-0-0-0-0~ prstv0 0/0~0 NULL NULL 80;400;1; 0;0;20;20;20;20 100;400;1;Arial 0 NULL 0 NULL NULL NULL 0 0 0 0 10 K dradr~D~~~~0~650~0~0~~,kname~~~~~0~550~0~0~~,lname~~~~~0~1500~0~0~~,text~~~~~0~1000~0~0~~,besre~~~~~0~1000~0~0~~,kabt~~~~~0~1000~0~0~~,ktpwy~~~~~0~1000~0~0~~,ktpwx~~~~~0~1000~0~0~~,kttgy~~~~~0~1000~0~0~~,kttgx~~~~~0~1000~0~0~~,ktmpy~~~~~0~1000~0~0~~,ktmpx~~~~~0~1000~0~0~~,kthfx~~~~~0~1000~0~0~~,kalia~~~~~0~1000~0~0~~,kraum~~~~~0~650~0~0~~,stat1~~~~~0~1000~0~0~~,sttaf~~~~~0~1000~0~0~~,sulzw~~~~~0~650~0~0~~,sulzm~~~~~0~650~0~0~~,sulzt~~~~~0~650~0~0~~,kstuf~~~~~0~1000~0~0~~,namvj~~~~~0~1000~0~0~~,kdvon~~~~~0~650~0~0~~,kdbis~~~~~0~650~0~0~~,ksule~~~~~0~1000~0~0~~,klehr~~~~~0~650~0~0~~,chper~~~~~0~... fwocs~~~~~0~650~0~0~~ NULL NULL NULL NULL NULL NULL NULL NULL k

Lectures

1 linha(s) com diferencas
Estado SCHOOL_ID SCHOOLYEAR_ID VERSION_ID LECTURE_ID Counter USER_ID Deleted SortId DATA
Modificado 40245 20262027 1 119600
Original432
Copy442
Original2
Copy4
Original0
Copy1
 119600 Cla:20,21~FA:0~FC:0~FM:0~FP:0~Sgr:38~Sub:90~Tid:0~V:0~

Lesson

2 linha(s) com diferencas
Estado SCHOOL_ID SCHOOLYEAR_ID VERSION_ID LESSON_ID TERM_ID Counter USER_ID Deleted SortId Text StatisticCodes TimeRequest TimeStamp Flags BlankFlags DESCRIPTION_ID ForeColor BackColor Factor ForeignData ForeignKey MiscData SortIdFinPer LessonNr Periods DoubleMin DoubleMax PeriodsRoom PeriodsRoomMax Priority PlannedYear SubjectSeqCla SubjectSeqTea ClassCollision OptFlag LesnGroups LessonElement1 LessonElement2 LessonElement3 LessonElement4 LessonElement5 LessonElement6 LessonElement7 LessonElement8 LessonElement9 LessonElement10 Lesson_TT Lesson_TTMinut PlannedWeekMinut PlannedYearMinut LESSON_GROUP_ID DateFrom DateTo ReasonNotPlanned TimeNotPlanned Block1 Block2 Block3 Block4 Block5 NoStudentMin NoStudentMax YPPerPeriod1 YPPerPeriod2 IntensiveTerm PartNos BlockN IsYearPeriods FinnishHighschoolStartFixTerms
Modificado 40245 20262027 1 9 0
Original2
Copy445
Original2
Copy4
 0 9 NULL NULL NULL
Original457431212
Copy462181605
 aBn AaCcDdGgHhi 0 0 0 NULL NULL ~~~~~~~-1 0 9 4 2 2 4 4 5 0 NULL NULL NULL NULL NULL
Original190~0~92~4;~0;~0~0~0~~AaB~~~~~~n~~;14;~~~0~0~7900~0~0~~7900~~0
Copy190~0~92~~~0~0~0~~AaB~~~~~~n~~;14;~~~0~0~7900~0~0~~7900~~0
 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL 0 0 0 20260914 20270607 0 0 0 0 0 0 0 0 0 NULL NULL NULL , NULL 0 NULL
Modificado 40245 20262027 1 66 0
Original2
Copy445
Original2
Copy4
 0 66 NULL NULL NULL
Original457701255
Copy462181605
 aBn AaCcDdGgHhi 0 0 0 NULL NULL ~~~~~~~-1 0 66 4 2 2 4 4 5 0 A NULL NULL NULL NULL
Original190~0~77~4;~0;~0~0~0~~AaB~~~~~~n~~;18;~~~0~0~27700~0~0~~27700~~0
Copy190~0~77~~~0~0~0~~AaB~~~~~~n~~;18;~~~0~0~27700~0~0~~27700~~0
 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL 0 0 0 20260914 20270607 0 0 0 0 0 0 0 0 0 NULL NULL NULL , NULL 0 NULL

LessonStack

2 linha(s) com diferencas
Estado SCHOOL_ID SCHOOLYEAR_ID VERSION_ID USER_ID STACK_ID TERM_ID TypeStack TypeElement Counter Deleted Coordinates
Modificado 40245 20262027 1 4 688 0 200 100
Original46
Copy442
Original0
Copy1
 20~0;170;-215;1
Modificado 40245 20262027 1 4 688 0 200 101
Original382
Copy442
Original0
Copy1
 190~0;5120;-316;1

School

1 linha(s) com diferencas
Estado SCHOOL_ID SchoolNo Lizense1 Lizense2 LizenseNr1 LizenseNr2 LizenseNr3 ExpirationDate USER_ID Date Time VERSION_ID LightModus Text NumberStudents
Modificado 40245 40245 Agr.de Esc. Luís António Verney Lisboa MXC-033 CER-PKV DUS-425 20261115 4 20260715
Original1553
Copy1604
 1 0 NULL 0

SchoolYear

1 linha(s) com diferencas
Estado SCHOOL_ID SCHOOLYEAR_ID CounterLast USER_ID Date Time SchoolYearZoned Text
Modificado 40245 20262027
Original427
Copy442
 4 20260715
Original1553
Copy1604
 2026/2027 NULL

TableInfo

5 linha(s) com diferencas
Estado SCHOOL_ID SCHOOLYEAR_ID VERSION_ID Type ID Counter USER_ID Deleted Date Time IdMax SortIdMax LessonNrMax
Modificado 40245 20262027 1 11 0
Original430
Copy444
 4 0 0 0 343 340 0
Modificado 40245 20262027 1 100 0
Original430
Copy443
 4 0 0 0 49 49 0
Modificado 40245 20262027 1 101 0
Original430
Copy443
 4 0 0 0 285 96 0
Modificado 40245 20262027 1 102 0
Original430
Copy443
 4 0 0 0 34 34 0
Modificado 40245 20262027 1 200 0
Original442
Copy445
Original2
Copy4
 0 0 0 905
Original902
Copy898
Original894
Copy901

User

1 linha(s) com diferencas
Estado USER_ID USER_GROUP_ID Name USER_ID2 User2Text Password LoggedIn UserCounterLast LogInDate LogInTime LogOutDate LogOutTime RefreshDate RefreshTime SCHOOL_ID SCHOOLYEAR_ID VERSION_ID TERM_ID Term DEPARTMENT_ID Department Mode Process Type UntisName UserInfo DepartmentRights FaultyLogin PasswordHash JsonData
Modificado 4 1 Paulo 0 NULL 294612465 1
Original116
Copy120
 20260715
Original1553
Copy1604
 20260715 1317 0 0 40245 20262027 1 0 NULL 0 NULL 1 0 0 NULL Oct 30 2025~0~PAULO-THINKPAD~ideia~2026.3.2 NULL 0 NULL NULL

Version

2 linha(s) com diferencas
Estado SCHOOL_ID SCHOOLYEAR_ID VERSION_ID CounterLast UserCounterLast USER_IDLast USER_ID Mode Process Date Time ProgDate Text Only1User Action UpdateDb ReadDb
Modificado 0 0 1
Original467
Copy470
 0
Original2
Copy4
 0 0 0 20260715 1007 Oct 30 2025 NULL 0 0 0 0
Modificado 40245 20262027 1
Original442
Copy445
Original116
Copy120
 4 4 85 2 20260715
Original1553
Copy1604
 Oct 30 2025 NULL 0 0 0 0