sqlite-web 0.7.2
xiaohe.db
assignment_items
Create
Query
abilities
ability_radar
ability_radar_history
achievements
alerts
announcements
assignment_items
assignments
bind_code_batches
bind_codes
binds
bookmarks_v2
chat_logs
checkins
children
class_students
classes
course_topics
daily_limits
favorites
generated_codes
homework_entries
institution_parents
institution_students
institutions
item_submissions
messages
mock_exams
parents
phone_institution_map
push_queue
report_templates
reports
review_error_mastery
review_packages
review_schedule_items
review_schedules
review_topics
sqlite_sequence
subject_quality
system_settings
teachers
Toggle helper tables
Structure
Content
Query
Insert
Drop
Import
Export
Insert row into assignment_items
id
Primary key.
TEXT
assignment_id
TEXT NOT NULL
child_id
TEXT NOT NULL
subject
TEXT NOT NULL (default '')
item_type
TEXT NOT NULL
title
TEXT (default '')
description
TEXT (default '')
content
TEXT (default '')
media_urls
TEXT (default '[]')
supplement_urls
TEXT (default '[]')
expected_answer
TEXT (default '')
status
TEXT (default 'pending')
sort_order
INTEGER (default 0)
parent_id
TEXT (default NULL)
created_at
DATETIME (default datetime('now'))
updated_at
DATETIME (default datetime('now'))
group_id
TEXT (default NULL)
Insert
Cancel