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 )
);
查看表的模型
标签:VARCHAR,INT,数据库,案例,music,user,KEY,设计,id From: https://www.cnblogs.com/L-1906/p/17792536.html