奥运火炬传递管理系统 第4页
C-Time char(20),
C-parterno char(20)
);
CREAT TABLE6 Parter
(pno char(10) PRIMARY KEY,
Pname char(20),
p-proficer char(20),
p-cityname char(20),
p-cityno char(10),
p-order char(10)
)
CREAT TABLE7 Slectorganization
(cityno char(10),
Address char(20) PRIMARY KEY,
Membernumber(10)
)
CREAT TABLE8 Contury-province
(con char(10) PRIMARY KEY,
Cname char(20),
Ctime char(20),
c-provinceno char(20)
Pname char(20),
Ptime char(20),
p-cityno char(20)
)
CREAT TABLE8 Contury-province-city
(con char(10) PRIMARY KEY,
Cname char(20),
Ctime char(20),
c-provinceno char(20)
Pname char(20),
Ptime char(20),
Cname char(20),
Ctime char(20),
c-cityno char(20)
c-selectorganization address char(20)
);
CREAT TABLE9 Contury-province-city-chance
(con char(10) PRIMARY KEY,
Cname char(20),
Ctime char(20),
c-provinceno char(20)
Pname char(20),
Ptime char(20),
p-cityno char(20)
Cname char(20),
Ctime char(20),
c-selectorganization address char(20),
cno char(10) PRIMARY KEY,
C-S-name char(20),
C-E-name char(20),
C-Time char(20),
C-parterno char(20)
);
CREAT TABLE10 Contury-province-city-parter
(con char(10) PRIMARY KEY,
Cname char(20),
Ctime char(20),
c-provinceno char(20)
Pname char(20),
Ptime char(20),
Cname char(20),
Ctime char(20),
c-cityno char(20)
c-selectorganization, address char(20)
pno char(10) PRIMARY KEY,
Pname char(20),
p-proficer char(20),
p-cityname char(20),
p-cityno char(10),
p-order char(10)
)
CREAT TABLE10 Contury-province-city-Chance-Parter
(con char(10) PRIMARY KEY,
Cname char(20),
Ctime char(20),
c-provinceno char(20)
Pname char(20),
Ptime char(20),
p-cityno char(20)
Cname char(20),
Ctime char(20),
c-selectorganization address char(20),
cno char(10) PRIMARY KEY,
C-S-name char(20),
C-E-name char(20),
C-Time char(20),
C-parterno char(20)
p-order char(10)
Pname char(20),
p-proficer char(20),
)
数据查询
(1)单表查询
Select *
From Organization
Where path=’ ‘and time=’ ’and parter like’ ‘
Select*
From Contury
Where cno=’ ’and c-pno=’ ‘
Select*
From Province
Where pno=’ ‘and p-cno=’ ‘
Select*
From City
Where cno=’ ‘and c-chanceno=’ ‘