ppsdatabase.sql.sql

学生作品展示平台数据库设计sql源码参考

drop database ProductionShow

go
Create database ProductionShow

Go
use ProductionShow

go
create table member_info
(
M_ID int primary key not null identity(1,1), 
M_username varchar(50) not null,
M_password varchar(50) not null, 
M_genger varchar(2) not null,
M_mail varchar(50) not null,
M_VIP char(2) not null,
M_graduateyear datetime,
M_QQ char(10),
M_phone varchar(15),
M_graduateschool varchar(50),
M_shcoolage char(6), 
M_major varchar(100),
M_like varchar(100),
M_state	char(2) default '真',
)

go
create table agent_info
(
Q_ID int primary key identity(1,1) not null,
Q_username varchar(50) not null,
Q_name varchar(50) not null,
Q_sort char(12) not null,
Q_webaddress varchar(50),
Q_address varchar(150)not null,
Q_phone varchar(15) not null,
Q_state	char(2) default '真',
)

go

create table admin_info
(
A_ID int primary key not null identity(1,1),
A_name varchar(50) not null,
A_mail varchar(50) not null,
A_password varchar(50) not null,
)

go 
create table production_info
(
P_ID int primary key identity(1,1),
P_sort char(12),
P_producerID int references member_info(M_ID)not null, 	
P_name varchar(50) not null,
P_background varchar(300),
P_introduce varchar(300) not null,
P_feature varchar(50),
P_date datetime not null,	
P_browsetime int,	
P_evaluatetime int,	
P_averageevaluate Int,
)

go

create table porduction_enclose_info
(
PE_ID int primary key identity(1,1),
PE_ProductionID int references production_info(P_ID),
PE_imgae Int,
PE_video Int,	
)

go

create table WorkerReq_info
(
WR_ID int primary key identity(1,1),
WR_agentID int references agent_info(Q_ID),
WR_year	Char(6),
WR_skill	varchar(50),
WR_responsibility varchar(100),
WR_limittime datetime,
WR_browsetime int,
WR_evaluate int,

)

go
create table DevReq
(
DR_ID Int primary key identity(1,1),
DR_agentID int references agent_info(Q_ID),
DR_background varchar(200),
DR_function varchar(200),
DR_limittime char(6),		
DR_browsetime int,
DR_evaluate Int,
)

go