Development of Music Online Teaching System Based on Distributed Database Search Technology

Table 2

Song list.

Field name	Field type	Illustrate	Constraint
Song_id	Integer	Unique identifier	Primary key, cannot be empty
Name	Varchar	Song name	Cannot be empty
Album _id	Integer	Belonging to the album id	Foreign key
Singer_id	Integer	Singer id	Foreign key, cannot be empty
Description	Varchar	Song description	Cannot be empty
Public_time	Datetime	Release time	Cannot be empty
Visitors	Integer	Views	Cannot be empty
Lyric	Varchar	Lyric text	Cannot be empty