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