Academic Journal of Science and Technology ISSN: 2771-3032 | Vol. 5, No. 3, 2023 115 Database Design of Online Education Platform Based on ThinkPHP Yan Liu1, Meina Zhang1, a 1School of Computer Science and Software Engineering, University of Science and Technology Liaoning, Anshan 114001, China a zhangmeina@163.com Abstract: In recent years, internet information technology has developed rapidly, and humanity has entered the information age. The rapid development of technology has led people to gradually pursue higher quality and more diversified education. The online teaching mode of the Internet enables the visualization of teaching resources, making online education further and more convenient. The innovative application of educational technology, represented by MOOCs and WeChat courses, has attracted industry attention, and online teaching and learning have become new trends in current learning. Keywords: Online Education Platform, Online Course, MySQL, ThinkPHP. 1. Introduction In recent years, internet information technology has developed rapidly, and humanity has entered the information age. The rapid development of technology has led people to gradually pursue higher quality and more diversified education. The online teaching mode of the Internet enables the visualization of teaching resources, making online education further and more convenient. The innovative application of educational technology, represented by MOOCs and WeChat courses, has attracted industry attention, and online teaching and learning have become new trends in current learning. Designing an online education platform that integrates knowledge resources and connects teachers and students online has become a necessary requirement for various universities[1]. 2. Introduction to Database MySQL is a secure, cross platform, efficient database system that is closely integrated with mainstream programming languages such as PHP and Java. At present, most small and medium-sized websites on the Internet use MySQL as the background database because MySQL has the characteristics of small size, fast speed and low Total cost of ownership. In addition, open source has also made MySQL databases popular among many companies. In addition to the above advantages, MySQL database also has an attractive advantage, which is that it is a completely free product, and users do not have to pay any fees during the process of using MySQL database. Below is a brief introduction to the power of MySQL from 7 aspects. 2.1. Powerful storage engine MySQL supports multiple database storage engines, which can be suitable for different application scenarios. According to actual needs, users can achieve the highest performance by using the most suitable engine to handle high traffic exceeding hundreds of millions. 2.2. Multi platform support MySQL supports at least 20 development platforms, with mainstream ones including Linux, Windows, FreeBSD, IBMAIX, AIX, FreeBSD, etc. This multi platform support feature greatly enhances the portability of programs. 2.3. Fast running speed Fast running speed is a major advantage of MySQL. MySQL uses B-Tree Disk Table (MyISAM) and index compression, while achieving fast connectivity through optimized single scan multiple connections. 2.4. High security MySQL's permissions and password system combine flexibility and security, allowing for host based authentication. At the same time, MySQL will encrypt all passwords during the transmission process according to a certain algorithm to ensure password security. 2.5. Low cost The MySQL database is completely free, and users can download it on the official website and use it as needed. 2.6. Support or multiple development languages MySQL provides support for the current mainstream programming languages and provides them with rich API functions. These languages include PHP, ASP. NET, Java, Python, Ruby, C/C++, Perl, and more. 2.7. Large storage capacity The maximum effective table size of a MySQL database depends on the operating system's restrictions on file size. For example, the InnoDB storage engine saves InnoDB tables in a table space created by several files, with a maximum capacity of 64 TB. Such a large capacity can easily handle tens of millions of records[2]. 3. Requirement Analysis The online education system needs to provide a comprehensive and easy to operate online education platform for student and teacher users, and provide a management platform with clear functions, clear modules, and convenience for back end administrators. 116 3.1. Front desk functional analysis The front-end of the system is divided into two roles: tourists and student users. Tourists who are not logged in can register and browse website information; Student users are already logged in users, and they have functions such as browsing website information, purchasing and watching courses. 3.2. Background administrator functional analysis After logging in, the back end administrator manages and maintains various information of the system, including permissions, users, videos, directories, news, announcements, and website information configuration. 管理员 用户管理 讲师管理 权限管理 类型管理 视频管理 目录管理 添加管理员 修改管理员 删除管理员 添加管理组 修改管理组 删除管理组 《include》 《include》 《include》 《include》 《include》 《include》 添加讲师 删除讲师 修改讲师信息 《include》 《include》 《include》 删除用户 查看用户信息 《include》 《include》 修改视频 删除视频 添加视频 《include》 《include》 《include》 添加类型 修改类型 删除类型《include》 《include》 《include》 添加目录 修改目录 删除目录 《include》 《include》 《include》 uc Use Case Model 用户 学生用户 游客 查看网站信息 登录 注册 主页浏览查看 分类查看 修改密码 «extend» 117 合作机构管理 新闻管理 广告管理网站信息配置 用户反馈 下载管理 公告管理 管理员 删除用户反馈 添加新闻 删除新闻 修改新闻 添加广告 删除广告 修改广告 添加合作机构 删除合作机构 修改合作机构 修改网站信息 添加公告 删除公告 修改公告 《include》 《include》 《include》 《include》 《include》 《include》 《include》 《include》 《include》 《include》 《include》 《include》 《include》 《include》 3.3. Solid Model Analysis Entity objects in the system are mainly data entities, and the main entity classes in this system are front-end functional modules and back-end management modules. Through the above use case analysis, list all entity classes and their encapsulated information. The system entity class attribute diagram is shown: admin -id -name -pwd -status -auth -photo advice -id -title -advice -uid -time -relation organ -id -organ -url -name -description app -id -uid -time -filename -addr user -id -email -pwd -status -auth -pic coursenote -id -uid -cid -content -ntime video -id -tid -nid -title -price -video -number -des -pid news -id -title -content -ntime type -id -name -pid -path teacher -id -photo -tname -organ -description auth_rule -id -name -title -type -status -condition course -id -vid -name -url -tid -time adv -id -price -url -des -pic -place info -id -title -content -time config -id -title -keywords -description -copyright -logo -status coursetalk -id -uid -cid -descriptione -content -talk_time auth_group_access -uid -group_id coursereply -id -uid -tid -content -reply_time userdetail -id -username -sex -description -realname -qq -special -edu -cardid -phone auth_group -id -title -status -rules 118 4. Database Design 4.1. Entity Class Design Transform these database tables into class objects under the ThinkPHP framework for operation in an object-oriented manner. The relationship between the entity classes of this system is shown. user -id -email -pwd -status -auth -pic admin -id -name -pwd -status -auth -photo course -id -vid -name -url -tid -time 1..* 1..* 1..* 1..* teacher -id -photo -tname -organ -description 11..* type -id -name -pid -path 1 * coursetalk -id -uid -cid -descriptione -content -talk_time coursereply -id -uid -tid -content -reply_time 0..* 1 11 coursenote -id -uid -cid -content -ntime * 1 userdetail -id -username -sex -description -realname -qq -special -edu -cardid -phone 1 1 auth_rule -id -name -title -type -status -condition auth_group -id -title -status -rules 1..* auth_group_access -uid -group_id 1 1 1..* 0..* video -id -tid -nid -title -price -video -number -des -pid 1 1 4.2. Database Table Design 1. The administrator account table is shown in Table 1. Table 1. Administrator Account Table (study_admin) field name data type data type Foreign Key Empty Information remarks id int(10) Yes No Not null Primary key name char(50) No No Not null Account name pwd char(50) No No Default null Password status tinyint (10) No No Default null state auth tinyint(10) No No Default null Group Name photo char(10) No No Default null head sculpture 2. The permission rule table is shown in Table 2. 119 Table 2. Permission Rules Table (study_auth_rule) field name data type data type Foreign Key Empty Information remarks id int(10) Yes No Not null Primary key name char(50) No No Not null rule title char(50) No No Default null title type tinyint (10) No No Default null number status tinyint(10) No No Default null state condition char(10) No No Default null condition 3. The website information table is shown in Table 3. Table 3. Website Information Table (study_config) field name data type data type Foreign Key Empty Information remarks id int(10) Yes No Not null Primary key title char(50) No No Not null Web title keywords char(50) No No Default null Website keywords description tinyint (10) No No Default null description copyright tinyint(10) No No Default null Website copyright logo tinyint(10) No No Default null Web LOGO status tinyint(10) No No Default null Web status 4. Download the information table as shown in Table 4. Table 4. Download Information Table(study_app) field name data type data type Foreign Key Empty Information remarks id int(10) Yes No Not null Primary key time int(10) No No Default null time stamp filename varchar(50) No No Default null Download version addr varchar(50) No No Default null IP Address 5. The management group permission table is shown in Table 5. Table 5. Management Group Permission Table(study_auth_group_access) field name data type data type Foreign Key Empty Information remarks uid Mediumint(10) Yes No Not null Primary key group_id Mediumint(10) No No Not null Management Group ID 6. The user feedback form is shown in Table 6. Table 6. User Feedback Form(study_advice) field name data type data type Foreign Key Empty Information remarks id int(10) Yes No Not null Primary key title char(50) No No Not null Title advice text No No Default null Content time int(10) No No Default null Feedback Time relation varr(50) No No Default null user account 7. The user table is shown in Table 7. 120 Table 7. User Table (study_user) field name data type data type Foreign key Empty Information remarks id int(10) Yes No Not null Primary key email char(50) No No Not null mailbox pwd char(50) No No Default null Password status Enum(0,1) No No Default null state auth Enum(0,1) No No Default null Authority Limits pic char(50) No No Default null head sculpture 8. The management group table is shown in Table 8. Table 8. Management Group Table (study_auth_group) field name data type data type Foreign Key Empty Information remarks id int(10) Yes No Not null Primary key title char(50) No No Not null Name status Tinyint(1) No No Default null State rules char(50) No No Default null Rule 9. The table of cooperative institutions is shown in Table 9. Table 9. List of Cooperative Institutions (study_organ) field name data type data type Foreign Key Empty Information remarks id int(10) Yes No Not null Primary key url char(50) No No Not null Link name char(50) No No Default null Name description char(50) No No Default null Description 5. Summary This paper introduces the database design of online education platform in detail. On the basis of clarifying the functional requirements, the design process of the system database was described in detail, and the phased achievements of each link were presented. The design of the database not only improves the overall design efficiency of the online education platform, but also provides strong support for the efficient and stable development of the later system[3]. 6. Foundation Fund1:2023 Innovation and entrepreneurship training program for College Students Fund2:2022 Industry-University Cooperation Collaborative Education Project of Ministry of Education.Project number:220501913011320 References [1] Liu Jie, Sun Hao, Guo Dongxu, Wu Yuqiao.Design and Implementation of an Online Education Platform Based on SpringMVC and MyBatis Framework [J]. Journal of Shenyang Normal University (NaturalScienceEdition), 2019(3):268-273. [2] Song Jinhua. Design and Implementation of an Online Education Platform Based on SSM Framework [J]. Modern Information Technology, 2022(5) 27-29. [3] Li Yang, Liu Ting. Database design of Household Appliance Recycling Management System Based on MySQL [J]. Technology and Innovation, 2023, (3): 141-143, 146.