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