simblue

Tables (9)

Application (Untitled4)

  • applicationId (application_id) — Primary key — NOT NULL
  • title
  • description
  • startDate (start_date)
  • endDate (end_date)
  • emoji

ApplicationAnswer (Untitled6)

  • applicationAnswerId (application_answer_id) — Primary key — NOT NULL
  • applicationQuestionId (application_question_id) — Foreign key → ApplicationQuestion.applicationQuestionId — NOT NULL
  • applicationId (application_id) — Foreign key → ApplicationQuestion.applicationId — NOT NULL
  • name

ApplicationOwner (CopyOfUntitled4)

  • applicationOwnerId (application_owner_id) — Primary key — NOT NULL
  • teacherId (teacher_id) — Foreign key → Teacher.teacherId — NOT NULL
  • applicationId (application_id) — Foreign key → Application.applicationId — NOT NULL

ApplicationQuestion (Untitled5)

  • applicationQuestionId (application_question_id) — Primary key — NOT NULL
  • applicationId (application_id) — Foreign key → Application.applicationId — NOT NULL
  • question
  • answerType (answer_type)

ApplicationRequest (Untitled2)

  • applicationRequestId (application_request_id) — Primary key — NOT NULL
  • studentId — Foreign key → Student.studentId — NOT NULL
  • applicationAnswerId (application_answer_id) — Foreign key → ApplicationAnswer.applicationAnswerId — NOT NULL
  • applicationQuestionId (application_question_id) — Foreign key → ApplicationAnswer.applicationQuestionId — NOT NULL
  • applicationId (application_id) — Foreign key → ApplicationAnswer.applicationId — NOT NULL
  • textAnswer (text_answer)

Notice (Untitled7)

  • noticeId (notice_id) — Primary key — NOT NULL
  • applicationId (application_id) — Foreign key → Application.applicationId — NOT NULL
  • teacherId (teacher_id) — Foreign key → Teacher.teacherId — NOT NULL
  • text
  • isPinned (is_pinned)

Student (Untitled3)

  • studentId — Primary key — NOT NULL
  • userId (user_id) — Foreign key → User.userId — NOT NULL
  • studentNumber (student_number)
  • admissionYear (admission_year)

Teacher (CopyOfUntitled3)

  • teacherId (teacher_id) — Primary key — NOT NULL
  • userId (user_id) — Foreign key → User.userId — NOT NULL

User (Untitled)

  • userId (user_id) — Primary key — NOT NULL
  • name
  • email
  • password