Releases: gradution-project/student-information-system-db
Releases · gradution-project/student-information-system-db
SIS DB v1.7.0
SIS API v1.7.0 Supported!
SIS DB v1.7.0 Released! 🚀
UPDATES 🟡
-
STUDENT_LESSON_ABSENTEEISM
THEORETICAL_HOURS_STATE('NOT_EXIST', 'NOT_ENTERED', 'ENTERED')
PRACTICE_HOURS_STATE('NOT_EXIST', 'NOT_ENTERED', 'ENTERED') -
Migrations Have Been Updated ✅
What's Changed
- Student Absenteeism Table Updates | SIS-199 by @agitrubard in #63
- Added Data In Tables | SIS-31 by @berinkrktt in #64
- Teacher Lesson by @berinkrktt in #65
- TeacherId and LessonId changing in Student Table by @berinkrktt in #66
Full Changelog: v1.6.0...v1.7.0
Contributors
agitrubard and berinkrktt
Assets 2
SIS DB v1.6.0
SIS API v1.6.0 Supported!
SIS DB v1.6.0 Released! 🚀
UPDATES 🟡
- UNIV_FEATURE_TOGGLE
NAME('FIRST_SEMESTER_LESSON_DATE_RANGE', 'SECOND_SEMESTER_LESSON_DATE_RANGE', 'FIRST_SEMESTER_LESSON_REGISTRATION_OPERATIONS', 'SECOND_SEMESTER_LESSON_REGISTRATION_OPERATIONS', 'NOTE_OPERATIONS', 'MIDTERM_NOTE_OPERATIONS', 'FINAL_NOTE_OPERATIONS', 'RESIT_NOTE_OPERATIONS') - STUDENT_LESSON_NOTE
MIDTERM_NOTE_STATE('NOT_ENTERED', 'UNCONFIRMED', 'CONFIRMED')
FINAL_NOTE_STATE('NOT_ENTERED', 'UNCONFIRMED'**, 'CONFIRMED')
RESIT_NOTE_STATE('NOT_ENTERED', 'UNCONFIRMED'**, 'CONFIRMED')
STATUS('UNFINALISED', 'PASSED', 'FAILED', 'FAILED_FROM_ABSENTEEISM') - STUDENT_LESSON_ABSENTEEISM
TEACHER_ID
WEEK
THEORETICAL_HOURS
MAX_THEORETICAL_HOURS
PRACTICE_HOURS
MAX_PRACTICE_HOURS
STATUS('NOT_ENTERED', 'ENTERED' 'FAILED', )
DELETES 🔴
- UNIV_LESSON_SCHEDULE_FILE
API_URL - UNIV_EXAM_SCHEDULE_FILE
API_URL - UNIV_LESSON_TIME_PERCENT
ID
LESSON_ID
THEORY_TIME
THEORY_TIME_PERCENT
PRACTICE_TIME
PRACTICE_TIME_PERCENT
TOTAL_TIME
CREATED_DATE
CREATED_USER_ID
MODIFIED_DATE
MODIFIED_USER_ID - UNIV_LESSON_EXAM_PERCENT
ID
LESSON_ID
MIDTERM_NOTE_PERCENT
FINAL_NOTE_PERCENT
CREATED_DATE
CREATED_USER_ID
MODIFIED_DATE
MODIFIED_USER_ID - STUDENT_INTERN_INFO
ID
STUDENT_ID
COMPANY_NAME
INTERN_START_DATE
INTERN_END_DATE
DOCUMENT
STATUS
CREATED_DATE
CREATED_USER_ID
MODIFIED_DATE
MODIFIED_USER_ID
What's Changed
- Unused Tables Delete by @agitrubard in #60
- Absenteeism API | SIS-139 | SIS-140 by @agitrubard in #61
- Schedule File Tables API URL Fixes | SIS-195 by @agitrubard in #62
Full Changelog: v1.5.0...v1.6.0
Contributors
agitrubard
Assets 2
SIS DB v1.5.0
SIS API v1.5.0 Supported!
SIS DB v1.5.0 Released! 🚀
UPDATES 🟡
- AUTH_STUDENT_PASSWORD_OPERATION
OPERATION_ID
STUDENT_ID
EXPIRE_DATE - AUTH_TEACHER_PASSWORD_OPERATION
OPERATION_ID
TEACHER_ID
EXPIRE_DATE - AUTH_OFFICER_PASSWORD_OPERATION
OPERATION_ID
OFFICER_ID
EXPIRE_DATE - UNIV_LESSON
LESSON_ID
DEPARTMENT_ID
NAME
SEMESTER
CREDIT
THEORETICAL_HOURS
PRACTICE_HOURS
COMPULSORY_OR_ELECTIVE('COMPULSORY', 'ELECTIVE')
STATUS('ACTIVE', 'PASSIVE', 'DELETED')
CREATED_DATE
CREATED_USER_ID
MODIFIED_DATE
MODIFIED_USER_ID - STUDENT_LESSON_NOTE
ID
TEACHER_ID
STUDENT_ID
LESSON_ID
MIDTERM_NOTE
MIDTERM_NOTE_STATE('NOT_ENTERED', 'UNCONFIRMED', 'CONFIRMED')
FINAL_NOTE
FINAL_NOTE_STATE('NOT_ENTERED', 'UNCONFIRMED', 'CONFIRMED')
RESIT_NOTE
RESIT_NOTE_STATE('NOT_ENTERED', 'UNCONFIRMED', 'CONFIRMED')
MEAN_OF_NOTE
STATUS('UNFINALISED', 'PASSED', 'FAILED')
CREATED_DATE
CREATED_USER_ID
MODIFIED_DATE
MODIFIED_USER_ID
What's Changed
- FE URL Updates | SIS-166 by @agitrubard in #54
- Lesson Registration Feature Toggles | SIS-182 by @agitrubard in #55
- Batch Confirm Lesson Notes | SIS-177 by @agitrubard in #56
- Theoretical and Practice Hours Update | SIS-180 by @agitrubard in #57
- Stundet Lesson Notes Fix by @agitrubard in #58
- Student Graduation Table Fix by @agitrubard in #59
Full Changelog: v1.4.0...v1.5.0
Contributors
agitrubard
Assets 2
SIS DB v1.4.0
SIS API v1.4.0 Supported!
SIS DB v1.4.0 Released! 🚀
UPDATES 🟡
- STUDENT_LESSON_NOTE
ID
TEACHER_ID
STUDENT_ID
LESSON_ID
MIDTERM_NOTE
FINAL_NOTE
RESIT_NOTE
MEAN_OF_NOTE
STATUS
CREATED_DATE
CREATED_USER_ID
MODIFIED_DATE
MODIFIED_USER_ID - UNIV_FEATURE_TOGGLE
ID
NAME
IS_ENABLED
START_DATE
END_DATE
CREATED_DATE
CREATED_USER_ID
MODIFIED_DATE
MODIFIED_USER_ID
What's Changed
- Student Graduation Table | SIS-129 by @agitrubard in #50
- Student Names Fixed by @agitrubard in #51
- Feature Toggle Table and Insert SQLs | SIS-147 by @agitrubard in #52
- Feature Toggle Table and Insert SQLs Fix | SIS-147 by @agitrubard in #53
Full Changelog: v1.3.0...v1.4.0
Contributors
agitrubard
Assets 2
SIS DB v1.3.0
SIS API v1.3.0 Supported!
SIS DB v1.3.0 Released! 🚀
ADDITIONS 🟢
- UNIV_FEATURE_TOGGLE
ID
NAME
IS_ENABLED
DATE
CREATED_DATE
CREATED_USER_ID
MODIFIED_DATE
MODIFIED_USER_ID
UPDATES 🟡
- STUDENT_LESSON_NOTE
ID
TEACHER_ID
STUDENT_ID
LESSON_ID
MIDTERM_NOTE
FINAL_NOTE
RESIT_NOTE
MEAN_OF_NOTE
STATUS
CREATED_DATE
CREATED_USER_ID
MODIFIED_DATE
MODIFIED_USER_ID
What's Changed
- Feature Toggle Table | SIS-120 by @agitrubard in #48
- Student Lesson Note Table | SIS-118 by @agitrubard in #49
Full Changelog: v1.2.0...v1.3.0
Contributors
agitrubard
Assets 2
SIS DB v1.2.0
SIS API v1.2.0 Supported!
SIS DB v1.2.0 Released! 🚀
ADDITIONS 🟢
-
AUTH_STUDENT_PASSWORD_OPERATION
OPERATION_ID
STUDENT_ID
EXPIRE_DATE
FE_URL -
AUTH_TEACHER_PASSWORD_OPERATION
OPERATION_ID
TEACHER_ID
EXPIRE_DATE
FE_URL -
AUTH_OFFICER_PASSWORD_OPERATION
OPERATION_ID
OFFICER_ID
EXPIRE_DATE
FE_URL -
STUDENT_LESSON
STUDENT_ID
LESSON_ID
CREATED_DATE
CREATED_USER_ID
UPDATES 🟡
- STUDENT_LESSON_REGISTRATION
REGISTRATION_ID
LESSONS_IDS
STATUS
CREATED_DATE
CREATED_USER_ID
MODIFIED_DATE
MODIFIED_USER_ID
What's Changed
- Student Lesson and Registration Tables | SIS-112 by @agitrubard in #46
- Student/Teacher/Officer Password Operations Tables | SIS-115 by @agitrubard in #47
Full Changelog: v1.1.0...v1.2.0
Contributors
agitrubard
Assets 2
SIS DB v1.1.0
SIS API v1.1.0 Supported!
SIS DB v1.1.0 Released! 🚀
UPDATES 🟡
- UNIV_LESSON_SCHEDULE
FILE_ID
FACULTY_ID
FILE
FILE_NAME
FILE_TYPE
FILE_BYTE
FILE_SIZE
API_URL
CREATED_DATE
CREATED_USER_ID - UNIV_EXAM_SCHEDULE
FILE_ID
FACULTY_ID
FILE
FILE_NAME
FILE_TYPE
FILE_BYTE
FILE_SIZE
API_URL
CREATED_DATE
CREATED_USER_ID
What's Changed
- Schedule File Tables Update | SIS-85 by @agitrubard in #41
- Officer Manipulation Update by @agitrubard in #42
- Teacher Role Fix | SIS-72 by @agitrubard in #43
- Officer Registration Date Fixes | SIS-95 by @agitrubard in #44
- Master Config to Live Config by @agitrubard in #45
Full Changelog: v1.0.0...v1.1.0
Contributors
agitrubard
Assets 2
SIS DB v1.0.0
SIS API v1.0.0 Supported!
SIS DB v1.0.0 Released! 🚀
ADDITIONS 🟢
- UNIV_FACULTY
FACULTY_ID
NAME
STATUS
CREATED_DATE
CREATED_USER_ID
MODIFIED_DATE
MODIFIED_USER_ID - UNIV_DEPARTMENT
DEPARTMENT_ID
FACULTY_ID
NAME
STATUS
TOTAL_CLASS_LEVEL
IS_THERE_PREPARATORY_CLASS
CREATED_DATE
CREATED_USER_ID
MODIFIED_DATE
MODIFIED_USER_ID - UNIV_LESSON
LESSON_ID
DEPARTMENT_ID
NAME
SEMESTER
CREDIT
COMPULSORY_OR_ELECTIVE
STATUS
CREATED_DATE
CREATED_USER_ID
MODIFIED_DATE
MODIFIED_USER_ID - UNIV_LESSON_EXAM_PERCENT
ID
LESSON_ID
MIDTERM_NOTE_PERCENT
FINAL_NOTE_PERCENT
CREATED_DATE
CREATED_USER_ID
MODIFIED_DATE
MODIFIED_USER_ID - UNIV_LESSON_SCHEDULE
ID
DEPARTMENT_ID
DOCUMENT
CREATED_DATE
CREATED_USER_ID
MODIFIED_DATE
MODIFIED_USER_ID - UNIV_LESSON_TIME_PERCENT
ID
LESSON_ID
THEORY_TIME
THEORY_TIME_PERCENT
PRACTICE_TIME
PRACTICE_TIME_PERCENT
TOTAL_TIME
CREATED_DATE
CREATED_USER_ID
MODIFIED_DATE
MODIFIED_USER_ID - UNIV_EXAM_SCHEDULE
ID
DEPARTMENT_ID
DOCUMENT
CREATED_DATE
CREATED_USER_ID
MODIFIED_DATE
MODIFIED_USER_ID - OFFICER_ACADEMIC_INFO
OFFICER_ID
FACULTY_ID
STATUS
EMAIL
PHONE_NUMBER
REGISTRATION_DATE
CREATED_DATE
CREATED_USER_ID
MODIFIED_DATE
MODIFIED_USER_ID - OFFICER_PERSONAL_INFO
OFFICER_ID
TC_NO
NAME
SURNAME
EMAIL
PHONE_NUMBER
STATUS
PROFILE_PHOTO
PROFILE_PHOTO_URL
BIRTHDAY
REGISTRATION_DATE
ADDRESS
CREATED_DATE
CREATED_USER_ID
MODIFIED_DATE
MODIFIED_USER_ID - OFFICER_PARAMETER
ID
NAME
VALUE
CREATED_DATE
CREATED_USER_ID
MODIFIED_DATE
MODIFIED_USER_ID - TEACHER_ACADEMIC_INFO
TEACHER_ID
DEGREE
ROLE
DEPARTMENT_ID
FIELD_OF_STUDY
EMAIL
PHONE_NUMBER
STATUS
REGISTRATION_DATE
CREATED_DATE
CREATED_USER_ID
MODIFIED_DATE
MODIFIED_USER_ID - TEACHER_PERSONAL_INFO
TEACHER_ID
TC_NO
NAME
SURNAME
EMAIL
PHONE_NUMBER
STATUS
PROFILE_PHOTO
PROFILE_PHOTO_URL
BIRTHDAY
ADDRESS
CREATED_DATE
CREATED_USER_ID
MODIFIED_DATE
MODIFIED_USER_ID - TEACHER_LESSON
TEACHER_ID
LESSON_ID
CREATED_DATE
CREATED_USER_ID - TEACHER_PARAMETER
ID
NAME
VALUE
CREATED_DATE
CREATED_USER_ID
MODIFIED_DATE
MODIFIED_USER_ID - STUDENT_ACADEMIC_INFO
STUDENT_ID
DEPARTMENT_ID
DEGREE
CLASS_LEVEL
EMAIL
STATUS
REGISTRATION_DATE
CREATED_DATE
CREATED_USER_ID
MODIFIED_DATE
MODIFIED_USER_ID - STUDENT_PERSONAL_INFO
STUDENT_ID
TC_NO
NAME
SURNAME
EMAIL
PHONE_NUMBER
STATUS
PROFILE_PHOTO
PROFILE_PHOTO_URL
BIRTHDAY
ADDRESS
CREATED_DATE
CREATED_USER_ID
MODIFIED_DATE
MODIFIED_USER_ID - STUDENT_GRADUATION
ID
STUDENT_ID
STATUS
CREATED_DATE
CREATED_USER_ID
MODIFIED_DATE
MODIFIED_USER_ID - STUDENT_INTERN_INFO
ID
STUDENT_ID
COMPANY_NAME
INTERN_START_DATE
INTERN_END_DATE
DOCUMENT
STATUS
CREATED_DATE
CREATED_USER_ID
MODIFIED_DATE
MODIFIED_USER_ID - STUDENT_LESSON_ABSENTEEISM
ID
STUDENT_ID
LESSON_ID
THEORY_TIME
PRACTICE_TIME
STATUS
CREATED_DATE
CREATED_USER_ID
MODIFIED_DATE
MODIFIED_USER_ID - STUDENT_LESSON_NOTE
ID
STUDENT_ID
LESSON_ID
MIDTERM_NOTE
FINAL_NOTE
RESIT_NOTE
MEAN_OF_NOTE
STATUS
CREATED_DATE
CREATED_USER_ID
MODIFIED_DATE
MODIFIED_USER_ID - STUDENT_LESSON_REGISTRATION
ID
STUDENT_ID
LESSON_ID
STATUS
CREATED_DATE
CREATED_USER_ID
MODIFIED_DATE
MODIFIED_USER_ID - STUDENT_PARAMETER
ID
NAME
VALUE
CREATED_DATE
CREATED_USER_ID
MODIFIED_DATE
MODIFIED_USER_ID - AUTH_OFFICER_LOGIN
ID
OFFICER_ID
PASSWORD
FAIL_COUNTER
LAST_LOGIN_DATE - AUTH_TEACHER_LOGIN
ID
TEACHER_ID
PASSWORD
FAIL_COUNTER
LAST_LOGIN_DATE - AUTH_STUDENT_LOGIN
ID
STUDENT_ID
PASSWORD
FAIL_COUNTER
LAST_LOGIN_DATE
What's Changed
- Master | Database Create Table | SIS-10 by @berinkrktt in #2
- Master | Alter Table Fix by @agitrubard in #5
- Master | README File Add | SIS-16 by @agitrubard in #7
- Master | Auth Merge To SIS by @agitrubard in #9
- Master | Auth Merge To SIS by @agitrubard in #11
- MASTER | infoTableNameFix_SIS-32 by @berinkrktt in #13
- Master | Remote DBs Integration | SIS-18 by @agitrubard in #15
- Master | Readme File Update by @agitrubard in #17
- Master | README File Update by @agitrubard in #19
- Table Fields Fix and Update | SIS-33 by @agitrubard in #20
- Insert To Student Table | SIS-20 by @berinkrktt in #21
- Table Fields Fix and Update | SIS-33 by @agitrubard in #22
- Insert To Student Tables | SIS-20 by @berinkrktt in #23
- Table Fields Fix and Update | SIS-33 by @agitrubard in #24
- Student Tables Manipulation | SIS-20 by @agitrubard in #25
- Table Fields Fixes and Updates | SIS-41 by @agitrubard in #26
- Table Fields Fixes and Updates | SIS-41 by @agitrubard in #27
- Insert To Teacher Tables | SIS-34 by @berinkrktt in #28
- Student and Teacher Mail Params | SIS-49 by @agitrubard in #29
- Student and Teacher Auth Pass Add | SIS-48 by @agitrubard in #30
- Univ Faculty and Department Manipulations | SIS-57 by @agitrubard in #31
- Student and Teacher Manipulation Fixes by @agitrubard in #32
- Student Manipulation Fixes by @agitrubard in #33
- Officer Manipulations | SIS-56 by @agitrubard in #34
- Parameters Fixes by @agitrubard in #35
- Lesson Tables Fix And Update | SIS-60 by @agitrubard in #36
- Officer API | SIS-23 by @agitrubard in #37
- Officer API Fixes | SIS-23 by @agitrubard in #38
- University API | SIS-50 by @agitrubard in #39
- TEST DB Password Update by @agitrubard in #40
Full Changelog: https://github.com/gradution-project/student-information-system-db/commits/v1.0.0
Contributors
agitrubard and berinkrktt