数据库设计案例

CREATE TABLE Music ( title VARCHAR ( 32 ), alias VARCHAR ( 32 ), image VARCHAR ( 64 ), id INT PRIMARY KEY );
CREATE TABLE Song (
NAME VARCHAR ( 32 ),
serial_number TINYINT,
id INT PRIMARY KEY,
music_id INT,
CONSTRAINT fk_music_song FOREIGN KEY ( music_id ) REFERENCES music ( id )
);
CREATE TABLE USER ( username VARCHAR ( 32 ) UNIQUE, id INT PRIMARY KEY );
CREATE TABLE conn (
music_id INT,
user_id INT,
CONSTRAINT fk_music FOREIGN KEY ( music_id ) REFERENCES music ( id ),
CONSTRAINT fk_user FOREIGN KEY ( user_id ) REFERENCES USER ( id )
);
CREATE TABLE Review (
content VARCHAR ( 256 ),
rating TINYINT,
review_time datetime,
user_id INT,
music_id INT,
CONSTRAINT fk_music_review FOREIGN KEY ( music_id ) REFERENCES music ( id ),
CONSTRAINT fk_user_review FOREIGN KEY ( user_id ) REFERENCES USER ( id )
);

查看表的模型