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