Student-Support

Tables (3)

StudentInfo (student_info)

  • UserId (user_id) — String — Primary key — NOT NULL
  • NetworkerId (networker_id) — number
  • TeacherId (teacher_id) — number
  • MaintainerId (maintainer_id) — number
  • Field

StudentSupoort (student_support)

  • SupportId (support_id) — number — Primary key — NOT NULL
  • StudentId (student_id) — String — Foreign key → StudentInfo.UserId — NOT NULL
  • SupportType (support_type) — enum
  • PreviousId (previous_id) — String
  • CurrentId (current_id) — String
  • RequestId (request_id) — String
  • RequestedAt (requested_at) — Date
  • CreatedAt (created_at) — DateTime
  • Field

User (user)

  • UserId (user_id) — String — Primary key — NOT NULL
  • OauthId (oauth_id) — number
  • Field