classroom

Tables (6)

UserLecture (Untitled)

  • Key — Primary key — NOT NULL
  • Key (user_Id) — Foreign key → user.Key — NOT NULL
  • Key (lecture_id) — Foreign key → lecture.Key — NOT NULL

commet (ANSWER)

  • Key (commet_id) — Primary key — NOT NULL
  • Field (content)
  • Field (create_time)
  • Field (update_time)
  • Key (post_id) — Foreign key → post.Key — NOT NULL

grade (GRADE)

  • Key (grade_Id) — Primary key — NOT NULL
  • Field (attend)
  • Field (midterm)
  • Field (final)
  • Field (assign)
  • Field (final_grade)
  • Key (user_Id) — Foreign key → user.Key — NOT NULL
  • Key (lecture_id) — Foreign key → lecture.Key — NOT NULL

lecture (LECTURE)

  • Key (lecture_id) — Primary key — NOT NULL
  • Field (lecture_name) — NOT NULL
  • Field (professor) — NOT NULL
  • Field (schedule) — NOT NULL

post (POST)

  • Key (post_id) — Primary key — NOT NULL
  • Field (title) — NOT NULL
  • Key (lecture_id) — Foreign key → lecture.Key — NOT NULL
  • Key (user_Id) — Foreign key → user.Key — NOT NULL
  • Field (content)
  • Field (post_type) — NOT NULL
  • Field (create_time)
  • Field (update_time)

user (USER)

  • Key (user_Id) — Primary key — NOT NULL
  • Field (name) — NOT NULL
  • Field (years) — NOT NULL
  • Field (user_role) — NOT NULL