Science_gamification

Tables (17)

ACCESSORIES (accessories)

  • ID (accessories_id) — INT — Primary key — NOT NULL
  • NAME (accessories_name) — VARCHAR(10)
  • APPEARANCE (appearance) — IMAGE
  • PRICE (gold) — VARCHAR(100)
  • DESCRIPTION (description) — VARCHAR(100)

AVATAR (avatar)

  • ID (student_id) — INT — Foreign key → STUDENT.ID — NOT NULL
  • ID (hat_id) — INT — Foreign key → HAT.ID — NOT NULL
  • ID (shirt_id) — INT — Foreign key → SHIRT.ID — NOT NULL
  • ID (pants_id) — INT — Foreign key → PANTS.ID — NOT NULL
  • ID (shoes_id) — INT — Foreign key → SHOES.ID — NOT NULL
  • ID (accessories_id) — INT — Foreign key → ACCESSORIES.ID — NOT NULL

CLASSROOM (classroom)

  • ID (classroom_id) — INT — Primary key — NOT NULL
  • PERFORMANCE_TEST (performance_test_id) — INT
  • ID (teacher_id) — INT — Foreign key → TEACHER.ID — NOT NULL

HAT (hat)

  • ID (hat_id) — INT — Primary key — NOT NULL
  • NAME (hat_name) — VARCHAR(10)
  • APPEARANCE (appearance) — IMAGE
  • PRICE (gold) — VARCHAR(100)
  • DESCRIPTION (description) — VARCHAR(100)

LEARNING_LOG (learning_log)

  • ID (learning_log_id) — INT — Primary key — NOT NULL
  • LEARN_TIMESTAMP (learn_timestamp) — TIMESTAMP
  • ATTENDED_CLASS (class_id) — INT
  • ATTENDED_LESSON (lesson_id) — INT
  • LEARNING_TIME (learning_time) — VARINT(10)
  • ATTENDED_LESSON_NUM (attended_lesson_num) — VARINT(10)
  • QUIZ_ERROR_RATE (quiz_error_rate) — VARINT(4)
  • RANK (rank) — INT
  • ID (student_id) — INT — Foreign key → STUDENT.ID — NOT NULL

LESSON (lesson)

  • ID (lesson_id) — INT — Primary key — NOT NULL
  • LESSON_CONTENT (lesson_content) — FILE
  • LESSON_VIDEO (lesson_video) — VIDEO
  • LEARNING_TIME (learning_time) — VARINT(10)
  • QUIZ_ERROR_RATE (quiz_error_rate) — VARINT(4)
  • ID (subject_id) — INT — Foreign key → SUBJECT.ID — NOT NULL
  • ID (teacher_id) — INT — Foreign key → TEACHER.ID — NOT NULL
  • ID (student_id) — INT — Foreign key → STUDENT.ID — NOT NULL

NOTIFICATION (notification)

  • ID (notification_id) — INT — Primary key — NOT NULL
  • CONTENT (content) — VARCHAR(100)
  • ID (student_id) — INT — Foreign key → STUDENT.ID — NOT NULL
  • ID (teacher_id) — INT — Foreign key → TEACHER.ID — NOT NULL

PANTS (pants)

  • ID (pants_id) — INT — Primary key — NOT NULL
  • NAME (pants_name) — VARCHAR(10)
  • APPEARANCE (appearance) — IMAGE
  • PRICE (gold) — VARCHAR(100)
  • DESCRIPTION (description) — VARCHAR(100)

PERFORMANCE_TEST (performance_test)

  • ID (performance_test_id) — INT — Primary key — NOT NULL
  • QUESTION (question) — VARCHAR(100)
  • UPLOADED_FILE (uploaded_file) — FILE
  • REWARD_POINT (reward_point) — VARINT(10)
  • REWARD_COIN (reward_coin) — VARINT(10)
  • ID (classroom_id) — INT — Foreign key → CLASSROOM.ID — NOT NULL
  • ID (student_id) — INT — Foreign key → STUDENT.ID — NOT NULL
  • ID (teacher_id) — INT — Foreign key → TEACHER.ID — NOT NULL

QUIZ (quiz)

  • ID (quiz_id) — INT — Primary key — NOT NULL
  • QUESTION (question) — VARCHAR(100)
  • ANSWER (answer) — VARCHAR(500)
  • REWARD_POINT (reward_point) — VARINT(10)
  • REWARD_COIN (reward_coin) — VARINT(10)
  • ID (lesson_id) — INT — Foreign key → LESSON.ID — NOT NULL
  • ID (student_id) — INT — Foreign key → STUDENT.ID — NOT NULL
  • ID (teacher_id) — INT — Foreign key → TEACHER.ID — NOT NULL

RANK (rank)

  • ID (rank_id) — INT — Primary key — NOT NULL
  • ID (student_id) — INT — Foreign key → STUDENT.ID — NOT NULL
  • TOTAL_POINT (total_point) — VARINT(10)
  • RANK_NUM (rank_num) — VARINT(10)

SHIRT (shirt)

  • ID (shirt_id) — INT — Primary key — NOT NULL
  • NAME (shirt_name) — VARCHAR(10)
  • APPEARANCE (appearance) — IMAGE
  • PRICE (gold) — VARCHAR(100)
  • DESCRIPTION (description) — VARCHAR(100)

SHOES (shoes)

  • ID (shoes_id) — INT — Primary key — NOT NULL
  • NAME (shoes_name) — VARCHAR(10)
  • APPEARANCE (appearance) — IMAGE
  • PRICE (gold) — VARCHAR(100)
  • DESCRIPTION (description) — VARCHAR(100)

SHOP (shop)

  • ID (shop.id) — INT — Primary key — NOT NULL
  • Field
  • ID (student_id) — INT — Foreign key → STUDENT.ID — NOT NULL
  • ID (hat_id) — INT — Foreign key → HAT.ID — NOT NULL
  • ID (shirt_id) — INT — Foreign key → SHIRT.ID — NOT NULL
  • ID (pants_id) — INT — Foreign key → PANTS.ID — NOT NULL
  • ID (shoes_id) — INT — Foreign key → SHOES.ID — NOT NULL
  • ID (accessories_id) — INT — Foreign key → ACCESSORIES.ID — NOT NULL

STUDENT (student)

  • ID (student_id) — INT — Primary key — NOT NULL
  • USER_ID (user_id) — VARCHAR(15)
  • NAME (name) — VARCHAR(6)
  • PASSWORD (password) — VARCHAR(15)
  • GRADE (grade) — VARINT(2)
  • NOTIFICATION_INCOME (notification_income_id) — INT
  • POINT (point) — VARINT(10)
  • GOLD (gold) — VARINT(10)
  • ID (classroom_id) — INT — Foreign key → CLASSROOM.ID — NOT NULL

SUBJECT (subject)

  • ID (subject_id) — INT — Primary key — NOT NULL
  • NAME (subject_name) — VARCHAR(50)
  • ATTENDED_LESSON_NUM (attended_lesson_num) — VARINT(10)
  • ID (classroom_id) — INT — Foreign key → CLASSROOM.ID — NOT NULL
  • ID (teacher_id) — INT — Foreign key → TEACHER.ID — NOT NULL

TEACHER (teacher)

  • ID (teacher_id) — INT — Primary key — NOT NULL
  • USER_ID (user_id) — VARCHAR(15)
  • NAME (name) — VARCHAR(6)
  • PASSWORD (password) — VARCHAR(15)
  • NOTIFICATION_INCOME (notification_income_id) — INT