数据库导航.txt

来自「准备： 1、启动MS-SQL服务器； 2、运行“DBCreate_Mus」· 文本 代码 · 共 65 行

数据库：DB/db_MusicSky.sql
=================================================
表：cdinfo
------------------------
CdId		(varchar(20))
Category	(varchar(30))
CdName		(varchar(50))
ArtistName	(varchar(30))
Publisher	(varchar(50))
PUBLISH_DATE	(varchar(30))
Price		(decimal(5,2))
Language	(varchar(10))
Info		(varchar(2000))

=================================================
表：musicinfo
------------------------
SongId		(varchar(20))
Category	(varchar(30))
Title		(varchar(50))
CdName		(varchar(50))
ArtistName	(varchar(30))
Publisher	(varchar(50))
PUBLISH_DATE	(varchar(30))
Price		(decimal(5,2))
Language	(varchar(10))
Info		(varchar(2000))

=================================================
表：lyric
------------------------
SongId		(varchar(20)) fkSongId REFERENCES musicinfo(SongId)
Title		(varchar(50))
ArtistName	(varchar(30))
Lyric		(varchar(6000))

=================================================
表：myorder
------------------------
ORDER_ID	(int)
USER_ID		(varchar(25)) fkUSER_ID REFERENCES userpassword(USER_ID)
Price_NUM	(varchar(10.2))
ORDER_DATE	(varchar(30))

=================================================
表：orderitem
------------------------
ID		(int) IDENTITY (1, 1)
ORDER_ID	(int)
SongId		(varchar(20))
music_NUM	(int)
Language	(varchar(10))

=================================================
表：userpassword
------------------------
USER_ID		(varchar(25))
USER_PASSWORD	(varchar(25))
ISMASTER	(char(1))
USER_NAME	(varchar(20))
ADDRESS		(varchar(100)) 
PHONE		(varchar(20)) 
EMAIL		(varchar(50))