
复制create table client( c_id int identity(1,联删列举1), c_name nvarchar(255) unique, c_pass nvarchar(255), c_sex bit, c_mail varchar(255), c_qq varchar(255), primary key(c_id) ); create table album_kind( k_id int identity(1,1), k_name nvarchar(255), k_desc nvarchar(255), primary key(k_id) ); create table album( a_id int identity(1,1), a_name nvarchar(255), a_desc nvarchar(255), a_create_date datetime, a_times bigint, c_id int, k_id int, primary key(a_id), foreign key(c_id) references client(c_id) on delete cascade, foreign key(k_id) references album_kind(k_id) on delete cascade ); create table album_word( aw_id int identity(1,1), aw_title nvarchar(255), aw_content nvarchar(500), commit_date datetime, a_id int, c_id int, primary key(aw_id), foreign key(a_id) references album(a_id) on delete cascade, foreign key(c_id) references client(c_id) on delete cascade ); 1.2.3.4.5.6.7.8.9.10.11.12.13.14.15.16.17.18.19.20.21.22.23.24.25.26.27.28.29.30.31.32.33.34.35.36.37.38.



