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