User(id, username, password, email, avatar, created_time, last_login_time)Task(id, name, description, status, create_time, completed_time, category_id)Category(id, name, description, num_of_tasks)StudyGroup(id, name, description, num_of_users, created_time)Statistics(id, total_tasks, total_time, avg_time, completion_rate),请将以上数据转换为表格形式
时间: 2024-04-27 16:23:01 浏览: 13
| 表名 | 字段名 | 数据类型 |
| --- | --- | --- |
| User | id | int |
| | username | varchar |
| | password | varchar |
| | email | varchar |
| | avatar | varchar |
| | created_time | datetime |
| | last_login_time | datetime |
| Task | id | int |
| | name | varchar |
| | description | text |
| | status | varchar |
| | create_time | datetime |
| | completed_time | datetime |
| | category_id | int |
| Category | id | int |
| | name | varchar |
| | description | text |
| | num_of_tasks | int |
| StudyGroup | id | int |
| | name | varchar |
| | description | text |
| | num_of_users | int |
| | created_time | datetime |
| Statistics | id | int |
| | total_tasks | int |
| | total_time | int |
| | avg_time | int |
| | completion_rate | decimal |